fminns-1058143 (4/28/2010)

---

Hi everybody, I wonder if you can help.

I recently set up log shipping (SQL 2005), and so have a readonly/standby database that the logs are being shipped to. The...

It does not matter that you can run it from...

xp_cmdshell runs on the server, not on the client. Try to run whatever your running on the server, through a command prompt, then you will see what is happening.

sunshine-587009 (4/28/2010)

---

xp_cmdshell is enabled I run the following and it says executing but nothing actually happens it just continues to say executing when via cmd prompt it works and only...

Grant Fritchey (4/28/2010)

---

Yes, but...

NOLOCK hints can cause you to get erroneous data. Not only will you see columns that have been changed but not yet committed within a transaction, but...

Not sure if this is what you mean, but if you use the nolock hint (look it up in BOL), it will prevent locking from happening

jcrawf02 (4/21/2010)

---

GregoryF: "don't worry about not knowing how many instances/servers there are, every where I have ever worked, no one know all of them, there are some that are barely...

WayneS (4/21/2010)

---

Might I suggest instead of...

SQL 2000 does not have that functionality

In SQL 7 or 2000 the only way to do it would be to:

1) Create a new table with [table_name], [last_update], [last_insert], [last_delete]

2) Create a trigger on the source tableto...

Me, and many of my friends do spend a few hours surfing the web during the day.

When that get's boring, I do thing like admin scripts (you learn alot about...

A couple of questions

1) Why would you want to backup the sa password? If something went wrong, why would you just not change it back?

2) If something we wrong...

Dan Fran (4/21/2010)

---

Just to understand a little more, doesn't varchar(max) allow for 2^31-1 bytes (or characters)? If that is the case, is it such that even though it allows...

Toby White (4/21/2010)

---

You can pipe the output somewhere, and then read that output, but you cannot treat with it like you would an output parameter. What do you want to...

Jeff Moden (4/21/2010)

---

Lynn Pettis (4/21/2010)

---

Toby White (4/21/2010)

---

What system, application, and/or users DO need to see the salary data? If you rely on the SQL engine to decrypt the data, then...