Hi guys - I am not sure if this is the news group I should be writing to, but I have been having a weird connection problem with an application that I wrote in SQLDMO when it tries to access the server. The server has several databases and my application tries to connect to the "MyA...more >>

Is it possible to create multiple user accounts within SQL 2000 via a script? We have a database on a development server that is overwritten every night. I would like to be able to create a script to create the user accounts needed. Any help or guidance would be appreciated. Thank you. ...more >>

Using VB 6, sp6, On sql server 2000 (sp4) When I try to establish a connection to the database from a VB 6 program using ADO, I get a similar message if the UserID does not exist or if the UserID does exist but does not have the permission to the database. The NativeError number is differe...more >>

Hi! I am trying to migrate the Back end of an MS Access based aplication to an SQL server 2000. I KNOW how to use passthrough queries in MS Access. So, my question is: How can I CREATE a passthrough query from a VBA code? I want to know WHERE to point that this will be a passthrough query? I ...more >>

A SP with join's between tables of 2 SQL 2000 linked server used to work relatively quick. Since a few weeks the same SP that runs on +/- the same amount of data takes much more time (43 sec). When i copied the DB so that the SP should run on the same server it takes only 13 seconds. Probab...more >>

Hi. I have a SQL 2000 server that I have created a number of tables. When I connect to the database using ODBC with ACCESS the table names appear to have my user details added to the front. ie. I create a table in Enterprise manager called "names" When I try to link to the tables with a...more >>

I am trying to make new connection with SQL Server 2005 Express Database from my Visual Basic.Net program. I am using connection string as "Dim connectionString As String = "Data Source=.\SQLEXPRESS;Initial Catalog=MgmtSystem;User Instance=True". But it is giving me error as " Failed to gener...more >>

I have followed the examples from MS. to create the link between my MSSQL2005 and Oracle 10g I have all of the Oracle client installed on the server. I have a net service defined. Here is what I ran to create link: EXEC sp_addlinkedserver 'OraLinkServer2', 'Oracle', 'MSDAORA', 'HPRD89...more >>

Hi, I have a problem to delete a user and it gives me this message in SQL2K5: The database principal owns a schema in the database, and cannot be dropped. (.Net SqlClient Data Provider) Can any body help me. I will be grateful This databade came from a SQL2K and I can connect from any ...more >>

"The request failed or the service did not the respond in a timely fashion" I am using xp servicepack 2.0 and sql server 2005 developer edition...more >>

Hello, When I try to connect it give the following message I copied from the log: Source Logon Message Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. [CLIENT: <local machine>] I am using Win 2003 Ent. and is domain controller. I use ad...more >>

Hello, I am working on a project that will require the use of SQL Server 2005 Workgroup Edition. We were planning to use the version that comes with 5 CALs instead of the version that is licensed based on processors due to the enormous cost difference. The application I am working on is...more >>

I notice that SQL 2000 has a datatype of image. My question is after I setup the table and fields how do I populate the table with image data? ...more >>

One my company's customers has allowed me to connect to their network via VPN. Overall, it seems to work fine. I can remote in, or map drives, etc. However, I have been unable to use my SQL2000 Enterprise manager to connect to their database. I can remote into the machine where that database r...more >>

in sql server 2000+ is there some stored procedure that shows your current disk space usage? ...more >>

Dear All, I've been searching the MSDN web for the MSSQL 2000 Developer connection limit. However, could not find any authentic documentation that says MSSQL 2000 Developer connection information. With MSSQL 2000 Developer Edition, do we have any limitation of connection direct to databa...more >>

I have the problem that at times I can't connected to the database via Microsoft SQL Server Management Studio. The error is: "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding". But in other times I can obtain a positive conne...more >>

I am using MS SQL Server 2000 in a server with Windows Server 2000. Workstations with Windows XP and Windows 2000 do noy have problems to connect with, but the ones with Windows 98/second edition/last updates and service packs cannot do so, specificaly it is impossible to create an ODBC connec...more >>

I have a machine where I have installed Visual Studio 2005 including SQLExpress. I have also installed MSDE2000. They are both named instances: MyMachine\SQLExpress and MyMachine\S3MSDE. Locally everything works fine. But when I connect to MyMachine from an other machine with the connectstring ...more >>

