You can use the help from the below link

http://www.sql-articles.com/index.php?page=articles/msysdb.htm

Can you explain in detail please. can't get what the problem is.

Use SQL profiler and trace for events on the particular table and the database. You can filter you criteria with SQL profiler.

Yes add it as a new named instance in your server.

Have you got this one sorted out.

Unless you have a business definition don't start creating table with _ always have names that are with the tables function. so that its easy to work on that.

Try capturing the events with SQL profiler to see whats happening when this command is issued. BTW why do you disable check constraints as it fails data integrity rules.

In the jobs you have to use the database mail profile to send mails to you once they are completed. You need to just add another step and use the...

You need it to happen immediately. You create a linked server to the other server. then create a trigger on the table for insert and update and then fire the...

It depends on your disk space. SQL Server has no restrictions to that.

Does the windows user which user are trying to use as a service account has got necessary privileges to work like logon as service rights, registry permissions, folder permissions, etc....

When using linked server are you using the four part naming convention. If so did you try running the query to see if the other sql server fetches results from...

Thats the only way you can rename the datafiles yet you can rename the logical file name using the alter database command. but the datafiles are physical and thats the...

as memtioned by the user above put those queries in the stored procedure and then try executing it. also check if the client machine have those options set as they...

You can transfer logins using DTS to you sql server 2005. Also you can use the script in the link given below

http://support.microsoft.com/default.aspx/kb/246133/

to transfer logins and passwords to...