I agree with Andy on the second part. Have you app if fails to open a connection to main server changes connection to local MSDE version. Then have a timer...

Check out http://www.microsoft.com/data/download.htm#CCinfo fo the MDAC Component CHecker, this will help you find out your installed version and should help diagnose install issues (which I haven't tested).

"Don't roll your eyes...

How is the logon with SQL AGent defined. Is it local system account or a domain account? If the later have you tried logining in as SQL Agent and testing...

Use to be that numeric was the best way to go by the way it was evaluated by the processor but I remeber someone pointing out in another thread things...

I get the same after testing, 7 doesn't do it but 2000 Profiler does. Looks kind of like a failed auto recovery implementation like is used in Word. Will need...

quote:

---

>If you have an app already running in Access I'd recommend moving the data to SQL and linking to the tables, preserving...

There are numerous factors that can cause this. Another possiblity is the amount of work being done in the DEV and PROD environments as opposed to the TEST environment which...

No. Restarting may be your only solution but you need to find the reason why this occurred.

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

Have you tried running this in QA to get the output information. I have no troubles with this format based on my databases but the output information should give a...

Is this handled per user or is exactly how does the SP work? If it is based on user connection then you can change the user login to a specific...

Either use datpart to get the pieces you need or look at CONVERT in BOL, for example

CONVERT(VARCHAR,GETDATE(),101) returns mm/dd/yyy

CONVERT(VARCHAR,GETDATE(),108) returns hh:mm:ss

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

If you mean as a column name then do

SELECT OBJECT_NAME([id]) FROM syscolumns WHERE [name] = 'valuetolookforhere'

Otherwise I am not sure what your are asking.

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

Any other jobs scheduled for the same time that might be causing this? Or is some other maintainence running that may be shutting service off temporarily?

"Don't roll your eyes at...

Thru TSQL it is

ALTER DATABASE [testDb] SET RECOVERY SIMPLE

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

Sorry other than to say they just didn't I don't know why they did this. May have something to do with the way existing functions don't belong to anyone and...