I don't believe you can do this directly because of the mapping of pages to logical files. My guess is you need to:

1. restore to db with 1 MDF/ 1...

First, the content will run like any other article, on the front page, in the newsletter, comments welcome. We just want to call it out so you're aware it might...

I think we had a 9th planet issue a long time ago, but it was about 5-6 years ago that there was a 10th planet issue. I think it was...

You need to use SQLCMD. SSMS and Enterprise Manager open multiple connections to the server.

DBCC SHOW_STATISTICS (table_name , index_name)

It's 1 point per post, correctly answered Questions of the Day at their point value (usually 1-2 points).

We may expand it to scripts and articles, not sure yet.

It's kind of...

Very interesting comments and thanks for the debate.

If the company doesn't ask about some skills or change the reason they hired you, then I think it's fair that you wouldn't...

I tend to agree with Sharon. Anyone other than an expert, meaning someone that has more experience and success than at least 75% of the people in the field is...

Glad to help and let us know if you figure something else out. Might help the next DBA.

Steve

This doesn't make sense.

Can you separate columns and data, or is that not what you're showing.

You have an incomplete SQL statement that includes stuff that doesn't seem to relate to...

I'm not sure what you mean here. Import into test before test?

If you are trying to drive a job with a loop, I'd make a table in some db, maybe...

I'd do what Phillip suggested and also you might want to ensure there are limits to how tempdb can grow. If you allow autogrow, you might set a "space holder"...

Same file in both cases? Same collation?

Are these the same server or at least same version/localization of Windows?

Can you post the exact error?

How are you importing?

Two different jobs, even with the same user calling them, in this case SQLAgent, should have different SPIDs. The SPID is the process handle for the connection. Name of user...

That's the way to do it. For regular operations (add, edit, delete) or objects, you don't want to mess with the system tables as a rule. There are exceptions, but...