Tough Question but scored well.

Unable to find the content in the Doc... 🙁

I missed to copy the EXEC( ) statement....Anyways....found something strange..

It does not create any proc, instead throw the below error msg..

Msg 111, Level 15, State 1, Procedure usp_dbaadministration, Line 8

'CREATE/ALTER...

Sorry Fellas. Please find attached.

I tried to attach the .SQL file, which it did not allow to upload. So missed. Thanks Steve!!!

Ok.

I found a good one. : - https://www.simple-talk.com/sql/reporting-services/sql-server-reporting-services-basics-building-ssrs-reports/

One question to you, if I need to run the same proc to multiple servers, what's the most convenient method followed?? I don't...

can you refer me some of the docs to create the report where in I will call a procedure and will execute on different SQL SErvers?

Thanks . Attached my backup script.

note: just added the FORMAT keywords. When the failures were reported, I did have the WITH INIT one, (no FORMAT)

Hi Jason,

For you have a similar one to update stats of all Dbs?

Hello Steve and Experts,

Occassional failure of my backup job:

I have a custom SQL Bkp job, which fails with the below error msg while it runs by schdule:

Error 3013, Severity 16,...

HI Jeff,

Good Evening.

Below is the script, I have written..but my woorry is the table in Mailer, does not populate with the records,. I surprise it may be due to datatype...

I managed that from msdb..backupset.

It's stuck in the conversion...Tried a lot, no luck. 🙁 Confused in the conversion..

NO Error....Only thing is that my mail alert does not have the table/with the details in it....

Wjhy are you passing "0.0 MB" as Griowthrate????

IF Not Exists (Select Distinct DBName from #TempDBSize2

where DBName in (Select Distinct DBName from DBGrowthRate))

Begin

Insert into dbo.DBGrowthRate (DBName, DBID, NumPages, OrigSize, CurSize,...

HI Steve,

There are many links which does not open. Even this too.

Is this something like blocked by Admin team in SSC or some issue with webpage?

http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62497/

Thanks and have a good...

This is an effective way to find DB growth for sure, but if the backup job failed for 10 days and none had addressed it (rare case), then of no...

Hello Mike Tutor,

Can you please paste your script here to know what kind of chyanges did you do to get daily alert/reports?

Thanks.