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 >>