Hi, I have install the SQL Server 2k Eval version on a Win2K computer and update to SP3. the computer also running the IIS too. When I install the server tools of SQL Server 2000 CE Edition, I got the following error message:- "SQL Serve CE Server Tools is compatible only with SQL Server 20...more >>

When I launch a big script (~30mb) with the isql or osql command-line utility, I get this error. There are go statements every 100 statements and I have plany of available memory on my machine. Does anyone know what could be causing this or have a solution Thanks in advance Pau parmitage@lgc.c...more >>

I got an error 547 INSERT statement conflicted with TABLE FOREIGN KEY constraint. Please let me know how to resolve this issue. ...more >>

Hi, I have a SQL Server 2000 and an ASP that execute a stored procedure. It works fine for a moment, then it suddenly stop working. The ASP reports "Timeout Expired", but from another application developed in delphi and from the sql query analyzer I can execute the SP. I have to restart the...more >>

I just wanna know that which one query is more optimized one.... 1) select COUNT(*) from patient a where NOT exists ( select PP_VPatientID FROM PatientPersonnel b where b.PP_VPatientID = a.PA_VPatientID) 2) select COUNT(*) from patient where PA_VPatientID NOT IN ( select...more >>

How can I execute a SQL script from DOS? ...more >>

Hi All I have installed a SQL Server Client Standard Edition. I am trying to establish a connection using the Enterprise Manager in accessing the SQL Servers of our company. The error message that was displayed is A Connection could not be established to <server name> Reason: Invalid attribute...more >>

Dear Professional I have used the following query osql /U sa /P ngsol /i c:\Query.qry /o c:\titles.TXT That above query gave me the correct result in titles.Txt file but the problem is that in the top I have received the following stuff which I wanna remove it and how can I do ...more >>

http://www.microsoft.com/sql/reporting/productinfo/trial.asp If you have a SQL 2000 license, you can use the software. I don't work for Microsoft, but I am excited enough to see this that I wanted to send out the link. I have been waiting a long time to move beyond the limits of Infomaker or...more >>

Hi, I was wondering if someone could explain the following: When I run this query, I get a result set of 0 rows: SELECT COUNT(*) AS CountMe FROM T1 WHERE (column1 IS NOT NULL) However, when the following query is run, a result set is returned: SELECT top 50* FROM T1 WHERE (colum...more >>

Win 2000 server with Microsoft SQL server 2000 Can anybody help a beginner? I want to store URLs and email address's hyperlinlinked in the db. So that when I do a SELECT statement in ASP the results come out hyperlinked in my table. Is this possible, what datatype do I use etc. Thanking you i...more >>

I have a question like I have one table name emp and I am going to copy that table through the following command. select * into empnew from emp Now my question is that in the emp table there is a primary key with identity ON but I wanna off that identity in my new table (empnew) how can I d...more >>

Hi, When I install MS SQL 2000 Desktop Engine on a win2K computer, I got an error message: "The instance name specified is invalid." and then cannot proceed. Why ? Please advise how to solve the problem. Regards, Derek ...more >>

Hello, I'm trying to do a proof of concept on storing files (i.e. word docs or .pdf) as a field in SQL 2000. I guess this would be embedding of some sort. Can someone point me to any resources that can provide more info on this subject matter? Any help appreciated, Phillip...more >>

After doing netstat -na, it appears that sqlserver is listening on all tcp interfaces. What configuration you need to change so that sqlserver could listen on specific interfaces? Thanks in advance ...more >>

I'm trying to either use and expression based column in my dataset which concatenates fields (this has got be a common task, name, new line, address and post code) but have had trouble because carriage returns don't appear to be supported, but more importantly if any of the fields contain a null ...more >>

PLease I need help on how to move a sql database from one machine to another. We just bought a new server that is fast and reliable, I just need help in migrating the databases...more >>

We have an application using SQL server. The error occurs after client logs in to the software: This is the error: Application has generated an exception that could not be handled, Process id=0x22c(556), Thread id=0x564(1380) Click OK to terminate the application. Click Cancel to debug...more >>

I posted a message on this site and i think i put my own email in 'Sender's Email'. Since then I have had loads of emails sent to me that seem to not relate to anything and look a bit dodgy. Please can someone tell me how I can stop them. Many of them are from 'microsoft corportation' and ...more >>

Is there a way to insert into a table that only has one IDENTITY column defined in order to get the @@IDENTITY generated?? The following works in Adaptive Server and DB2 but MSSQL does not allow default on an identity column. insert into table1 (seq_no) values (default) Thanks!!...more >>

Hi, This is an urgent requirement. Another process is trying to load sql server table. How can i know the status of the table whether records are being imported into proper table. Please let me know. Thanks ...more >>

We're running SQL 7.0 sp3 - I have tried to change the role of a user from C to B. After selecting and clicking ok I receive the window "Confirm new password". I've done this many times in the past - have not been able to resolve this. Anyone else run into this issue or have ideas? Tha...more >>

I thought I knew enough about SQL Server 2000 that I understood my queries, but I've recently come across a situation that's very perplexing to me. The situation is that I've written a fairly straight forward query that runs very quickly one way, but very slowly when I make what I thougth was a m...more >>

How do I unregister a SQL-server in Enterprise Manager when the server is not available? thx in advance ...more >>

Hi All,. I am a total newbie to this but have been asked to research a few things regarding SQL Server. Can anyone please answer this question: If we were to develop a web front end to perform queries on an SQL database, can we effectively give 1000 users concurrent access to the SQL data...more >>

i wish to collect mobile numbers from a table outcustomer and verify if it exits in contact table, and only select those numbers which do not exist in contact table. suggest select * from outcustomer where mobile <> (select mobile from contact) *** Sent via Developersdex http://www.deve...more >>

Hi , In Excel, there is function -- TREND . I'm wondering how can we acheive this in SQL Server. Function will do something like this. TREND Returns values along a linear trend. Fits a straight line (using the method of least squares) to the arrays known_y's and known_x's. Returns the ...more >>

Hello, During the install of a SQLServer 2000 client I receive an error message that files are open from a previous installation and that I must reboot. I rebooted and re-attempted the installation, but the message re-appears. I have found a Microsoft article which suggests deleting various registr...more >>

Hi.. I have written a stored procedure that take 5 - 8 minutes to fully execute.. I wrote this routine as a stored procedure because I started to create all the functionality via ASP but I kept getting time out errors on my ASP page. The problem is that when I call the stored procedure from t...more >>

Is there a way to do this with DTS or another tool? I have an Access 97 app and I'm converting the BE to SQL2K. The upsize tools all want to convert my Access Text fields to nvarchar, but when I link them back to A97 this causes problems. I manually changed a field to varchar and the problem disa...more >>

Any idea what is this error mean and how to troubleshoot it? TIA SQL code 10040 encounter attempting to connect to database KDM group Db-library network communications layer not loaded...more >>

Hello, We are experiencing this severe problem with our software installed at a customer's office. We've tried to diagnose the problem, but we couldn't find the cause (and therefore couldn't find the solution either) that leads to this undesired behavior. I'll expose the scenario and the probl...more >>

I have one procedure name generalinsert which are as follows :- CREATE PROCEDURE generalInsert @tablename varchar(30) , @WhereString varchar(4000) AS BEGIN declare @column varchar(50),@datatype varchar(50),@query varchar(8000),@columnname varchar(8000), @reccount int,@counter int declar...more >>

Hi, We have a SQL Server 2000 system with two instance of SQL Server. On one system, and only on this one system, we cannot connect to one of the instances of the database. We can connect to the other instance. When we try to add the server instance to the server group we get the message: ...more >>

Hi - I need some help. We have a SQL Server that has a stored procedure on it. We also have some vb script inside of an excel workbook that calls the stored procedure. It works like a charm on my system ( I have SQL Server installed on my system). While we were testing, we sent the wor...more >>

I have created on table like this create table DateTest (DateChk datetime) and insert values in that table like insert into DateTest values ('01-01-1752') It gave me error like Server: Msg 242, Level 16, State 3, Line 1 The conversion of a char data type to a datetime data type resulted ...more >>

Are their any known issues with running SQL 2000 enterprise manager on an NT 4.0 sp 6 workstation. The SQL server is 2000 server, but enterprise manager is running on the nt 4.0 box. It runs for a few days, but then stops connecting to the sql server? Ideas? TIA...more >>

I have created a stored procedure that creates xml output via the FOR XML AUTO COMMAND. This stored procedure creates 3 levels of data which can be decribed as follows. CLIENT (ALL CLIENTS) -> DATE (WILL SHOW EVERY DATE FOR 5 WEEK) ---->APPOINTMENT TIME (APPTS ON THE DATE ABOVE) I am ...more >>

Hi In a table I have an image-column in which I am storing word-documents. Is it somehow possible to select only the text contained in the stored word-documents? TIA Klaus...more >>

i've a table like this Field1 field2 1 1 1 2 1 3 1 4 1 5 2 1 2 2 2 3 now i want to select only top 2 first rows of field1 like this 1 1 1 2 2 1 2 2 is there any sql statment for this Thanks...more >>

I have the following error when : The process could not deliver insert(s) at the 'Publisher'. I don't know anything about SQL. I have SQL 2000 server with SP3a and SQL 2000 PE with SP3a and I use Merge Replication. Thank you Laurentiu ...more >>

Hi, I am trying to create an application for IPAQ (windoes CE) that can access data from SQL 2000 server and send data back to that server. Can someone tell me how can I do this. Thanks, ...more >>

Hi! Is there any method to copy list of servers between Enterprise Managers? Regards Silmar ...more >>

I receive "Error 429: ActiveX Component Can't Create Object" when running a VB software that try to connect to SQL server. My PC running on Windows 2000. I have tried a few way that listed in MS knowledgeBase, but still not get it. Appreciate if anyone can answer this. Thanks....more >>

I have a client server application that needs to access a SQL database on the local server. It will work only if I use Named Pipes in SQL Client but not with TCP/IP. I checked everything possible but could not find a clue. But Query Analyzer works fine with either setting in Client Network Util...more >>

My question is pretty simple: How does one go about purchasing an extra license for SQL Server? A customer of mine has recently asked about this. I work for a small computer that usually only sells products like MS Works or Norton Antivirus, so I know very little about SQL. My usual who...more >>

Does somebody know how can I fix thir problem?? Error 28559: SqlServerCe encountered problems in opening the sql server ce database. I can sychronize data from the server to my pocket PC using a merge replication, but I can't do it from my pocket PC to the server. Thanks....more >>

A user connection which was killed went into RUNNABLE status with KILLED/ROLLBACK cmd when we monitored with SP_WHO2.It looks like the process was hung and no activity in CPU or I/O.How do we get rid of that process completely without restarting the sql server? ...more >>

I am running into a dilema with one of the reports I have to run from MSSQL. One table contains over 1 million rows (A) and 2nd table contains 20000 rows (B). row A needs to compare items from row B. This isn't that bad until I realized that this might take a few days to give any kind of re...more >>

Hi Recently I had posted a question on Enterprise manager error -> "Can not see any items under SQL Server enterprise manager" User could not see any items under Databases folder in enterprise manager(even after refresh and reconnect etc...). But when the user opened some table in ob...more >>