Very heavy usage of CPU sos hould avoid during normal hours.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Its all about virtual log files and that you need to get back to the beginning before you can truncate and shrink the physical file.

The basic process is

Set the recovery...

There is a great article on SQL mag about retoring backups, including file backups, differential backups.

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=25915

You will need to register.

Simon

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

Many areas of possibility, if you want to code this the SQLDMO is probably your best option. This is want enterprise manager is based on

Simon Sabin

Co-author of SQL Server 2000...

Put it this way MS found it difficult to find a source of data that tested the limits of SQL server and came up with satellite pictures and thus terraserver,...

The only reason I have to have user sps in master is to be able to run them from any database with out the need to copy them to that...

How are you calling the stored procedure in .net. It looks like you are not using parameters, which could be an issue with compilation.

What is the SQL of the report?

Simon...

Sorry not possible.

Not sure what benefit you get if the billingdate and vehicletype are indexed.

Also using <= today generally doesn't benefit from an index because it doesn;t filter the...

If your SQL 7 was not licensed under a downgrade i.e. SQL2000 downgradedto SQL 7 you will have to buy new licenses for SQL2000 as of 1 July, when MS...

Your function in the example is not restricting on the billingdate is this an issue.

I thought in line functions get optimised in a similiar fashion to views, but I would...

is the location being specified as a UNC path. I have known in the past with w2k selecting a UNC path but what got stored is a local path to...

Do you have any amount of down time ?

Log shipping is another option.

The name thing is biggest problem I see. How do you have both servers up but called the...

Apart from the security issue dynamic SQL is not bad if it is written using parameterisation (sp_executesql).

It is the easiest way to perform complex searching where the search conditions...

Quickest way to copy data from db to db is select into, from server to server is bcp out and then bulk insert in. Putting exclusive tablelocks speeds things up...

It would be so nice to have global variables

Anyway to get hold of the username 2 options I know of,

use SETUSER on each connection...