Dear friends I have written this code for create a database in my sql server express = (for to be clear after this program I think to found program in my = server where there is Master, ecc. Instead the program have create the = file in: C:\Documents and Settings\Giuseppe\Impostazioni locali\...more >>

I have a web application which uses SQLOLEDB for connecting SQL server 2000 database (sp4). The application server and database server both runs on Win 2000. strConn = "Provider=SQLOLEDB; " strConn = strConn & "Data Source=PC; " strConn = strConn & "Initial Catalog=ABC; " strConn = strC...more >>

Hi, I am connecting to my SQL server 2005 database using a remote connection. Can someone provide me with a SQL script which will enable connections via TCP/IP to the database? (i.e. I'd like to do the step of going to the configuration manager and enabling the TCP/IP protocol for the SQL ...more >>

In ADO.NET how to tread a large NTEXT field in small chunks? e.g. my NTEXT field is many megabytes but i only wat 10k at a time? how to do this in ADO.net? ...more >>

MSDE has a connection limit (as far as i remember, you can't open more than 20 connections at the same time) but other editions of SQL 2000 has no limit for opening connections. Is there a limit for how many connections can be opened to SQL 2005 Express edition at the same time. ...more >>

how to display 10 rows at a time when 1000's returned form sql query how to select the 20th-30th row in a where clause? e.g. select the 20th to 30th employee who name is 'bob' in tsql. i need this because my select often returns 1000s of rows and i want to display them in pages of 10 at a tim...more >>

Is there a way to establish an exclusive SQL 2000 connection, i.e. only allow 1 user to connect? In Access I am able using a file DSN with Exclusive=1. Is there a similar property to use in the connect string or ADO connection object (I do not see anything glaring there)? Thanks - Tom ...more >>

Hello, I have an asp.net application which connects to SQL server using the normal ado.net mechanism. One customer cannot get it to connect to the database. his connection string is user id=aaaa;password=bbbb;initial catalog=cccc;server=dddd and he gets the message: Cannot open databas...more >>

Is there a way to avoid the following problem: I have a database created in SQL 2000. I detatch it from the SQL 2000 instance. I attach it to a SQL 2005 instance (I can see the compatibility mode is SQL 2000). I detatch it from the SQL 2005 instance. I try to reattach it to a SQL 2000 insta...more >>

Hi All, Should the transaction isolation level persist across the reuse of a connection from the connection pool? From my experiment it does persist and I was not expecting it. I was under the impression that "sp_reset_connection" will tear down all the connection level settings and go back t...more >>

I have two machines and same problem. I installed SQL EE on XP HOME EDITION it is OK ! Localy work OK ! I try to connect from another machine with SQL Server Management Studio and I can't. I some how successed to connect with named pipes but TCP/IP is not working. I turn on all protocol...more >>

We use SQL Server 2000 and have a Linked Server to a Progress 9.1E Database. Everything works fine until a schema change is made in the Progress database. We then get an error message similar to the following: OLE DB provider 'MSDASQL' supplied inconsistent metadata. An extra column was su...more >>

Hi All, I need transfer data from MySQL to SQL Server 2000. Does anyone know how to make a linked server from SQL Server 2000 (SP3 or SP4) to MySQL? If it's possible, I need install MySQL client software in my SQL Server box. Am I right? What kind procedures I need follow? Regards! -Chen ...more >>

Hi, I am testing a asp page using sql server as the backend database. However, I cannot connect to the database from asp. I have the following error coming and I have also added the connection string that goes with the asp page. Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E...more >>

Hi, I have this problem: When I create a new Login with a "SQL server authentication". And if I change some User Mapping and Server Roles it gives me the follow message "Create failed for User 'win2kadmin " Server Name: SERVER\SERVER Error Number: 15023 Severity: 16 State: 1 Line Numbe...more >>

I have a dedicated Windows 2003 Web Edition server running SQL Server 2000. SQL Server 2000 was pre-installed. What tools can I use to interrogate and update the SQL Server 2000 database from the Windows 2003 Web Edition Server? Client and Adminstration tools are not supported and will not ...more >>

I have SQL Server 2000 installed which has a server name of NOTEBOOKDELL. I installed SQL Server 2005 Community Technology Review last October, 2005, and somehow gave it a server name of NOTEBOOKDELL\SQL2005 so that I can keep my SQL Server 2005 databases separate. All was well until I...more >>

I need to rename a column in a table in a sql server database from my .NET program. I can't seem to find the syntax to do this. Can it be done just using sql? Thanks db...more >>

Is there a way that i can rename some fields in a table using SQL from my ..NET program? The customer send sthem in as BMT Number and I need BMT_Number, etc. Thanks db...more >>

For some unknown reason we just lost the connection to our local SQL server. The error message is "Connection failed, check sql server registration properties". I can't find any usable info on this cryptic error message. Nothing was being done to the server around the time that this happened...more >>

Connect to Sql Server >> SQL Server: [____________] Connect using: [ ] Window authentication [ ] Sql Server authentication Login Name : [____________] Password : [____________] -----------------------------------------------------------------------------------------...more >>