I attempted to upgrade to SQL Server 2000 from SQL Server 6.5 using the SQL Server Upgrade Wizard and I immediately received the following error message: An unknown error occurred while trying to restart your SQL Server 2000. Please check the server errorlog and try again. I've checked the...more >>

Does anyone know how to purge old data in a MS SQL server 2000 database? ...more >>

I have a situation where I want to filter records for a given day. The field that stores the date/time uses the date() function as a default value, kind of a date/time stamp for the record. The problem is when I want to filter records for a given day instead of a date range. I use the CONVER...more >>

I want my application to create a new database/tables when run for the first time. I have created a stored procedure to create the new database named "budget". When I run the stored procedure, it creates the budget database but the tables are created in the "master" database. Please help. ...more >>

We currently use SSIS to build DTS packages in which we store changes to our database schema, as well as scripts that need to be run upon each release. This works well for small sets of changes that never need to be updated or for architectures with only one database. We store each of the cha...more >>

I need a way to view all existing triggers in our MS Server database especially since I don't know what tables are involved. Thanks, kwilla ...more >>

Hi. I need to make a trigger which fires when after an UPDATE is done on table A in database X. The trigger must perform a statement which copies some of the data from the update to table B in database Y on the same server. My question is: Can I access the data which caused the trigger to fir...more >>

The iussue: Sql 2K I have to keep in the database the data from the last 3 months. Every day I have to load 2 millions records in the database. So every day I have to export (in an other database as historical data container) and delete the 2 millions records inserted 3 month + one day ago. ...more >>

I do a lot of file processing and I usually run a little script I copy and paste to read directory information to see if a new file it there and then process the file if it is. So, I decided to wise up and make a stored procedure to automate a lot of that. The pivotal step in this is that i r...more >>

Hi all I am creating a web services application in Visual Studio Dot net which links to a MS SQL database. I need to create a form which lets the user pick his field of choice(doesnt matter what it is..) using drop down boxes,radio buttons etc and query the database according to what he ha...more >>

Hi, I have one table like : MyTable {field1, field2, startdate, enddate} I want to have the count of field1 between startdate and enddate, and the count of field2 where field2 = 1 between startdate and enddate, all in the same query. I know how to get the first part (see below), but i ...more >>

Hey yall, I have a problem, I'm a DBA for about 250 databases. I currently have ZERO means of notification on them. I put together an entire plan for using SQL mail, got a pop3 account set up and all that jazz, but when I put the request into my company to get outlook installed on my sql se...more >>

Hello experts, I'm trying the run the following query with specific intentions. I would like the query to return 5 results; i.e., 4 distinct and one duplicate. I am only getting, however, 4 distinct records. I would like the results from the '007' id to spit out twice. I'm not using 'di...more >>

What are the ways to export/import data in/out of SQL Server 2005? I used to use DTS for 2000 to do such thing and now I can't even find the wizard in 2005! ...more >>

Could someone please point me in the right direction on how to read in a large query with .net. I am trying to emulate a legacy database system so I don't know the upper bounds of the sql query. An example query would be something like: Select * from invoices where year > 1995 the query ...more >>

Hi, I am new to MS SQL. When I create a column in a table, when shall I use nvarchar or varchar? Please help. Thanks, Mike ...more >>

Our database(s) are all over the place - no documentation - lot's of rubbish and unused stuff. I'm managing a project focusing on data quality that covers code changes, alterations to DTS packages, schema changes etc etc. What I'd like to do is see where the bit I want to change is being used...more >>

hi, I have a table with several million rows. Each row is simply the date and time a certain page was viewed. eg page1 1-1-00 page2 2-1-00 page1 16-1-00 page1 17-1-00 page2 19-1-00 I now need to find the most popular pages so I do this... SELECT TOP 10 COUNT(*) AS mycount...more >>

Can someone please tell me what is meant by a file share? I'm doing a little reading on MS Sql Server and they talk about how you can connect to the sql server through a named pipe. I'm guessing that a file share means a specific service running on a server. Is this correct? The book says the...more >>

