sql-server-2000

Cannot sort a row of size 8130, which is greater than the allowable maximum of 8094

Hello All, SELECT DISTINCT tblJobReq.JobReqId , tblJobReq.JobStatusId , tblJobClass.JobClassId , tblJobClass.Title , tblJobReq.JobClassSubTitle , tblJobAnnouncement.JobClassDesc , tblJobAnnouncement.EndDate , blJobAnnouncement.AgencyMktgVer...

cross tab query

Hi guys, I have a project table with the following columns ProjectID, ProjectDescription and a list data table which has the following columns ProjectID ListType Date Memo Every project has many list type entries in the ListType Table. What I want to do is run a query which will return something like this ProjectID, ProjectDescri...

AES/Rijndael implementation for SQL Server 2000?

Do you know any function implementation I could use for decrypting data encrypted by AES/Rijndael in SQL Server 2000? ...

Image save in database

I want to save an uploaded image to database. Now my question is: What should be the data type for SQL Server 2000 for image? a. image b. varbinary what is the code for saving image in database? How to retrieve the image from database and show? Please refer me any tutorial or guidline. Or if you can please share with me. Thanks in a...

Figuring out the resource a lock in SQL Server 2000 affects

I am adding a simple web-interface to show data from a commercial off the shelf (COTS) application. This COTS issues locks on any record the user is actively looking at (whether they intend to edit and update it or not). I have found sp_lock and the Microsoft sp_lock2 scripts and can see the locks, so that's all well and good. How...

SQL Server 2005 Table Alter History

Hi. Does SQL Server maintains any history to track table alterations like column add, delete, rename, type/ length change etc? I found many suggest to use stored procedures to do this manually. But I'm curious if SQL Server keeps such history in any system tables? Thanks. ...

Problem convert column values from VARCHAR(n) to DECIMAL

I have a SQL Server 2000 database with a column of type VARCHAR(255). All the data is either NULL, or numeric data with up to two points of precision (e.g. '11.85'). I tried to run the following T-SQL query but received the error 'Error converting data type varchar to numeric' SELECT CAST([MyColumn] AS DECIMAL) FROM [MyTable]; I tried...

Unique id of a column

Hi. Does each column of a table in SQL Server have a unique id? I've looked into sys.columns and the column_id there is merely the order of the columns which changes if the order of the column is changed. I'd like to know if SQL Server maintains a unique id for each column as it does for each table and other objects. And if it does, how ...

SQL Server: Can INFORMATION_SCHEMA Tell Me When a SQL Object Was Created?

Given: I added a non-nullable foreign key to a table. I settled on a way to populate the foreign key with default values. I checked in both changes to a re-runnable DB creation script. Other developers ran this script, and now they have the foreign key populated with default values on their developer machines. A few days later howeve...

Run long-running sproc (that doesn't need to return) from ASP.NET page

I would like to know how you would run a stored procedure from a page and just "let it finish" even if the page is closed. It doesn't need to return any data. ...

A column insert or update conflicts with a rule imposed by a previous CREATE RULE statement.

I'm working on a online game. I got some problems with inserting new data to table. I'm getting 2010-4-8 2:14, 37000, 513, [Microsoft][ODBC SQL Server Driver][SQL Server]A column insert or update conflicts with a rule imposed by a previous CREATE RULE statement. The statement was terminated. The conflict occurred in data...

sql server deadlock issue on a single table..................

I have one table let's say "xxx "in sql server 2000 . One .exe is inserting data into that table "xxx" through sql job. But once data is inserted , one stored procedure is reading the data from that "xxx table "and inserting/updating into other two tables and updating back the status into the same "xxx" table. Now, client says that mult...

Remove duplicate from different columns in SQL Server 2000

I have table : number city1 city2 mentions 1 a b 5 1 b a 5 1 c d 2 1 d c 2 what I need is to remove duplicate records, such as a, b equal to b,a became : number city1 city2 mentions 1 a b 5 1 c d 2 any clue for me ? thanks before :) ...

Convert SQL Server 2000 to 2005

I have a SQL Server 2000 database and I want to convert it to SQL Server 2005 ...

upgrade sql2000 to 2005

I have sql 2000 server and sql 2005 server running on the same box right now. I want to start upgrading my sql 2000 databases to sql 2005. What is the best way to do this? ...

Transfer Database Task in SSIS 2008

I am trying to use SSIS to transfer a database from a SQL 2000 instance to SQL 2008 using a Transfer Database Task. I've tried everything that I can think of to get this to work including using accounts with full access to both databases in the Connection Managers. However, each time I try to run it, I get the following: Informat...

SQL Rounding Problems in 2005 and 2000

I have a value in the database which is 2.700000002. When I run a query in Management studio in SQL SERVER 2005 I get 2.7. But when I run in SQL SERVER 2000 query analyzer it comes 2.700000002. 2.70000002 is correct why is SQL SERVER 2005 trying to change the value by rounding it or selecting the floor value? ...

Am I Leaking ADO.NET Connections?

Here is an example of my code in a DAL. All calls to the database's Stored Procedures are structured this way, and there is no in-line SQL. Friend Shared Function Save(ByVal s As MyClass) As Boolean Dim cn As SqlClient.SqlConnection = Dal.Connections.MyAppConnection Dim cmd As New SqlClient.SqlCommand Try cmd.Conne...

SELECT TOP N With Two Variables

I have the following example in a SQL table Cust Group Sales A 1 15 A 1 10 A 1 5 A 2 15 A 2 10 A 2 5 B 1 15 B 1 10 B 1 5 B 2 15 B 2 10 B 2 5 What I would like to show is the top 2 products per customer, per group sorted descending by Sales i.e. Cust Group Sales A 1 15 A 1 ...

MS-Access to SQL Server 2000 problem with datetime

I'm trying to transfer some data from Access to SQL Server 2000 (there are no other way to do this sadly), I'm using Access to mssql to do the job. The program fails everytime it finds a datetime in this fashion: 03/07/2009 10.17.00 While it imports date like this: 29/12/2008 I don't understand where this problem come from so I ask...