Viewing 15 posts - 38,806 through 38,820 (of 39,456 total)
Sorry, for some reason it disappears in the forums. It does, however, exist from the main page.
Steve Jones
November 30, 2001 at 9:36 am
November 29, 2001 at 4:25 pm
Don't know. Can you log in as the SQLAgent account and run it from EM manually?
Steve Jones
November 29, 2001 at 4:23 pm
I think Brian's book is pretty good (from WROX, pro sql server DTS). I've glanced at the New Riders book and it looks ok, but haven't read it.
I'd pick one...
November 29, 2001 at 4:17 pm
I've only done the 229 exam, but knowing the basics of SQL is important. There are questions where you must know the correct syntax, so be sure to pick a...
November 29, 2001 at 4:15 pm
You are welcome. Credit actually goes to Mr Itzak Ben-Gan and Tom Moreau. I learned this trick from their "Advanced T-SQL" book.
Steve Jones
November 29, 2001 at 10:51 am
November 29, 2001 at 10:50 am
Can you determine the source of data? If so, then modify the date with a dateadd() function.
I know this is kludgy, but you will need to deal with this somewhere....
November 29, 2001 at 10:22 am
np. just informing you. We check all forums on this site, so a single post here works.
Steve Jones
November 29, 2001 at 10:20 am
You can, but you need a subqeury to do it and it is inefficient (uses aggregates).
create table MyCount( MyKEy int, MyVal char( 3))
go
insert MyCount select 4, 'ABC'
insert MyCount select 5,...
November 29, 2001 at 10:19 am
AFAIR, you cannot shrink in v6.5. This was a problem for us in the past. I know at one point, we archvived a bunch of data, then bcp'd out all...
November 29, 2001 at 10:09 am
November 28, 2001 at 4:26 pm
I usually use DTS for something like this and either check for existence and delete the file or just run the extract(or import)
Steve Jones
November 28, 2001 at 4:25 pm
November 28, 2001 at 12:45 pm
Viewing 15 posts - 38,806 through 38,820 (of 39,456 total)