If you're using SQL 2005+ you can also setup an Event Notification for all the Audit_Login events. I'm implementing this now. It's easier to off load the service broker queue...

I found this for you, though not sure if it will work. Here's a link to the thread in case you want to see the whole discussion http://www.symantec.com/connect/forums/security-update-sql-server-2005-service-pack-3-kb970892-fails-install.

Microsoft's...

Through the GUI (i.e. SSMS, Enterprise Manager)...

2005 - Linked Servers are listed under Server Objects within Object Explorer

2000 - Linked Servers listed under Security

So, late in the day, I received the 12th email to this saga. We were instructed to notify the users as a courtesy. That's like emailing the users when I...

A simple way to set "Output to Text" is by pressing ctrl+t and ctrl+d sets the query results pane back to grid.

By default, I believe results to text only outputs the first 255 characters or so. Go to Tools >> Options, Expand Query Results, Expand SQL Server, and Highlight Results to...

The OSQL command will be depricated in a future release. You should use the sqlcmd utility, which has the -o option allowing output to a file. As stated before, SSIS...

The code is right. The problem is a permissions issue on the directory you're trying to write the backup to. I believe SQL Server Service account will need write permissions...

It could be a permissions issue on the procedure since you renamed it. Have you granted the appropriate user\group execute permissions? That's the only other thing I know to check.

Have you tried verifying the database or checking the Database settings from within Crystal? Go to the Database menu to check all the settings and field mappings.

There are a ton of SQL 2005 books ranging across many topics. The Inside series are some of the best. Are you looking for info on the new features in...

You can also use the RESTORE FILELISTONLY command to see what databases exist in the .bak backup file.

Example:

RESTORE FILELISTONLY

FROM DISK = 'enter file path with filename'

According to BOL, they recommend now using the dtexec command prompt utility (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlcmpt9/html/89edab2d-fb38-4e86-a61e-38621a214154.htm)

This is utility appears to have many options for executing and logging SSIS packages, which are precisely what...

Maybe the test DB is set to Simple recovery and production is set to Full. I doubt this would cause a 10.75 hour difference in execution though. It sounds like...

"A full database backup backs up the whole database. This includes part of the transaction log so that the full database backup can be recovered. Full database backups represent the...