Viewing 15 posts - 38,701 through 38,715 (of 39,456 total)
December 10, 2001 at 9:50 am
In v6.5, you can do an sp_dropserver <servername> and then an sp_addserver <newname>, local. I thought this worked for 7.0, but you'd have to test it.
Steve Jones
December 10, 2001 at 9:48 am
December 10, 2001 at 9:46 am
December 10, 2001 at 9:45 am
Not that I know of. You could insert everything into a temp table with a counter and go from there.
Steve Jones
December 10, 2001 at 8:26 am
Haven't seen this. Is this a single dynamic properties task and a single bulk load?
I'll check it out tomorrow or Mon.
Steve Jones
December 8, 2001 at 3:07 pm
You can do anything as long as teh driver allows it. As far as I know, you can move this data using DTS, just not sure if there are any...
December 8, 2001 at 1:59 pm
you probably want to do a subquery
select colour, ..
from MyView
where modified = ( select max( modified) from MyTable)
Steve Jones
December 8, 2001 at 1:57 pm
Why can't you delete the existing one? I have a series on version control going on now that covers some of these items.
Steve Jones
December 8, 2001 at 1:55 pm
December 8, 2001 at 1:53 pm
Agreed. If you want to go to SQL Server we can help. If you are moving to Oracle, I suggest you check out their site.
Steve Jones
December 7, 2001 at 3:41 pm
December 7, 2001 at 3:34 pm
That's quite a topic. Usually most companies will have some sort of docucment style for technical tdocs. Start there.
Then work one section at a time. Perhaps, "installation of SQL Server"...
December 7, 2001 at 11:02 am
Not that clear. Can you post a sample data?
Are you looking for the most recent inserted record or the greatest value for itColourID?
Steve Jones
December 7, 2001 at 11:01 am
I'd get some help on this one and get access to the server (even if its with an admin) to do some debugging. David has the right idea.
Steve Jones
December 7, 2001 at 10:59 am
Viewing 15 posts - 38,701 through 38,715 (of 39,456 total)