Hi I have a local computer with a MSDE and a SQL Server PE installed. They both have SP 3 installed. I would like to import an Access database to my MSDE (or the PE if MSDE import is impossible). I use SQL Server Enterprise Manager When I rightclick on a database and select All Tasks-->Import ...more >>

This is really weird. I have a query in sql that runs like this: SELECT * FROM uvTTExport option (force order) It runs fine and returns 800+ records. I need to run this query in Access so I can use some Visual Basic + MAPI code to process the records... so I created a pass-through query wit...more >>

Hi, Now there is a requirement for me to connect the remote server via internet. Is it possible? If yes, what i want to do. I'm the beginner. Please explain in detail. Thanks in Advance. Regards, E.S.Mohammed Igbal M.Sc., Chella Software Pvt Ltd., Madurai. Phone No: 5391927 ...more >>

Hi, I am trying to login into my server via query analyzer and I am receiving the following error. Any ideas how I can rememdy this issue. Thanks! Connection failed: SQLState: '01000' SQL Server Error: 1326 [Microsfot][ODBC SQL Server Driver][DBNETLIB] ConnectionOpen (Connect()). ...more >>

hi, we are using sqlclient to connect to DB from app code. When ever there is an error we set the SRV_DONE_ERROR falg in srv_senddone & we also send the result-set. now sqlclient throws an exception whenever there is an error ( when SRV_DONE_ERROR flag is set ) and does not allow us t...more >>

Hai Guys, See if anybody could help me out. I am unable to connect to a remote sql server 2000 using query analyser. It give me the following error msg 17, level 16, stste 1 SQL Server does not exists or access denied. Can anyone let me know the solution for this. Sath...more >>

Hi, Is there anyone over there with experience of writing C code for a tabular data stream (TDS) connection with a SQL server? Hope someone could help me with this. thnx in advance! ...more >>

Hi Everyone, I'm new to the SQL Server world. I am looking for a tool similar to SQL navigator in Oracle, that will optimize Sql queries for me. Any suggestions? - SM ...more >>

Hi All I have SQL Server Developer Edition Installed on my server. Can you explain how I comnnect my workstation to the server to be able to use Access 2000 as a front end database with the SQL Server as the back-end. What if anything needs to be set up on the WS to connect to Server. I am con...more >>

Hello people, I am experimenting some problems with two linked server (the first one with SQL 7.0 SP 4 and the other with SQL 2000 with SP 6), when I try to run some querys I get the follow message: "OLE DB provider 'SQLOLEDB' supplied inconsistent metadata for a column". Somebody can hel...more >>

Hello: We are using MS SQL 2000 server on one of our sites. We are unable to access the databases folder in the server. After connecting to the server through Enterprise Manager and clicking on the databases folder, the server does not responds for long and later hangs. As mentioned by...more >>

Hi All, I had posted this is security, but this looks like the right group for this. I just put the blaster patches on our SQL servers and now all kinds of problems have appeared. When trying to connect as SA using Enterprise Admin, the error appears Reason: Not associated with a ...more >>

Hi Please help me URGENT How do i make an tableField with a Auto-Incr, the same like in an access DB where it's called AutoNumber Thanx in advance __________________________________________________________________ Flemming Paulsen ICQ#: 270065050 Current ICQ status: + More ways to contact m...more >>

The MSDE SP3 installation went fine. Service is running, but not TCP socket is listening on 1433, The log says SQL is listening on shared memory. What did I do wrong? --Eric...more >>

Hi, looks like sql server 2000 (no sp) can't distinguish between 2 rows with timestamps less than 3ms apart in other words if you query a bunch of rows with a date > expression in the where clause in a select statement it will actually drop rows heres an example select top 5 id, modi...more >>

Hi, Does anyone have or know where I can get or download this program. Thanks!...more >>

My sql Mail is properly configured. Every time i use xp_sendmail , the result set confirms that mail is sent.When i check my outlook, nothing shows up. When i go to enterprise Man->SQL server agent->jobs->right click->properties->Notifications-> assign any one of the operators to be noti...more >>

I'm connecting an Oracle linked server using the Oracle Ole DB Provider (the Microsoft driver is trashing my Multibyte characters). Any select query returns an error about "inconsistent metadata". A search of this group indicates that others have seen the same problem, but none of the threads re...more >>

I need to be able to detect the name of all sql server that are on the network...more >>

Hello NG, I have a problem with my SQL Server running on Windows Server 2003. It is impossible to connect to that server from outside (that means from another computer over internet). When I try it with oSQL I get: SQL Server does not exist or access denied. Local connections to the SQL Serve...more >>

