How about DDL triggers at database level!!!

In case you have the original script of the procedure somewhere in VSS, just get the script and create the same here.

No Probs Suresh.

Good Luck!

Pavan.

I had/have a similar situation and I am implementing snapshot replication as the solution.

You might face few issues, but end of the day your task will be done.

Why dont you try copying the file from FTP to local server and then restore it?

Pavan.

Other DBA added an index(which is added in all other client sites), went out and I was not aware of it, suddenly the server was very slow and the its...

Check it and change it!

Select the database, right click properties--> Options-->Set Auto Close to False

It should be immediate.

It can be even like 2 phase commit, first it commits in the subscribers and then in the publishers.

pavan.

Select the database, right click properties--> Options-->Set Auto Close to False.

Hey Raj,

I had a similar issue, even my test mail was failing and it was giving similar sort of error.

While setting the db mail, in the SMTP server, I used...

First thing is what are the changes made in test environment

1.Like DDL changes (alter,create etc)or even DML changes(insert,update and delete to existing tables).

2.If only DDL changes, it shouldn't really matter,...

Was it working fine earlier?

Try sending a test mail and see the log for what's happening?

If the test mail is fine:

Go to SQL Agent Properties-->Alert System-->Enable Database Mail.

Restart the SQL...

Get the size of the database files and check for the unused space!

Set nocount on

Print 'Show Size, Space Used, Unused Space, Type, and Name of all database files'

Select

[FileSizeMB]=

convert(numeric(10,2),sum(round(a.size/128.,2))),

...

Mahesh,

When you are backing up multiple databases and deleting them (after retention), it fails even if a single database in the whole list fails and you get a mail saying...

Try it on some other computers also and see what its saying?