Hi

There is a article in BOL which tells how to upgrade within a existing version of sql server. check that out.

search "editions of SQL Server" in BOL.

As far as a...

Hi

there is nothing like compacting a db in that sense of the word. U can do frequent log backups to keep the log file size in check. Also you...

Hi

At first glance i dont think giving a alias name will casue any issues ( i may be wrong).

Is the value u r passing in "sChk " a...

Hi

staging table should have the same check constraints as the production tabble.

Agree with steve there. If your atributes are least like to change then you can have them as columns. Otherwise you can keep then user definable. Keeping them user definable...

HI

When u debug are u stepping into the IF loop?

Put the break point before the IF loop just to check.

Hi

Is the break point inside some condition?

Hi

CTE's do have performance implications. If your CTE is going to return huge volume of data then performance can come down.

Hi

Kenneth seems to right. you will be able to do this only if the production db and the db where you are going to restore is the same..... whihc means...

you can install the sql once more , give a different instance name than your existing instance.

While installing it will ask whether you want to upgrade existing instance or add...

Hi

Your best bet is to created a varchar (8000 or less) column if that is possible. then create a index on that.

Has ur network become slower ? Are there any heavy duty processes running on your db server.

Hi

My comment "You mean to say you want to bring the db in single user mode? " was intended for Maddy. 🙂

hi

Iam also working on a similar thing. Are u planning to use notification services or dB mail etc..

Please give more details so that we can understand better.

Hi

You mean to say you want to bring the db in single user mode?