Excel 2003 Linked Server
Sun, 24 Feb 2008 08:30:48 -0800 (PST)
Dear All,
Please can you help with a problem that I am having which I have
spent
all day trying every conceivable permutation of options to solve
without success. I am sure I have done this kind of thing before
using
sqlserver 2000 without problem.
I am using sqlserver 2005 express (SP2) and am trying t ...
|
SQL Server 2000 License Question
Fri, 22 Feb 2008 11:45:00 -0800
Hi,
If one of my third party applications makes a connection to a SQL database
and runs a select *.... and returns a {...} values? Do I need x licenses
based on the # of users connecting to the database?, I expect multiples
connections might occur every minute?
Thanks ...
|
XCopy not Detaching Database
Thu, 21 Feb 2008 15:39:13 -0800
I am using the AttachDBFileName and User Instance properties to cause my
.mdf database to dynamicaly attach and detach when the application runs and
stops execution. This is known as Xcopy Deployment, a very cool idea
available only in SQL Express.
It all works perfectly both with and without User Instanci ...
|
MSSQL ODBC And Transactions
Wed, 20 Feb 2008 14:18:01 -0800 (PST)
Hi There,
I have developed the ODBC app which can work with Oracle as well as
MSSQL server databases. I need to use transactions at some level. By
setting AUTOCOMMIT OFF and using SET TRANSACTION and BEGIN WORK,
COMMIT WORK everything works fine with Oracle. But with MSSQL server
does not. Do I need to co ...
|
Failure Audit Event ID: 18456 SQL Server Error
Wed, 20 Feb 2008 10:00:33 -0800
Hello Everybody,
I am getting the following error in MS SQL SERVER 2005 Enterprise Edition.
The IP reported does not even belong to our domain.
Does it means someone is trying to hack into our system or something else?
Any suggestions please?
Thanks
Anand
Event Type: Failure Audit
Event Source: M ...
|
Machine x receives results meant for machine y
Wed, 20 Feb 2008 09:07:00 -0800
In an Asp.Net web farm we sometimes see web server 2 receiving from a SQL
Server 2K5 a resultset that actually was destined for a connection on web
server 1.
Usually this is after web server 1's SqlClient has timed out on that
command, due to longlasting lock issues. The batch probably just continues on
...
|
Attaching a 2005 *.mdf file
Tue, 19 Feb 2008 13:09:01 -0800
SQL 2005 with only an *.mdf file
When I attempt to attach an *.mdf file (no *.LDF) I keep getting the message
that the *.LDF file is missing - which it is. How can I attach this XYZ.mdf
file and not be concerned that I wasn't provided the XYZ_ldf.LDF file? I
need to change the name of XYZ.mdf to XYZOlder. ...
|
|
|
SQL Server 2000 SP4 client connection problem
Fri, 15 Feb 2008 18:04:21 -0500
Description: I have a server and two clients (ClientA and ClientB).
All are on static IP, on the same LAN segment.
Server
------
W2K3 Enterprise SP2
SQL Server 2000 SP4
Clients
-------
WinXP SP2
Attempts to connect from ClientB result in the application's hanging.
Attempts from ClientA work. This ...
|
SQL 2005 Not Using Configured Port
Thu, 14 Feb 2008 08:06:03 -0800
I have a SQL Server 2005 cluster. when I open the configuration manager and
look at the ports configured for TCP/IP, it shows 1433. Yet, when I try to
connect using Management Studio from another machine, it can't connect on
port 1433. I used SQL Ping to scan the server, and it appears that SQL Server
is run ...
|
TDS, RPC malformed packets with SQL Server 2005
Thu, 14 Feb 2008 01:38:46 -0800 (PST)
Hello,
we have a standard apappliaction which uses a sql server.
Till last week we use a sql server 2000 and no problems.
Now we use SQL Server 2005 and now we got 40% malformed Packets in
application traffic to SQL Server.
Wireshark means TDS, RPC malformed packets.
If the session crash the application ...
|
