This is the basic strucutre of how I use a temp table in SP and has not failed me.

CREATE PROC ip_ProcName

--Variables Here

AS

SET NOCOUNT ON

CREATE #TEMPTABLEHERE (

[COLUMNSOFTEMPTABLE] [datatype] (NOT) NULL

)

INSERT...

Try using sp_resetstatus to clear the suspect marking and see if clears.

Excerpt BOL

quote:

---

sp_resetstatus

Resets the status of a suspect database.

Syntax

sp_resetstatus [ @DBName =...

And I believe that requires the SQL to be licensed per cpu otherwise you will have to get a client license.

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

Sorry I don't have a copy here with me today but I believe you can do a custom install which allows you to set these paths when you install. I...

Also you know it worked previously, you need to find what specific change you made before it failed. From your statement

quote:

---

The...

Can you change you settings back the way they were before the failure and then change them one at the time and test. Also since Agent runs the jobs how...

It also depends on where Profiler is running and what you are capturing. I would suggest stop profiler (close it, hopefully you output to a file or table). Then see...

I don't believe it won't work but do believe you will run into issues. I could not find anything on this and nor have I tried myself but some good...

You didn't happen to try connecting with two apps did you? Ex. QA was connected before you were opening EM. Also what is the problem you are having, is it...

Usually it is done thru command line switch at startup. Check you service to see if any switches were added. Also usually the first person in does not have this...

I guess it boils down to what you are needing to do as to how we best answer your question. Can you give us a bit more detail please?

"Don't roll...

How is your linked server defined for server B from A as far as login process?

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

If you need some help where the justifications can be made if you will post the full specs of each machine here we can over help I am sure.

"Don't roll...

Duh, I knew that, been so long since I wrote the code to do this weekly (thinking of something else sorry). What does your showcontig look like when you run...

I have never seen the "bad page ID" statement but error 823 I have with insufficient resources, take a look here may over some here http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=sql&Query=823&Queryc=823&REF=false&srchstep=0&KeywordType=PHRASE&Titles=false&numDays=&maxResults=25

Also might try using DBCC...