Discover SQL servers
Fri, 4 Jul 2008 15:17:44 +0530
Hi All,
Using TCP method , is it possible to find all the SQL instances running
on a machine?
Thanks in advance.
Supriya.
...
|
how to disconnect
Thu, 3 Jul 2008 22:09:25 +0800
I am working on SQL2000. Lately I find some users repeated executing INSERT
OR DELETE on SQL2000 remotely. May I disconnect these users when they
execute Insert operation 5 times? How can I relize it? Or may I disconnect
specified user by user name?
thanks
hui
...
|
Defualt Pooling
Thu, 3 Jul 2008 01:51:01 -0700
Hi
if SQL Server uses pooling even if i didnt do any setting in my connection
string i wanted to know haw this default setting will behave if i sent with
each connection string of my application a different user name and password ?
will it make a new pool for each connection ? isnt there a way to overcome
...
|
Creating a linked server to DB2 within SQL Server Management Studi
Mon, 30 Jun 2008 04:33:02 -0700
Hi,
I've successfully created a Linked server within SQL Server 2005 Management
Studio to a DB2 database (DB2 is hosted on Windows Server 2003). If I right
click the linked server and select 'Test Connection' and get a message 'The
test connection to linked server succeeded'.
However, when I try to expan ...
|
Connecting to MS SQL server
Sat, 28 Jun 2008 13:39:53 +0100
Hi all,
I dont know if this is the best place to ask this question...
Is there a DLL etc, to allow connection to a MSSQL 2000 and 2005, from a
simple C application, preferably via TCP port 135?
I dont want an overly complex COM etc, solution. Just something which
allows the issuing of SQL commands and r ...
|
SQL Server 2005 Instance Connection Failed on Vista
Fri, 27 Jun 2008 09:14:53 -0700
Hi,
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 to
connect a database on ...
|
ASP connection string to SQL2005
Thu, 26 Jun 2008 17:21:02 -0700
I am trying to connect to SQL2005 server, and the script is written in ASP.
I am trying to figure out why I am getting this error as below;
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument: 'Mid'
I currently have following connection string;
"Provider=SQLDB; User I ...
|
|
|
Connection to SSAS 2000 from Windows Server 2008
Thu, 26 Jun 2008 14:35:01 -0700
Hi all,
I am looking at migrating a web application from a Windows 2000 system to a
Windows 2008 system.
This web application connects back to a SSAS 2000 server. Can I install the
SSAS 2000 connectivity software on Windows Server 2008?
TIA ...
|
SQL Server 2005 and connectivity to Oracle 10g
Wed, 25 Jun 2008 08:36:02 -0700
I am working on a new project where we would like to eliminate processes that
involve bulk loading data extracted from an Oracle 10g database into a SQL
Server 2005 database. The extracts come in the form of Excel worksheets.
Can I get the data from the Oracle DB directly, through linking or some other
met ...
|
SQL 2005 not associated with connection
Wed, 25 Jun 2008 12:13:48 +0200
Hi All,
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
works.
i found this http://support.microsoft.com/kb/889615 but that didn ...
|
