I made a query on a non indexed column using SQL Server 2000. The estimated execution plan in Query Analyzer stated that it used the Clustered Index Scan. Can anybody explain to me why and how? Thanks much! Aiden Fung ...more >>

I have a search page that takes in various fields. Users may leave some of them empty. However in the sql generated the code is still doing a "Where X='' or Y='12'". Notice how X is still there, just that it's blank. Does this lead to more overhead on the sql server? ...more >>

We have a SQL 2K standard sp3a box with 4 procs, 4GB ram, and IO on a good SAN. We had a situation where there were only two processes running on server. Process one is a bulk insert into DB1. Process two is a simple select in DB2 with join of 2000 rows with 3.5 million rows. The select ...more >>

I just stress tested my web application (dotnet + ms sql) using 50 virtual users. Now, after the stress test is long over, I'm still unable to browse the site. I've restarted the sql server as well as IIS, but still it doesn't work. I've not restarted the server yet though. What can be caus...more >>

Hi Folks, I was wondering if there's a way to change a user's password without knowing what the current one is. sp_password needs the new password, even if the sa account is executing it. Is it possible to change the password without knowing the new one? Thanks, Brian ...more >>

I would like to update a field in a table based on the summazition query of a value in the same table where the value of the record is in the top 10% of the total value In my head I figure I need to get the the following : "select sum(inventory.value) from inventory" = 270...more >>

hi all....i need to write a stored procedure to generate a key colum id/code/number etc here is wat i need to do... lock the record so it can't be updated until i finish generating a new number lastnum is in the column, need to increment this number than write it back again before anyother use...more >>

Hi I hope somebody has already dealt with this type of situation and will help me. We have Sql7sp4 and db2/AS400. By using openquery and linked server(for libraries in AS400) in sql server I'm able to insert, delete and update the data. But my problem is I need to write Stored procedure for ...more >>

In my SQL server installation the msdb database has been marked "suspect" and also the SQL agent cannot be started. Also I can not define any backups in database management plans (there was on but now it is not working). The rest database seems to work fine for more than 2 weeks now. Any ide...more >>

We need to create a new unique file # for a document. This file # will be unique to the document type and to a year of the document. So each (document type, document year) combination has a next key value. Anyone have a suggestion for how to do this and avoid concurrency problems without using a...more >>

I have a db that should only have one entry per client for one of two services offered in a fixed time period. I am trying to write a query that will show any client that has more than one of these services. I have entered a known case with both services offered but the following query doe...more >>

I have what is probably a simple query, but I can't get anything to work. I have three tables. Table one(t1). Item, Description, product group, ........ 111 My item 43 222 Another item 44 Table two(t2): Item, location, qty_on_hand 111 1 12 111 2 4 222 1 20 222 2 10 Ta...more >>

Hi, can anyone help me convert from MS SQL database, into MS Access, with keeping all relations and constraints?...more >>

Hi there. Just wondering if there's a select you can do against the sys tables in SQL server like there are in Oracle. ie. SELECT distinct column_name from user_tab_columns where table_name = 'CUSTOMER' order by column_id ...more >>

Anyone used SQLSourceSafe? Or any other sql source control tool? Just want to learn your exp. ;)...more >>

Is it possible to script a Table as: "Create table a ..... Insert into a (....) values (...)" how can I do it (not manually;-) ? Thanks for any help Freestyler ...more >>

Below is a function i created for adding zero padding. The function works if i want to add '0' padding at the back. for example test00000. But if i change the function to make it pad '0's in the front it does not work. for example 00000test DOES NOT work. The commented code in the function...more >>

Hi all, I have a customer table with duplicate records. There's a primary key in the table and there're few other tables linking to it. I would like to keep the oldest record and delete the rest of the duplicates. Before that, I need to update some columns in the oldest record with the newe...more >>

Searching through a database with data stored as text places a huge load on the server. I've seen some applications that use some sort of word indexing that helps speed things up. Is this the recommended strategy? And if so, how is this implemented and are there any articles that detail this...more >>

I have written a application that stores tasks for a given day on my laptop. I'd like a query that , upon execution (I would call it from the task listing page) , would see that i have task(s) from a previous day that was not complete. Then it would set that status to 'Forwarded' and crate a NEW...more >>

I have recently installed XP SP2 on my machine and am unable to access the database properties in Enterprise Manager. If I right-click on a database and select properties, Enterprise Manager closes. Earlier, it had popped up a message saying that Data Execution Prevention had caught it and was...more >>

Hi, I am trying to create a new stored procedure in a database that has already been created. In SQL 2000 when I right click on stored procedures and look to New Stored Procedure it is greyed out and will not let me create a new one. Why is that? TG...more >>

Hi, Can anyone tell me what the recovery model RECMODEL_70BACKCOMP, referred to in the source of sp_helpdboption, is? I can find no references to it on Google. Cheers Simon Kissane...more >>

I am trying to allow connection to my ASP page using Sql Server 2000. I have set up a login name "web" and password "web" on my development machine (not my normal Sql System). In Sql Enterprise Manager, it shows "web". In my default database, I have it set up as public,db_datareader,db_da...more >>

I am wondering how I deploy SQL Server in a multi-seat application if I have SQL Server Developer edition. DO I have to buy a license to deploy, if so how much am I likely to pay per license. DO I have to buy the multi-thousand dollar package to deploy and then do I not have to pay per deployment...more >>

To all, After installing Windows XP SP2, a new problem was created in Enterprise manager. When you select a table and try to view the rows, the message "Provider cannot be found. It may not be properly installed." This occurs regardless of all the fixes that I have tried as posted by Micros...more >>