You could try creating a custom alert which is based on a performance condition. Specifically on the object SQL Server: Databases and on the counter Backup/Restore throughput/sec. Then set it...

 I used to use a number of queries against the system tables to derive this information but I found a link on this site to a very nice tool...

I prefer to script out database objects when promoting them to a new server. This way you are sure what is being moved and if an error arises you see...

Or even:

Select custId, lName, fName from dbo.Customers where CanceledOrder != 1

If you have a unique id in the table you could try this:

DELETE FROM namesaddresses

WHERE id NOT IN (

SELECT id FROM (

(SELECT DISTINCT id, firstname, surname,...

The simple steps to restore your master database are the following:

1.  Open a command window and run the code NET STOP MSSQLSERVER.

2.  Still in the command window change your directory to...

I used to use a number of queries against the system tables to derive this information but I found a link on this site to a very nice tool which...

It is under msdb...Roles.  It is a standard db role called TargetServersRole.  I know it is available in 7 and 2000, not sure abour 6.5.

To allow users to view job history, run status and other such things without giving the user sysadmin you will need to add some execute permissions to the user, or...

Hey,

There is a role in the msdb database called TargetServerRole.  If you add the user to that database and to that role they should be able to view jobs.  However,...

The vendor is correct that practice of giving an application dbo access is not a great idea.  However, it is not unheard of in many "Packaged Solutions" software.  In my...

Yeah, I thought of that but it still does not work. 

That works perfectly for jumping out of the loop.  I tried putting a print statement with the break to state the table name that the error occured on but it...

That did it.  Thanks so much.

I agree with you 100%.  I have just started here and am still working out some admin things.  Thanks for your confirmation.  At my last position we were involved in...