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...

Store the user and pwd in a table. Pass them to a stored procedure and return a 1 or 0, true or false, approved, failed, whatever.

No easy way to do this in SQL that I know of. You can return these in rows and then compute the number of distincts. Create a temp table using...

Third vote here. Detach dbs, use sp_help_revlogin (from MS) to script logins. Save of DTS packages, uninstall, reinstall.