More information:

http://blogs.msdn.com/b/farukcelik/archive/2008/12/05/how-you-should-set-your-firewall-rules-to-be-able-to-connect-to-a-sql-server-2005-2008-clustered-instance.aspx

I always took IP_ANY to refer to all possible IP Addresses and make no reference to the port. So I too question this. I have never seen...

If this is SQL 2008, can't you use auditing? I haven't tried it (yet, but we will next year), but according to the docs, you can set up a...

Of course, even those who never allow SQL SPs to go in via automatic updates can get hosed. June 14th MS released a big security fix to SQL Server...

George Carlin would have had a field day with this thread. After all, STUFF is what life is about.

Richard M Karpel (5/20/2011)

---

If the data is store outside the database this is true but according to the white paper found at http://msdn.microsoft.com/en-us/library/cc949109%28v=sql.100%29.asp Then the limitation does exist as...

Ugh -- they did it on purpose? For God's sake why? It violates all good database protocol? That really needs to be flagged heavily in BOL.

SanDroid (5/18/2011)

---

Carlton Leach (5/18/2011)

---

Another bug vote here, and another wrong answer for me.

NULL is NULL...fullstop. You never know what NULL is so regardless if you insert, concatenate, stick it somewhere...

SanDroid (5/17/2011)

---

Nice question. Easy answer for me, but I have used string functions a lot.

I understand all the comments about a BUG, or BOL not getting it right. ...

brazumich (5/17/2011)

---

I'm going to play devil's advocate here (like MS needs any help...). In my copy of online help...

Burned by what SHOULD be versus what IS.

Logically, NULL plus anything should be NULL. Period, end of story. NULL means "unknown" and you can't assume that you can...

I knew it was either 1 or 4, but I wasn't sure whether the heap would span the partitions or not. So I took a stab at 1 and...

K. Brian Kelley (4/19/2011)

---

jeff.mason (4/19/2011)

---

Of course, all of the solutions listed assume that you have a domain admin-level account that can go out and do this searching. If you...

Ray Cacciatore (4/19/2011)

---

When a transaction is in progress and it locks a table for either an insert or an update, can someone explain to me how another process "waits" for...

tksitp (4/19/2011)

---

Fairly common scenario: My existing application has an SQL Server back-end, and business logic on the front-end. To connect to the App, obviously a connection to SQL must...

Only thing I can think of would be making sure that the filegroup has the file you are looking for properly assigned. You are doing the correct method for...