You can compare schema with sysobject & syscolumns tables.

But it can't be automated.

It can be done in SQLServer 2005. It has DDL Triggers.

You can use table variables.

Declare @process table (col1 int,..)

Declare @pk int -- this may vary according to your primary key

Insert @process select .. from tablename

while exists (select top 1...

Do u have replication set up?

You are wrong.  You can not shrink transaction log to 0. What is your recovery model?

Backup Folder : It is not the way to take backup.

You...

Thanks Richard!

I have created a job to run shinkdb periodically.

I have one doubt. I am having union views on cross databases. Will it be a problem? I could find many...

Hi,

From the SQL Server Books online, it is found that it is not possible to use UPDATE FROM statement on a view that has INSTEAD OF UPDATE trigger.

There is no way...

No, I want to insert/update/delete records in the view.

I have done it using three instead of triggers.

Thanks.

Usually, this will happen if you have some huge datatype in your table.