Hi, When trying to open the gui to create a linked server i get the error 126 with an exception_access_violation. When I click ok, it opens the linked server window but i don`t have any data source available. Any ideas? Config: W2KAdv Sp3 SQL 7 Sp4 Mdac 2.7 RTM refresh ...more >>

Hi, why would DBCC SHRINKFILE not work? It is not reducing my Transaction Logs on MSSQL 2000. Thanks, alex. ...more >>

Hi Gurus, I detached a database from my sql server 2000 which happended to be the default database. Now, I can't log onto the server with my NT login any more. And, I don't know/remember the "sa" password. Is there any other way to log on in this case? thanks, KC ...more >>

Hi, Has anyone ever tried or heard of a way to connect to SQL via an old DOS compiler such as QBASIC or BC7? Alternatively would any body know of an API to ISQL ? Don't like my chances of people using 10year old s/w but you never know. Cheers...more >>

I am getting the following error ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure everytime I try to add a new field to a table in any database on my server. I can do queries, I can add new tables. I just can't edit the structure of an existing one. I am using versio...more >>

I have problems passing a date as a parameter from .NET to SQL Server. .Net seems to pass across the date as "#11/28/2003#" SQL Server seems to want it in the form '11/28/2003'. Can someone tell me how to reconcile the different formats....more >>

Hello: I think this is a simple problem, and frankly, not sure why it's a problem. I have MSDE on a laptop and need to be disconnected from my network. After the cable is disconnected, I cannot open MSDE anymore. I've checked all that I can think of. I get varying error messages depending...more >>

I need help verifying how many access licenses I have on my SQL server. Nothing shows up in the normal licesneing area in windows 2000. When I purchased the server it was with the understanding that I bought a per processor licesense so that I would deal with issue with access licenses...more >>

I need help on this one. I have 1 instance of SQL7.0 with SP2 and several SQL2000 with SP3 on 1 Server. Using SQL2000 Enterprise Manager, I login from my client using the DBO login for a certain database. When expanding the Database, I could not see any databases, sometimes using Refresh...more >>

Hi, I am using SQL Server 2000 as backend and VB.Net as front end. The SQL Server will be kept at a central location. I can access the SQL Server from any computer which belonged to the same domain. But I don't know how I can access that SQL Server remotely (from a computer that did not belong t...more >>

Hi, First sorry for my english I'm french. I developped a web app that work good under XPDEVSERVER machine (iis5) = and SqlServerDevelopper Edition. I get problem when I moved this app to an other web server (IIS5.0) = win2000. Actualy, I only have problem to connect with the Database tha...more >>

Is there a published articles decribing How to connect an AS/400 as a linked server using Client Access ODBC? All of the articles out there (Q222937, Q218590 & Q287093)only reference an SNA connect....more >>

Hi I'm using VB.Net to connect to a SLQ Server DB, currently i am developing on my PC, which is also the SQL server box, therefore i am using the connection string: data source=(local);database=isis;integrated security=true This works fine. However i cannot connect to it using the network...more >>

I am posting the following information in hopes that it will help someone trying to accomplish a similar task. My search for this solution was fruitless across newsgroups, MSDN and Google. On my current project, there is a need for adhoc ODBC SQL Server server links created from a .NET Win32 ...more >>

On my LAN: 1. W2K Server, SQL Server 2k, is a Distributor 2. W2K Pro, MSDE (with client tools), is a Subscriber When trying to register the W2k Pro on the W2k Server's enterprise manager I get "SQL Server does not exist or access denied [connection.open()]..." But the odd thing is I ca...more >>

It appears that any machine I have using SQL server 2000 SP3a cannot properly connect to an Oracle Linked server. Machines that fail to connect are SQL version 8.00.760 (SP3) running Win 2003 and win 2000 they are Dell Severs. and the two that do connect are SQL Version 8.00.194 RTM runnning...more >>

Hi, I have SQL server 8.0 installed on my Win2k server. IT had to change the server hostname and after that SQL server refuses to logon (via Enterprise Manager or query analyzer..) I was under the impression that changing the server hostname would not affect the db server, the hostname be...more >>

Hi all, I just installed Win 2003 enterprise on my laptop. I also installed VS 2003. My Server Explorer works fine until I unplug it from the network. When I unplug it from the network I get a connection error message and a big red X under the server node in Server Explorer when I try to ...more >>

Run time error "2147467259(80004005)DBNMPTW. What could be the problem?...more >>

Ok, here's the scenario. On a Windows 2003 Server I have MSSQL 2000 installed. On another test server I have Windows 2003 server, IIS 6 and Coldfusion installed. There has been an account created in SQL and assigned permissions. My coldfusion web site makes multiple calls to the database ser...more >>

I have a process that is trying to connect to the sql instance which resides at "local" or "localhost". Unfortunately for me, I need it to go to my SQL 2000 instance, not the "local" name which points to my SQL 7 server. Is there any way to "trick" the name "local" or "localhost" so it w...more >>

I manage several member servers (MS SQL Server 2000 SP3 / Windows 2000 SP4) in a large Windows 2000 domain. Yesterday, a domain admin renamed one of the servers to conform with our server naming policy. SQL Server is set up for both Windows Authentication and SQL logins. However, now remot...more >>

How can I connect to a SQL server that is on a different domain?. We have 1 NT and 1 Windows 2000 Domain Contollers both with SQL on. We used to dial in and connect, for replication purposes, which was fine but we now need to connect across a lan without re-configuring the domain serve...more >>

Hello, I have a server in house, I created my own database on the server, then added my computer name as an admin user with windows autenthication. Then on my workstation, I installed SQL Server, added the server name in client network utility, and after tried to register the serve...more >>

Hello, I am currently trying to connect from SQL Server standard 2000 to MSDE 7 using linked servers, but whenever I try to remotely execute a query, I get the error "SQL Server does not exist or access denied." I am using standard SQL logins on both machines, and I have checked and do...more >>

I changed the archive of a program in VB6 that used Access 97 Database via DAO USING JET 3.5 passing it to SQL server (sqloledb1 driver) and using ado 2.7 and with surprise (The file structure and data is not grown) I find now the program slower than before using access file?? It is possi...more >>

Hello: I need to be able to determine the name of the client machine running the session. The value in sysprocesses.hostname is client-supplied, so it may be not the real name of the client machine. The client can explicitly specify any host name in the ADO connection string. Is there a way to...more >>

Hi all, I am new to SQL, using an accounting package that runs mssql engine. I need to stop and start the engine thru my backup software. I am using Backup Exec 8.6 which allows me to type in a command before backup and then once after backup is run. My question is what is the dos comm...more >>

Hi, We have SQL 7 and 2000 servers and I create link server on each machine respectively. I use openquery to get data from each machine by creating a view. Somehow, I will get timeout frequently by query the view at SQL 7 (which use openquery to get data from SQL 2000). But, I don't ...more >>

Hello all, Can Yukon workbench be connected to any other version of SQL Server? Thanks Steve...more >>

Hi all SQL Gurus ! I'm trying to connect an Access 97 database using a Linked Server (on MS-SQL 2000). The Access database is stored on a file server. Here is the SQL Statement I used to create the Linked Server : sp_AddLinkedServer 'TEST', 'Access 97', 'Microsoft.Jet.OLEDB.4.0', '\\Serve...more >>

On my local machine running Win XP Pro, a sql server login fails: ][SQL Server]Login failed for user 'userid'. Reason: Not associated with a trusted SQL Server connection. The connection to sql server is specified in a web file called dataconnection.asp: Set objConn = Server.CreateObject("A...more >>

Hi, I keep getting a "Must use dbSeeChanges option with Open Connection Error", while connecting to a table that has an Identity field. I have also trying this line of code instead of the origionl (Listed below), but get the same error. Set TotalViewMURST = TotalViewMUDB.OpenRecordset...more >>

I'm receiving this error intermittently while performing an OPENQUERY on a link server to Viz FoxPro data. Does anyone know how to resolve this? tks, PH...more >>

(With thanks to previous contributors) I am trying to assign a variable to a Select Statement in a Stored procedure e.g. CREATE PROCEDURE Count_Records AS SELECT top 10 * FROM CustomerBufferData GO Where the 10 would be replaced by a quantity that I wish to pass from a VB app....more >>

Could someone please provide tell me how create a SQL Server 2000 linked server with Sybase adaptive server anywhere 8.0? I can create a ODBC System DSN, but I can create a linked server in Enterprise Manager. Thank you....more >>

hello my sqlserver is refusing to restart after i have displaced my data base files on another disk please help urgent...more >>

Dear all, I'm trying to configuring my MS_SQL Server 2000 to use linked server connecting my database password setup .mdb (not using workgroup admin) I always got error "'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80040e4d: Authentication failed" I have been checking o...more >>

When we connect to SQL server through a client over the network, is the login information (id /pwd) encrypted ? If so, what is the algorithm used ? Does the same apply for connection through ODBC drivers ? Please help. Regards, Shreesha....more >>

Hi All I am new to MS SQL Server.I am using MS SQL 2000.I have a problem in creating a table by using Select command.I have table called "test" and i want to create another table with the same structure and rows.I tried with the following comman create Table test1 as select * from test But it ...more >>

Is there a way to use Windows Task Scheduler to notify me via email if either the Server or Agent service stops. We have numerous support personnel that change the User password for the account that runs these services and then the services fail. If not, is there is another method not inv...more >>

We want to have a section of our web site for our clients to login to there own section and was wondering can a database be created in SQL and link to our web site so when clients log in, the SQL datbase will be updated?...more >>

I realize the problem has been around for a long time. Has any service pack or patch available that allows paged query to overcome the limit? Thanks. ...more >>

We've just installed two machines, both running Windows Server 2003. One is hosting a SQL Server, the other one is used as webserver. I try to make an ODBC-connection from a website to the SQL Server, but end up with the following error message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]S...more >>

How can I assign a variable to quantity in a stored procedure ? e.g. 'select top @quantity * from tablename' doesn't work....more >>

I am running SQL Server 2000 (SP3a) on a Windows 2003 server. Within the same domain I am running a Windows 2003 server machine with IIS 6.0 on it. The web site I am working on makes numerous calls to the database server using an account set up in SQL. The problem is this; every few day...more >>

All setup and configurations are in normal status on Windows Server 2003 (Standard) with SQL Server 2000 SP2 (Standard Edition). The SQL Port is 1433 by default. But, I still cannot access SQL service by PC's Query Analyzer. I've tried to activate sqlxml and set IIS back to 5.0 isolatio...more >>

Is it possible to disable logging when performing an Update query with Query Analyzer? If not can it be done via bcp? The reason is I don't have enough disk space for a large update. -Craig ...more >>

*apologies for multipost Hey we have an SQL7 box (soon to be upgraded to SQL2k) we have in-house client software that connects to a db hosted on the box via ADO + SQLOLEDB. Our client software always specifies an "Application Name=" parameter in the OLEDB connection string. The applicatio...more >>

We've been trying to setup appropriate filters on our internal firewall to allow me to connect to our prod SQL 2000 clustered server which uses port 1433. However, when just allowing 1433, I can't connect using the native SQL tools (Ent mgr & Query Anal). The network folks "sniffed" my traffic...more >>