If you are looking to script the database for #1, then right click the database, select Tasks, and there is a Generate scripts option.

For #2, if you want to...

Typically the error shown is when the pathing is wrong. Perhaps the production system has different drive paths or you don't have rights to open the file.

I could see how this helps and it might be easier, but it depends on your data. With the two join tables, the advantage is a picture can be used...

We've seen some of that here in the past with invalid cards. However it's typically been 2-3 attempts only.

I wouldn't be surprised if it was regularly occurring as people always...

No idea of failure rates, but you should be able to contact your bank for statistics on your current situation.

I think you need to get the SQL Server into the internal network. Anything else is not only a bad idea, but probably a big problem.

Whether you use #1 listed by Markus or not, you should always use roles.

do not assign rights to users. Sooner or later they will quit, someone else will do their...

Sounds like a problem with the install media. Possibly some files weren't read correctly.

If I remember correctly, a reparse point is a part of the file that determines where the...

There is no "cursor capacity". It will use available resources to read everything up to the full size of the table. You could cause memory issues, but that is a...

You can have multiple instances and I know clusters can support this, so I wouldn't expect an issue, but I have not specifically tried this. I think if you have...

Is there a client running with this isolation level? Sounds like the data changed while it was being streamed out. READ UNCOMMITTED would allow that.

Sounds like a problem with one of the files. I'd reset the snapshot and see if that works.

If you need to change the data in your local database, you have no choice but to use the full backup.

However, daily restores seems like a lot. Think about whether...

You don't want the file to grow by itself, ever. That's an emergency thing if you can't respond.

You should be monitoring this and if you see it getting low, add...

Not sure what you mean about the stored procedure in the table.

You don't need the name of the stored procedure to call it, you can send in parameters in order....