I am trying to change my search query to use  SqlBindParameter instead of
"inline" search pattern like:
SELECT last_name FROM users WHERE last_name = 'S%'
I am using "SQL Server" ODBC Driver (version 2000.85.1117.00) with MS SQL

Is there any SQL Server 2005 Express setting or ODBC setting that will cause
global temp table not be dropped after the connection created it is lost?

Hi,
Our environment is:
Windows Server 2003, Service Pack 2
SQL Server Express 2005

  Using TCP method , is it possible to find all the SQL instances running
on a machine?
Thanks in advance.
Supriya.

I have a C# .Net App using Windows trusted security connecting to a
Sql server 2000 (running on a Windows 2000 Server).  If I change the
connection parameters to use a SQL Account it works fine, but when I
change it to use  NT Security, it fails with Unable to Generate SSPI

I've done this dozens of times on my local XP, so this should be automatic,
but now I am confused because I can't connect to the SQL Server 2005
instance databases on newly installed Windows Vista.  The standard
"localhost\instance_name" connection is not working.  When I tried ...

I have a SBS 2003 R2 premium with a SQL2005.
when i login with a user on a client a get the error: Not associated with a
trusted SQL Server connection.
when i right click on the icon and select Run As, and use administrator it