...more >>

A user received this message (subject line) while trying to add a record to one table in a SQL Server 2000 database accessed through VB 6 and ADO. The application was the only one on his machine running against the database. The Microsoft Knowledge Base has an article (316782) but it is fo...more >>

I have a tAdoConnection setup up to connect to a SQL Server 2k db. When trying to connect i get the following error intermittently, but quite often. [DBNETLIB][ConnectionRead(recv()).]General network error. If I retry a few times then it will eventually connect. Like I said, it is very unpre...more >>

I've been using Sql Server 7.0 and managing several databases using the MMC for 3+ years. About two weeks ago I lost the capability to view only the tables for only one database. Has anyone seen this? How do I correct this problem?...more >>

How do I update multiple tables in a sql database through a VB interface. None of the table are updated when the update button is pressed in VB interface....more >>

Hello. I am trying to run the following query: select t.orgname,s.descr, sum(CASE WHEN cast((wl.durwaitmnt/30)as smallint) <= 3 THEN 1 ELSE 0 END) "0 to < 3 months", sum(CASE WHEN cast((wl.durwaitmnt/30)as smallint) > 3 AND cast((wl.durwaitmnt/30)as smallint) <= 6 THEN 1 ELSE 0 END) ...more >>

Hi, Thanks for viewing my post? May i know... If i'm using per-seat mode running with windows 2000 Advanced Server, now i am setting up a SQL server for Development purpose, am i need to buy the SQL CAL for those computer access to SQL Server? Thanks for your answer....more >>

Hi HAve installed SQL Server 2000 (Personal) and SP3a, but still get the problem with Enterpise Manager and Query Analzer reported in number BUG #: 351147 (SHILOH). Can anyone advise what I may have missed out. Many Thanks Bret...more >>

Hello, I wish To start the Distributed Transaction Coordinator of the SqlServer on Win 98/2000. Can I do it through a command promt? Regards Jai...more >>

Hello, I wish To start the Distributed Transaction Coordinator of the SqlServer on Win 98/2000. Can I do it through a command promt? Regards Jai...more >>

We are running a query from a dotnet 1.1 client which is working fine on SQL 2000 but times out on SQL 7. The query does work on SQL 7 when using Query Analyzer 2000. With the dotnet app the connection times out (a trace shows the query finished). If we use Query Analyzer 7 (sp 4) the f...more >>

Hai, I installed SQL Client 2000 i am able to connect to database server, When i try to view a table on databse i am getting an error message saying that "Unknown Error" with a heding Sql Server Enterprises Manger, can some one help to resolve this problem ...more >>

