Figured it out. At several points in the past the server had been renamed and the @@servername was returning a previous name. I renamed the sp_dropserver, sp_addserver stored...

I tried to create it once and see that it is set up as an sa account, with that name. It didn't work, I'm assuming because I don't know...

I'm out on a limb here, but try setting the database compatibility level back to the 7.0 version. This might do something.

Tom

I think that you can also put an expire date on the backup and just keep backing up to the same device. I've only read a little about this....

Stopped and Started Sqlserver and that seemed to clear the problem up.

Thanks

Not surre but I thought I read something in books online that if you originally create the table with ansi_padding on, it will not change unless you drop and recreate...

I'm not for certain because I don't have your environment, but I'm pretty sure if you use square brackets around the [SQLserver\Name].dbname.owner.table it will work for you.

Let us know.

Tom Goltl

...

Steve,

Use sp_dboption 'dbname','option_name','option_value'

ie

sp_dboption 'somedbname','dbo use only','true'

You can use it to also set it to read_only, single_user.

Hope this helps.

Tom Goltl

If you use the per-processor-license then you do not need the CAL's. Also, if it is an internet SQL server you need to use per processor. The per-processor...

One of the reasons to rebuild the indexes is to eliminate or to minimize fragmentation. In your case, it sounds like different execution plans are being used when the...

This could be from the default net lib that you are using. You might be connecting with named pipes from the application. Configure you net lib using the...

There is also a system stored procedure--sp_msforeachtable. The syntax for this is much easier than the code shown above. Another handy one is sp_msforeachdb. This will issue...

We have an active/active cluster and our mail client is buggy. Will work sometimes and not others. I think that this is more because we are currently not using...

Clustering requires that you use a named instance. We have an active/active cluster and the servernames are A and B, the virtual cluster name is C, and the virtual...

It comes on the Developer edition of sql or by itself, not with the other versions of sql. Pretty standard Sql licensing. Also if you had MSDN, depending...