Yep I agree, 99% of times users were suggested NOT TO INTERFERE with system tables in all da forums out there.

But I scripted the trouble some system table and...

GilaMonster (10/11/2011)

---

Yup. Someone updated the system tables back on SQL 2000 and stuffed up the integrity of the system tables. There's no fix for this.

Script all objects, export all data,...

I ran UPDATE USAGE followed by CHECKCATALOG as per its suggestions and found out the following.

Does this help to troubleshoot this issue ?

DBCC UPDATEUSAGE (0);

GO

/*

Msg 211, Level 23,...

Perry Whittle (10/11/2011)

---

can you provide more details of the move from 2000 to 2008.

Did you run DBCC CHECKDB after the upgrade and did it run successfully?

Did you run DBCC UPDATEUSAGE...

The...

Thanks for the reply. I was wondering why did you use the condition

WHERE ALLOW_PAGE_LOCKS = 0

in the script ?

Anyways I will run the script and let you...

Can you please tell me how do i do that. I see options to export , import and upgrade, Bu tnot edit.

Thanks Guys

I was'nt sure of the ELSE Case

This answered

🙂

Tired the following in teh derived column

(SUBSTRING([CONVERTED PHONE1],1,10))

(SUBSTRING([CONVERTED PHONE1],1,10))

(SUBSTRING([CONVERTED PHONE1],1,10))

Converted : to DT_STR

This didnt help either.

Hope this helps to reproduce the error.

Atatched is a sample excel file. The columns Phone1, Phone 2 and Phone 3 are to be mapped with the Phone1, Phone2 and Phone3...

Anjan Wahwar (5/16/2011)

---

Addition to the difference given by...

None of the above solutions worked , after a coupel of hours of head bangigng...

Firgured out that I had invalid date formats which appeared valid .. that is ..

Few...

I cannot get into advanced tab, coz everything is combined into a single 'column0'.

I tired specifying column width as 8 on column0 just for testing , but nothing changed....

I appolozize for the unethical post.

I am atatching three scripts:

1. TO create the table

2. TO insert sampel Data

3. Expected results for about 13 records out of teh selected TOP...

happycat59 (3/29/2011)

---

As a general rule, I recommend that a database file should NEVER grow during the period of main activity. You should be managing the file size and...