Hi, I have FormA used to input data into TableA located in a SQL2K Server having one of the fields as check box (bit, not allow null). FormB is used to edit data stored in TableA. When checking/unchecking the box using FormB, Access shutsdown and restarts (It doesn't do it when insert...more >>

Server = NT 4.0 sp 6 and SQL Server 7.0 sp 4 with hotfix 031. Background: Our company is very large and is going through a domain shift to AD. A = new ID B = old ID X = old domain Y = new domain ( BX )Old id, old domain was original setup and worked fine. User then was switched ...more >>

I have 3 tables AUTHORS BOOKS SW_BOOK_AUTHOR_JUNCTION this is a junction table joining authors to books and this is a many to many relationship what i want to do is list my authors and a count of how many books they have each authored. author ! count of books --------!--------------...more >>

I'm getting the error above when ever I try to register a sql server in enterprise manager. This just started occuring today and I haven't been able to find anyone who has successfully dealt with this error. If anyone has had any luck....please let me know. I started by reinstalling MDA...more >>

One of our developers accidentally added a 'rowguid' column to all of our tables (mssql 2000). I'm trying to write a script that will drop this column from all the tables; however, I've run into a problem where I can't drop them because there are dependant contraints/indexes. The following cod...more >>

Has anyone an idea what this type of error means? Event-ID: 17052 Error: 17882, Severity: 18, State: 1 Error accepting connection request via Net-Library 'SSNETLIB'. Execution continuing. ...more >>

Hi all, Can any one tell me if you can update a ntext field from a stored procedure? My insert works but the update method using set does not work. Thanks Nishan...more >>

Hi, I posted this mensage on the access.form NG but I got no help. I thought to post it here and see if I have better luck in getting help. I have a dialog Form with a combo box used to select a record in a table and via a command, I bring up a Report. I would like to add two Date fields in...more >>

Dear Expert Does anyone advise me why I cannot use SQL Query Analyzer to connect SQL 2000 Server (SP2 - 8.00.608) installed on Windows 2003 Standard Server from another PC at the same LAN? (I've used SQL Server authentication "sa" account for direct connection and set IIS to 5.0 as isolat...more >>

Hi , Our company decided to convert all char columns to varchar in our next software release. We have lot (40+) of client databases which is more than 75GB . Below the query I wrote for this ,but it's taking long long hours to complete the upgrade. Is there any better way to write this ?? Th...more >>

My enterprise manager runs very slow. How can I install client network library and configure to windows XP? What are the Network protocol setting and other setting required??? Thanx at advanced Bhavin...more >>

Hi I have installed SQL Server Enterprise Manager on Windows XP. I register my server under SQL Server Group. When I click on my server name it shows me five folders Database, Database Transformatin Server, Management, Replication, Security and Support Service. But when I click on database...more >>

Hi, When I try to install the sqlsetup.exe (CD: SQL2000 \X86\SETUP\SQLSETUOP.EXE)on the W95 PC it starts to install but then says: "Setup Initialisation error, The system cannot find the file specified Source:'E:sql2000 \x86\setup\setup.ins Target: C\windows\temp\setup\bin\setup.ins. Also me...more >>

Hello All, What is the best way to build an application that uses an SQL server data base. I am trying to get something that is similar to a ACCESS wizard application.. with a switchboard or menus to add and view records and reports. Thanks ...more >>

I'm thinking about installing MDAC 2.8 (RTM) on client machine (Win2000Pro SP3 ou SP4) and servers (Win2KSP3 + SQL Server 2000 SP3) (cause some programs run on). Is this version of MDAC stable ? Or, migth I prefer 2.7 SP1a and wait for 2.8 SP1 ? What is your experience ? Thanks. Jacques...more >>

Hi! I have table with [EntryDate] field in it. I have problem creating where clause with selection for last 30 days starting from today's day. Any help appreciated. Thanks ...more >>

I have a SQL server that is hosting 5 databases, when I try and use Enterprise Manager running it from the server its self and connect to one specific database I get A runtime Error has occurred Do you wish to debug? Line 306 Error: Unspecified error it only does it for one specific da...more >>

Hi, Recently, my manager has mentioned that there was a software called "Leeco" or "Lecco", which is used for SQL administration. I was wondering has anyone heard of this software? Thanks. Peter ...more >>

Hello, I am developing a program using VS.NET 2002 and SQL Server 2000 to access the database. However, every time I write code to access the database using the command "ExecuteNonQuery()" I get the following error message: "unhandled exception of type "System.Data.SqlClient.SqlExceptio...more >>

How do I interpret the results of the sp_spaceused proc? I've got: database_size: 51 MB unallocated space: 7.70 MB reserved: 35128 KB data: 29504 KB index_size: 5114 KB unused: 480KB How much total space do I have in this database? How much is currently taken up? What do reserved and...more >>

Hi, all. I have a SQL2000 Stored Procedure that accepts 2 input parameters (works as designed, returns a small set of records). I have an Access 2002 .adp with a simple form (2 textboxes, 1 command button) for users to enter the 2 parameters and run a report. I've created a report a...more >>

Hello, Howto convert existing text in several columns to upper case? In other words, I would like to convert to upper case the entire table. TIA Sergi ...more >>

Hi, I have a column (CustOrderNo) which is set to datatype int and IX_tbl. We need to change the format of our Customer Order Number from 123456 (6 digit #) to T123456 (alphanumeric) format. 1. Can the data type be changed w/o affecting the data? 2. If so which datatype would be more appropria...more >>

Dear Professional I just wanna know the last access record like I have three records in one table like 1 ABC Active 2 EFG NotActive 3 EDS Active I just wanna know when the 1 record(ABC) last access date, in...more >>

Hello, I am using CRViewer to Dispaly the Reports. I am using ADO & Access as Database. The reports run Fine on the code machine. But when Packaged and installed on th another machine without Crstal reports, The CRViewer is Shown but no Report display. I get the Message Physical Database not F...more >>

I work for an organisation that uses a bespoke document imaging system, the database of which is an MS sql server. We have MS Access and already use it for some querying of the database. The database comprises a large number of distinct cases, which are differentiated by case reference numbers, ...more >>

We are trying to access a SQL server 7 database using an application called "Saleslogix". We are connecting from Windows 2000, and XP clients running the SQL Server 2000 client. On all but one of the systems, we can access the database great. On the last one, we keep getting the error ...more >>

We are running custom apps written in VB for SQL when you close a program sometimes it remains open in the background.You can go into task manager and the app is still running,I am talking app not process but the app is closed on the desktop.We use XP but had this happen with both NT and W2k....more >>

I have multiple clients connected to my training SQL Server 2000. All the machines are configured the same they all have the same RAM, hard drive space and programs installed. One machine is very slow responding when the SQL (Windows NT) Icon, I am talking from 25 minutes to an hour or lo...more >>

I need to how to convert julian date to date...more >>

I have a question. For example I have a table called Customer, it has the following structure. >CustID PK - Clustered Index >Last Name - NonClustered Index >First Name >Zip Code Is the following Select query use indexes to retrieve data or table scan as Zip Code is not part of non-clustere...more >>

I am storing the request and response from a webservice on a "log" table. The data is in as LogText Column varchar (3000). The character data has all the XML tags and such. We now want to display portions of the log table such as the XML request and XML Response as character data to incl...more >>

i can connect to my sql 2k using names pipe but is not connecting using tcp/ip getting error 17...more >>

Hi there. U have table structure shown here: category (Int - AutoIncrement) parent_category(Int) Title(string) 1 0 HOME PAGE 2 1 FIRST DEPTH 1 3 ...more >>

We are due to go into a meeting with a company who use Oracle instead of SQL 2000. We have been playing with SQL 2000 for around a couple of months now, and the whole point of this meeting is to find out how effective/reliable SQL 2000 is over Oracle when it comes to extracting data out o...more >>

I have sql server running an enterprise software with several clients. After running for about a week sql server increasingly uses all the available memory until performace becomes unacceptable. Is this normal or is there a configuration or patch that I need to apply? thanks...more >>

We have two machines on a peer-to-peer: MachineA: Office 2000 MachineB: SQL2000 Server, with 2 test tables called cust and inv with 7m and 168m records respectively. What I want to do on MachineA, is use an ODBC link to extract data from SQL2000 on machine B. Can someone give me some...more >>

Hi Can SQL 2000 tools be installed onto a Windows 95 machine? When I try to run the install, the only option available is the client connectivity. Thanks Jono...more >>