From what I have read only Database Mail is supported when using SQL 2005 64 bit edition.

Since SQL is running as 64bit it is not viable for it to communicate...

Here is how to embed the creation of the view within the sp_MSforeachdb proc.

Please note all quotes are single quote character (') that may be repeated up to four times....

Even though you have a left join in your original select statement, your where clause requires a successful (inner) join to match the criteria based on ExpHybrid.

If you want all...

Al,

You say you created an automated backup routine. You do not mention how. If it was with the Database Maintenance wizard this would create a fresh backup file each time.

However...

The total size of the length of all the fields in the select statement comes to 8458.

You need to reduce the fields in your select statement.

If you have implicit field...

WIthout knowing if you have got a different fields for the brokered and regular amounts, you would need a case statement for each field to be outputed.

The following script should...

Thanks for the replies.

Binnie - the KB article applies when restoring a database. This is not the case here.

Alzdba - I had renamed the old ldf file and then used...

Even though got around the issue, here is some code that should work. Effectively use the case first to test your parameters, then test the field you want to filter...

With SQL2000 abilities to have named instances, you could have up to 16 sqlserver.exe running.

I have seen a similar occurrence - After I have installed SQL2000 Standard for our product,...

You could achieve both a primitive load balancing and fail over using Active/Active with two SQL instances on each node.

This does however revert to your original recommendation that the Authoring...

OK Strippy,

Have a good look at the following code:

Given that you cannot create any objects, not enough temp tables, will just have to utilise derived tables and subqueries.

Here is my...

Between reading the original response and writing this answer, there have being several posts.

Now I am not sure whether I should post the solution since it was an exercise given...

If you are actually attempting to change the value by factor for all records in TableB, use t-sql code like the following. This uses the power of sql set theory,...

Given the sequence number always indicates the order, and effectively the list wraps back to the beginning, using the captured data of the last sequence number (@LastSeqNumber) on which video...

Here is a way to get your desired results.

Does not use the UDF, but it does use a temporary table whilst it generates the list of children per parent.

The use...