Viewing 15 posts - 38,911 through 38,925 (of 39,902 total)
You will have problems because the limit for a parameter is varchar( 8000) and an XML doc can easily exceed this.
Form BOL, Generally, FOR XML cannot be used for any...
January 3, 2002 at 10:32 am
We use FTS for your search on this site and there are more than 200 records. Can you provide more info?
SQL Version? SP?
NT/2000? SP?
Event Log errors? SQL Log Errors?
Steve Jones
January 3, 2002 at 10:10 am
Also, what does the job do? Use network resources? connect to another SQL Server?
I agree with Brian.
Steve Jones
January 3, 2002 at 10:05 am
January 3, 2002 at 9:45 am
Yikes, yes somehow our data got crossed.
this should be fixed shortly.
OK, so encryption doesn't easily work. Here's what I recommend for something like Credit cards.
1. DO NOT connect the db...
January 2, 2002 at 5:02 pm
January 2, 2002 at 4:52 pm
January 2, 2002 at 4:44 pm
Funny, but my group and boss have the same belief that I am too busy to be bothered with many things. I consider myself approachable and usually can fix issues...
January 2, 2002 at 3:18 pm
January 2, 2002 at 3:15 pm
January 2, 2002 at 3:14 pm
What is in your package? If you use the copy SQL objects task, then you have a checkbox for dependencies and include indexes and keys.
Steve Jones
January 2, 2002 at 11:45 am
It would be interesting to see if this works with a Unix based server. trying to find one now.
Steve Jones
January 2, 2002 at 11:30 am
That's a good solution that solves part of the problem. Personally, I think this is an area that SQL Server 2002 could greatly improve, but we shall see.
Steve Jones
January 2, 2002 at 11:27 am
Keep in mind that if you are importing data v objects, there are different needs. Your DTS package can be set to create the objects (and dependencies) and then move...
January 2, 2002 at 11:21 am
Interesting. Does this work in all windows versions, or is it a 2000 thing. I wasn't aware NET USE could run through FTP, especially in Pre-W2K systems.
Steve Jones
January 2, 2002 at 10:17 am
Viewing 15 posts - 38,911 through 38,925 (of 39,902 total)