The job steps execute with the security context of the job owner. However, assigning an owner does not mean that the login has the necessary permissions to run that...

Spicy food 🙂

This is probably because most email clients have a true-type font as their default font and you aren't going to get those columns to line up unless you use tab...

Now that's a cool procedure. In the years I've worked with SQL...

A point to consider is that if a trigger is writing out text files, the transaction itself will wait for the file to be created in the file system. ...

Jack Corbett (9/10/2013)

---

WayneS (9/10/2013)

---

SQLRNNR (9/9/2013)

---

Jack Corbett (9/9/2013)

---

Hey is anyone going to be at the SQLSaturday this week in Orlando or next week in Providence? If...

Grumpy

I have to agree with Sean - this sounds like a bad idea. Depending on when the trigger fires, you're going to end up with an awful lot of...

I see from the "create table as" and to "to_char" that you're using Oracle. Sean is exactly right and DISTINCT works essentially the same in Oracle as in SQL...

Here's another way.

IF OBJECT_ID('ProcedureName', 'P') is not null drop procedure ProcedureName;

Here's a way you can run a query and write the results to a text file.

EXECUTE master..xp_cmdshell 'bcp "SELECT output_field FROM table_name ORDER BY ID;" queryout "z:\filename.txt" -C RAW -R...

I actually saw the 11 characters in the last value and answered 0. When I got it wrong and read the explanation, I had to run it because I...

SQLRNNR (9/10/2013)

---

What are...

Breakfast

That's because, as Lynn pointed out, the code is a template. You need to...