sql-server-2000

Sql Server 2000 Backup

I had more database and I tried to make backup for them but they weren't worked well I want the best way to make backup daily ...

Changing the indexing on existing table in SQL Server 2000

Guys, Here is the scenario: SQL Server 2000 (8.0.2055) Table currently has 478 million rows of data. The Primary Key column is an INT with IDENTITY. There is an Unique Constraint imposed on two other columns with a Non-Clustered Index. This is a vendor application and we are only responsible for maintaining the DB. Now the vendor has...

sql server 2000: current_timestamp as function actual param

how can i use the "current_timestamp" as actual param of a function, perhaps in a view that contains the function? the db is a sql serve 2000 ...

Migrating an ERP product to SQL 2008 (regular or R2) from 2000.

We are running a version behind the latest for our ERP system which runs on SQL Server 2000. My version is not supported on 2008 (regular or R2). In fact, the latest version of the ERP is not certified to work with R2 (which isn't surprising since it hasn't been released yet) I have done some preliminary testing with 2008 and it appears...

Pass a variable into a trigger

I have a trigger which deals with some data for logging purposes like so: CREATE TRIGGER trgDataUpdated ON tblData FOR UPDATE AS BEGIN INSERT INTO tblLog ( ParentID, OldValue, NewValue, UserID ) SELECT deleted.ParentID, deleted.Value, inserted.Value, @intUserID -- how can I pass this in? FROM inserted IN...

Need help limiting a join in Transact-sql

I'm somewhat new to SQL and need help with query syntax. My issue involves 2 tables within a larger multi-table join under Transact-SQL (MS SQL Server 2000 Query Analyzer) I have ACCOUNTS and LOGINS, which are joined on 2 fields: Site & Subset. Both tables may have multiple rows for each Site/Subset combination. ACCOUNTS: ...

Help replace this SQL cursor with better code

Can anyone give me a hand improving the performance of this cursor logic from SQL 2000. It runs great in SQl2005 and SQL2008, but takes at least 20 minutes to run in SQL 2000. BTW, I would never choose to use a cursor, and I didn't write this code, just trying to get it to run faster. Upgrading this client to 2005/2008 is not an option i...

I need someone to explain this ASP function to me

Hello! I've got an ASP document that 5 years old. Actually I'm working with PHP but I must use ASP for a Windows Application. So I need someone to explain this function to me. //DNS SETTINGS ARE INCLUDED ALREADY. function Check_Is_Web_Locked() dim cmdDB , Ret OpenDatabase Set cmdDB = Server.CreateObject("ADODB.Command") ...

Can someone explain me the parameter RETURN_VALUE ?

Hello. I want to know what does RETURN_VALUE mean! I'm stuck at this thing. How to use RETURN_VALUE in a SQL Server stored procedure? thanks.. ASP: Set cmdDB = Server.CreateObject("ADODB.Command") With cmdDB .ActiveConnection = ADOConM .CommandText = "usp_jaljava_member_select" .CommandType = adCmdStoredProc .Parameters.App...

What can be a cookie? How to set with OUTPUT? RETURNVALUE?

hello. i think i got some problems with setting a cookie data. for this code: Set cmdDB = Server.CreateObject("ADODB.Command") With cmdDB .ActiveConnection = ADOConM .CommandText = "usp_jaljava_member_select" .CommandType = adCmdStoredProc .Parameters.Append .CreateParamete...

How to get use text columns in a trigger

I am trying to use an update trigger in sql 2000 so that when an update occurs, I insert a row into a history table, so I retain all history on a table: CREATE Trigger trUpdate_MyTable ON MyTable FOR UPDATE AS INSERT INTO [MyTableHistory] ( [AuditType] ,[MyTable_ID] ,[Inserted] ...

How can I search for numbers in a varchar column

I've got a simple nvarchar(25) column in an SQL database table. Most of the time, this field should contain alphanumeric text. However, due to operator error, there are many instances where it contains only a number. Can I do a simple search in SQL to identify these cases? That is, determine which rows in the table contain only digits in...

Attaching databases of sql 2000

I have few databses of sql 2000 on windows 2000. Can I attach these databases to another instance of SQL Server 2000 on anothermachine having windows 2003 installed?? Does attach and detach of databases are platform independent?? ...

What is the difference between a unique constraint and a unique index

What is the difference between the following two statements? alter table [dbo].[Demo] add constraint [UC_Demo_Code] unique ( [Code] ) go create unique nonclustered index [UK_Demo_Code] on [dbo].[Demo] ( [NB_Code] ) go Does the constraint have an index to help it enforce uniqueness, or will a table scan be performed on every insert/upd...

How to enforce this constraint in sql server

I have a table called city, and a table called city_city. city_city correlates two city records, so it has a fromcity_id and a tocity_id. I can enforce uniqueness on fromcity_id and and tocity_id through a unique key, but how do I enforce uniqueness so that I cant insert a record if fromcity_id and tocity_id are reversed. For example,...

Two query in one with SQL Server

Hi, This is what I'm trying to do something similar to the following request, but I don't know if it's possible with the SQL-Server syntax: declare @idClient int select @idClient=idClient from table where entite is null and (SELECT * from table where entite=@idClient) is null Thanks. ...

How to Delete Duplicate Rows in SQL 2000?

I thought I had this figured out but it turns out I'm just deleting the first record. The following returns the duplicate rows. All have a count of 2. I just want to delete the first one for each duplicate record. select scorestudentid, scoreadvisor, scorecorrect, count(*) from scores where scoretestid = 3284 group by scorestudentid, s...

Query in SQL2000

How to alter the datatype of a column in a table? ...

Query in SQL2000

How to drop a Particular column in a Table? Thanks in Advance ...

SQL 2000 - Returning from a Stored Procedure

Hello, I'm writing a stored procedure. This procedure has a case where if it is met, I want to stop executing the procedure and return -1. How do I do this? Currently, I'm trying the following: IF @result <> 1 BEGIN SELECT -1 END However, SELECT is not a typical "return". As you can imagine I spend most of my time ...