I got this fixed.I had to change the enforce on parameter to client rather than server.

Please go through the following article and you may find the solution to your problem.

http://support.microsoft.com/default.aspx?scid=kb;en-us;288890

Thanks don

Hi,

I usually fall into this kind of situation.

I take the backup of the trascation log with no_log command and then shrink the file.

Once it's done i take the backup of...

What I think is, it is not the covered Index which is making the system not to choose parllelism but the effective execution plan which the system is generating is...

If you cannot do it with linked servers try remote servers.

Valli,try to create the link servers first or else you cannot execute the remote stored procedures.

Example:

EXEC servername.databasename.dbo.storedproc.name

you can execute this from within the stored procedure or individually.

Try this.

select * from LSERVER.databasename.dbo.dbfcustomers

Try this.

select * from LSERVER.tablename.dbo.dbfcustomers

No you cannot.

Initially Linked servers need to be configured and execute the stored procedure with the server name, database name , sp name.

EXEC servername.databasename.dbo.storedproc

You can print it directly from the QA but not sure if you can get the color.Never tried to print out the query on the color printer.

I have tried attaching single file but it is not working.Does the database needs to be existant previously on the server I am trying to attach.Can I give any name...

DavidBurrows, I have tried to attach the database but it did not help since it was asking for the existing database name.I am not sure if I am doing it...

Greg Larson can you explain little more on importing thr tables from the access.