JF1081 (4/1/2010)

---

I googled it and the first item returned was a SQL server central thread. The link took me to the middle of the thread and I thought to...

That is parameter 255 of the optional set 😉

You're welcome.

1 million per month is more than they earned as a couple per month over the last ten years. Poor desolate woman.

One of the houses is strictly for laundry....

Joker

I think I would explore other alternatives than the maint plan from the UAT server. Some possible options: ssis package, Powershell, sql script using xp_cmdshell, or an OS...

You would be better served by starting a...

Awesome article. I particularly enjoyed the possible uses of the queries provided.

And those DB Mail accounts can be accessed and mail sent via each one through script.

Another option could be notification services, which too can use a script to send email...

Please provide more info. We need sample queries that you have tested as well as table structure. In order to test, we would also need test data provided.

Rather than use the notifications, use an additional job step. IN that step write a query that will execute the mail send task and specify which mail profile to...

double post

You should be checking sys.database_principals to see if the user exists or not.

Please provide table definitions for the tables involved in this query.

Just reiterating what has been said. SQL 2005 does not store this information like SQL 2000 and prior. You will need to check your invoices.