I would take a look at Gail Shaw's article on SSC:

Managing Transaction Logs[/url]

Then do a search on Bing/Google/SSC for "Transaction Log size" or "Log size" and you will get plenty...

Is the database in FULL or SIMPLE recovery mode?

Is this due to running out of disk space or simple wanting to keep the log file size under control?

I would also look at this way...

If reviewing the transaction log backups consistently show that a particular period time of day they don't backup anything, then its a waste of...

Jeffrey Williams-493691 (9/2/2010)

---

Make sure the version of the client tools is at the same or greater version as the database you are connecting to. For that matter, make sure...

Yes you are correct if you disable it the extended stored procedures for SQL Server Agent are not accessible, then you will see the little red X on the node...

A PowerShell script might be an option. Not having done this before but looks cool:

http://msdn.microsoft.com/en-us/library/ez801hhe%28VS.80%29.aspx

If you check the "Community Content" at the bottom of the page it has a 2...

Duplicate post...this post already has response

You can use the undocumented sp_MSForeachdb procedure and then do something like:

EXEC sp_MSForeachdb '

USE ?

SELECT DB_NAME()

SELECT * from sysobjects

WHERE name like "%objectname%"'

'

Then this should only return data back for...

Since the application is the one throwing the error I would probably start with the documentation or vendor on the memory error you are receiving.

I would take a look at...

pshaship (8/31/2010)

---

This error occurs once or twice in a week and I need to run the profiler for 1 week continuously to capture the connection which may not be feasible...

Well that is true, sys.dm_exec_sessions is for seeing what a particular user/login is doing. Forgot about that.

Try using sys.sysprocesses (http://msdn.microsoft.com/en-us/library/ms179881%28SQL.90%29.aspx). This one has the dbid column to filter by the...

pshaship (8/31/2010)

But how to know whether the application is connecting to a SQL Server named instance by using TCP/IP sockets or not?

To fix this issue, do we need to use...

sp_who (less detail) or sp_who2 (more detail) are the most popular. They are pretty much what you see in the Activity Monitor, which is the GUI version.

With DMVs a good...

It's more of a best practice "if you ain't gonna use it, don't turn it on". DoD security checklist have the same thing. "Disable this feature if not required."

The "required"...

I would be Shrek...cause he gets to belch, pick his nose, and far#...oh wait he ain't a superhero...dang it!

He-Man hands down! Why = The Most Powerful Man in the Universe....