Viewing 15 posts - 16 through 30 (of 78 total)
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...
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
November 9, 2011 at 10:24 am
GilaMonster (10/11/2011)
Script all objects, export all data,...
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
October 11, 2011 at 2:37 pm
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,...
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
October 11, 2011 at 2:06 pm
Perry Whittle (10/11/2011)
Did you run DBCC CHECKDB after the upgrade and did it run successfully?
Did you run DBCC UPDATEUSAGE...
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
October 11, 2011 at 12:47 pm
GilaMonster (10/11/2011)
Please post any messages in the error log that relate to this DB.Does this error persist over a SQL restart? Is the database giving any errors when accessing data?
The...
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
October 11, 2011 at 12:46 pm
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...
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
June 21, 2011 at 6:06 am
Can you please tell me how do i do that. I see options to export , import and upgrade, Bu tnot edit.
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
June 20, 2011 at 1:50 pm
Thanks Guys
I was'nt sure of the ELSE Case
This answered
🙂
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
May 20, 2011 at 12:55 pm
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.
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
May 16, 2011 at 9:27 am
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...
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
May 16, 2011 at 9:24 am
Anjan Wahwar (5/16/2011)
Ninja's_RGR'us (5/16/2011)
Anjan Wahwar (5/15/2011)
Convert to "Unicode String [DT_WSTR]" instead of [DT_STR]What's the difference between the 2? >>> never used ssis b4.
Addition to the difference given by...
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
May 16, 2011 at 9:05 am
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...
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
May 11, 2011 at 3:06 pm
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....
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
April 20, 2011 at 5:18 pm
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...
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
April 19, 2011 at 4:20 pm
happycat59 (3/29/2011)
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
March 29, 2011 at 9:49 pm
Viewing 15 posts - 16 through 30 (of 78 total)