Viewing 15 posts - 3,691 through 3,705 (of 6,216 total)
For the master it depends. Logins are the big one of course, you might also have additional procs that you have added, user defined error messages maybe, other housekeeping stuff....
July 25, 2002 at 4:44 pm
Rad,
I use it a lot with SQL2K SP2, dont have SQL 7 running on anything at the moment but it "should" work with NT authentication. Profile both servers to see...
July 25, 2002 at 4:42 pm
Yes, it does. Anything that is part of the package gets moved.
Andy
July 25, 2002 at 4:37 pm
As I said earlier, you can do it from DMO or ADO, either will work.
Andy
July 25, 2002 at 11:04 am
Gotcha. Ok, so what you need is to get the servers using a new id range. If you've got a lot of foreign keys that are actually documented, probably the...
July 25, 2002 at 10:50 am
Make sure you either pick the db from the dropdown to show where it should execute, or fully qualify it like this:
exec db.owner.storedprocname
Andy
July 25, 2002 at 10:46 am
You can't do it that way unless you build up the entire statement and assign it to a string, then run it using Exec(yourstring). This is called dynamic sql. It...
July 25, 2002 at 10:33 am
You can run queries using the executeimmediate method, but it returns a queryresult object rather than a recordset. Basically an array. If you're just running an update its fine, if...
July 25, 2002 at 8:23 am
Not sure, but I think running sp_change_users_login 'report' may help.
Andy
July 25, 2002 at 7:44 am
How could the publisher db be static if you're using merge replication?? If somehow it is you have a chance.
The symbols indicate a foreign key relationship.
Depending on your answer to...
July 25, 2002 at 7:43 am
RedGate Software sells a product called Data Compare that you might want to look at it. Compares tables and generates TSQL to make the data the same. Low tech replication....
July 25, 2002 at 4:54 am
Doesnt sound like fun. No easy way to unravel that. Got a plan in mind yet?
Andy
July 25, 2002 at 4:51 am
Agree that if you can do it with DTS thats the easiest way. If you're moving all the jobs you could look at moving the MSDB itself to the other...
July 24, 2002 at 8:06 pm
I looked through the newsgroups, didnt find anything definite. Things to check are that you arent out of disk space (or space allocated to the db), that you dont have...
July 24, 2002 at 7:04 pm
Not that I know of. I usually use the Object Browser in QA (SQL2K), drill down to triggers then right click to script to the window.
Andy
July 24, 2002 at 10:26 am
Viewing 15 posts - 3,691 through 3,705 (of 6,216 total)