You might find something in our script library, we have a pretty good selection these days. The replace option of the restore command will drop the existing database before restoring....

You have to think of it terms of data, not the index. All the index does is order it. You can use an order by in a select to achieve...

The best way is to run a trace and log it to a file that you can later import to a table.

Andy

Doesnt really matter where the mdb is, you create the linked server so that you can use it just like you would any SQL database. http://www.msdn.microsoft.com is usually the first...

Have you double checked that the userid & password you're using for the service is correct and has disk permissions?

Andy

Start adding a new linked server. Enter a name for it. For the provider select MS Jet 4.0, for data source enter the path and name of the mdb. That's...

If the integer format matches what SQL uses for dates you could use the convert function which supports formatting through the styles parameter.

Andy

Could you post the trigger code and the function?

Andy

Interesting! I will take a look at that, could be useful.

Andy

You could use a user defined function or a cursor to achieve the results on multiple rows in one insert.

Andy

Sorry, only answered part of it - I'd say start by seeing if the proc exists on the server or not.

Andy

Its in the master db. Looks like to does a bunch of clean up..as you'd expect!

Andy

That's why I recommend using the stored proc add-in that was mentioned in the link I posted to my article. It generates all the param code for you. Definitely don't...

If you can get good code reuse out of building the view, why not?

Andy

Not that I know of - you might try a search on Google to see what you find. I recommend picking up any one of the beginner level books on...