No you cannot use a foreign key constraint on a view. Only on tables themselves.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

You may need to look at in Profiler to see if anything is going on under the hood. Look at SQL:StmtBegin and SQL:StmtComplete to see if extra transactions are occurring...

For me I walk the middle road. I tend to code right off on things I am comfortable with. Things I have not tried I will test until I understand...

Is there any Active scripting in you process. This is the error I see when creating and object that calls a COM object that is not properly done.

"Don't roll your...

If this is so you can restore the database or duplicate somewhere else then consider this. Create a database from the scripts and import the data you want to be...

Some details on how you perform your backups will be helpfull as well. Are these disk or tape backups? How often? Etc.

"Don't roll your eyes at me. I will tape...

Not really a way to stop them from seeing another users items in EM. However they will be unable to affect the item unless the owner has given permission to...

Also you will need to set the variable with a default value when nothing is submitted or it will return an error.

Ex.

@prmWidthvalue varchar(25) = "",

Then you can further what andy...

This problem usually comes from SQL Server Agent running under local system account on the box or an account without access to the remote path. If you have a domain...

Sorry, need to see the UDF itself to understand possible why.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

FOr you to output different long date formats you need to setup each user with the version valid for them in there login. This can be defined by using sp_defaultlanguage.

This...

Are you wanting to use the IUSR_ account to log in to SQL or are you just wanting to log in?

The way a connection is made is determined by you...

Is SQL Server the only thing you have setup this way? If not then have you tried any of the other connections to see if they are working properly. Also...

Running this should shut down those changes if they are open.

EXEC master.dbo.sp_configure 'allow updates', '0' RECONFIGURE WITH OVERRIDE

If the previous options are not fixing the issue you may need...

Also consider anything that may have changed in the setup. I have not heard of bogus errors from AS400 but the latest Oracle drivers are a pain to get a...