The fix was to basically Add back the Article and than drop it again and it cleared the flag that was on the table.

The table was removed from Replication and it won't be added back. I am still not sure why the flag was not changed.

Thanks, I will review from the link.

Thank you for your reply. On one of the identified poor performing procs, With Recompile' was add to see if proc performance would improve. It still returned slowly....

Thanks.

I think I am going to use the File Watcher component. Thanks.

Also, you still would need to set up trustworthiness if you use sys.dm_exec_sessions instead of sysprocesses.

But will use this instead of sysprocesses.

Thanks for your help. I did have to add one additional step.

1. ALTER AUTHORIZATION ON DATABASE::dbname...

Thanks.

Here is what it looks like if I modify a test proc in SQL Server Management Studio I just created for this example:

As you can see it automatically throws in a an...

I checked that already.  I don't have it set at the connection level, database level, or server level.

Any ideas.

thanks,

Daniel

Thanks for the info.

thanks for the input. I will try.

Daniel

Thanks for your help.  But there is still an issue with it.  The data from the Excel spreadsheet was imported in from a different data source, and I am still...

Where\how do I add the 'IMEX=1' to the connection string in my SSIS package?  Do I go to properties on the Excel Source? 

Thanks for your  help.

Daniel