primary = F,G,I

order = G

checkout=F,I

yes

Is the internal SP under a different  owner name?

If yes, add  owner_name.youre internal_SP

LMT

check this:

sp_dboption [ [ @dbname = ] 'database' ]

    [ , [ @optname = ] 'option_name' ]

    [ , [ @optvalue = ] 'value' ]

and

DBCC USEROPTIONS

try this

before SQL

 write:

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

The best after me   integer

Example:

cast(convert(char(20),your_date_column_name,112) as int)

It can be easily controlled and is faster, much faster that any date or varchar datatype

LMT

Thanks for the article.

What buggs me is the public role ijn Master db

because it has powers against information_schema objects

Could we get rid of those permissons with no further negative effects?

Thanks

Lavinia...

Thank you

that is a good idea.

The only think that I would do ..instead to recover in the same PC I would recover in different one because the memory and CPU...

how you do your backup - on backup devices?

- what type of backup?

try and run DBCC CHECKFILE(file_name)

jeffwe you are right.But I think that is the closest.

What I did is to create datafiles and move my tables - wrote a note with where the tables...

Thanks a million.

I did now to use "indid"...that answered my question

You have no idea how much headache solves me!

how many times /week/day you load the data?

If 1,2,3/week change the option model for the database to Bulk-Logged

and make sure you do a backup log after...

and no error message at the PC app level or system level...wierd!

sorry for my late reply.

I restored into a different PC and even when I reproduced the tempdb error I did not get the 823 err.

I...