sp_update_schedule: http://msdn.microsoft.com/en-us/library/ms187354.aspx

sp_update_job: http://msdn.microsoft.com/en-us/library/ms188745.aspx

sp_add_jobstep: http://msdn.microsoft.com/en-us/library/ms187358.aspx

As another potential drawback for NoLock, I've actually seen it crash a server, requiring database repair.

A shared connection (from a web server, of course) ran into two concurrent missing data...

Rob-350472 (1/30/2012)

---

What are the implications of setting "READ_COMMITTED_SNAPSHOT" to ON rather than OFF (the default)?

I seem to recall looking into this before (ages ago) because it sounded attractive but...

I just copy-and-pasted your script into SSMS and ran it. I had to remove the drive/file specification for the database, but otherwise left it as-is.

I got the same error...

SQL Kiwi (1/30/2012)

---

GilaMonster (1/30/2012)

---

Plus the absolute entertainment of queries occasionally failing with error 601

No, using nolock on every single query 'just because' is not good practice. There are places it's...

Any error in creating the database?

I've seen errors on Use commands before, like what you're getting, when there was a problem with the database being created.

I've seen it plenty of times. That's why it was my first thought on the subject.

Have to admit, I've never tried to deny connection on a user before. ...

I think that any company where this would work, it wouldn't be needed. Any company that needs a service like this, it will be abused and won't work. ...

You're welcome.

Jack Corbett (1/30/2012)

---

As I said earlier you...

Arrow next to a login at the server level means that. At the user level, it doesn't necessarily. I've got 2 user accounts in...

Matt Miller (#4) (1/27/2012)

---

In terms of validation: you can run aggregate functions in both the excel file and against the table to make suer you end up with consistent...

I don't think so. How would you use a function for this?

Koen Verbeeck (1/27/2012)

---

I...

No associated Login at the server level, if I'm not mistaken.

Query "select * from sys.database_principles" and see what the "sid" column has. If NULL, there's no login associated with...