When you backup system files do you backup open files? If not you may find they where skipped by the backup.

End of the day for me as well.

Hope everyone enjoys there weekend.

Quite correct Frank,

The same day. That reminds me I must update those images of the baby, they are nearly two months old now

And maybe a Union...

I'll suggest that you trial SQLLitespeed, and maybe you're like it so much you could get the budget to buy it

Edited by - steven_white40 on 09/04/2003...

You could use a server side trace to record this information to a file, then load the file into a table, and query it.

See sp_trace_setevent in bol for what events...

The problem with going to the last post (and the advantage of the current system)

is that people tend to read the whole thread, rather than the question and the last...

I was thinking really about one step further, as there are a number of people who answer a lot of questions and that would allow people to try and answer...

Perhaps it would be worth looking at the code the page was running to try and speed it up.

In addition the forums get a wide range of questions from newbies to experts.

Its a good place to exchange ideas, and promote the use of sql (and hopefully improve the...

Aged 33 and Married with three children (7 years,5 years and 2 months old)

Is someone going to create a profile for sql dba's....Age, Gender, No. of kids etc.

Edited by -...

With that approach you will also need to create all the accounts on the 2000 server.

In SQL 2000 you get a copy database wizard which I seem to remember works...

Phill's recommendation of

http://www.sqldts.com/default.aspx?204

is very easy , just coping a table.

I've used that idea before. It works a treat

IISServer\UserAccount is a local account to the IIS server only.

Take a look at sp_attach_db in books online.

It may be what you are after.

You could add the /L<filename> switch to output a log file.