Viewing 15 posts - 38,701 through 38,715 (of 39,466 total)
What do you mean? Using Access and SQL 7 are completely different. If you have hosting, have they setup a db or do you do it?
If you have Access setup,...
December 10, 2001 at 11:55 am
Good luck. If you build the script or process, fell free to post it. I might work on it if I have a chance.
Steve Jones
December 10, 2001 at 11:19 am
There are two ways I have found.
1. Use Dynamic Properties task to reset a value in the sendmail task based on a query, global variable, etc.
2. Use an Active X...
December 10, 2001 at 11:18 am
The only thing I can think of is to script all indexes and then clean the results or write a quick parser to get the table name and columns. Then...
December 10, 2001 at 11:10 am
Aha, makes sense.
I know that setup includes the ability to generate a "silent install" script. Perhaps that would be useful here?
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q233337
Also, search "Unattended Installation" in BOL or "How to record...
December 10, 2001 at 11:05 am
You'd have to proivde more info on what you want. As far as building a database, we can help with specific questions, but not with a general "how to build...
December 10, 2001 at 11:01 am
Can't just run sp_dropserver, addserver, before the stop and start of services?
Steve Jones
December 10, 2001 at 10:29 am
Not sure of the error. Can you recreate the maintenance plan. I've had issues with these things failing and not really providing good error messages.
Steve Jones
December 10, 2001 at 10:28 am
This is almost always the share being inaccessable (networking problem) or rights (security problem).
Steve Jones
December 10, 2001 at 9:54 am
I've had 3 failed upgrades moving from 1 CPU to 2 in NT 4. Haven't tried in W2K. I'd stay away from it.
My solution is to reinstall NT/SQL and then...
December 10, 2001 at 9:53 am
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
Viewing 15 posts - 38,701 through 38,715 (of 39,466 total)