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....

This has happened at times in 2000, and as mentioned above, the only thing to do is stop and restart SQL Server.

I would not link the servers. Often people with rights to query staging do not have rights to production (nor should they). It's a potential security hole.

Instead I'd give rights...

I hadn't mentioned writing, but it is something I'd ask for if it's an unusual request. Thanks for mentioning and glad that people are thinking of it. I'd also note...

I think there are always jobs. I've seen reports this week that IT hiring was strong in the US and also that it was not doing well. Overall you can...

I'd use Karthik's solution and then be sure you get them into a version control system. Ideally you are checking them out of some SCC and then editing them before...

Constraints internal to the table require scripting. If there are FKs to other tables, are you importing them?

Andras mentions scripting it out, probably the easiest way, recreate the table in...