One other question, is there a method to do this backup (of the table) without putting a lot stress on the production server (ServerA)? For example, without writing to the...

I want to do a full server backup which would include the O/S, sql server backups (.bak files) and vendor application files.

Thanks, Kevin

Does fragmentation only occur at the index level? Does it occur at the non-indexed table level? Can the database files (.mdf) become fragmented?

Thanks, Kevin

I am using this scenario to get a better understanding of the Transaction Logs. If I take a complete backup at 3 A.M. and run Transaction Logs Backups every 15...

What option or sql command can be used to remove fragmentation?

Thanks, Kevin

We are using Business Objects XI. Please just let me know the different ways I may set up a BO Connection. (I do not have a lot of information on...

I am using VBScript to do some other processing with the Table Data.

Paul thanks for your reply. I was shrinking the database because of a large data delete (100 GBs) with the 2nd DBCC Command below. I was trying to execute the...

I do not think this would work because I still want the DTS Package to stop executing if there are errors other than duplicate records.

Thanks. Can I use the same outer query to get a net of (Amount1 minus Amount2) for all records in the result set?

Thanks. Can I use the same outer query to get a net of (Amount1 minus Amount2) for all records in the result set?

Thanks for the queries. The following query is returning 7-2-2005 instead of 6-30-2005. I have to review it more in depth to see were the problem is.

/* Previous months last...

I have just discoverd that my two tables contain duplicate records. I think this is why the code is not working properly. The tables have an index but they do...

The above provided query is not working for me.

I need to compare the shares, price and market_value columns of the two tables. The below query is not working, it...

I am restoring from Disk. In BOL under the Restore Command Subject states:

RESTART

Specifies that SQL Server should restart a restore operation that has been interrupted. RESTART restarts the restore...