When did this problem start happening?

I was not clear if this is happening 24/7 or not?

Have you gone into task Manager checked show all process and sorted by Memory Usage...

Have you checked the following threads:

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

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

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

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/e4421665-215a-42e6-bdb8-0aa6cca2a78c

http://support.microsoft.com/kb/2008286

http://www.sqlservercentral.com/Forums/Topic800068-146-1.aspx#bm800361

http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/

http://www.bigresource.com/MS_SQL-Database-Mail-bC5q1LdQ.html

I hope this helps 🙂

Ah, I missed all the action. It is 3:48 AM here. While I was sleeping you guys were hard at work:-)

You can use the old way to find out what you script is doing by using sp_who2 to get the SPID and then use the DBCC INPUTBUFFER(SPID) to identify the...

Please check out these articles:

http://www.sqlservercentral.com/Forums/Topic673151-146-1.aspx

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/4c442212-e815-4d72-9988-7fc4bee39842

Could you please provide the error that you getting.

Have you check the logs, etc?

You should disable the xp_cmdshell unless absolutely needed:

http://www.sqlservercentral.com/Forums/Topic828767-386-1.aspx

http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SQL2005SecBestPract.doc

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

http://blogs.msdn.com/sqlsecurity/archive/2008/01/10/xp-cmdshell.aspx

Respectfully,

Welsh

I see that you posted this issue on another forum and the problem was resolved:

http://social.msdn.microsoft.com/Forums/en-IE/sqlsecurity/thread/ecec679e-1e50-4eff-beb1-283fb0fb8f54

Sorry but I missed your reply...

This Post should be closed.

Regards 🙂

Please check the following Link:

http://forums.oracle.com/forums/thread.jspa?messageID=3278968

I hopw that it helps..

Please check the following Link:

http://forums.oracle.com/forums/thread.jspa?messageID=3278968

I hopw that it helps..

Thank you Sir. If you stumble upon the SQLCLR Code someday I would appreciate if you could post it.

Thanks again.

Thanks for providing the script.

I'm feeling a little tired or I would have provided something.

Way to go! 🙂

You can write a script to extract the Users from the System Table and concatenate the SP to grant DB Access, add the user to a role, assign permissions etc.

I...

--------------------------------------------------------------------------------------------

I saw a couple of times that the database id was fine but then SQL was putting things in the NOT Like part of the filter, something like that.

---------------------------------------------------------------------------------------------

I suspect...

If you are a member of the SysAdmin Role you do not need to grant any Database Roles.

If you are a member of the DBOwner FIxed Database Role then you...