Quick without looking it up… what does this script do: SELECT * FROM dbo.sysfiles WHERE (status & 0×40) <> 0 So if you’re like me and don’t have all the bit compares memorized for all the tables you probably didn’t know that this is how (in SQL 2000) you would query the current database to find all the transaction log files. Every now and [...]
Posts Tagged ‘SQL 2000’
SQL 2000 Replication… changing Recovery Mode
Short Answer: YES It had been a while since I worked with SQL 2000 Replication so I was fairly confident that you could but wasn’t willing to just go and do it without a proper test first. I took at copy of the database that I was looking to do this on and built myself [...]
String Concatenation on a text column (SQL 2000 vs SQL 2005+)
So most of my blog posts are “inspired” by questions that gets asked to me either in my day to day work or from emails I get from friends (usually developers hehehe) who need a quick answer on how to do something “SQL” related. So my blackberry started buzzing at 11:30 pm one evening… well [...]
SQL Versions, Editions, and Features
When putting forth a recommendation for a version and edition of SQL Server to install it is important that you understand what features are available in each version and edition. SQL 2000 – http://msdn.microsoft.com/en-us/library/aa175266.aspx SQL 2005 – http://msdn.microsoft.com/en-us/library/ms143761(SQL.90).aspx SQL 2008 – http://msdn.microsoft.com/en-us/library/cc645993.aspx These 3 websites give you a very detailed look into each version and [...]
