I believe when I got that error rebooting the machine took care of it.

Hello

I found this forum that discussed the problem:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82093

at the bottom of the discussion this is how they got it to work:

On our SQL Server 2005 development...

John Doe (7/2/2009)

---

I need to know what drive sql server 2005 is installed on? Is there anyway we can find it out using TSQL? I found some info on WMI...

If this is SQL Server 2005 Try this:

USE [master]

GO

EXEC dbo.sp_dbcmptlevel @dbname=N'Database_Name', @new_cmptlevel=90

GO

The default owner of the db_owner Schema is dbo. Use this to change it back.

USE [DatabaseName]

GO

ALTER AUTHORIZATION ON SCHEMA::[db_owner] TO [dbo]

GO

I checked out this problem and the answer seems to be to Log into your terminal server remotely or through the remote desktop utility. Open up SQL management studio on...

So your just trying to get this to your phone? And looking at the address you have that states your trying to send it to "phone number@provider.com" ...

Hello

Yes you can do this by creating a new role. I call the role sp_execute. You then add your role members (the users who will be able to execute the...