When you make a schema change, a new table is created, the data copied over, and then the old table dropped, new table renamed.

This is probably what's happening. If you...

Does the user need to read all tables?

A login is a server level security object that maps to a user in a database. So you need to create a user...

Thanks and glad you like the topic. I was hoping for more of a response 🙁

We used to change emails to email001@xxx.com, email002@xxx.com, etc., to correspond with some id value...

I find the painting thing hard to believe, but it probably depends where it was tried. San Francisco might allow that 😉

Let me reframe this slightly, since I probably didn't...

You've done a lot of what I'd suggest. I would look at the disk system, I wonder if you've got hardware issues.

The other thing I'd check is do you have...

I'd go with Matt's solution. Even if you change memory, you have to read in the initial data into the data cache, which is slow.

We've done this, created a...

Does the SQL user have rights to run the package? It has to be able to read it from MSDB.

If you execute that statement from your workstation, does it work?

Neither one. They will run differently. The first runs as 3 separate transactions, assuming you do not have implicit transactions changed. It could result in some data being inserted...

Jack is correct. There are two mail systems, SQL Mail, run by the SQL Server database engine, and SQL Agent Mail, run by SQL Agent. You need Database Mail set...

I tend to agree with Jack that any database could work. However I'll qualify in terms of what scale/rate you're looking at. If you were to want to store high...

If I buy a painting, I don't have a license. I have the right to do what I wish with it, including destroy it. I can copy it if I...

I'm confused. You installed SQL express on your machine and how do you register other servers? I thought Management Studio didn't come with express.

In any case, Management Studio shouldn't be...

You are really doing parsing at this point, which isn't a strong point of T-SQL.

You can use charindex/patindex in the returned field (Cast to varchar) and then find the...

The DBMK will be encrypted with the SMK, but you can unencrypt it and back it up, then open it on the new server, or after the restore and encrypt...

Couple questions, are you inserting scalar, specific data? Is there a PK on the fields?

If there's a primary key, and there should be, then it won't insert. You could move...