anand13685 (2/16/2011)

---

If you have access to SQL server error logs...which any DBA would....just check the time when the SQL server was last started, and in the startup parameters, it gives...

Thordog (1/21/2011)

---

Rudy Panigas (1/21/2011)

---

The code will not work on a cluster unless you run it from the node(s) and not from the virtual SQL server.

Give it a try and...

If your SQL servers are in a data center, say in your building, isn't that a "Corporate Cloud"?

I think the cloud will go the way of out sourcing. A...

Thanks Sarab.

Nicely done....

michael.wanke (2/14/2011)

---

I do like the idea of removing the cursor. Either an update as already suggested or the SQLServerName column could be changed to use a default:

[SQLServerName] [nvarchar](150) NULL...

Willem Gossink (2/14/2011)

---

Not knowing enough about SSIS, I devised another solution in which a central (management) server retrieves SQL error logs from managed servers and stores them in a central...

This code was...

alen teplitsky (2/14/2011)

---

thx

i've been meaning to add this to my daily data collection. i'll probably just change the process to use SSIS to import data for numerous servers into a...

abacrotto (2/14/2011)

---

I'm sorry for asking something that simple. Why would you use a Cursor and a loop for updating the server when you can use an SQL UPDATE statement instead...

hakkie42 (2/14/2011)

---

Aren't you missing a

USE [ErrorLogStorage]

GO

in the database creation script? When I ran it, it created the ErrLogData table in master...

Apart from that, a smart solution: why struggle with...

nick.welham (2/3/2011)

---

Two questions, if someone could help me please!

1. Does the Master DB contain the server Master encryption key data or should I add this separately?

2. I know the Master...

I think companies will use cloud computing to off load the security liability. If the data is lost/stolen they can then put the blame on the cloud computing supplier and...

Markus (2/3/2011)

---

I try and do this after a patch or when I know I have an outage window. It is always good to have an easy way to get...

mohammed moinudheen (2/3/2011)

---

Rudy,

The title of this article is really catchy.

Regarding this section: It's All Proactive

You are referring to a SQL Server instance which is running fine right?

I am assuming...

Hello everyone,

Thanks for all your comments. Looks like some people like and dislike the article but this is to be expected.

Apparently some are commenting that the article name is misleading....