No, not without a reinstall.

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

If you have an index on the EmployeeID it may have had the highest density of unique values making it a stronger candidate for index use, use sp_statistics to look...

Be carefull but the way I do things like this where a specific condition can be met is like so.

sp_MSForEachTable '

if charindex(''mds'',''?'') != 0

begin

select ''?'' as verifyworksfirst

--drop table ? --uncomment...

IS it coming thru as NULL or '' (blank), if later try adding AND F3 != ''. I also believe this was asked before in the groups, you might want...

The biggest areas of slowdown are with indexes. If you can script out your non-clustered indexes unless your primary key is one of them, drop them and recreate when done....

These are the sort orders for code page 850

quote:

---

40 bin_cp850 Binary order

41 dictionary_850 Dictionary order, case-sensitive

42 nocase_850 Dictionary order, case-insensitive...

I have not seen this and no where has anyone else came across. If the error is repeatable and the customer knows the steps the best thing to do is...

If large I will take a look if you want to email to me.

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

How are you stopping the queue. Are you destroying the queue? I believe you have to xp_trace_deletequeuedefinition to get rid of the queue and thus release the queue handle.

As for...

Yopu should also get these

Network Connection Type

Network Connection Speed

Domain/ADS/StandAlone

Domain/ADS Name

NT Hard Drive configuration and capacity

SQL file layouts

ANd it is good to get a base line of SQL statistics. Database/log growth,...

If you do via DBCC will work in SQL 2000 but you may have to run BACKUP LOG dbName WITH TRUNCATE_ONLY. If SQL 7 you will need the script Steve...

Take a look here and see if does not work http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q240853&

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

Try dropping the job and recreating, may be a permissions issue. DO you have any code checking at the end the process was successfully in the DTS or job itself....

DO you know where the suid reference is coming from? Is there a table or view referenced on test that is not that way in prod? If not try watching...

Check out http://support.microsoft.com/default.aspx?scid=kb;en-us;Q310468 for the reason and the solution.

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