hi, I have a table with several million rows. Each row is simply the date and time a certain page was viewed. eg page1 1-1-00 page2 2-1-00 page1 16-1-00 page1 17-1-00 page2 19-1-00 I now need to find the most popular pages so I do this... SELECT TOP 10 COUNT(*) AS mycount...more >>

I have a directory of user information. What I would like to do is allow someone to search for person X and then return not only the information for person X, but also the information for the next 15 people following person X sorted alphabetically by lastname. So if someone searched for the l...more >>

Hi, After just installing sql 2005 on our test machine, I am trying to restore a database using a backup file on the network. However, the specify backup diagol box allows only for browsing to a file on the local machine - I find no way to type a UNC path to choose the backup file fro...more >>

Hi, This is the log file for my SP1 on 2005 install. Can anyone please look at this and tell me if this looks normal? I'm concerned about the following in the log: "Failed to read registry key: Debug" AND all the entries that show "- Not Applied" What does this mean? According to SE...more >>

Dear Experts, When I use a single table I can easily use constraints to enforce my business logic, but what do I do when I normalize a single table into multiple tables. For example, imagine that my initial table has the columns ID, Name, Salary with the constraint that Salary is not NULL....more >>

Hello All: I am in desparate need of assistance. We are using an application called PaperVision Enterprise which takes scanned invoices and puts them into a database for the purpose of easy reference to any scanned invoice in the db. 2 weeks ago while trying to perform a 'match and merge' of th...more >>

Hi, We currently have a fairly old product, which was originally only compatible with SQL 2000. When we upgraded our server to SQL 2005, the client product gave us a "This product is not compatible with this version of SQL server" error. We put the server into SQL 2000 compatability mode, ...more >>

test ...more >>

Hi, I have a very simple issue: for simplicity lets say I have 2 tables, A and B. - Table A contains 5 fields. Amongst these there is a 'id'-field which is but a reference to table B. - Table B contains 2 fields: 'id' and 'text' In order to post data to table A I thus (from a kno...more >>

I have an ASP that has been working fine for several months, but it suddenly broke. I wonder if windows update has installed some security patch that is causing it. The problem is that I am calling a stored procedure via an ASP (classic, not .NET) , but nothing happens. The procedure doesn't w...more >>

I am trying to copy the data from one table to another table linked in SQL. I keep getting an error message saying "the data types nvarchar(max) and ntext are incompatible in the equal to operator" I went into the SQL Management Server and tried to modify the codes and am still having no luck....more >>

Hi all, I have the following table Name Date Wish Valid Name is person's name, date defaults to getdate() and is never assigned directly (datetime field), Wish is some message, and Valid is bit, 1 indicates if the wish is the latest, and therefore valid. All previous wishes are kep...more >>

Here is my replace query and I need to run this on every column in my table. Right now I manually enter the column name (_LANGUAGES_SPOKEN) but this is time consuming and would like to automate this process as much as possible. Update PROFILE SET LANGUAGES_SPOKEN = replace(cast(_LANGUAGES_SPO...more >>

Ok my last formatting question. How can I insert a money value as a padded string in another table? example $1.25 gets inserted to another table as 00000125 I want 8 total characters and no decimal another example would be 4,225.99 becomes 00422599 can this be done? thank you!! ...more >>

Hi, I'm using VS2005 and I'm trying to link the C# windows form to MSSQL. I used BindingNavigator Control to read the data. After that I add sqlcommand and sqldataadapter to send the data to the database. My code is this sqlDataAdapter1. InsertCommand. CommandText = "INSERT INTO SUDENT (" + ...more >>

Hello, I thought this would be easy, and I've read a lot of posts, but I can't seem to find exactly what I'm trying to do. >From within a stored procedure I would like to insert a date value into another table to a Char(8) field....but I want the value to be formatted as YYYYMMDD (specific...more >>

Hi .. I am geeting myself into many knots around how to do thsi extraction. There is a table that contains the following: aID bID cID dID -------------------------- 6 9 28 1 6 2 28 2 6 11 28 3 6 1 27 5 6 9 27 5 6 11 27 5 I am trying to get a result of: aID bID ...more >>