You're welcome.

I have a couple of traces I add to every production server I administer, and a couple I add to every dev/test/QA server. I find them very, very...

Brandie Tarvin (2/23/2011)

---

WayneS (2/23/2011)

---

Brandie Tarvin (2/23/2011)

---

LutzM (2/22/2011)

---

Jeff Moden (2/21/2011)

---

...

I dun no... DE-troit boy goin ta ohia mur dan wonce in da sames yer mite git da kin folk...

Including the schema on those can improve performance, since it doesn't have to include a compile-lock to check security at runtime (allows for better concurency), but I don't think including...

You can get that from the system views and DMVs in tempdb.

For example, select from tempdb.sys.columns to get column and datatype data about temp tables.

select *

from tempdb.sys.columns

where object_id = object_id(N'tempdb..#MyTempTable');

That'll...

Running a trace does have an impact on the server, but it's microscopic. You'd have to run dozens or even hundreds of server-side traces before you're likely to even...

Are those values stored in the database? Are they in one table or multiple tables? Are they stored as strings (varchar/nvarchar/char/nchar datatypes)? Are you building the string...

You're welcome.

You're welcome.

Ian Massi (2/23/2011)

---

The one that threw me off the most as the starting question on an interview was, "Can I get you a beer?". Later, "Do you drink?". ...

Can you explicitly add @@servername to the query and use that?

Double the single-quote right after xp_cmdshell, right before COPY.

GilaMonster (2/22/2011)

---

Protecting as in...

I'm guessing that when the primary attorney value equals the fee attorney value, then that's the one you want to display the number on, if it exists. Correct?

If so,...

Depending on the application you are using to access the data, it won't generate the ID value until you actually submit the data to the database.

Generally, that means clicking on...

Steve Jones - SSC Editor (2/22/2011)

---

On a similar debating note, does anyone know of code in SQL Server that's worth protecting with CLR, obfuscation, or any hassles of encrypting? Not...