Thanks.

I was able to use your code to create a UDF that works for me.

Thanks, but I don't want to set defaults.  The defaults are already set.  I want to select the defaults.

In the example I gave, I can insert a varaible (@WatchPoint) or...

Is pol_id an identity column?

I would add to that that one of the motivations for putting images on a file server is cost.  Your SQL Server data might be on very expensive SAN disk...

It depends on your situation.  If you're loading thousands or rows into your tables every night, you certainly want to update statistics.  You might even consider dropping indexes before the load...

Sorry, I missed the part where you said it was a Pervasive database.  I thought we were dealing with two SQL Servers. 

You would not use openquery in your view.  You would use the four part name as follows:

select * from servername.databasename.owner.table

Off hand, it sounds like a data quality problem.  Most likely, some of your dates are not real dates, such as 2/29/2003.

Use restore filelistonly

I have *actual* experience with several databases over 200 GB.  I'm currently working with serveral holding financial data which are over 400 GB and expected to grow to several terabytes.

There...

It takes time for SQL Server to update the usage.  You can kick off the process yourself with DBCC UPDATEUSAGE.

For one thing, you can choose to ignore duplicate keys when you create a unique index.  This isn't possible with a unique constraint.

For another, you can cluster a unique index.

I'm afraid it won't work.  SQL Server ensures transactional integrity with triggers, and I don't think there's any way to modify that behavior.  Since Access does not support these kinds...

I also agree that this would make a poor username.  In fact, I don't recommend using identities (or any primary keys) as anything other than an internal reference.  By this,...

I've been experimenting, and it looks like modifying syslogins and sysusers will work.  I haven't found any problems so far.  If anyone has any further information -- you've done it...