Might find this helpful:

http://www.sqlservercentral.com/columnists/sjones/pagesize.asp

Andy

http://www.sqlservercentral.com/columnists/awarren/

Couple options. One is to start in single user mode, then just drop the db you're concerned with. You can also use (havent tested, but I think ok) trace flag...

Thanks for posting the correction!

Andy

http://www.sqlservercentral.com/columnists/awarren/

Cool. How did you implement bi-directional? Sounds like it is is causing an endless loop maybe.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Really only one book worth looking at:

http://www.sqlservercentral.com/columnists/awarren/reviewofrealworldsqldmo.asp

Andy

http://www.sqlservercentral.com/columnists/awarren/

Combination of the two. For small changes the developers send me the script. FOr larger ones I use 3rd party to show the differences, then review the changes with the...

Agree with Antares (or was he agreeing with me?). Makes sense to write the app as if it runs local, if you need to just wipe out/change the reg servers...

Good answer Antares!

Andy

http://www.sqlservercentral.com/columnists/awarren/

I think you have to put the file in the expected location for now. You can use command line switches to set location of both master and the folder containing...

I dont think you can get the info from another machine. Not sure why it would make sense to do so anyway? If you want the list of available servers...

I'd recommend doing it only for tables with low numbers of inserts, xp_sendmail isn't the quickest call in the world. Also have to decide what to do if multiple rows...

I agree that replication makes sense. It solves the problem cleanly and with less work. The downside to replication is schema changes become harder. Not impossible, just harder. One advantage...

You'd have to log into the machine as Ted to test it. If you enter a password, you're entering a sql login rather than an net login. Have not tried,...

One comment about scripting, if the model has already been modified with additional tables/procs your new db will have that stuff PLUS whatever you add to it. If you want...

Probably find something in the script library that comes close. Just need a job that checks sysprocesses, then kills the spid if its too old. Have to leave out system...