Check the following link may be useful to you

http://www.devx.com/dbzone/Article/29585.

Can you post with more details with example data?

Login ID:A login ID is the account identifier that controls access to any SQL Server 2000 system. SQL Server 2000 does not complete a connection unless it has first verified...

Check the following link

http://forums.databasejournal.com/archive/index.php/t-16770.html

Check the following link

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=854321&SiteID=1

Sorry there is no clarity in the post. What is the result you want to achieve? Please Post clearly.

Check the following link

http://support.microsoft.com/kb/836873

Check with the following query which is working without any error.

create table #1(pc varchar(1),rev decimal,mon numeric)

insert into #1 values('A',2000,1)

insert into #1 values('B',1000,1)

insert into #1 values('C',3266,1)

insert into #1 values('A',5633,2)

insert into #1...

Hi

It should not give any error. Please paste the query what you are trying to execute.

I have created an temporary table and checked with the following query.

SELECT Pc,

[1] AS January ,

[2] AS February,

[3] AS March FROM

(SELECT ...

Check the following link

http://support.microsoft.com/kb/301060

SELECT [Event Date],[Mobile Number],[Event Type Name],[Identification

Method],[Customer DOB],[Account Reference No] FROM [StatusPasPorts$] where

[Mobile Number] = '" + this.TextBox1.Text.ToString() + "' order by [Event

Date] ASC

Try with the above. You...

If any data existing in the table copy the same into a temparory table. Delete the records in the table and alter the table. Insert the records into table...

Run DTS independently you can know where it is failing.

If you have any old backup you can recover upto that date. Otherwise there is no chance of recovering crashed MDF.