Viewing 15 posts - 1 through 15 (of 16 total)
Good Day Raushan,
Thank you for your help.
got it working!
Have a great day!
August 29, 2013 at 2:05 am
Raushan,
I get the following message when I try saving this:
Cannot save 'C:\ServerUpTime.ps1.sql. The folder is marked as "Read Only'.
Can you assit with this error.
Thanks
August 28, 2013 at 6:40 am
Figured it out!!
Don't have enterprise edition.
Thanks
August 21, 2013 at 9:43 am
Thank you Richard for the script. Newbie to SQL Server and am using 2008 R2 and am getting the following error:
Cannot enable compression for object 'DatabaseGrowth'. Only SQL Server...
August 21, 2013 at 9:16 am
sqlpanther.
Thanks for helping.
I can't see anything wrong with this:
--clean up sp_who
USE [SQL_Monitoring]
Truncate table [SP_Who_Results]
--run SP_Who
Use [SQL_Monitoring]
Insert into [SP_Who_Results]
execute sp_who
July 25, 2013 at 11:46 am
sqlpanther, thank for your time.
I'm now getting this error:
Message
Executed as user: NT AUTHORITY\LOCAL SERVICE. Cannot find the object "SP_Who_Results" because it does not exist or you do not have permissions....
July 25, 2013 at 11:23 am
Thanks.
now getting this and trying not to throw hands up in air.
Date 7/25/2013 2:19:47 PM
Log Job History (DBA-SQL Monitor - Report Whats Running Now)
Step ID 0
Server AGV-SQLLAB
Job Name DBA-SQL Monitor - Report Whats Running...
July 25, 2013 at 11:21 am
Thank you for the reply.
yes, I understand that now and am now getting:
Date 7/25/2013 1:42:50 PM
Log Job History (DBA-SQL Monitor - Report Whats Running Now)
Step ID 1
Server AGV-SQLLAB
Job Name DBA-SQL Monitor - Report Whats Running...
July 25, 2013 at 11:00 am
Thank you for the reply.
yes, I understand that now and am now getting:
Date 7/25/2013 1:42:50 PM
Log Job History (DBA-SQL Monitor - Report Whats Running Now)
Step ID 1
Server AGV-SQLLAB
Job Name DBA-SQL Monitor - Report Whats Running...
July 25, 2013 at 11:00 am
Hello Kim,
Appreciate your script. I was hoping i could just copy and paste as I'm not familar with SQL as I'm a newbie. I received the follwoing error:
Msg 14261, Level...
July 25, 2013 at 10:29 am
Got it!
Thanks again.
July 17, 2013 at 10:24 am
Thank you very much Leonid. Perfect!
Since I'm running this on different servers, is there a way to list the server name on the report?
I would apprecaite any input on training...
July 17, 2013 at 2:07 am
Thanks Leonid.
Unfortunately, I don't have any SQL programming training.
I took what you had and tried to run it and had errors.
I will be under taking some training, however, in...
July 16, 2013 at 9:25 am
Thank you Leonio.
Newbie to SQl!
i need to get a report like this but that also details the last access date for databases.
How can i get this with your script.
Not a...
July 16, 2013 at 6:23 am
Viewing 15 posts - 1 through 15 (of 16 total)