Viewing 15 posts - 38,821 through 38,835 (of 39,466 total)
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
If you run this, keep in mind it is running from the server, not your workstation. Is the file on the server?
Steve Jones
November 28, 2001 at 12:43 pm
November 28, 2001 at 12:41 pm
Control Panel / Administrative Tools / Local Security Policy / Local Policies / User Rights Assignment / Log on as a service
Dbl click and add the account.
Steve Jones
November 28, 2001 at 11:36 am
November 28, 2001 at 10:20 am
Did you assign this account through EM or the Services applet? You need to be sure this accoutn as the "Log on as a service" right.
Steve Jones
November 28, 2001 at 10:19 am
Viewing 15 posts - 38,821 through 38,835 (of 39,466 total)