Not sure what you are looking for, but I use the below code to generate a SQL script. Could be modified to do interactive restore. We also use Litespeed,...

Here is some Powershell code, that I set up in a SQL job, to run every 30 minutes. I have a list of Instances in an AdminServer. I use...

A couple of reasons to test. One, is to ensure everything is working as advertised (it doesn't, by the way). Not all alerts get picked up automatically. Some...

Thanks Bob. Missed that in my earlier search. I guess MS must have had their reasons for changing it.

Leonard

See this post, for some Powershell scripts: http://www.sqlservercentral.com/Forums/Topic1506486-3451-1.aspx.

There is a zip file attached to the last reply. It doesn't have the code you need to execute a PBM,...

Here is a link to an MSSQL tip: http://www.mssqltips.com/sqlservertip/2397/sql-server-central-management-servers-system-tables/. That is an article that explains how to get the Central managmeent server list.

To access using a linked server,...

Here are some of the PS code I use. To use the instance table, create the table, using the SQLServerInfoTableCreate. Rename it if you like. The LoadSQLServerInfo.ps1...

I've never been able to schedule a job, to use the registered servers, although if i remember correctly, there is a way to retreive the list, if they are in...

This may be a good place to use Powershell. I have a scheduled job, that runs daily, that checks last backup date\time, and if it is older than a designated...

Nice article. I have done something similiar, however, I use Powershell, and run a SQL job as needed. My table is very similiar to yours. When I add...

SELECT [SPACETIME] FROM GALAXY WITH (Warp Speed)

i do this with Powershell. Job runs every morning, and checks to see if a backup, full or differential, has been run in the last 24 hours. Also checks to...

A simple update would take care of this.

Example 1 :

Update 1 column:

UPDATE TableName

SET Column1 = 0

WHERE Column1 IS NULL

Example 2:

UPDATE TableName

...

You should be able to connect with the ip address of the server\pc where the sql server is installed. Just use it in the connection string. A couple...

I do something similiar, with a couple of differences. One, I run the step as type PowerShell. The other thing I do, and I suspect this may be...