John Mitchell-245523 (7/21/2016)

---

You could try [font="Courier New"]sqlcmd -L[/font]. It works better on some networks than others, though. Read the sqlcmd page in Books Online so that you understand...

GilaMonster (7/21/2016)

---

The first wouldn't apply to Celko. Traceflags aren't ansi standard.

Some people, unfortunately, have an elevated opinion of...

Hi

A couple of suggestions:

(1) use the Registered Servers functionality in SQL Server Management Studio to create a group of servers that you wish to query, and run the query against...

Celko?

I don't think that the reviewers at...

It looks as though you're also going to have problems when handling strings / varchar() fields - you've not wrapped the values in quotes, so you'll generate an insert statement...

jasona.work (7/19/2016)

---

Lynn Pettis (7/19/2016)

---

jasona.work (7/19/2016)

---

So this is almost funny...

I'm happily working away, when I feel my cell phone buzz. Now, typically, during the work day, this is an e-mail...

I've had this problem on WordPress.Com - haven't got round to fixing all previously posted scripts. The problem is that WordPress decides to do the whole "intelligent quote" thing...

<voice=Brian_Blessed>Brandie's Alive!</voice>:-D

Not me - funeral-planning. No, wait. Planning...

This...

rk1980factor (7/18/2016)

---

to run the query you posted i have to connect to each server individually to check the backup, i want script which should remotely monitor or backup and create...

The query used depends on your own requirements.

For a quick and dirty view of the last backup date/time of each database, you could use something like this:

SELECT database_name ,

...

Here's the process I went through:

* For each ID, Generate the combinations as a separate field ('ER,TE,YT'), using the XML string concatenation trick

* For each of...

Just out of curiosity, how big are these databases, and how much data is changing daily?