ssismaddy (3/30/2010)

---

Hi, I was asked to give the statistics of the disk usage of all the databases in our production servers for the last 3 months. Is there anyway that...

Well first are you trying this...

I usaully install the .NET framework prior to trying to install SQL Server. I will tend to install it and then Windows Update to patch it to current.

This is the MSDN (aka Books Online) that show the DMVs used in SQL Server 2005:

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

Then sys.dm_tran_locks will shows you the locks currently active (http://msdn.microsoft.com/en-us/library/ms190345.aspx)

sp_who

--OR

sp_who2

Executing one of these commands in query should give you pretty much what is shown in Activity Monitor

If you have Windows Authentication allowed...can you...

Attached the script, formated for those interested 😀

Marios Philippopoulos (3/26/2010)

---

The owner of any job can drop, create, modify any database objects in the SQL instance (including databases themselves), since job is running under the SQL Agent service...

http://connect.microsoft.com/SQLServer/feedback/details/414108/ssms-2008-activity-monitor-fails-to-monitor-sql-2005-cluster-instance

Not that his has the fix but it does mention to ensure the user account running Activity Monitor has permission in the "Performance Monitor Users" Windows group.

I don't recall ever having that problem. Have you checked to see what build number your management tools are at, may have gotten fixed in the service packs.

I like to check the logical name as well to make sure I have the MOVE statements correct:

RESTORE FILELISTONLY FROM DISK = 'D:\FullBackup.bak'

Came across this post that he did it with Windows Vista

http://www.igregor.net/post/2008/01/Installing-SQL-Server-2005-Reporting-Service-on-IIS-7.aspx

To output to a file just create a SQL Agent job and then under "Advanced" for your step set the "Output File" to your desired location. Then you can...

Yeah...no luck here either without CTRL held down.

I found they that the option under Text Editor > Any Option > General, includes an "Enable single-click URL navigation". This was...

if that is the full script you are using. You must have a DECLARE statement for the @message. You could also just put the text straight on the...