thanks...that helped.i was looking for this xp...

Thanks ..

I was looking for an reason why its behaving differently...Is there data mismatch which is foricng it for NOCHECK and then enabling the CHECK....

I wanted the foreign key to...

Please advice ...

Do you mean to say what i thought before was correct?

If i have two nodes A,B and two instances X,Y .

If X,Y are running on A ,and B is idle...

select * from sysfiles.

or go to database properties.

We used to have a XCOPY command in a .bat file and is called by a windows scheduler task every night.If you want to schedule it then use this...

status 16 indicates that torn page detection is enabled for that DB.If you are using 2005 use sys.databases instead of sysdatabases.It has more info.

Query the sys.databases system table in master.

It is session based command.In your session if you set this option ON for one table,you cannot set it ON for another table.Server level will not be affected.

sp_help 'tablename' will get the info of foreign keys and table references.You can know the relationships between tables.Not sure about the diagrams..i think one need to create diagrams

For this case only i have given the solution above.

Users are for databases and logins are for instance.With log-shipping you shipped a database and so users will be shipped.But logins...

Create a user in the primary database with readonly permissions.Once it is shipped to secondary database create a login on secondary server with the SID of the user.Refer BOL...

You can also check with sp_help 'tablename' .You can see the new filegroup where the data is stored.

No ,dont change the recovery model to simple,you cant perform transactional backups and you cannot recover the database point in time.

Keep it in FULL as it is now.Schedule the index...

Create a maintenance plan for index rebuild and a job will be created for that.Schedule it weekly once or once in two weeks depending on your database size and...