what error message are you getting?

I do have second thought about the First part of the question.

As clearly mention "Consider the following table" and table says about the IDENTITY Column!! Hence we can understand that...

Hello Ron

I liked QOD... Really appreciate your efforts to bring hidden things to public. I feel question could have been formed better but that is absolutely managable. Though I...

Instead of any third party tool... Yes replication is surely better option. Schedule the job to distribute the data nightly from Publisher to subscriber. Also the advantage is you can...

you can also refer "sysfilegroups"

sp_helpfile

will also give you the filegroup info. Also you can refer FILEGROUP_NAME check following link for detail

http://msdn.microsoft.com/en-us/library/ms176088.aspx

If you have not performed any full backup in between Old full backup and latest differential backup than yes you will be able to perform the restore.

There are two ways:

1. Create Trigger on the table

2. Enable SQL Profiler for only one specific table and desire action.

HTH

I guess it could be possible. As two different instance on a same server will be distinguised by the different tcp/ip port. Hence I guess what you are planning to...

You have to create maintenance plan. But it is possible that you do not include any backup step. Also you can have only deleting files Task to your maintenance.

CHECK rebuildm.exe utility for sql 2000

And for SQL Server 2005 refer this link:

http://msdn.microsoft.com/en-us/library/ms191431(SQL.90).aspx

HTH

Yes, it is quite possible if you are using sql 2005 or higher.

Create a Maintenance plan and select maintenance cleanup Task. Go to property of the Task and there you...

Yes, that is the security file created during the SQL Server installation.

This clearly mentions that Database is recovering. The recovering process is a transient state; where database will automatically become online if the recovery succeeds. In case the recovery fails, the...

If you would like to create a Batch file simply do BCP out of a table into text and text file will be your batch file.