Hi,

you can use SQL Server Agent Alerts which can notify you about Restores.

Take a look here:

http://www.sqlservercentral.com/articles/Administration/alertalertbackupandrestorebaby/1253/[/url]

Regards

Dirk

The very first post has a link in it´s footer:

http://www.sqlservercentral.com/Forums/Attachment5016.aspx

Hi there,

it´s the same on my side.

I look out for useful scripts, tools etc and adapt them.

The repository mentioned in the tacklebox is running on one server in the company...

I never tried it in this way...

What I did to run the solution:

Implemented the proc and a corresponding sql srv job on each server.

Now I get from every server a...

Look at the very 1st post.

There is an attachment with the script.

It has an .txt ending.

Regarding the code:

Inside the whole SP, there´s one variable called @TableHTML which will...

What exactly do you need or in which part of the sproc do you want to declare an additional variable?

alnawrass2002 (4/8/2012)

---

How can i declared a variable at the beginning of...

Sorry Christopher,

I completely forgot to look after the modification to get rid of the overflow error.

The only difference I have found is in line 330 (depending on your editor of...

Hey Ron,

first of all: thanks for your article.

Only one little thing. The pdf you´ve mentioned (SQL Server Instance Health Monitoring Tool) cannot be opened.

I get a message from...

Thank you frome22. Now I have something to read this morning 🙂

I have to take a look on monday when I´m back in office.

Also had the error in the beginning. Just changed a variable or column of a temp table since...

Hi Ian,

thanks for mentoning the book. It´s now on my wish list

The sample chapters look promising.

Regards

Dirk

Hi Ron,

I tried to take a look into the paper you´ve mentioned (SQL Server Instance Health Monitoring Tool) but it seems that the pdf is broken. It says the data...

Hi Gail,

thx for the reply.

I have already SQLFool´s index defrag script[/url] placed into an admin db to use it on that instance.

Regards

Dirk

Hi kvr,

I would say no.

Maybe a slight increase in CPU consumption (as Paul already mentioned) if you have a system which writes/modifies a lot of pages.

So run your databases all...

Steve Jones - Editor (9/2/2010)

---

...

I would love to see a server level role that allowed someone to add a login, and a user for a specific database (s) only....