This?

CREATE TABLE Test (Test char(1));

go

INSERT INTO Test SELECT 'A' UNION SELECT 'B';

go

select * from Test;

go

begin try

begin transaction

TRUNCATE TABLE Test;

--If this insert fails I want to rollback the truncate

INSERT INTO Test...

I never said don't disable xp_cmdshell. My comment about locked doors only keep out honest people was based on the comment that admins can turn it on and off....

opc.three (9/19/2012)

---

Lynn Pettis (9/19/2012)

---

opc.three (9/19/2012)

---

Lynn Pettis (9/19/2012)

---

opc.three (9/4/2012)

---

Jeff Moden (9/4/2012)

---

opc.three (9/4/2012)

---

All sysadmins can execute any commands they wish and those commands will run in the context of the SQL Server...

Eric M Russell (9/19/2012)

---

Lynn Pettis (9/19/2012)

---

Two year old thread, and no, I don't want to learn SQL from...

Lowell (9/19/2012)

---

Sean Lange (9/19/2012)

---

My answers would have been similar to this.

I did know this one, 1024 or 30,000, depending on whether we are...

opc.three (9/19/2012)

---

Lynn Pettis (9/19/2012)

---

opc.three (9/4/2012)

---

Jeff Moden (9/4/2012)

---

opc.three (9/4/2012)

---

All sysadmins can execute any commands they wish and those commands will run in the context of the SQL Server service account, i.e....

Brandie Tarvin (9/19/2012)

---

Yep.

My current drama is...

The following worked on my laptop system which uses a named instance for SQL Server 2005:

bcp "select * from master.sys.databases" queryout C:\Users\lynn.pettis\testfile.txt -S ISS203897\ISS2K5 -T -c

The following failed on my...

On the new server, what was the error message? (Sorry, but saying it failed doesn't tell us anything.)

Grant Fritchey (9/19/2012)

---

Lynn Pettis (9/19/2012)

---

Stefan Krzywicki (9/19/2012)

---

SQLRNNR (9/19/2012)

---

Grant Fritchey (9/19/2012)

---

Nothing wrong with this maintenance plan. I mean, everything is covered:

1. Check DB Integrity

2. Back Up Db Full

3. Back up Db...

Do you ever feel that no matter how many times you tell someone what the problem may be that they just aren't listening?

Stefan Krzywicki (9/19/2012)

---

SQLRNNR (9/19/2012)

---

Grant Fritchey (9/19/2012)

---

Nothing wrong with this maintenance plan. I mean, everything is covered:

1. Check DB Integrity

2. Back Up Db Full

3. Back up Db transaction log

4. Shrink Db

5....

opc.three (9/4/2012)

---

Jeff Moden (9/4/2012)

---

opc.three (9/4/2012)

---

All sysadmins can execute any commands they wish and those commands will run in the context of the SQL Server service account, i.e. you lose the...

Yes, it will work on SQL Server 2005. You need to check the settings for QUOTED_IDENTIFIER on your server.

Just...

Two year old thread, and no, I don't want to learn SQL from your blog. I already...