No Backups or Maintenance was running. I was looking at active processes and nothing strange things were happenging at that time. The query (store proc) is called by aspx page and...

Oh, one correction

the query that we are using is dynamic cursor

>>> the query that we are using is NOT dynamic cursor

Hi SQLBill,

Yes, I actually was on sql cluster admin and watched it failed over. About 30min before sql failed and failed over, we saw hundreds of error messages from web...

There are a lot more then just start mail for sending mail.  Are you using Exchanging Server or POP3?

Here is one article that you might find interesting.

http://support.microsoft.com/default.aspx?scid=kb;en-us;153159

BTW, you don't...

Perhaps, some other folks knows good links about this. I usually uses BOL, Books Online, from SQL Server and try all different thing. I know sometimes, BOL is not easy...

If System Admins really wants it, he/she can do it especially with Windows Authentication. However, there are a couple ways to prevent System Admins to explore databases.

One of them is...

You are welcome

BTW, I put this script to find out database file information. I am sure you already knows it but just to...

For Backup Commend, there is no special about it. You can use any way to backup. Just create backup device and do like this.

BACKUP DATABASE MyDB to MyDBBackup_Device

And put...

First of all, please feel free to correct me if I am wrong.

Most of time, DBCC SHRINKFILE works but time to time, doesn't work and both Adam and Charlie method...

I am sure this is not what you want to hear but, let me explain about what I am doing for that just in case..

There...

Simple answer would be "WITH MOVE" option. Here is from BOL

MOVE 'logical_file_name' TO 'operating_system_file_name'

Specifies that the given logical_file_name should be moved to operating_system_file_name. By default, the logical_file_name is restored to...

First, sorry this is not an answer that you are looking for. But I would like to let you know that if you don't get any good response soon, I...

I'd try use SKIP and NOFORMAT option for that even though SKIP is for checking expired date, I usually put it there for initializing ones. Might not have to be...

I use both query below.

SELECT @@VERSION

SELECT CAST(@@SERVERNAME AS NVARCHAR(50)) 'ServerName', RTRIM(CONVERT(Char(20), SERVERPROPERTY('ProductVersion')))

+ ' = ' + RTRIM(CONVERT(Char(20), SERVERPROPERTY('Edition')))

+ ' - ' + RTRIM(CONVERT(Char(20), SERVERPROPERTY('ProductLevel')))

'SQL Server Version'