Using MS SQL Server

64-bit SQL 2000 Compatibility
I'm running 64-bit SQL Server 2000 Enterprise Edition SP4 on a Windows 2003 R2 server. Is this configuration compatibile? I heard DTS is not certified to run like this. thanks! ... 28 Jul 2006 14:16

delete particular rows in a table
hi all i hava eetable that is , eename sal _______ ________ suresh 100000 ramsesh 100000 raja 100000 susjssj 100000 dkddkd 100000 jfdjfdjfd 100000 so i want to delete from second to Fourth row by using Rownumber... 27 Jul 2006 23:19

syntax error ALTER TABLE
Hi Having a problem with a ms sql 2000 server. The script below was created i SQL manager 2005 lite and gives a syntax error near '(' ALTER TABLE [dbo].[Community_ActivityLog] ADD CONSTRAINT [PK_Community_Errors] PRIMARY KEY CLUSTERED ([activity_ID]) WITH ( PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATIS... 25 Jul 2006 12:24

Linear Regression for column values
This is a real challenge. I hope someone is smart enough to know how to do this. I have a table TABLE1 [Column 1- 2001] [Column 2- 2002] [Column 3- 2003] [Column 4 - 2004] [Column 5 - 2005] [Column 6 - 2006] [Column 7 - Slope] [2001][2002][2003][2004][2005][2006] [Slope] [1] [2] [3] [... 25 Jul 2006 17:46

Deleting a column DEFAULT....
Hi, I've the following problem. I must delete a column DEFAULT from a table, but I must do it with a script, independently from the server where it'll be executed. Locally I've tried with: ALTER TABLE [dbo].[PlanningDettaglio] DROP CONSTRAINT [DF__PlanningD__OreSt__688C6DAC] GO ALTER TABLE [dbo].[Plan... 26 Jul 2006 18:13

Exporting data from SQL 2005 to Access
Hi Guys, I was trying to export the database from 2005 sql to access. But it shows error Setting Destination Connection (Error) Messages Error 0xc0204016: DTS.Pipeline: The "output column "ReplyText" (961)" has a length that is not valid. The length must be between 0 and 4000. (SQL Server Import and Export Wizar... 20 Jul 2006 04:16

Text Import Finding Table to Import to Problem
Dear All, I'm trying to import a quite large text file (25mb) I had this working fine by using the transfertext command and having a schema.ini file, however having changed the username and password for my connection to SQL server all my tables and queries come with dbo attatched, which is fine as I've now edite... 20 Jul 2006 03:45

Delete 2005 [user] schema?
TITLE: Microsoft SQL Server Management Studio The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138) I have an installer that is supposed to "clean up" the DB server before an install. The installer checks for like object names and attempts to clean ... 20 Jul 2006 02:24

SQL Server 2005 Startup error - TDSSNIClient... error 0x5... code 0x51
Hi, My SQL Server 2005 won't start - can anyone provide some help? This seems to be the most significant error: - TDSSNIClient initialization failed with error 0x5, status code 0x51. There was some info here, but the reg key described looks okay: - http://blogs.msdn.com/sql_protocols/ I am running SQL Ser... 13 Jul 2006 18:10

Cursor loop
Hello, I've created a stored procedure that loops through a cursor, with the following example code: DECLARE curPeriod CURSOR LOCAL for SELECT * FROM tblPeriods DECLARE @intYear smallint DECLARE @intPeriod smallint DECLARE @strTekst varchar(50) OPEN curPeriod WHILE @@FETCH_STATUS=0 BEGIN FET... 12 Jul 2006 19:35