Cool thanks, all my SQL servers seem to be up to date now!!!

Duh. Somedays you just feel stupid. Ok, so the Service pack info is about the OS not the SQL server. Who knew. It's sort of obvious after you think about...

This is a direct copy of each of them. I felt they should both say Service Pack 4. As you can see the MSDE on says it is SP2, not...

Yes, exactly. Go after and publicly punish those who spam, emit viruses and worms, and share copyrighted material.

I have great concerns about some proposed legislation here in canada that will...

I too, am concerned about Government intrusion and regulation based on a lukewarm excuse.

For example, I don't want ISPs forced to monitor all client traffic because some users illegally...

Probably not a permissions prob then. One thing I recall is when you run a DTS package in Query Analyzer it tends to run sequentially but if you run it...

I may have misled you a bit. Here's what I was talking about:

"Normally, SQL Server allows access to any object referenced in a stored procedure as long as the user...

.. I have checked the connections and there are never any dead ones.

How are you doing that? The issue is returning the connection to the connection pool abruptly after you are done with...

My thoughts:

1) you said it was asp.net

2) You said you were logging in as user1/pass1 and it has the requisite permissions.. do you mean logging in as that is in...

I looked up 'Query Table' in Excel to see what you were talking about, couldn't find it. Are you talking about importing the data into the Excel sheet, from Excel,...

A couple of thoughts... if you're selling something on the net that you're delivering immediately, then you need to verify and charge the cc immediately. This requires a relationship with...

Well, I spent a half hour on it, and in BOL (which I consider cheating). Only by reading the forum did I get the fact that it was sort of...

When you authenticate, then your asp pages run under the windows user id with which you authenticated, and presumably you have properly set up this user id as a database...

I'm a little older, looking back at it all, and was struck by your concerns about leaving the development work behind and moving to management. A couple of thoughts: It's...

You said that the memory SQL server uses keeps on growing but just in case you are suffering on the VB side, remember that if you repeatedly call the...