We are running SQL 2008 with a single database that is receiving data from a
logging application. When forwarding the information from the application
residing on the same server, everything works fine. When trying to forward
the data from another server on the same LAN, the data ...

I have the following questions:
1. How many SQL server 2008 and Express can be installed per domain? can you
refer me to any MS documentation regarding this. I found  a limitation for
number of instance per server.

I am testing (trying to test) a simple database with a new and very generic
sql 2008 dev edition install.  My installed sql server is on a laptop
running vista Home Premium and I have two other machines (Vista ultimate and
windows XP sp3)  Neither of these two machines can ...

Years ago, I had a girlfriend.  She worked for one of the major
Hollywood make-up studios.  She'd brag too me about how her and her friends
would sit around chat all day, and that she only really had to work the last
week of every month.  The company hired some efficiency experts ...

I try it with MSSQL 2005. and it's seem the is not work!
swtQueryTimeout is Apply only on lock?
I try with
jTDS 1.2.2

When I try to open a recordset ina a Visual Basic program I get the error
"The object name 'NameTable' is not valid".
The table exists and I can run the select with SSMS .
Any help?

plz tell me that hw should i remove my ths problem:
i hv server client relationship when i work on client application  after
sometime the odbc sql server disconnect.again if i create a odbc connection
it start working properly...so plz tell me wat i do...

I just installed SQL Server Express 2008 on my machine for testing
purposes.  I am using Classic ASP and am having problems figuring out
what the connection string should be.  The following is not working:
Dim conn

I have a basic question regarding SSPI.
Can I use SSPI to authenticate a user in one domain to the machine on
another domain ?
e.g. My SSPI client application is in dom1.com and my SSPI server

I have been running SQL Server 2005 for a while on a stand-alone machine
using Windows Authentication.  I added a user with a password using SSMS and
then tried to log on with that user.  The result was this message:
Login failed for user '<username>'. The user is not associated ...

We're in the process of setting up new SQL Server hardware to which we will
be porting databases from our existing environment in stages.  Many of these
databases are accessed by stored procs/views found on other remote servers
which rely on 4-part naming to accurately access the ...

Can anybody help with this?
I have a Windows 2003 64-bit server  with a default instance of SQL Server
2005 64-bit Standard edition and a named instance (SQLEXPRESS) of SQL Server
2005 Express edition, all fully up to date with service packs etc.

This is a free site I set up with tens of thousands of
programming articles available to read or download.&nbsp; There is n o specific
type, this site covers, web programming, database and application
development.&nbsp; No mater what level of a programmer you are

How can I obtain and set the security context for a linked server connection?
Most of the connection details are available from the sys.servers table, but
not this.
I am referring specifically to the Remote login and With password entries on

    We recently upgraded from SQL 2000 to SQL 2005 and we are using Windows
2003 SP2 on the server. This is all in a TEST environment. We also installed
the SQL 2005 JDBC driver. Our intranet application will not completely load
now. It worked fine before the upgrade. I have ...