I have an end user with SQL Server 7 and it has been working fine. Apps connect to it through ODBC, including on the system running SQL Server. They installed some address book program on the system running SQL Server and after that, the ODBC data source could not connect to the server (on the...more >>

Hello, I was to be able to upload a file on to an FTP Site from SQL Server. I know that there is a DTS Task that can download files/file from and FTP site and this is not what I want to do. Instead, I want to be able to transfer a file on to an FTP Site (more or less Uploading not downloading). ...more >>

Anybody seen this messege when using SQL Server Enterprise Manager ? An error 1722 - (The RPC server is unavailable) occurred while performing this service operation on the MSSQLSERVER service. ...more >>

All, I am trying to connect to a sql server (2000) across the internet using Enterprise Manager (no vpn, no dial in,etc.) - strictly across the internet. Now, I use the Query Analyzer tool to connect and it works, I can access the server just fine. When attempting to do the same within Enter...more >>

We have a prototyped access front end with linked ODBC tables when we push out the front end to clients machines so that they can run it locally the WSID in the ODBC connection string refers to the developers PC. How do you change this so it refers to the clients PC. Unlinking and relinkin...more >>

Hi all, I have a SQLServer or MSDE Instance called X, which I am trying to start through SQL-DMO. I've noticed a difference between the OS's Using the following...... set o=CreateObject("SQLDMO.SQLServer") o.Start 0, "(local)\X" This only works on Win98/ME machines! To start an...more >>

To make this short, I'll ask the questions first and outline the problem further on: Can I run two different instances of MS SQL Server on the same physical machine using **two different** passwords for the sa account in each instance? If so, can I access both servers with Enterprise Mana...more >>

We are creating an offline version of all of our web apps and SQL server databases for a fully disconnected training / demo session. IIS 5 Web Server Hosting Multiple Websites -> Copied to laptop server 4 Separate SQL Server Database Servers -> Copied to laptop server All to be copied to...more >>

I use Enterprise Manager and IP addresses to connect to several Sql Servers in another city. When I have a project on a particular DB I am given a SQL Login for that DB and away I go. I recently got a project on a new server (Windows 2003) and couldnt register it. I have EM as result of...more >>

It is bad enough that my email address got harvested for the fake Microsoft IE 4.01 product alert email that has a virus attachment as a security patch. But I think the posts should be more closely censored as you can see from some of the posts in this newsgroup. -- ***********************...more >>

Server OS: W2k sp2 + security patches. SQL Server 2000 sp3 Mail Server OS: W2k sp2+security patches Microsoft Exchange 5.5 Steps I have taken: 1. Created a Domain User with Admin Rights for the SQLServerAgent Account 2. Added that user to the Machine Admin group on the SQL Server 3. Logged ...more >>

I have SQL Server installed on my PC along with an App that connects to it and manipulates various tables, etc. For this app, I do not utilize any network connections and only access my own local database. Also, I use an ODBC connection for connecting to the Database on my PC. The problem...more >>

Applied security update 815495 (cumulative patch for SQL Server) and MDAC 2.8 on Windows NT 4.0 Server SP6a with SQL Server 7.0 SP4 installed, and users cannot connect to database. Attempted to rollback security updates with no luck. Troubleshooting steps?...more >>

Hi, Is there a method to export sql resultset to excel sheet? Thanks. ...more >>

Hello, I've installed a local version of SQL server personal Edtion on a Windows 98 PC and IIS on a Windows 2000 server. Under IIS a virtual map points to a directory on the 200 machine. In this map I created an asp page that points to SQL Server on the 98 machine. A simple html page with no...more >>

SQL Server 2000 is supposed to support up to 8K varchar data type, but if I use ODBC to connect to database, I can only retrieve 255 characters. How to retrieve more than 255 chars? ...more >>

my sql server database is in remote place. how to create a instance of remote server database from my local machine. i want to access all of my tables which are available at remote sql server database. ...more >>

I have started administrating a system that has 44 databases running on the same server. That is 44 user databases. This is running under NT4 SP 6a and SQL 7 SP3 I am sure that SQL was not meant to support this number of databases on the same server but unable to find any documentation to s...more >>

I'm attempting to set up a table on SQL Server 2000 for analysis, using source data from an AS/400 server and the IBM AS400 OLEDB Provider which is installed with the Client Access Express product. If I use the DTS Import/Export wizard, the data preview for the "Copy tables(s) and views(s) fro...more >>

This is my first SQL project. I'm attempting to run AutoDL's setupdb.bat from the Exchange 2K Resource Kit. It tells me that I've failed to make a connection. The script is running on the server where SQL 2K lives. What do I need to do to establish a connection? ...more >>

I installed sql server 6.5 on Windows 2000 server. I opened sql enterprise manager to register a new server locally. It said the server couldn't be connected. I cannot find any active server in enterprise manager. I am sure sql service manager shows this server's ms sql server, msdtc, and ...more >>

Hi, I have connected to the SQL server database using the Access Project but I am not able to add in rows to exisiting tables when I open up the tables for editing.No empty rows shows up at the end of the table to allow me to do so. It works fine for new table setup.I am able to add in data f...more >>

how do I combine 3 columns within the same table. for instance firstname, lastname, middlename all into one field ...more >>

I need to install another instance of SQL. The manual for the program I am installing tells me that if there is already another instance there, that I cannot use port 1433. What other port would, should I use?...more >>

Hi. I'm running the same ASP.NET code on the same IIS box in two different virtual directories, but against two different SQL servers. We upgraded the SQL servers to SQL SP3 and I now cannot connect to one of them. I'm not convinced it is a client issue as, as I mentioned previously, I'm running...more >>

Hi i want to connect to the mssql7.0 database with this asp script dim strConn strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/../../mssql7/data/stage_data.mdf") dim adoCn dim strSQL set adoCn = Server.CreateObject("ADODB.Connection") adoCn.Open strConn di...more >>

how do i remove sql from my win2k server in prep for a fresh install of mssql? ...more >>

I've seen similar postings with no solution, so I'll post again.... Windows 2003 server, default instance of SQL Enterprise edition. Client has utilities from SQL Server Standard edition. (MY Win 2000 server has Standard edition. I am merely helping out another division in getting th...more >>

I have an Access 2000 DB that has an ODBC connection to a SQL 6.5 Server. The server is runing in Mixed Mode (SQL Authentication and NT Authentication). I can open the ODBC connections if I use SQL authentication (my SQL username and password). I cannot use a trusted connection to open the Ac...more >>

I have several different databases, including a single Thorough-Bred database, an old My SQL and a new My SQL database. My question is this, can I merge all these into one single database or is there a way to front all five data bases with some type of gateway that somehow downloads every...more >>