What version of client tools are you using? I can register my SS2K servers, SP3a on W2K from my W2K3 server.

What error are you getting? # and msg?

I'm not sure if this helps the server, but dbcc freeproccache will clear the cached plans from SQL Server. Might allow some memory...

Might try here: http://www.vba-programmer.com/

Once SQL Server has the memory, unless the operating system requires it, it will not get released. How much memory on the server and what does SQL grow to?

QA and...

select * from information_schema.columns. Sort, rearrange as you like, then save the data into a file. (CSV) and open in Excel.

T-SQL, or Transact-SQL is from Sybase and I've been working with it since 92, when it was SQL Server 4.2 on OS/2, ported from Sybase v4.2 on *nix. I'd suspect...

select

case when t.type = 'D' then t.amount

end 'Debit'

, case when t.type = 'C' then t.amount

end 'credit'

from Transactions t

gets you them...

You should have your maint plans create a jog. The error code in the job is worthless, check the log.

If 2 is cast as a datetime, isn't it converting a null to 1-1-1900 then adding 2 to it? The explanation says:

The null value in SQL Server is converted to...

The explanation wasn't worded greatly and has been corrected. Also, the ordering can't be known, but it's assumed, at least by me, that the "second row" referred to the NULL...

I think you need to delete this file and initialize a new one for SQL Server backups.

Also: http://www.sqlservercentral.com/columnists/bahmed/backupscenariosforsuccessfulsqlserverrestoresandre.asp

No good one I've seen. Maybe mail the owner of this site: http://www.vba-programmer.com/RefDocs.htm

No,

hopefully in 2k5, but no way to do this now. I've administratively (through email/memo) set a policy and then used NGS Software' SQLCrack to look for passwords that don't meet...

This can and does occur. I think it might have been fixed in a SP so it's not the default, but it does happen. It might not happen on YOUR...