Right-click on the server name in Enterprise Manager, select properties and under version it will tell you a service  pack for SQL Server.

Or if connecting remotely:

select serverproperty('productlevel')

Please, note that Select...

Nita,

to visually see in Enterprise manager expand the database and in Users container see all users, when opening user's properties (double-click) you will see the permissions.

to summarize by script use...

I have to work a lot with "End Of Line" characters that normally are:

CR(carriage return) (ASCII 13), LF (line feed or new line ) (ASCII 10) or CRLF (both).

Everything...

I would use a database designer like ERWin or ERStudio to make a structure and then would pump data either by DTS or intermediate dumps to flat files and use...

They  meant answers A and C (First and Third) but numbered not in letters but in numbers.

Additionally Platforms usually are used to describe Operating Systems, VB, C== and C# are mostly...

Thanks to both of you. I will store these notes.

Yelena 

Sushila,

Great article. And a great purpose: people tend to forget that other people may be newbies in something but be expert professionals in something else.

The only comment I would...

Rudy,

Do I understand correctly that when working with SANs  we should ask network Administrators (SAN admin) to create several META-LUNS  on SAN for the databases and then we will treat...

Check SQL Server Agent properties on how it connects to SQL Server on Connection tab. Also check how your Enterprise manager and Query Analyzer are connected

For an example of 3rd Normal Form but not BCNF see 

http://www2.cs.uregina.ca/~tang112x/research/papers/2003s/0617/5NFBC.htm

Hello Richard,

They usually say that having data files on different physical volumes improve performance, so it may be better to have files on 3 volumes, but I did not work...

Hi Peter,

HP Openview has SQL Plug-ins, our Server support did use once for a couple of my servers and I got an alert once. But you have to have the...

I find it a good question.

Scott,

I was trying to understand what users you are talking about: Windows (Machnename\Username) or SQL Server standard logins?

For SQL Server standard logins I create a login on the secondary server...

SQLBill,

It is OK, I just misread one of QODs a couple of days ago.

But I am glad Rudy answered because we now know who to ask things about the network...