SQL Newsgroups: Microsoft SQL Server Administration

The old inability to toggle/change/switch between ALTER PROCEDURE <---> CREATE PROCEDURE bug (or is

raylopez99 - 31 Mar 2007 10:26 PM - 12 messages

Keep in mind this is my first compiled SQL program Stored Procedure (SP), copied from a book by Frasier Visual C++.NET in Visual Studio 2005 (Chap12). So far, so theory, except for one bug (feature?) below. At some point I'm sure I'll be able to laugh about this, akin ...

Flood of SQL services

Tim Meltzer - 31 Mar 2007 3:10 PM - 2 messages

Hi, I've just setup SQL Express 2005 SP2 on my fresh SBS 2003 R2 system. I never had anything to do with and have no idea about SQL, the only reason for updating from MSDE was the annoying and ugly event id 1000 relating to ...

Script

Newish - 31 Mar 2007 2:55 PM - 3 messages

I have a foreign key. I want to script how to create it without using the management studio i.e. from the query analyser in SQL 2005. Is there a system stored procedure or something that does this for you. ...

database diagram

yshie via SQLMonster.com - 31 Mar 2007 9:38 AM - 11 messages

i am about to create a database diagram but this error appears. what does this mean and what should i do? tnx This database does not have a valid dbo user or you do not have permissions to impersonate the dbo user, so database diagramming is not available. ...

DIFFERENTIAL backup

Ben Rum - 31 Mar 2007 8:22 AM - 2 messages

Just want to clarify the date from which a DB backup with DIFFERENTIAL option includes its changes. I have a db which I do a full backup on Saturday, and a differential the other days (this is plenty in our case) ...

Comparing database structures

Earl - 31 Mar 2007 2:10 AM - 3 messages

I'm trying to evaluate the RedGate SQLCompare tool and it did a nice comparison between an up-to-date version and an older version of the same database. However, when I try to synchronize, it synchronizes the normal tables, then I get a message: ...

Pivot Comma List

David - 31 Mar 2007 1:58 AM - 4 messages

Hi All I have a table that contains a comma separated list of products that I want to pivot so that they each product is listed individually. Below is a sample of the table and the data as well as how I am trying to return the data. Any ...

BCPing into a Table with more columns than the source data file

scudi54 - 30 Mar 2007 11:57 PM - 3 messages

Hi, I have a table with 15 columns. However, in my data file I only have 9 columns. I have created a format file to map the data fields to the relevant columns. Each time I BCP data into the table though it just ...

How do I register a Server (2005)

lurch279 - 30 Mar 2007 11:20 PM - 15 messages

Hi Folks! I have just installed SQL Server 2005 (Standard) on my work (networked) computer and I'd like to create a "sandbox" database on my computer to play around with. I have admin rights on the computer. I should point out I know NOTHING about sql server 2005 right now. I'm ...

Batching a cmd

Ana - 30 Mar 2007 10:16 PM - 2 messages

Hi, I'd like to do a daily backup of my db using windows programmed task and running the following batch file: sqlcmd -S server\db_Express -U username -P password BACKUP DATABASE [dbSQL] TO DISK = N'D:\db05\dbSQL' WITH NOFORMAT, INIT, ...

Using Brightstore to backup SQL errors

Elbryyan - 30 Mar 2007 7:24 PM - 4 messages

I have a windows server 2003 sp1 server that had SQL 2000 SP4 installed and I was able to back the databases up using CA's brightstore with no problems. Due to hardware contraints we installed another instance of SQL 2005 on the ...

Problem installing SQL Server 2005 SP2

Zoro - 30 Mar 2007 5:37 PM - 4 messages

The problem seems to be with the authentication. It froze when Windows updates attempted to install it, so I downloaded the exe from the ms site. However this freezes too while running the "Authentication Verification". This also happens if I just click the Test button. ...

Hardware Configuration - Need Advice

Eric - 30 Mar 2007 3:52 PM - 2 messages

We have a web app currently being hosted on a RAID 5 with four disks, 2 GB RAM, Xenon 3.2 processor. Also running Windows 2003 Server Standard Ed. and SQL Server 2000 Standard Edition. Our database is about 4GB and at most we ...

Maintenance Assistant SQL 2005 Error 12291

Lanying & Manfred Chen-Fischer - 30 Mar 2007 2:59 PM - 2 messages

Hello, SQL Server 2005 EE Trial Version SP2 Win 2003 SP2 I've tried to backup the AdventureWorks database with the help of Maintenance Assistant, I've created a fairly simple job, straight forward, no tricks and radio button clicks! ...

Go To Url through Sql

Tazar via SQLMonster.com - 30 Mar 2007 2:11 PM - 2 messages

Is there a way to open a webpage through SQL? ...

Not Requiring Admin Sign On

mlarsen1982 - 30 Mar 2007 1:43 PM - 2 messages

Hello Hopefully someone is knowledgeable about this that can help me. We use SQL Server, and usually FTP our microsoft documents up to it. Obviously, when different locations access these files through our intranet, they are read only. I wanted to see if there is a way to ...

Collations

Dylan Parry - 30 Mar 2007 1:11 PM - 4 messages

Hi, I'm starting to build a database that will contain English and Welsh text. Up until now I have just used the default collation settings, and everything has been fine - but I've only ever needed to use English. ...

Licencing per processor and compatibility level 80 and the 2Gb mem

Ola Carlander - 30 Mar 2007 1:02 PM - 2 messages

Hi! Two questions, one simple and one a bit harder. First, the licencing model. How does per processor licencing work if you have a dual core processor? Is it per physical processor or per core? Secondly, If I run a database in 80 compatibility mode in a sql2005 ...

Safely Shrink tempdb while online

blam - 30 Mar 2007 12:55 PM - 7 messages

I've read that when using DBCC shrinkfile or shrinkdatabase it is best to be in single user mode. My question is when using DBCC SHRINKFILE on the tempdb (tempdev) while the database is in production and live is this bad? If I use the sys.database_files view to figure out the ...

Only * (All columns) in EM Query builder when database name contains a . (dot)

Roel Schreurs - 30 Mar 2007 12:02 PM - 5 messages

I encountered a nasty bug in SQL Server 2000. Symptoms: When you try to create a query in the Query Builder of Enterprise Manager, the selected tables are displayed without columns. Only * (All Columns) is displayed. Besides that, the table receives an alias ...

Moving Report Server Log Files

MACason - 30 Mar 2007 11:50 AM - 2 messages

I am setting up a new SQL Server 2005 EE server with Reprting Services installed. The log files have all been moved to a seperate drive. However, I have never moved log files for Reporting Services and can find no ...

sysadmin fixed server role

Dutt - 30 Mar 2007 11:37 AM - 2 messages

Hi, Greetings... I'm given 'SYSADMIN FIXED SERVER ROLE' for a database. But, I'm unable to run DBCC FREEPROCACHE DBCC DROPCLEANBUFFERS statements. Could anybody guess what could be the reason. As I'm dumped with many tasks today, I seek ur help. ...

Error on Restoring Database

Richardw - 30 Mar 2007 10:40 AM - 5 messages

Hi All, We are trying to restore a database from a live system to our test system. However, we are receiving the following errors when attempting to perform this restore "Modify file encountered operating system error 112(error code not found) ...

Scheduled Job works when run manually but not when scheduled

Bobby - 30 Mar 2007 10:11 AM - 6 messages

Hi I have a very simple local package, which performs the following: 1. Execute SQL Task Delete from PURCHASE_LEDGER Delete from SALES_LEDGER 2. Transform Data task Copy everything from SAGE PURCHASE_LEDGER to SQL PURCHASE_LEDGER ...

What is the maximum amount of RAM supported by SQL Server 2000 on Windows 2003 standard edition serv

Ramakrishna P - 30 Mar 2007 4:12 AM - 4 messages

Hi What is the maximum amount of RAM supported by SQL Server 2000 on Windows 2003 standard edition server? Regards Ram ...

Memory Allocation for 64 bit

abraceyiii - 29 Mar 2007 11:32 PM - 5 messages

I have a client experiencing problems with SQL Server 2005 64 bit (sp1). The server has 4 gigs of memory available, however I can not increase the memory allocated via management studio past 2 gigs. When I look at the .exe in task manager, I see that service is using about ...

Best way to keep a database synched with a server that is outside the firewall

a - 29 Mar 2007 10:36 PM - 4 messages

Hi, We have two servers, one inside the firewall and one outside and need to keep them synched up on a daily basis. Short of doing full backup and restore, what is best solution? Thanks. ...

CLR Stored proc is timing out

Quimbly - 29 Mar 2007 9:44 PM - 4 messages

At one seemingly inoccuous step in my CLR stored procedure, execution stops and the query times-out. I've tried debugging the stored proc by stepping into it from within VS. When I do, I get to the code in question, but then simply get this message: ...

EXEC sp_start_job Remote Server

Matthew - 29 Mar 2007 9:07 PM - 2 messages

I am trying to create a centralized job monitoring system that can be managed by some operators to restart a job if it fails. Everything will be running on one system but I need to invoke remote jobs on ...

Bringing up SQL Server 2000

sharman - 29 Mar 2007 8:28 PM - 4 messages

Hi, I was trying to test SQL Server 2000 master database restore and to do that I stopped MSSQLSERVER service and tried to restart with a single user mode. However, on typing the command "sqlservr.exe -m" in the Command window it ...

query engine statitistics

x - 29 Mar 2007 8:21 PM - 2 messages

Hi, Is there an esay way to gather information about how many times each stored procedures has been called , the average execution time , etc .. I know profiling can give you punctual info about this .. however i need aggregated info over a determined period of time ...

Variables Parameter Question

Calvin Willman - 29 Mar 2007 8:12 PM - 2 messages

I've written a frunction that accepts 2 nvarchar parameters, which are passed to 2 IN clauses of the where portion of a SELECT... such that the function can be called like... select * from dbo.fn_GetDTZInvoice(N'SINV146917', N'SCRN010040') ...

Rookie question

Cary W. Shultz - 29 Mar 2007 7:45 PM - 6 messages

Good afternoon! I know that I have asked this question a while back but I can not find it so I am asking again! This time I will print it out! First off, I am not a database guy! At all! This is something that will ...

SQL Server 2005 Maintenance Assistant error Id: 12291

Lanying & Manfred Chen-Fischer - 29 Mar 2007 5:16 PM - 2 messages

Hello, SQL Server 2005 EE Trial Version SP2 Win 2003 SP2 I've tried to backup the AdventureWorks database with the help of Maintenance Assistant, I've created a fairly simple job, straight forward, no tricks and radio button clicks! ...

Database Server Hardware Architecture

pbd22 - 29 Mar 2007 4:49 PM - 6 messages

Hi. I am in the process of "ramping-up" (read: spending more money) on a home project. To date, I have done the web and database development on the same machine. I have been advised to put the DB stuff on its own box. My question is, what kind of box should this ...

SQL Server 2005 -- "Delete Files older than"

robboll - 29 Mar 2007 4:48 PM - 9 messages

Using the SQL Server 2005 Maintenance Wizard -- Where do you tell it to delete files older than a certain date? With SQL Server 2000 it is a checkbox where you specify an age before it is deleted. Any ...

Converfting a 2000 db to 2005.

Mufasa - 29 Mar 2007 4:45 PM - 7 messages

I have a 2000 db that I've restored to a 2005 machine. When it restored it restored as a version 80 db (2000 I would assume). To convert it to 2005 do I just go into options and change the compatibility to 90? ...

SQL Server 2005 DTS for Visual Studio

gabe - 29 Mar 2007 4:30 PM - 2 messages

Hi, Is there a Visual Studio Add-In for the new equivalent of DTS that can used with SQL Server Express? Thanks, Gabe ...

Restoring MSDE databases to SQL Server 2000

sharman - 29 Mar 2007 3:10 PM - 4 messages

Hi, We have a MSDE 2000 installed on a Blackberry server that contains Blackberry configuration data. For testing the Net backups we need to restore it to a SQL Server 2000 server. The SQL Server 2000 is already installed and ...

Backup to Network Resource from a Server Machine Service Account

BQ_rmsterling - 29 Mar 2007 2:50 PM - 7 messages

SQL Server 2000 SP4 Trying to backup to a network resource when SQL uses the machine service account. Obviously something like EXEC sp_addumpdevice 'disk', 'device_name', '\\filer_name\share_name\path\file_name.ext' would be used but this doesn't work because of permissions. ...

Store Procedures and nested stored procedure

Roger - 29 Mar 2007 2:42 PM - 4 messages

Have 2 stored procedures; procA and procB ProcB calls procA within it. ProcA has select queries that pulls data from a linked server and then returns a select statement. Within ProcB when I execute the procA, I insert it into a temp table. Cause, ...

How to restore from a BAK file to MDF and LDF files

carlach - 29 Mar 2007 1:36 PM - 3 messages

All I've been given is a bak file and I need to get the *.MDF and *_log.LDF files from it. Any ideas? ...

event id 4014

Zvonimir Bilic - 29 Mar 2007 12:46 PM - 3 messages

Hello, I keep getting these errors in Event Log. Source: MSSQLSERVER A fatal error occurred while reading the input stream from the network. The session will be terminated. For more information, see Help and Support Center at [link] ...

SQL2000 -> SQL2005 migration

Griff - 29 Mar 2007 11:15 AM - 2 messages

When migrating a database from a 2000 to a 2005 SQLServer, one has the option to make it compatible with 2005 (90) or to keep it compatible with 2000 (80). I am wondering which compatibility level to set mine to....(I know that ...

Apparent System hang during intensive long running script: SQL Server 2000 Best Server Settings

JimLad - 29 Mar 2007 10:06 AM - 7 messages

Hi, Our db server appeared to hang during a long running script last night. Our windows guys rebooted the server. However my suspicion is that the script was consuming all systems resources but was still running. The SQL server is set to use all CPUs (4) and max all memory. It also ...

How to disable server cursor?

George - 29 Mar 2007 9:44 AM - 2 messages

Hi All, When using SQL profilter, I noticed that sp_cursorfetch has taken the most CPU and has the longest duration. I have searched on the Internet and found that sp_cursorfetch is used by server cursor which may be created automatically when client queries the server. Can we disable server cursor or ...

Is NTBACKUP breaking SQL Server 2005 differential backup chain..again?

NGD66 - 29 Mar 2007 9:25 AM - 13 messages

Hi All, We recently upgraded a box running Windows Server 2003 SP1 with SQL Server 2005 SP1 to Windows Server 2003 SP2 and SQL Server SP2. For some time we have had the following backup regime for some SQL Server ...

Collation Properties

Venkat - 29 Mar 2007 7:21 AM - 6 messages

Hi, I want to specify case sensitivity for my database, but at the same time i want let customer decide the sort order. What i mean is: take the following collation property SQL_Latin1_general_cs_as in the above property, i want to specify only CS, and let cusotmer decide ...

Check if Column has an index

David - 29 Mar 2007 5:20 AM - 5 messages

Hi All Ho do I go about determining a list of all columns in a table that have an index on them? Thanks ...

Negative Stolen buffers value

cbrichards via SQLMonster.com - 29 Mar 2007 4:51 AM - 4 messages

If I run DBCC MemoryStatus and I get a negative value for Stolen in the Buffer Distributions section, what does a negative value indicate? For example: Buffer Distribution Buffers ...

upgrade of SQL 6.5 to SQL 2000

daltilio - 29 Mar 2007 2:02 AM - 2 messages

I am upgrading SQL 6.5 (NT4) to SQL 2000 (W2K server). This is an intermediate step before upgrading to SQL 2005 (Win2003). I am using the upgrade wizard. It gets through everything and fails on "Export and Import ...

DBA guru advice - changes to production database

Sandy - 29 Mar 2007 2:00 AM - 13 messages

Hello - I need to find out how to be able to change a production database, i.e., adding a column to a table that will necessitate changes to multiple stored procedures, without shutting down the application that depends on the ...

Default Collation

jsully79 - 29 Mar 2007 12:38 AM - 3 messages

Is the Default collation SQL_Latin1_General_CP1_CI_AS in SQL server 2000? ...

Changing Collation SQL 2000 sp4

jsully79 - 28 Mar 2007 11:49 PM - 2 messages

Hello We just upgraded to SQL server 2000 sp3a from sp4 . Could the collation change upgrading to SP4 (from SQL_Latin1_General_CP1_CS_AS to SQL_Latin1_General_CP1_CI_AS. Or can that only be changed on the initial installation. Thanks ...

et?

sp - 28 Mar 2007 10:52 PM - 3 messages

Minimum password length for SQL Server Authentication and special character â€“ how to set? I need to set that minimum password length for 8 char and password should include special character in SQL (2000) Server Authentication â€“ is it possible? ...

SS2005 data encryption

jason - 28 Mar 2007 10:00 PM - 4 messages

hi all, basic SS2005 questions. native data encryption is an option with SS2005...but it is not on by default is it? and setup is not a simple matter of clicking a checkbox to turn it on, similar to how easy it is to make sql server account password rules to match ...

Query runs fine but not when inserted into a sproc

Shkedy - 28 Mar 2007 9:20 PM - 7 messages

I have a query that I can run from query analyzer and it will execute within a matter of seconds. If i run the same query from within a sproc it times out. Any ideas? ...

SQL Server locks and performance issues

Moshe Rosenberg - 28 Mar 2007 9:08 PM - 6 messages

We have been having an issue with SQL server performance and I think it has to do with too many locks. I have not found anything online that would indicate what a normal number of locks are and a normal wait time. I have taken a screenshot of my counters ...

How to grant "Act as part of the operating system" to a domain user

Ian Boyd - 28 Mar 2007 8:49 PM - 4 messages

This is a facetious question, but how to i grant the "Act as part of the operating system" to a specific domain account? i try, on our Windows 2000 domain controller: 1. Start 2. Programs 3. Administrative Tools 4. Active Directory Users and Computers ...

Memory

msnews.microsoft.com - 28 Mar 2007 8:18 PM - 2 messages

I have production SQL server with 2GB, Memory is configured Dynamically with Maximum of 1537MB, can I increase this to maybe 1800MB or do I need to add more memory . would 500MB for the OS is planty? Thanks ...

SQL2005 - Copy a database to same server?

Gerry Hickman - 28 Mar 2007 7:49 PM - 5 messages

Hi, (SQL Server 2005, one instance, running on Win2k3 member server) We need to create an exact copy of 'our_data' as 'our_data2' on the same instance while 'our_data' is still on line. This is for development and testing purposes. At first I thought the "Copy Database Wizard" would be the way to go but ...

Jobs Export

MikeCosca - 28 Mar 2007 7:30 PM - 4 messages

Is there a simple way to Export a listing of all the SQL Server Agent Jobs to a text or xml file? ...

URGENT: EventLog: The process Explorer.EXE has initiated the restart of computer X on behalf of user

JimLad - 28 Mar 2007 7:23 PM - 2 messages

Hi, Is anyone familiar with this event log message? We were running a release out of hours and in the middle of a large script that was rebuilding a million+ row table the server crashed. Suspicion has fallen on my script as the transaction logs were considerably larger ...

memory

msnews.microsoft.com - 28 Mar 2007 7:12 PM - 2 messages

I have production SQL server with 2GB, Memory is configured Dynamically with Maximum of 1537MB, can I increase this to maybe 1800MB or do I need to add more memory . would 500MB for the OS is planty? Thanks ...

How would you restore just a Stored Procedure from backup?

codesweeper - 28 Mar 2007 6:06 PM - 6 messages

Hi there, on accident I dropped a stored procedure I didn't have the code saved elsehwere for (it was encrypted). However I have full backup sets. So my question is, how would I restore just the procedure without doing a full restore? Would rather not occupy the ...

setuser

stoney - 28 Mar 2007 5:58 PM - 3 messages

when I try to say setuser 'abc' I get an error no such users or group 'abc' but I can connect with users 'abc' and the account is system admin. Any thoughts? Thanks ...

Example of certificates?

ChrisR - 28 Mar 2007 5:44 PM - 3 messages

Can someone please point me to an example of how to create and use certificates in 2005? TIA, ChrisR ...

Inconsistent sp_spaceused

Leon Shargorodsky - 28 Mar 2007 5:42 PM - 2 messages

When I run sp_spaceused 'table', @updateusage = 'TRUE', here is what I get: name rows reserved data index_size unused ------- ---------- ------------ ---------- ------------- ---------- table 0 7253 KB 5020 KB 32 KB 2201 KB ...

Inconsistent sp_spaceused

Leon Shargorodsky - 28 Mar 2007 5:32 PM - 5 messages

SQL 2000 Enterprise, SP4, 8.00.2175 sp_spaceused 'table', @updateusage = 'TRUE' returns this: name rows reserved data index_size ...

Returning XML values

Brian Bunin - 28 Mar 2007 4:22 PM - 2 messages

I have an XML field in one of our tables. A sample of the data is here: <PackageAddTask xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/ XMLSchema"><Item><PackageItemId>11</ ...

too complicated query -- timeout

sweetpotatop - 28 Mar 2007 3:44 PM - 4 messages

Hi, I wonder if someone can let me know what the query is trying to do, looks like it is doing some unnecessary steps, especially the "IN" and "NOT IN" clause, can someone please simplify this query as I am ...

Poor Linked Server performance when running a query with a variable

Steen_Schlüter_Persson_(DK) - 28 Mar 2007 2:12 PM - 5 messages

Hi We are facing a quite strange performance issue when using a linked server to an Oracle server. When we run a query containing a WHERE clause using a variable, it takes ages for SQL server to return the data. When we instead just type in the ...

Update Statistics Task after SQL 2005 SP2 applied

Anders - 28 Mar 2007 1:32 PM - 3 messages

Version 9.0.3042 After applying the service pack I can no longer run Update Statistics task succesfully unless I run it with fullscan. It fails whenever it hits a view. Fullscan takes 4 hours to run due to the size of the databases in question, ...

Please Help! How to get list of SQL Servers in LAN?

Pola - 28 Mar 2007 1:30 PM - 5 messages

Hello, Is it possible to get list of SQL Servers existed in the LAN (on VC++)? Thanks in advance, Pola ...

local account

brymer28303 - 28 Mar 2007 1:20 PM - 2 messages

I have a mixture of SQL Servers running the SQL services under the local account and a domain account. I am trying to standardize all of the services to run under the domain account. Does anyone know of any issues of changing ...

Problem of casting to timestamp

Michal Valenta - 28 Mar 2007 12:38 PM - 8 messages

Hello, During my work I have found following problem. All tables that I am using have column RecTimeStamp (timestamp). I do the selection based on last remembered timestamp. For some reasons my last timestamp is saved as decimal number (Int64), so I do some casting to timestamp in my queries. Once the DB ...

sp_cursorfetch has longest duration and cpu in trace log

George - 28 Mar 2007 9:44 AM - 5 messages

My clients are complaining that client program performance is extremely slow in Monday and Tuesday. I have used SQL Profiler and found sp_cursorfetch has longest duration. Most of them may use 10 seconds to return result (256 rows). I searched on the Internet and found some similiar cases but do not ...

sql commands don't update tables

yshie - 28 Mar 2007 7:39 AM - 13 messages

Visual Studio 2005 MS SQL Server i have insert and update statements. they don't produce any errors but no changes happen in my tables. are there any possible reason for this. i used sqlcommand and even stored procedures but still the same. ...

ERwin

othellomy - 28 Mar 2007 4:31 AM - 2 messages

Hi, I have just installed ERwin data modeler and can't seem to get past the 'connection manager'. In 'Master dafatase' I have put: master but it is saying invalid object master..m7License. I have enteretd the license keys during installation. Do I have to make any changes in the ...

Set IDENTITY_INSERT

Ant - 28 Mar 2007 2:59 AM - 3 messages

Hi, I'm using SET IDENTITY INSERT to be able to insert into an identity col. I have explicitly named every col to be added & set identity Insert on then off, as in the code below, but I still get the error that says: ...

How to install Windows 2003 SP2 on Cluster (with SQL)

nexdeveloper - 28 Mar 2007 2:07 AM - 4 messages

Maybe there's a better group for this post? Where's the definitive article on install a service pack on a Windows 2003 Cluster? I've found this article: [link] ...

RaisError in trigger

kei - 28 Mar 2007 1:58 AM - 8 messages

I use raiserror in trigger but the error message does not show in the calling application, why? e.g. set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER TRIGGER [UpdateWHBal_ItemTransaction] ON [dbo].[ItemTransaction] FOR INSERT AS PRINT N'This user has SET NOCOUNT turned ON.' ...

I can't Copy a database from Sql Server 2000 to 2005

Johan Garst - 28 Mar 2007 1:55 AM - 3 messages

Hi, I can't Copy a database from Sql Server 2000 to 2005. I am using the Copy Database option from Management menu. I want to transfer all tables, and all stored procedures. I've tried everything for the past 3 days, and it didn't ...

8.00.0276 still showing within SQL Server 2005

childofthe1980s - 28 Mar 2007 1:50 AM - 2 messages

Hello: We upgraded SQL Server 2000 to SQL Server 2005, last week. No issues arose. But, when we opened the SQL Server 2005 Management Studio, the phrase "8.00.0276" appeared next to the name of the SQL Server on the left (above ...

Database space monitoring.

Ritesh Kumar - 28 Mar 2007 1:24 AM - 5 messages

Hi can any one please help me or guide to some good article to create a script that has to look into the data file space and log file space for each database on sql server and if the database id running out of space then it ...

Bulk-Logged Recovery - Data Loss?

Scott H. - 28 Mar 2007 1:16 AM - 2 messages

Folks, Version: SQL Server 2000 SP3 I've been trying to determine from the documentation if there is any potential for data loss while a database is in Bulk-Logged Recovery Mode (BLRM), assuming that the server does not experience anything out of the norm. ...

SQL 2000 Service Pack 4

Meg - 28 Mar 2007 1:14 AM - 2 messages

I recently upgraded version 8.00.194 to service pack 4. After a re-boot select @@version still returns 8.00.194. The properties tab also returns the old version. I didn't think the SP had been installed, so I tried to apply ...

How to configure ports in SQL server configuration manager

Tim Meltzer - 28 Mar 2007 1:12 AM - 4 messages

Hi, unfortunately I mixed up the ip settings in SQL server configuration manager (I'm running SBS 2003 R1 with Backup Exec 11d and SQL 2005 Express). Now I have an event in the application protocol (3), it says that configuration for ...

Encrypting with certificate and symmetric key

Dave - 28 Mar 2007 1:02 AM - 2 messages

I posted the following question in the programming section on 3/19 and did not get any responses. Can anyone here help me out? ------------------ I can avoid opening a symmetric key when I decrypt data by using the new function "decryptbykeyautocert." ...

HELP: Problem with naming convention.

John Steen - 28 Mar 2007 12:51 AM - 3 messages

I'm trying to update a table in one database with data from a table in another database on the same server, but I'm having trouble with my naming convention. Here's the script (thanks to Russel Loski for providing it): ...

Permission issue

spremji via SQLMonster.com - 28 Mar 2007 12:43 AM - 8 messages

Hello, Some facts: - I am using SQL Server 2000 on W2K3 - I have a SQL Login called 'Rlogic' with dbo permission rights on every database. It is also a member of the Systems Administrators Group. In Query Analyzer, when I run the following:- ...

Local Admin access

stoney - 28 Mar 2007 12:22 AM - 2 messages

Hi, Can you give me reason why a SQL server DBA needs local admin access to the server it self. This is to convinece auditors. As a SQL DBA I feel we need to have full admin access. ...

Possible to alert on SQL Server Agent Error Log?

ssciarrino - 28 Mar 2007 12:22 AM - 3 messages

We have one SQL server where the mail may disconnect from time to time with the SQL Server Agent. Is it possible to flag an alert to notify when the SQL Server Agent produces an error in the SQL Server Agent Error Log? ...

Best Practices Analyzer

DXC - 28 Mar 2007 12:20 AM - 4 messages

Before hand, I Apologize if I am posting this on a wrong group. I have downloaded and installed "SQL Server 2000 Best Practices Analyzer" from [link] ...

Sending mail from sql server

sharman - 28 Mar 2007 12:19 AM - 2 messages

Hi, Is it any way possible to send email from SQL Server without installing Exchange server or MS Outlook or SMTP server? Can we link another SQL Server and use its settings to send email or is there some way out? Thanks in ...

Problem installing SQL Server 2005 Service Pack 2

apitman - 28 Mar 2007 12:17 AM - 3 messages

I tried to run the new SP2 and it crashes. I get the dialog asking to send the crash data to microsoft. I then checked the upgrade log and found a message saying that it could not log into the server. I know it had the right password because the service ...

Safely Importing Data from Excel into SQL 2000

Brian - 28 Mar 2007 12:12 AM - 5 messages

I am searching for an automated, safe method of importing data from Excel into SQL 2000. Ideally, I would like to use a DTS package to accomplish this, however, I am concerned of the security risks associated with the use ...

Installing 2nd (Named) Instance of SQL Server 2005 EE

MACason - 28 Mar 2007 12:02 AM - 3 messages

When installing a 2nd instance of SQL Server 2005 EE on a server, is it necessary to install Reporting Services, SSIS, and Analysis Services again? Does anyone know of any good documentation that discusses this subject? Thanks. ...

How to diagnose IO Problems

Dan - 28 Mar 2007 12:01 AM - 2 messages

Recently our production database began experiencing very poor I/O performance. How do I begin to narrow down the queries or tables that are affecting this? ...

How to setup Multiple tempdbs?

Jnadile - 27 Mar 2007 11:58 PM - 4 messages

Hi, We have got a huge SQL server 2000 box and we want to setup Multiple tempdbs for a multiprocessor machine, but do not know how. Anyone that can help please? Thanks ...

SQL Server removal from registry

startup options

Remove SQL Server 2005 from pc

Notification Email/Alert Email

missing ldf file

Brainbench test questions

SPN Registration Error

How to troubleshoot a strange result from a stored procedure?

Why was database restarted after log full?

Stored Procedure Problem

Perfmon doesn't show all the sql 2005 user databases

Investigating Deleted Records

HELP : all records of one table have been deleted!!

Error Message on optimization plan in sqlserver 2000

sql server error 17884

problem in connecting to SQL2005 on 64 bit machine

SQL 2k Table question

statistics question

Backing up MS SQL Server databases

Unable to modify maintenance plan

Problems accessing Oracle Linked Server data

bulk insert vs CLR stored proc doing transactioned insert

sql2005 sp2

export a table

Emulate Oracle's "Sequence" on SQL Server 2000/2005

Language issue on SQL Server 2005

Can move a file outside of PRIMARY to a new file group?

Monitoring SQL Server Error logs

HELP! Data Conversion Rounding Problem

SQL Server automatically partitioning?

Log backups not truncating log

SQL 2005 fails to register a SQL 2000 Servr on a connected machine

JPGs added to Image column are truncated at 1024 bytes (but only when import executed as a Job)

Loadbalancing and Failover for SQL Server and IIS!

SQL2005 Disaster

License Question

Keeping record of data changes

pageiolatch_sh

Backup question

SQL Server 2005 Express - allocating RAM

Urgent - I have restore weird problem

Converting string to unicode string in T-SQL

Help with manual Log shipping in SQL Server 2000

ssis problem

SQL 7 to SQL 2005 migration issue.

Free - Text Indexing

SQL Server 2005 transaction log backup view t-sql statement empty

Cluster W2003K , SS2K EE and memory=8GB

Connect to another server?