any suggestions on this is helpful..

The backup file name like  database_yyyymmdd.bak  .

We are  using the sql agent job  to take the local drive backup of all the databases   on the source and having sufficient permissions on the destination server .xp_CmdShell is...

SQL Edition is enterprise and version should be 2012.

No i am not using any CMS,  needs to configure on servers

i need to get the stored procedure details which are using xp_cmdshell  on all databases

Thanks  for the help ...

Do i need to execute the stored procedure  query on individual databases or in master db

i have  50+ jobs in my server its not possible to go each step in job  and see  whether it is enabled or not , is any alternative way to...

i dont have any db monitoring in place ,  i need to configure alert of t-log utilisation exceeds the limit  of all servers in one server .i.e on central server...

It will  give report when specific service is in stopped state   ,

Get-ServiceSQLAlert -ComputerList C:\ file .txt -includeService "", -To  -From  -SMTPMail

also it will not give correct data  for cluster servers...

Thanks for the reply i used the below script

Function Get-ServiceSQLAlert

{

param(

[String]$ComputerList,[String[]]$includeService,[String]$To,[String]$From,[string]$SMTPMail

)

$script:list = $ComputerList

#Make sure to check write acess on c:\ drive. if not, change the path

$ServiceFileName= "c:\ServiceFileName.htm"

New-Item -ItemType file $ServiceFilename -Force

#...

if any links provided is helpful  to me

thanks for the replies .

Thanks for the update .

Sone of the stored procedures having 3 naming  in the database if we restored with different name it will point to the old database name . How to resolve the...