Is there any way I could get some of you to change habits and note quote 3,4, 10 posts in your replies? It does clutter the forum and make it...

SQL Clone from Redgate, Windocks, plenty of ways to help from third parties. Disclosure: I work for Redgate.

If you just need to move databases often, is backup/restore not...

I'm not recommending this specifically, but Cloudberry is one solution to move files to Amazon or Azure. They have a database item, but you can just use their...

Typo, apparently temporary dyslexia.

My apologies, we'll award back points for this one.

This should be corrected

banned

If you saw issues on the site this am, Rackspace had some network flapping going on, dropping packets. Should be fixed now.

I'd start here with the Stairways, they are designed to help you get started. Once you have basics, pick up Itzik's book and learn more.

You can capture the output of the script and execute it directly instead of using xp_cmdshell.

You would need to do the inserts one at a time.
WITH myTally(n)
AS
(SELECT n = ROW_NUMBER() OVER (ORDER BY (SELECT null))
FROM (VALUES (1), (2),...