BOL Reference: http://msdn.microsoft.com/en-us/library/ms187928%28v=SQL.100%29.aspx

LOL, I had to give myself something to aim for.

I'm hoping I get to 50k. That would be another few years.

There were lots of fixed in SP2, and there is a hot fix that you need post SP2 for 2005 servers. I would actually recommend SP3 for the server AND...

This is why we would need regulation. Companies left...

Allergies

you'd think with no rain for a month and none in sight that I wouldn't be searching out Benedryl this morning.

What do you mean handle? I'm not quite sure what you're looking for. Ideally the manager should be handling you.

Moving to Employees forum

DEADBEEF, that was funny :hehe::hehe:

I struggle with this. One thing I loved about my Android phone was the integration with Google Calendar and the phone, and my Outlook. Now I'm on an iPhone and...

When you connect locally, are you putting in the virtual name, the local name or "(local)"

krowley (9/15/2010)

---

I understand the gist of this thought process but it seems to me to be a sad way to have to live. ...

... we would actually be less likely...

Eric Russell 13013 (9/15/2010)

---

Based on the cases I've read about, it seems that only a small pecentage of data breaches are the result of someone hacking the actual database server....

The reason people are recommending a tool is because there isn't a good way to do this natively within SQL Server. You can write something, but you'll easily burn more...

Lynn Pettis (9/14/2010)

---

CirquedeSQLeil (9/14/2010)

---

Lynn Pettis (9/14/2010)

---

I'm guessing not many will jump to help bit boy if he runs into more trouble and posts a question on SSC again (if he...

you should be able to do this, but deny to who? Everyone? If that's the case, then why not just prevent the table from being created?

Can you post exactly what you run. The syntax Lutz showed should work.

It's

IF ()

begin

end

else

begin

end