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 2005’
SQL Server 2005 Edition Upgrade
As most of my posts are inspired by stuff I’ve been working on or have worked on recently this is no different. A request came in to upgrade a SQL Server 2005 Standard Edition Instance to a SQL Server 2005 Enterprise Edition Instance. Funny thing is that I’ve been working with SQL Server 2005 since [...]
Pivot…. I said PIVOT!!!!
Apparently I must of skipped this entry in BOL when I was going through and memorizing it LOL… I had a “brain fart” yesterday when I tried to use the PIVOT function and I just couldn't get the thing to work. I had used it in the past and thought maybe it was just late [...]
db_Executor Role – updated
In a passing conversation the question about how you grant execute to all stored procedures to a user came up. In SQL 2005 the ability to grant the execute permission at the database level was introduced. Instead of having to build some 'smarts' into a script to cycle through all your objects, etc you can [...]
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 [...]
