Did it happen only once or it happens often?

I don't think it could be done. Just in case I looked through my 7.0 books. Administrator's Companion and MCSE SQL Server 7 Administration don't say anything.

"Inside Microsoft SQL Server...

Thanks Brian and Terry!

This is what I get all the time: I install SQL Server and it does not ask me to reboot. But if I need to install a service pack right...

Did you check your developers who may dynamically create and drop databases every few hours just to test something? For example if someone is working on the application installation package...

Brian,

Can you have EM and Management Studio both open at the same time? I do understand that you say we can have both of them installed on the workstation.

The reson...

Could we have both versions on the client? I did not try it myself yet.

One thing I found out is that 6.5 compatible databases can not be managed through Management...

Hawg,

you do have to read these 2 pages that I said from Ron Soukup's book. I am sure you can use his solution.

You may send me your email address by...

Ed,

Thanks. It is me who always says that my SQL is better than my English. And as targeted audience I read your post.

Another exaple of the "long way" based on...

I also want to answer John Kelly:

1 .This is a good article

2. This site IS for both Newbies and professional DBAs.

3.  Professional DBAs do not write code every day, they...

Talking about NULLs: this something I do EVERY time I am in a hurry and then wonder where are my rows for 30 seconds before realizing that I probably should...

Hi,

I would opt for WMI. Go to Microsoft website. Download Scriptomatic tool (search by the keyword "scriptomatic"). Install it. Installing consists just of unzipping the tool and the readme. Double-click on...

When you say VB Client Connects... what do you mean?

Is it OLEDB or ODBC connection? It may depend on the driver:

OLEDB: sqloledb.dll, ODBC: sqlsrv32.dll

also, did you install sql server...

Yes.  There is an idea. 2 actually.

First, try to post this topic on this site on SQL Server - T-SQL Forum. They may have more ideas.

Second. Get a hold of...

Rudy,

Thanks. I will do that and will let you know if it helped.