Hi,

I think the easiest way is to open Query Analyser and load each of the files in turn, then execute them against the correct database to create the Stored procedures.

I...

No problem. If it were me i'd change the use of the YEAR to datapart as it currently wont allow you to make use of any index on the viewdate...

Hi Phil, you forgot to mention that Access tends to kill SQL as the majority of users wont know how to write a query properly (perhaps that's doing a disservice...

You can perform a backup to a UNC name, you just need to make sure that the account used for SQL has access to the remote machine.

Have you created the stored procedures in SQL Server yet or are they only in the file?

Assuming they're already in SQL you can simply do the following

exec <1st Stored Procedure...

I have no idea, but if it's working properly then I'd be tempted to leave it alone

That's a whole lots of records and is going to take quite a bit of tempdb space to do anything with.

I'm assuming that you...

I would always tend towards the varchar unless I was 100% certain that a field would always be an exact length no-matter what, at which time I would consider changing...

I dont think I know of any DBA's anywhere that haven't had this at some point

It would be nice to think we didn't...

Unfortunately you can't kill an extended stored procedure once it's become disconnected, we had this sort of thing happen a while back and I ended up researching it pretty heavily. ...

I'd agree with Chris, care in setting up the database in the first place can significantly reduce disk fragmentation. 

I always defrag the disk on a new server before creating...

If it were me then I'd probably go with the mdf files first, that's where the majority of the data is going to be.

That's fine for OS file fragmentation but...

We use a third party utility to do this, why reinvent the wheel (actually we're using 2 to decide which is best).

Red-Gate's SQL Compare and Innovartis' DB Ghost.

Both are more than...

Why do you only want to have the one stored procedure.

If it were me i'd create a seperate SP from each distinct task and then call them via the ASP. ...

But who in their right mind wouldn't have already excluded all of these things from the virus scanners

Quick appologies to anyone willing to...