Viewing 15 posts - 5,926 through 5,940 (of 9,643 total)
What have you tried so far?
I did a quick test and put a Data Conversion task and converted to Unicode String with a length of 4000 and it worked. ...
February 19, 2009 at 10:18 am
Lynn Pettis (2/19/2009)
February 19, 2009 at 9:51 am
As I said earlier you DO NOT need the @addresses table as long as you have a primary or unique key in your source table.
Your code would only have to...
February 19, 2009 at 8:15 am
A couple of questions:
1. Do you really need all the OUTER JOIN's? Can you have an order without a customer? I normally would think that would not...
February 19, 2009 at 6:56 am
I don't think that there is a way to do this natively in SSRS. When I have needed that I have usually done an aspx page that has the...
February 18, 2009 at 2:49 pm
Mike Levan (2/18/2009)
only events i am interested are1. Add Login to DB and type of role assigned
2. Delete login in DB or dropped login from the memberrole
Do you mean User...
February 18, 2009 at 2:44 pm
Steve Jones - Editor (2/18/2009)
What features would really help you "high posters" here at SSC? Changes to the forums? the...
February 18, 2009 at 2:29 pm
I don't see anything in BOL about being able to change the character format.
February 18, 2009 at 1:30 pm
Mike Levan (2/18/2009)
If you want notifications you can do the DDL triggers or you could do a job that queries the default trace on a regular basis which sends you...
February 18, 2009 at 11:42 am
Lynn Pettis (2/18/2009)
Ninja's_RGR'us (2/18/2009)
Jack Corbett (2/18/2009)
Lynn Pettis (2/18/2009)
Jack Corbett (2/18/2009)
My pet peeve of the day. OP's who do not read through the solutions provided and keep posting.
Any OP in...
February 18, 2009 at 11:13 am
Perry Whittle (2/18/2009)
Jackdid you mean to specify column I.StartTime twice?
Nope. I copied most of the code from a script I use for another purpose that uses Max and Min...
February 18, 2009 at 10:33 am
Runs fine against my server. Try replacing the "::" with "sys." as I recall having recently read where the "::" syntax is being deprecated.
I have seen odd...
February 18, 2009 at 10:01 am
Lynn Pettis (2/18/2009)
Jack Corbett (2/18/2009)
My pet peeve of the day. OP's who do not read through the solutions provided and keep posting.Any OP in particular?
Actually I have experienced more...
February 18, 2009 at 9:55 am
My pet peeve of the day. OP's who do not read through the solutions provided and keep posting.
February 18, 2009 at 9:43 am
Is this a production database they are making changes in? If it is you should setup a dev system that they make changes in and then do not give...
February 18, 2009 at 9:06 am
Viewing 15 posts - 5,926 through 5,940 (of 9,643 total)