I too would like to know more about his alert. I had a job starting to fail due to insuffecient permissions on the Agent Account trying to access a...

Thank you both, I had never heard of this method. but I assume it was a triage method when out of disk space, accepting the risk of loosing point-in-time restores...

I was going to add a topic on this, but then I saw this thread.

In the following article, it talks about setting min server memory based on an equation, 24k...

Nevermind, can't do it within CMS, have to use Linked Servers.

1. Check the install log for SP2

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log

look for error related to path information or configuration

2. Check the Event Log

look for errors related to path information...

I am working with PBM with the STIG at DISA. We FINALLY got a 2008 server I could use to do this with. So I will share what...

Just a quick follow up.

I decided to go with SQLSkills, the HA/DR and the Dev Support/Sec/PS class.

I'll be there in August.

Alan.

I'm using Chad Miller's Powershell-based solution here for capacity planning.

http://www.sqlservercentral.com/articles/powershell/68011/

SSC,

Thanks for the reply.

Wouldn't looking at HostName just give me the name of the server?

http://msdn.microsoft.com/en-us/library/ms186265.aspx

I forgot to mention that Control-M Server is installed on the same box...

I have not used it in a long time, but TOAD is a very powerful tool to use. It is great if you are a developer too.

http://www.quest.com/toad-for-sql-server/

I just shut down the SQL instance and looked in the System log in the Event viewer. I don't see that EventID at all.

Thank you both.

I really wanted to know this. I don't like spending company $$ on basic tutorial training which seems to be more the norm in M$...

Small correction

It picks up System Stored Procedures, not just Extended SProcs. MSDB doesn't contain extended sprocs. It is picking those up as well, which is fine in my...

My filter is now N'%exec%sp[_]%'

I was picking up any execution with SP_ in it.

example:

create table #tmp_sp_get_sqlagent_properties

Now I will pick up only system extended stored procedures in either the Master or...

If you include the underscore within brackets, "%SP[_]", it will look for just that character.

See this section in the link from my previous post.

"Using Wildcard Characters as Literals"