REVERT

Tracking Database DDL Changes with SQLVer

Presents an open-source T-SQL based version tracking system for MSSQL

Alas Poor Snapshot, I Knew Him Well

Extending the REVERT statement using the WITH COOKIE clause in SQL Server 2005

In a previous tip on Switching Execution Context using the REVERT clause, you have seen how to switch execution context to a more privileged user and revert back to the original context of the caller within a programmable object. The REVERT clause accepts a parameter WITH COOKIE to provide an even more granular option. How do we use it?

RE: Script to "find" table...

Phil, that worked GREAT!  Thank you very much.  1/2 my goal is worked out.I now need to take each db indentified as possesing the "looked for table", and do a dump (xml, flat, whatever) of everything in it, minus data.  This would include sp's, triggers, tables, jobs, etc.. Any ideas?!  BTW, thanks again!

RE: SQL2K not releasing memory

Thank you for your reply.The server has currently got 4Gb RAM, I have tried setting the memory to fixed starting with 0 min to 1536 max. Reason for 1536 is because it is running standard edition and I read it somewhere that it can only access up to 2Gb of RAM, plus the fact that […]

RE: How to see the content of an .sdf file?

Sorry I haven't had a chance to play with SQLCE but are you saying your trying to attach to .sdf with EM from desktop or within CE device. See if this helps any http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnroad/html/road05222002.asp

RE: DBA's tasks in general (daily, weekly or monthly)

Some additional information that might be helpful is on this web site:

RE: SQL Server 2000/ SQLXML

That's the one. Only avaliable in 2K South African Edition. Cheers, Crispin