I'm creating a DTS package. After specifying the source, destination, and tables, I get the Save, schedule, and replicate package step, which has a Save DTS Package checkbox. If I check the box to save, I get these options: SQL Server SQL Server Meta Data Services Structured Storage File Visual Basic File Can anyone give a good exp...
I have the following setup... Table: properties p_id [pk] p_propname o_id_owners [fk] Table: owners o_id [pk] o_extcode o_fname o_lname Table: selectedfeatures s_id [pk] d_id_features [fk] p_id_properties [fk] Table: features d_id [pk] d_code d_featurename g_id_featuregroup [fk] Table: featuregroup g_id [pk] g_featuregroupname I...
Hi any body help to tell me how to create a Procedure to defrag index on a daily basis in MS SQL Server 2000. Appreciate your answers Joseph ...
Is there a way to write to MSMQ from T-SQL and/or Stored procedure? I am using SQL Server 2000. ...
I have the following query: SELECT dev.DeviceName, Count(dom.DomainID) AS CountOfDomains FROM tblDevices dev JOIN tblIPNumbers ip ON dev.DeviceName = ip.ServerName JOIN tblDomains dom ON dom.IPNumberID = ip.IPNumberID WHERE dom.PointerTo=0 AND dev.DeviceType='3' AND (dev.[System]='32' OR dev.[Syst...
My project needs a SQL Server 2000 User Id and password created for an ASP.NET website. How do I create a user account in SQL Server 2000? ...
In the table 'Emplyoee' there are two fields-JoinDate and EmployeeName. All Data contains in Emplyoee table is as follows: JoinDate | EmployeeName ------------------------ 02-12-2009 Vijay 03-12-2009 Binoy 03-12-2009 Rahul My select query is as follows: SELECT DISTINCT JoinDate,EmployeeName FROM Emplyoee I got the Res...
The error is return when the following stored proc is attempted to be executed: EXECUTE p_someProc --list of vars CASE WHEN @var1=1 AND @var2=1 THEN 3 WHEN @var2=1 THEN 2 WHEN @var1=1 THEN 1 END, --more vars There are other CASE functions included, though only a single error is spewed up which points to the first CASE. Wh...
Using SQL Server 2000, I need to insert the deleted records from one table into a second table. What's the best way to achieve this using a SQL Server 2000 trigger? with thanks and regards Sathia ...
I am moving from SQL 2000 to SQL 2008. The SQL 2000 is on a Server 2003. SQL 2008 is on a Server 2008. I have imported my database successfully. I am able to perform queries and they work fine. I use a VB6 program running in the IDE to update the database. When my VB6 program runs on a server 2003 the program will connect using the fol...
I need to implement an LDAP instance that will query SQL Server 2000. Can anyone point me to a tutorial/guide that will help me with the setup? I need to use the Windows build from OpenLDAP. Any material on back_sql configuration for OpenLDAP on windows? ...
How can i exit in the middle of a stored procedure? i have a stored procedure where i want to bail out early (while trying to debug it). i've tried calling RETURN and RAISERROR, and the sp keeps on running: CREATE PROCEDURE dbo.Archive_Session @SessionGUID uniqueidentifier AS print 'before raiserror' raiserror('this is a raised error'...
At our sports centre, I would like to analyse the number and types of subscriptions our members have, but I'm having trouble with the exact SQL queries. A "subscription" is an entry pass that lets you into specific activities in our sports centre. They have a start and end date, representing the period they are valid. They have an assoc...
I am using SQL server MSDE 2000. I have a field called notes of type nvarchar(65). The content is 'Something ' with an extra space after the content (quotes for clarity) in all the records. I used the following command. UPDATE TABLE1 SET notes = RTRIM(LTRIM(notes)) But it does not work. Is there any alternate way to do it? ...
Hi I have a table which has a column 'CompanyID int not null' and its default value is set to 10. Now I want to write a query which will alter this default value to 1. How can can I do it? Any help will be appreciated. I am using SQL server 2000. ...
I've written a stored procedure as following: CREATE PROC spSoNguoiThan @SNT int AS begin IF not exists (select column_name from INFORMATION_SCHEMA.columns where table_name = 'NhanVien' and column_name = 'SoNguoiThan') ALTER TABLE NhanVien ADD SoNguoiThan int else ...
I'm using Microsoft's SQL Server 2000 and have a query that is essentially this (except that Z is a further subquery, not a table): select A.key1, A.key2, B.value1 from A left join (select * from Z where value1 > 0) B on A.key1 = B.key1 and A.key2 = B.key2 order by A.key1, B.key1 Column value1 is of type float. For some reas...
Is there anything like the SQL 2005 SQLCMD for SQL 2000? I need to run updates/deletes in an unattended mode. ...
I'm working with SQL 2000 and I need to determine which of these databases are actually being used. Is there a SQL script I can used to tell me the last time a database was updated? Read? Etc? I Googled it, but came up empty. ...
I'm using SQL Server 2000. How can I connect Dreamweaver asp.net to SQL Server 2000. Please give give the coding ...