one small syntax error - edited above. re-read my previous post now. Sorry!

I don't have any of your underlying data, so I no way to test - however...

Wow - lots to work with. Most of the sub queries are using subtotals on the same table, and are set up as correlated sub-queries, so each row and...

...never mind the loss of ability to use point in time restore should newbie destroy sometihng in DB prior to next full backup....

Well - you could always use the second syntax I'm throwing at you.

Otherwise, here are a few "space-saving tips":

1. The ONLY select in the long sequence of UNION ALL select...

Sounds to me that you're now actually talking to the server (meaning - we've managed to get the error to change).

18452 in a "pure windows" mode can be...

1. well - with the question wide open like that - there are several options. The most general way to do that is through a series of INSERT statements.

Insert...

If I understand the LDAP description you should be able to refer to badpasswordtime.Lowpart and BadPasswordTime.HighPart (assuming badpasswordtime is a valid name - I didn't actually look that one up)....

Using the same class doesn't in itself negate using multiple tables (that's what inheritance is for). I prefer the separate tables approach, and using the sub-classes/inheritance in the app...

Is the SQL Bowser service running? If it isn't - turn it on, and try the login again.

Also - are you trying to use mixed mode or windows auth...

I shudder to even imagine what you would need that for. The management report is going to be more torture on the system than the system will generate for...

....or -

select isnull(secondaddress,'') as secondadd_notnull ,

....

I think you're running into a red herring - try this:

Select s.*

INTo linkedserver.mydatabase.dbo.testtable

From

(Select top 10 *

From dbo.localtable) as s

You want to look at something like this (very generic because your example code is mangled)

Select giver.name,Env.RecieptNum, Env.Date,

sum(case when then envamount else 0...

The thing you have no described is what you'd like to get. tell us what you'd like to pass in (as parameters), and what the resulting output should look...

Am I missing something - SQLExpress has alerady installed the Native client components on your machine - why are you needing to reinstall them? BOL and SQLNative client are...