What's the provider and what were you doing? Not sure either, but looking for more clues.

Don't think there's a Red Gate tool to do this. Not sure you want to script server settings (sp_configure) to new servers. Maybe, but there are differences between servers you...

xp_cmdshell opens a shell, or command prompt, from inside SQL Server. You can't see it, and it can't need user input, but it works like a batch file, allowing you...

But wouldn't some transactions in merge be applied if they committed? It wouldn't necessarily roll back everything because the network dropped. My understanding is that merge is transactional two-way, but...

I think you might need to loop here, and you need to be sure that there's an order that ensures that records that could be duplicated appear together so you...

I would avoid storing formatting. Things often change, people don't enter them the same way, and it's easier to strip formatting to ensure consistency than add it in later. Phone...

Also, if you have more than one subscriber, the commands don't go down until ALL subscribers have gotten them.

I wouldn't mess with this. Uninstalling things from a cluster can be tricky, and I'm not sure it's worth messing with.

You don't want things enabled that you don't need, or...

You can see if it's enabled and check for jobs running, look in SSMS for publications defined.

With the rate of changes in some technology, even SQL Server, I feel like I've got 1 year of experience many times over in some areas (SSIS, Service Broker, etc).

Well, I'm definitely not a physicist. I took some Modern Physics, starting with relativity and moving forward from there, and was lost. We had some questions on the final...

Logins might be the big thing to move. sp_help_revlogin (search this site) can script out the logins so you can recreate them with the same passwords.

Script everything else out and...

You can, but you need to also be aware of logins. You can install SQL Server on the new box, attach the MDF/LDF as a new database, and you'll...

You can't make the FK reference multiple tables. It's a relationship between tables, not rows, so you can't switch on rows.

The way that I've done this is you have the...

Are you adding another database or an instance? Instances are more complicated.

Adding a database means that you share tempdb, and there are some threads, data cache, procedure cache, being used...