Does SQL 7 include the procs for

* Registry access

* OLE Automation?

You could go either of those methods.

Or, use xp_cmdshell to run "set computername" and parse the results.

Or, create a table,...

I think you're still doing the same (inefficient) algorithm but with more convenient syntax. As suggested you should try to think of the overall result that you want -...

Perhaps try a select * rather than going for the count straight away. You'll see all of your column names there. Perhaps you've misspelt the name in either...

Great article. Replication has been one of those "spooky" things that I have wanted to play with but setting up a test environment to learn in and then willing...

And you read my silly first post before I posted the sheepish "oops" one. 🙂

Silly me, if I paid enough attention to Jeff's example I'd see that he's executing it 100 times already and returning different results 🙂 And I'd seen similar things...

I think you're right Grant. Certainly the error message from SQL 2000 is along the same lines. If you try to convert the string '-0' to a float...

Use the SQL Server manual - called SQL Server Books Online - and look at the topic "Checkpoints and the Active Portion of the Log". There's a wealth of...

Do you get a similar performance boost when you simply restart the SQL Server service rather than restarting the server?

Definitely treat your logs with respect 🙂

You could also try running...

For the DBA you have one integrated tool (although slower than old isqlw in many ways unfortunately) rather than QA and EM separately.

You can now have the GUI script all...

If you visit this site even once a week and haven't been living under a rock you should have known the answer to this one 🙂

It's a shame that it's...

I haven't looked into it too far, but does MS SQL use some smarts (in 2000) that assumes that a function is deterministic given its parameters and thus executes it...

Have to agree with the others...

Whilst I understand that you use this pattern as a way of debugging and inspecting what your procs do, I think good commenting, some debug...

At the risk of reinvigorating fanatical discussions (search for the threads associated with any NULL-related article on the site), it's not Microsoft's design flaw as NULLs are a basic part...

I've just been getting my feet wet with Analysis services myself. In this whitepaper (http://www.sqlbi.eu/Default.aspx?tabid=80) they use many-to-many dimensions to do exactly what you're after. For...