Didn't know EditPlus did that, though I use that for lots of stuff.

I have started using GitHub for keeping code sync'd between machines. Like that for now.

I don't know that everyone can, or wants, to learn programming, but I do think there are a wider group of people that can than are doing it now. Some...

I suspect you have memory issues.

Check free memory in Task manager, make sure that it isn't too low. In line with that, here's a related thread: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/b43c3631-b28f-4564-a802-7b737966b457/there-is-insufficient-system-memory-in-resource-pool-internal-to-run-this-query

DBCC MEMORYSTATUS will help...

I think it's what it says. You're memory starved for this operation. Is it a busy instance?

The logins need to be mapped to users in each database, and a role set there.

I think this will help. I can't test right now, but it looks like it reads the files, gets the info from them, and then builds the restore command.

http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/30962/

Looks like notifications are working. Not sure if something broke loose or got fixed.

Are all databases going back to the same pathing? Or to the default paths on the new server?

Not available, but I've asked for this as well.

Would this help?

http://www.sqlservercentral.com/scripts/96623/

You can want it all, but you can't have it all unless you can spend some money on resources. You'll have to make tradeoffs.

If your app goes to other databases...

If you grow the files, they should be at that size on restart. Are you sure you manually grew them and didn't just assume they'd stay the same because they...

The Azure test is interesting, however I'd recommend you set up a virtual machine. Lots of free players, including Virtual Box.

you can then go through the install yourself.

I assume you want a create or alter script of some sort. the problem is that you are always working with two versions to generate changes. Otherwise, how can you...

Jamie Ingram-729524 (7/8/2013)

---

Can I just whinge about the link to the updateable snapshot?

What's wrong with updating the base table and then regenerating the snapshot? This is a far better solution...