Yep. we reboot it once a month. Have it scheduled with our operations staff. Otherwise it's head gets filled with Stuff. Too bad WinNT (what this app is running on)...

physname

- ejl

First, I cannot thank you all enough for your help. Wow. You've been great!

The create database that finally worked was...

CREATE DATABASE epic_names

ON DEFAULT = 20480

It didn't give me all...

Alas, I can't do that. SS4.2 was bundled by the vendor with their product. I'm doing this to clear up data prior to moving to a more modern system.

You're right. That's the frustrating part. This is a 14 y.o database engine and I can't find _any_ documentation on it. Even MS Knowledgebase doesn't go back that far. Grrrr....

Yes I did. It doesn't like that. New error...

Msg 102, Level 15, State 1

Incorrect syntax near 'NAME'.

Thanks

- Ed L