Simon,

Eddie is correct, you can see 2 processors on the Processor tab in SQL Server Properties and 2 processors in System Summary but it could be only 1 physical processor....

I wonder if Muhammad knows how to register a server since he says he is new to SQL Environment. Linked server is good to run SQL queries. But if you...

I would first take a look in the Event Logs on the server to see if there is any error or warning messages. I would verify that the SQL Server...

Mark,

the link you posted

http://www.microsoft.com/technet/scriptcenter/resources/qanda/aug04/hey0824.mspx

is so cool. It is working well for me. I just replaced DC parameters with our domain names.

I also use dsget and dsquery...

I agree with Sushila. We do need articles for the beginners. Performing tasks from this article will make them familiar with options. Good comment from Dan Collier:  Maximum characters per...

Hi,

You have to check what is going on.

Try to execute this job by steps and see what happens.

What is the job anyway? Is it DTS package or SQL Statement? Try to execute it...

I answered correctly but I think one of the other selections would be a good choice if Microsoft implements it in the future. You all probably understand which one I...

Yes, sure that explains.

Sure you can have more databases, I just misread your original question where you say that you get all system databases and 1 user database (that gives...

Hi,

could you tell us what databases are missing from the list?

What databases you call system and what user? I mean, why 10 databases on MSDE with only 1 user among...

We would normally get a suspect database status when the database file does not exist.

The sequence: normally you would restore Master and MSDB first, then restore or re-attached user databases, see...

is there any reference that distributor_admin has to be in Sysadmins?

Scott,

you say "you should read some of our claims". Do you think that some people would use ambiguous expressions on purpose in hope that an insurance employee would interpret it...

Hi,

I had to do a text field update once from 2 text fileds from 2 tables into one text field in the third table. I used a simple update but at...

Scott,

Disambiguate!

The perfect example was in Scientific American magazin about 20 years ago. The article talked about artificial intelegence. How the computer can interpret "The chickens are ready for dinner"...

Yuri,

try DTS with  text files.

I had to test-populate some text field, I used DTS with a couple of text files with a lot of text.

Why do you say you can...