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