Here's how I'd do what I think you're trying to do:

-- Create Logins for the SQL Server and SQL Agent services. (Could either be be one account for both, or separate...

Took a while to find it again, but in BOL, under contents, look under:

Creating and Maintaining Databases

  Databases

    Database Design Considerations

      Estimating the Size of a Database

...that and the three entries...

Would the function ISNUMERIC() help in filtering numeric data from character data? You could use it in a CASE statement:

CASE

  when ISNUMERIC(value) then <numeric value processing>

  else <character value...

The solution was to install proper error handling. Detect the timeout condition, issue rollbacks, close the DTC transaction properly. (This, needless to say, was not the fix used; no, the...

I hit something like this once. It's complex, and may not be what you're dealing with, but sounds very similar. I do not use entirely technical terms below; this is...

And that goes double for xp_schedulersignal!

   Philip

I'm looking into the restriction of access rights (via "guest" and "public") in the master database, and have a question. In the list of procedures to remove access to, you list...

One way to check if a database file (master or otherwise) is in use: while SQL Server is running and the database is attached, try and rename the file. (Windows...

Alternatively:

IF OBJECT_ID('tempdb..##stuff') is not null

    DROP TABLE ##stuff

Avoids direct access to system tables. Supplemental checks for "is ##stuff actually a table" might be advisable. Also, while I haven't...

Quickest way: run sp_detach on the database, copy the files to the new machine, then use sp_attach on the new box

Next-quickest: Create a complete backup, then restore the backup on...

It's got to be at least as tough as mom says.

 - If I can create a backup of your database, and create it on a volume I can access, and restore...

SQL Server hitting the network for NT account verification has got to be a factor in here somewhere. I am by no means conversant with the subject, but if you're granting...

I attended a few user groups sessions (in Chicago) with the idea of getting information and ideas--maybe getting answers to problems I was working, maybe giving answers to others problems....

Alternatively, you can mess with job ownership. If a job is owned by a specific SQL login (NT groups are not eligible), that login can start, stop, review, etc. that...

Both Remi and Mark suggest a course of action similar to the one I implemented at my last position: tight control over code produced by the development team. [Note that...