Check these out:

http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech

http://www.sqlteam.com/item.asp?ItemID=5003

You can send an e-mail by using SQL Mail or SMTP. I am not aware if sending a fax or making a phone call is possible through SQL Server. If...

The "DBCC MEMORYSTATUS" command will provide the information you just sent.

But when I run this through QA or isql, it does NOT make an entry in the SQL logs, as...

I understand the difficulty you are facing. What I have is, on the master server, I have created the linked servers and the linked servers stay there all the time. I...

I could be wrong but, I think it is 2 bytes for any varchar or nvarchar field per row and one bit per page for any column that allows nulls. So,...

Why would you want to Re-Index the tables? The indexes will be updated as the data is populated in the tables. If you are considering dropping the indexes so the...

I am not sure, but you could try

"[LinkedServerName].[DatabaseName].[Owner].[UDFName] ([ParameterList])"

I have never tried this, but it might work. There are some commands like "Set Indentity_Insert On/Off" for example that do not...

Sorry Andoi, I don't know the answer to this one but would like to. The only way I can get an e-mail when members reply to this post, is by...

One of our Servers is Windows Server 2003 and SQL Server 2000 (Standard Edition) with SP3. Has no problems at all. But, then again this Server is used very mildly.

On...

I already am using SQL2000 with SP3, but still the problem. I have had SP3 for a little while now, but the problem only surfaced a couple days ago.

Well, I...

Here is my 2 cents worth.

I understand edwin_fredrick's point and he is quite right in brining it up. But, a scoring system is of little use IMHO. You can judge...

Sorry to get back late here, we had some other problems I was working on. Well, our hardware people said that there was nothing wrong with the drive in question....

Greg : We use the same method as you. But, we don't have an app that can combine all the scripts together from VSS into a single script.

The app you...

Thanks for the answers guys.

I have never used the 'Start'. It is a DTS package that is running and hogging all the CPU time. I am not sure if I...