Hope someone can help with this: I have an Alpha box running open VMS which has an ODBC client from easysoft set up as a system dsn in ODBC data sources. I can select the data source from Excel/Access/VB asp etc with a connection string of "dsn=dsnname" How can I set this up as a linked serv...more >>

Hello Is there any way to get a list of NT logins (not just SQL logins) ? I have a form that adds logins to a database. Since user's don't have access to create logins, we have a store procedure that does this as a job. I want to be able to check if a username is a valid NT login before allowin...more >>

Any body have faced this problem? I am using SQL2000 server resided on WIN2000 Professional Server. I have loaded SQL2000 client on a WIN98 PC. Through Enterprize Manager I am able to connect to the SQL Server. I have created the local dsn . But while running the software developed in V...more >>

SQL 2000 Servers: DB1 & DB DB1 --> replicates a database to DB DB1 has DB2 as a remote server (not a linked server I need to run a query on DB1 that references a db table in DB Adding DB2 on DB1 as a linked server fails because it say's it's already there what do I have to do to make this w...more >>

Hi Guys, i am using sql server 2000 on windows 2000 cluster with 150 concurrent license . now i want to add 50 more licence. do i have to add this for both nodes? what is the procedure to do this ? is it using licensing manager in control panel? PLS advice me ...more >>

Hi Guys, i am using sql server 2000 on windows 2000 cluster with 150 concurrent license . now i want to add 50 more licence. do i have to add this for both nodes? what is the procedure to do this ? is it using licensing manager in control panel? PLS advice me ...more >>

I have an install which works on 99.9% of machines (98, 2000, XP) On one Windows 2000 (SP4) machine my install gets an error when trying to register sqldmo.dll the error is 0x80040154 (Class Not Registered). I run depends on the machine and everything is in place. Obviously I'm installing...more >>

Windows 2003,sql server How can i connect sql server 2000? Unable to get a linked server working. Please help me,thanks gouki...more >>

Brief background... I have basically the same sql/db at each of my locations and once a week I try to merge all of the db into one corporate db. I have several queries that are in a stored procedure that seem to be working just fine but there is one query that just does not want to work. ...more >>

How do I generate a certificate request for SQL Server without using a certificate server? I want to encrypt my DB traffic but I don't have a certificate server....more >>

Does the setup for SQL also set the corresponding environmental variable, or is this something that has to be done separately? If separately, which environmental variable and how? Thanks, Victor ...more >>

Hi I've got an SQL server 2000 (sp3) This box has multiple IP addresses. These are for web page But i only want the SQL server (port 1433) to listen on one of these addressses It seems to listen on all the addresses which i don't want it to. for sercuirty reasons as wel as for it's resource sa...more >>

Oracle 8.1.7 and SQL 2000 (with SP3) are on a Win2003 server. We have MDAC 2.8 installed. Unable to get a linked server (to Oracle) working. We get the erro Error 7399: OLE DB provider 'MSDAORA' reported an error OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0...more >>

I am trying to track down a blocking issue. Part of the blocking issue is with a cross-database query. The problem I am having is attempting to find the query causing the blocking. I can see the blocking event, but when I look at the command that is running through the DBCC inputbuffer com...more >>

Hi, All, SQL7.0, SP3 on Win2000 server+ sp1 I remote access our client in FL, recently I get error message [DBNMPNTW] Connection write(writefile()) message then the connection failed. What's cause the problem how can I fix it. Thanks and have a nice day Hawk ...more >>

We have an ASP web site driven by a SQL 2000. For several months I have satisfactorily been able to view and edit the database using a) Access 2000 project and b) Excel with an ODBC link Suddenly we started getting messages such a connection failed: SQLState '01000' SQL Sever Error 10060 [Mi...more >>

I would like to be able to limit users from connecting to the database using other than the dedicated application. Of course it could be done using application role, but the applicationd does not support this. Therefore I have been writing some code to catch the bad guys, but how should I trig...more >>

I am trying to create Sql Server 2000 remotely using and getting = following error on some of the machine, but on some of the machine it is = working fine. All client machine having W2K Prof. "[Microsoft[[ODBC Sql Server Driver][Named Pipes]Specified Sql server = not found" Server alias/cli...more >>

Good morning, In sql-server(7 or 2k)can a linked server have an alies or a synonym? I need to avoid the 4 part naming convention (linkedserver.dbname.owner.object)when I refer to an object on a liked server and use an alies/synynom for the "linkedserver.dbname.owner" portion. Is this d...more >>

Hi All I hope I'm on the right NewsGroup, please let me know if I should post that elsewhere. I am runing the Developer edition of SQL Server 2000 SP3 on a Windows 2000 OS, All the latest updates to the OS, IE and Office are installed. I recently upgraded to MDAC 2.8 and since doing that ...more >>

I am getting a random timeout when calling a stored procedure from c## / asp.net and using an SqlDataReader to access the data. Also get same results if using sql in-line rather than a stored procedure. However, the query runs great and never has a timeout from the Query Analyzer. Any ideas o...more >>