To Eddie Wuerch:

Thanks for the explanation. I did not know about that NoExpand option. I will try on my Standard Edition.

Yelena

Steve,

get an Exam Cram book. It shouldn't be that big.

Whoever finds out where the server names stored let all of us know.

Do you think they could be in

C:\Documents and Settings\MyLoginName\My Documents\SQL Server Management Studio\Settings\CurrentSettings-2006-01-16.vssettings ?

The date in the file name is the same as the date of the install, but the...

Most of the older questions are specific to SQL Server 2000.

Did anyone mentioned that Indexed Views are working in Enterprise Edition only in SQL Server 2000 (from production editions)? Developer has it too because it is development edition for Enterprise Edition

Everything above is correct plus:

Client Network Utility Aliases

DNS Aliases (in addition to correctly mentioned DNS itself)

Client Connections should include both Data Sources (DSN), Hardcoded Connections Strings, Configuration Files, TNS...

Sure. We do that sometimes. Add a job step or a DTS package task of ActiveX Script type and use FileSystemObject to get to the files.

Ninel,

It does look right. Copy the whole thing and paste to Command Prompt Window on the Server computer. Click Enter. See error messages.

Then run it again but add a space...

I use a trace with login events. I find it more convenient because we can run queries to get data from the trace.

Ninel,

it means that COM Server which is a a friendly name for DLL to describe it simply, can not load because DTSrun utility can not find it. For me  it...

Hi,

I would like to add that the database size should be multiplied by 5:

First, some people tend to create a an extra database on the same machine to QA something...

Brian,

Great Article, good examples. I like a lot that it points out differences between 7/2000 and 2005.

As a comment, there was probably one typo:

"............In order to turn on policy checking...

Greg,

The manuals usually say that EM changes everything correctly. I did not have any issues so far, but I can not garantee that there is no issues. As I say, I normally...

Greg,

Startup accounts should depend on the business and security need. I would not do a domain startup account for the secure server where the app is located on the same...