Deepak

Thanks for your reply. Does that mean that i download SP2 and install it... nothing else to be done.....

by the way have you done this...

Hi

you will have to write a dynamic query in the procedure for this.

faboudib

If the values in this column will frequently change then this may not be a good candidate for creating a clustered index. In general its not a very good...

Hi

Do you have any char Foreign key columns pointing to UniqueIdentifier Primary key columns.

Hi

Dont know whthr this will help or not.

U can add identity columns to tables after u create the tables and import data into tehm. Identity values will be created...

Hi

Only one table can be SET IDENTITY_INSERT "ON" in a session. See whthr you want to set identity insert for multiple tables in a session.

Or you can set...

Hi

Did you check your installation. I think you can reinstall client tools so you will get query analyser. You can use osql utility to execute sql queries/ procedures from...

Hi

Are you sure you have set the On Delete cascade correctly everywhere its required.

Are there any circular reference anywhere in this chain or any triggers.

Hi

If you are taking regular log backups then your log file size should not grow to a large size. You can shrink log files only when you feel they have...

Hi

Auto-close means that database will shut down after the last connected user has exited. U will disable this. U can do this by taking database properties\options.

This is a feature that...

hi

if its system error messages you want you can put the error number (@@Error) in a variable and fetch the corresponding error description from sysmessages table. Then you can put...

looks much better now.... thanks for making the changes

hi

looks like the page may be corrypt. you will have to run the dbcc checkdb or dbcc checktable .

Hi

i think the sql server name (instance name)

may be 'ABC-CDEFGHI-JKL'. u must have installed default instance of sql server.

execute this and check the server name

select @@Servername