Ok it is not the login problem but the fact they use the script under the sa login. Since it is a script then try this at the begining

if SYSTEM_USER...

To my knowledge no. There is another thread similar to this and I am looking at code I wrote months ago that was and attempt at this. However for views,...

Sorry leave both on. Create and Update.

As for the second question this is from BOL

quote:

---

AUTO_CREATE_STATISTICS

When set to ON, statistics are...

I believe this is due to permissions on the remote server as you have to have an account that SQL is running that is also the same on the remote...

I am a CNA and MCP (just lazy and have not taken the MCDBA tests I need to finish which would also finish my MCSE) My biggest beef is the...

quote:

---

side question: One of my programmers needs to be able to tell , in her program, if a db is read-only. I...

I would use SQLAgent as the jobs have multiple steps, can make decisions based on fail logic, and can send you a message to let you knwo if all your...

I don't think you need to run sp_createstats but as for sp_updatestats I would consider. I was involved with a thread about the stats this past month and someone noted...

I have some partial unfinished code that does that but have not had time to finish it. Querying the nsystables and syscolumns also does not give you the nice index...

I think with my cofussion on what you were saying that was an accident.

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

You shoot consultants from other companies coming in to mess with your server on site, dead or alive. Then when you get thru laughing about what you were thinking...

Sorry can you post a clean example of what did work in SQL code. I just want to compare as I don't see the issue right off.

"Don't roll your eyes...

I enjoyed the challenge and glad to hear.

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

Ok, when you do schedule job it will always be 00:00 daily by default. However if you go into SQL Agent and jobs unless your jobs were defined to delete...

Same unless you change.

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