I dont' much care for sports unless it is my homes teams and they are winning and in the super bowl or I know someone on the team personally. However I love...

Actually all virus vendors have seen various attacks including if I remember correctly Symantec have a buffer overrun flaw several years back and a virus was using that to hide...

Ok here is the hard and fast of the issue. You are truncatin the data which is fast but as each record inserts it causes inserts and reording of the...

I agree you should seperate them or at least use procedure groups. If you have all encapsulated in a single sp you will take a big performance hit each time...

Not to mention the laws governing SSN actually say it cannot be used as a form of identification except by certain orginizations. Just an example but I am sure someone...

There are conditions such as the subquery example previously where the parser has trouble using parameter assignment. You have no choice but to build the string in Script and load...

Ok I am going to throw in my opinion here and anyone who just wants to can throw back.

With the case of using an indentity column it usually boils down...

Wow, either you are hiding the real inputers or you have the whole split personality thing down to a science.

Unless you see a negative impact I do believe you can ignore this message. Not sure if there is anywhere you can just turn off thou.

I have had only one situation where using ? to assign a parameter via a global variable failed. That has since gone away but what I ended up with was...

Hate to say but when you have a spid hang like that it many times means a restart will be required. You might try killing the spid again first.

Backup the database then restore using the WITH MOVE option, this will allow you to designate the name differently. If the above does not work.

Sorry no they are not automatic. From that site any marked PSS will require speaking with MS and only if you are experiencing the issue. The ones not marked PSS...

I like this method as well which will take less space than an indexing method will take.

Yes there are, only a few are public and SP4 is in beta right now. But go here

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37

and there is a list that is is the best you can...