I've noticed this before when working in Visual Studio.NET (at least in versions other than 2003)  I think it has to do with garbage collection not being run while the...

There are several good scripts here to help with blocking problems.  I've used this one http://www.sqlservercentral.com/scripts/contributions/407.asp

Also Microsoft has a good proc called  'sp_blocker_pss80.'  see http://support.microsoft.com/default.aspx?scid=kb;en-us;271509

Sounds like an authentication error.  Are you accessing SQL Server via Integrated Security?  Have you tried the remote app using A SQL Server login?  (Just to see if the security...

My understanding is that setting any object to Nothing marks that object as eligible for the garbage collector to pick up.  This process happens on the Web server and has...

Check out http://www.sqlzip.com/ 

I would use the SqlCommand object as oppossed to the the Connection object.  This way you could make use of the parameters method.  The parameter method ensures you are passing...

You may want to reconsider using the sa userid for an application.  It is potentially dangerous even if your application is immune to sql injection attacks.  You risk the user...

I tried it too.  The proc executes but the statement:

INSERT #Reg

 EXEC master..xp_regenumvalues N'HKEY_LOCAL_MACHINE',

 N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters'

does not work on startup. I changed #reg to a permanent table and removed the drop table statement so I could...

You're right..  no startup procs.  The Config value would be = 1.  If you had a test machine you could try it there.  Otherwise wait until you can restart the...

check if there is any stored procs that execute at startup that may change the password.  use sp_configure and look for the parameter scan for startup procs.  If this is...

I'm not sure how helpful this is but I have 3 SQL Servers that have been running with hyperthreading for several months now (using WIN 2K Professional) and I haven't...

Right click on the server in Enterprise Manager, select properties and click on the Security tab.  I suspect it says Authentication Windows only.  If you want to use SQL ids...

The n in front refers to Unicode data.  If your data includes characters other than the regular english character set (ancented characters, National Character data types in the SQL-92 character...

You may want to look at using bcp which can run in fast (not logged) or logged mode.  Fast mode is good for large amounts of data not only because...

In the code sample I gave you I assumed you would only reindex the primary key index named pk_tablename.  In doing this I assume this is the clustered index.  If...