You can add a trigger to syscomments but it is highly frowned upon for a number of reasons - only one of which I will state. Primarily modifications to system...

You have a choice

avoid dynamic SQL or avoid putting the SP in the master database.

If you cannot put things in the master database then you will need dynamic SQL...

I've seen this type of failure a couple fo times. Both were related to the AD account used in the cluster installation. In your case chedk out cluster_admin in AD....

First a few questions:

• Are you running backups through the SQL Agent ?
• Is your backup performed via a SQL Maintenance Plan or your own TSQL ?
• Can you post the exact error...

Try running your command at the prompt first. My guess is that since you did not provide either the -n or -c parameter to tell bcp the format of the...

I still say "run, run, run away from it" ...

But if your a true 'masochist' you could try downloading the latest and greatest from the HP web site and burn...

You can also just use the base command buried in the stored procedure: DBCC ERRORLOG

Steve, please do not stop reviewing things. It's one of the most positive attributes of this site - I know when I get a script from SSC it's OK. I...

It was too flaky. Granted it was free, but this product has 'tarnished' the company's reputation in my opinion. The candid email to explain things is spin control - just...

We have no issues with this. We even use a separate accounts for SQL Server and the SQL Agent. You say that the SQL Server Service domain account is a...

I would create the CDOSYS smtp mail as a separate SP then just change your EXEC line:

exec master.dbo.xp_sendmail @recipients = @vcMailRecipients, @subject = @vcSubject, @message = @vcMessage

Out of curiosity why do you need this information ? If you are using a SQL Maintenance Plan for your transaction log backups the actual filenames should be sufficient for...

If you are speaking of 4 million transactions (rows) per day I'd probably opt for a couple of things on the hardware storage side first. SAN storage for starters using Meta-LUNs as...

... in addition to getting a bit more 'old farts' ahve a wry sense of humor as well !

One 'old fart' to another !