Seems you have a couple records with two dates in there.. fix those and it works fine

So its probably not the most elegant solution and may not even be viable depending on your situation. but you can always have a job that runs a delete...

Alright.. I think this might what you're looking for with a pivot-ish solution. I found this on another site and retro fitted to your code ( I just used...

well, that device does stink, but it seems fairly easy to set up what your trying to do. You create a private network with (DHCP) and then...

Hmm, I thought it was set to auto manage by default..

I am assuming you created the server level logins on the 2005 box. My first guess is that the logins in the DBs are not matching the server level...

Are you actually out of disk where the temp log file lives?

Or if you don;t have an 80K Doubletake license.. Set up your SQL 2005(64 bit), set up your logins etc, Backup your current prod, and restore to the...

The suggestion above to set the expiration at the account level in AD will suffice.

Although.. According to MS, SQL 2005 does not need to be restarted to...

We have exclusions for our service accounts within group policy. The admin may not know or may just be telling you that because he doesn't want to deal with...

Try this... I forget where I got this from

SELECT TOP 50

qs.total_worker_time/qs.execution_count as [Avg CPU Time],

...

We have run into a similar issue.. we ingest a bunch of files daily from 8M rows to 50K rows and on our 2000 boxes they all ingest relatively smoothly...

The correct one will render what was mentioned above:

CREATE LOGIN [User] WITH PASSWORD=0x0100..5A5B11 HASHED, CHECK_POLICY=OFF, SID=0x199F..E19

Which is what your looking for I beleive

Thanks,I ended up doing

Case @Sortby

When isnull(@sortby,Quantity) Then Quantity

Else Null

Having the task scheduler running during install will allow it to install on the second node, but it would probably render a different error(well, it did for me)

Did...