Viewing 15 posts - 38,686 through 38,700 (of 39,456 total)
Haven't seen it, but it looks like replication is looking for that account. Can you create it on the remote system? It's setup on my system as a system admin.
Steve...
December 10, 2001 at 2:56 pm
December 10, 2001 at 12:17 pm
I scripted out the indexes and did a Search and replace in QA to get down to
"INDEX [Addr_NDX1] ON [dbo].[Addr]([CityID], [StateID])"
I then Loaded this into a table and cleared...
December 10, 2001 at 12:16 pm
December 10, 2001 at 11:59 am
Not sure what a "Function Index" is.
No real idea. Don't find anything on MSDN or Technet. Perhaps Oracle has some ideas?
Steve Jones
December 10, 2001 at 11:58 am
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
Viewing 15 posts - 38,686 through 38,700 (of 39,456 total)