Viewing 15 posts - 38,761 through 38,775 (of 39,754 total)
Try this:
declare @d datetime
select @d = '01/03/02'
-- first day of month
-- select cast( convert( char(6), @d, 112) + '01' as datetime)
-- last day of month
-- select dateadd( day, -1, dateadd(...
January 3, 2002 at 10:47 am
January 3, 2002 at 10:33 am
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
Viewing 15 posts - 38,761 through 38,775 (of 39,754 total)