If it were me, I'd prefer Lowell's first approach as opposed to a database job. The procedure, having permissions to use xp_cmdshell, must be running with sysadmin privs, so...

ThomasRushton (4/4/2016)

---

Ed Wagner (4/4/2016)

---

ThomasRushton (4/4/2016)

---

Ed Wagner (4/3/2016)

---

TomThomson (4/2/2016)

---

SQLRNNR (4/1/2016)

---

Locks

You know those things that mean contention on resources and a winner is chosen while the...

Brandie Tarvin (4/4/2016)

---

Ed Wagner (4/4/2016)

---

Brandie Tarvin (4/4/2016)

---

So I didn't get out of work until after midnight on Friday thanks to the joys of month end. Finally someone found a switch...

Brandie Tarvin (4/4/2016)

---

So I didn't get out of work until after midnight on Friday thanks to the joys of month end. Finally someone found a switch that we could superglue...

Agreed.

A nice and simple question to start the week. Thanks, Steve.

I'd first ask yourself why you want to replace it with something else.

If this is to make it more secure, then I'd suggest looking at who can run it. ...

ThomasRushton (4/4/2016)

---

Ed Wagner (4/3/2016)

---

TomThomson (4/2/2016)

---

SQLRNNR (4/1/2016)

---

Locks

You know those things that mean contention on resources and a winner is chosen while the other becomes a...

Jeff Moden (4/3/2016)

---

Just in case you may have missed it, there are no longer any excuses. for the many that we try to help and that refuse to help themselves....

Jeff Moden (4/2/2016)

---

Yet Another DBA (3/30/2016)

---

I tend to use a GUID for the password. Simple, straightforward and has approximately 5,300,000,000,000,000,000,000,000,000,000,000,000-ish combinations.

Only issue is to remember which post-it-note it was...

TomThomson (4/2/2016)

---

Tress

I guess the...

In Oracle, you can...

It sounds like you might benefit from the NTILE function. Keep your ROW_NUMBER, but you can use your NTILE result to join to a table (either physical or table-valued-constructor) to...

If the employees table has lots of rows, you shouldn't be using table variables, as they t get the benefit of statistics.

If these were physical tables, I'd suggest primary keys....

Whenever your shrink the log, you're yielding space back to the operating system. However, activity that occurs in the database will be logged, so the log does need space....