What steps are they using when creating the table and are the setting the value themselves in the index screen if they use EM? They have to be setting when...

See my answer in the following thread http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3367&FORUM_ID=5&CAT_ID=1&Topic_Title=@@SERVERNAME%20=%20NULL%20?&Forum_Title=Administration

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

It is available in the design screen when you choose to manage indexes. Open to a table in EM and right click. Choose design. WHen the window opens, right click...

Take a look at "SET SHOWPLAN_ALL" as that is the extra fields data you list. There are almost no resources on this on the web and most are rehashes of...

I agree with Andy the field and data should still be available in the trigger. Can you post what you have for your trigger, maybe there is something going wrong.

"Don't...

Can you post your full steps and I will try to test tomorrow. Also what version of SQL are you running?

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

I would think that each has to be loaded and fired seperately so yes a small (probably almost indetectable) amount of overhead would occurr. Plus then you have to check...

Sorry, doesn't sound like a bug with SP as I run SP on a prod machine right now simply because I have had no need to upgrade. No issues. Could...

sp_start_job

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

There are several options on the wizard that deal with data. You need to uncheck these, also there have delete and create tables on those options show be sure you...

Sorry that would be a no. These items have code and structures that may not be supported in SQL and it cannot translate them.

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

That would be my next plan of attack. If all works fine otherwise recreate the Maintainence Plans and see if it works then. If does the old are corrupted in...

Not sure, could be. So let me make sure, you tried BACKUP DATABASE and some failed? If this is correct what was the message with those? I can look and...

Thanks Brian, sorry I use IIS5. As for security even on a private network I would suggest using SSL to connect (128Bit) and if you can get Verisign Certificate...

Unless you are trying the details of some system item I cannot find I cannot find anything similar to this. My suggestion would be drop the index and recreate, then...