108 reputation
5
bio website ryanbseattle.myopenid.com
location Greater Seattle Area
age
visits member for 3 years, 6 months
seen May 28 at 0:37

SQL Server DBA


Jul
24
answered SQL Server : CheckDB runs fast enough on one database, agonizingly slow on another
Jun
30
answered sql log backup expiration settings
Jun
11
answered How do I data warehouse a set of tables and delete the source?
Jun
6
awarded  Supporter
Jun
4
revised 32bit SQLServer with AWE NOT enabled. Buffer Cache Hit Ratio High, Disk Read Queue VERY HIGH, WHY?
added 1 characters in body
Jun
4
awarded  Revival
Jun
4
revised 32bit SQLServer with AWE NOT enabled. Buffer Cache Hit Ratio High, Disk Read Queue VERY HIGH, WHY?
added 189 characters in body
Jun
4
awarded  Teacher
Jun
4
answered 32bit SQLServer with AWE NOT enabled. Buffer Cache Hit Ratio High, Disk Read Queue VERY HIGH, WHY?
Jun
4
awarded  Scholar
Jun
4
comment SET RECOVERY Model Using sp_msforeachdb
Thanks a lot. I hadn't thought that the engine was still evaluating the SQL regardless of the condition.
Jun
4
accepted SET RECOVERY Model Using sp_msforeachdb
May
31
comment SET RECOVERY Model Using sp_msforeachdb
With the IF statement it returns the Name and DB_ID of each of the user databases.
May
31
awarded  Editor
May
31
revised SET RECOVERY Model Using sp_msforeachdb
added 114 characters in body
May
31
comment SET RECOVERY Model Using sp_msforeachdb
I thought the same thing but adding the ? to the DB_ID check, or adding a USE ? to the parameter still produces the same error.
May
31
comment SET RECOVERY Model Using sp_msforeachdb
Thanks Kyle. I understand the reasons why doing this would cause an error. That wasn't really my question, though. Why am I getting the error at all, is the real question.
May
31
asked SET RECOVERY Model Using sp_msforeachdb