Viewing 15 posts - 1 through 15 (of 27 total)
June 14, 2011 at 2:40 pm
Thank you for your quick reply. After installing Business Intelligence Development Studio, I try to launch the DTS Package Migration Wizard. I now get an error stating that I need...
June 14, 2011 at 2:02 pm
September 16, 2010 at 12:52 pm
Thank you for your reply. Attached is the scripts and sample data. Thanks for the posting etiquette, didn't know. Still getting same error. I included a screen shot also.
September 16, 2010 at 9:51 am
Yes I have. But I am using SQL Server 2000. Any help?
July 29, 2010 at 3:02 pm
I know this is the 2005 forum, but would this work in Server 2000?
July 29, 2010 at 12:15 pm
Thanks for the info. I am doing something similar already. But you raised a question about archiving to a different server. I am aware of getting data from different db's...
July 29, 2010 at 9:56 am
Thanks for the info, yes I am using xp_sendmail and then the light went off. Different database. Go figure.
July 15, 2010 at 9:15 am
As it turns out, I was modifing the wrong table. This is not an issue.
Thanks for your responce and time.
April 23, 2010 at 1:41 pm
It is just the one field. Now I added a new field and set varchar to 50. I can see the new field in ent mgr but in query analyzer...
April 23, 2010 at 11:19 am
In production it is
Microsoft SQL Server 2000 - 8.00.2187 (Intel X86) Mar 9 2006 11:38:51 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition...
March 22, 2010 at 7:06 am
No errors, just cant set breakpoints and see local variables.
March 9, 2010 at 10:56 am
Here is the information. Pleae let me know if there is anything else.
Thanks fir looking into this.
February 8, 2010 at 1:58 pm
The RTRIM(COMMENTS) does not give me the correct results. The 'header line' that is generated by 'results to file' option is 1000 characters. But I have found a solution with...
December 10, 2009 at 3:50 pm
An update. I am using XP_SENDMAIL with @QUERY. The results for @QUERY can be sent as an attachment or in the message of the email. In either case the results...
December 10, 2009 at 3:03 pm