With Access they've tried, and you can set up essentially the Express engine for Access apps.

I think we are getting closer with Exchange, but I'd like to see the specific...

The script is a T-SQL script. You need to execute it in SSMS.

Gail's design shows why it's better for you to give us the information about what the entity is, and what the data is represents. A good designer will consider that...

The conversion time is hard to guess. It's a "build a new table, copy all data from the old one". You can test that with a fake table.

As far as...

Probably could, and should.

The decision on what to make a clustered index is more based on the queries made against the table, not the definition. You would want those queries that look for...

We don't allow deleting of posts, and we're prefer if you figure it out, just post again.

Thanks for the update.

Steve,

We'd love some basic articles on how this stuff works if you're interested. You wrote some great descriptions above.

It's not clear what you are asking or what you did. Please provide more details about what happened, and what commands you ran.

Please don't edit posts to remove everything. It's rude and looks bad.

Closed post.

You can even use the "START" command in a command prompt to spawn a process, or you could use DTS and execute the restores in parallel.

You do need two different...

So check and be sure that TCP/UDP 1433 and 1434 are open. I think UDP 1434 is the browser to enable you do connect.

If you can make an ODBC...

I like Pradeep's solution. If allows you to do other maintenance if you wanted to rebuild indexes/statistics, obfuscate data, etc. while keeping people out. you could also send a message...

Be sure that you check the Windows Event Log (System) to see why it didn't start. There should be an entry that gives you a reason.

You can use three part naming, database.schema.table to reference the other database. The write an insert select statement.

If you try and have issues, we can help, but we don't do...