The reason is MDAC is not a critical component of the Win 2000 OS. The Service Pack only pertains to OS issues, SP3 does not install any MDAC updates at...

SET is designed to set the value of a variable in one easy step with an clearly understandable keyword (primary thing).

SELECT variable does the same thing but typing

SELECT @var...

quote:

---

Please explain

"Use paramater substitution so that the actual statement text remains the same."

Since i will be pulling all the text from a...

One additional thing that I think should be added in regards to maintaintence which I got from another thread is this.

Singles database all users interact within the same envrionment. This...

Where I work IT supports the entire infrastructure and personnel. And my group supports the IT help desk for the entire corporation by developing tools to ease their load. If...

You always get a bennift by increasing the number of synchronous IO that can take place at one time. Yes major advantage, or even using a single controller with multiple...

Try running

SELECT * FROM Eq..sysobjects WHERE [name] = 'CK_code_e'

I tested your statement and works fine for me in my test DB, must be something it sees.

The restart is most likely that the service is set to restart on failure.

As for the other no documentation you will need to check with MS on this one unless...

Also, which version of SQL are you running. From what I can remember here you have 7 cannot understand the Access 2000 format and can only write to 97, I...

To the best of my knowledge, no. You can use systypes in master to give you a list of the datetype names but no list for things such as function...

Can you post what you did? (alter security stuff)

I am not sure exactly what you mean. Can you explain to us what you are looking for?

It doesn't tell you anywhere. The owner name is generally the creator but can be changed afterwards.

Shew did a great job there. I am wondering if you have started the server in single user mode? That is this line

sqlservr -c -m

You have to have the server...

The error may be coming from the batch file itself and not seen by the job. To find out what it is doing add at the end of your command...