SQL 2000

Odd problem (conversion or openquery?) only appearing in a stored procedure but not when running it adhoc

Here's the code I can run with no problems: declare @AnneeSelectionnee numeric select @AnneeSelectionnee = 2009 declare @DateDernierImport datetime select @DateDernierImport =  'Nov 14 2008 12:00AM' SELECT     LTRIM(RTRIM(T_ASFSTAG0.STANS1)),     LTRIM(RTRIM(T_ASFSTAG0.STHFO1)),...

Replication and using EMC Autostart

I am using EMC Autostart to monitor and mirror an application that uses a SQL 2000 DB. All worked well until I incorporated replication to keep certain tables synchronized with 2 other servers. The Autostasrt uses virtual names and IP's for clients to connect no matter which server is acting as...

SQL 2005 Password

If you move a sql 2000 database to sql 2005 which admin password does it have now.

Error inserting into table with identity column

I have 2 stored procedures. Both insert records into table variables, and each of those table variable has an identity column. One procedure executes and the other gives an error telling me that I am explicitly trying to insert into the identity column (which I'm not). Here is the code from the...

Send a email with attachment?

How do I send a email with attachment in a sql script using SQL2000

SQL Restore takes 6-10 minutes to come up in Enterprise Manager

SQL Restore takes 6-10 minutes to come up in Enterprise Manager. We have a customer with hundreds of sites, and all their servers do the same thing. We had to roll back after an upgrade and we find that when just selecting "Restore Database" it will seem like Enterprise Manager is hung, but...

Is there a way to retrieve datatypes from stored procedures?

I have used the following simple query to retrieve datatypes from sql 2000 tables. select TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH from <tablename>.information_schema.columns where table_name = '<tablename>' and column_name = '<columnname>' Is there a...

SQL 2005 and Security Account Delegation

I read this feature for SQL2000 SP3 but I wonder if this is still valid for SQL2005 or, if it has changed which is the new feature that enables to retain the authentication credentials of the original client.

retrieving data from SQL express

i have sql 200 and express 2005 runing on one machine and all is working but for some reason i cannot retrieve data anymore hence it says the data is being used by another instance.

SQL 2000 and 2005 Offline Table Reindex Determination

Hello, I have prcessed SQL 2000 offline reindexes in the past for specific tables when there was scheduled downtime, but I was wondering if there is a tool or script that I can run for a specifc SQL database to determine which tables in the database would need to be reindexed. I do not want to...

Initialization DB-Connect Failed, Return Code 000256

I have migradted 4.6C with 4.6D Kernel from HPUNIX, and Oracle to Windows 2003 Server, 4.6C, and MSSQL 2000, when updating the Kernel getting above mentioned error, can someone please help

RAID 1 or RAID 5

I have 1 file server and 1 email server. both are Win2k3....one with exchange 2003 one with SQL 2000 but only 4 people using a small accounting program on it. Both are Dual XEON 2Ghz processors 1 Gb RAM 15K rpm hard drives. Ultra SCSI 160 controllers File server has software RAID 1, Exchange...