Attend this virtual conference for a deep dive into all things Microsoft & how core Microsoft tools and technologies can help organizations stay secure and productive.
A. Yes you can, but any un-committed transactions will be lost. This command is unsupported and undocumented so should be used with caution. It works on SQL 6.5 - whether it works on 7.0 is unknown...
A. To store/retrieve this sort of data within TSQL scripts you have to use the WRITETEXT and READTEXT commands rather than standard INSERT/SELECT statements. These are documented, with examples, in the books-online but are basically a real pain...
A. Here is a script courtesy of fellow MVP, Bob Pfeiff. Note, it will only get rid of one CRLF per column, so you may want to stick the update in loop and keep doing it until you get a zero rowcount...
A. NT Service Packs do not have any shared code that affects the SQL Server kernel, so application of NT service packs should be independent of SQL Server and should be applied based on the stability or otherwise of your NT system - plus it's...
