Check books online searching for 'Instance Name' under 'Installing SQL Server' answers to all your questions should be there.

ll

Govind,

I agree with everything said above but one simple thing to always remember in SELECT clauses is only to select exactly what you want to return, i.e instead of the...

Ok no probs, my ALTER TABLE script was wrong, should have read:

ALTER TABLE tablename 

  ADD CONSTRAINT 'constraintname' DEFAULT (getdate()) FOR 'columnname'

Lloyd

TIA,

There is no way I know of to automatically (unless anyone else knows better??) insert the current datetime in to a table open within EM unless the COLUMN has a default constraint set...

Juanita,

Be aware that you will not be able to truncate the original table if it is referenced by any foreign keys which...

Marsha,

are your SQL servers running on NT 4.0? if so i'm not hugely surprised!  i have had no problem with this on 2003 server, or 2000 (from what i can remember).

lloyd

JP,

try running sp_helpdb without passing any parameters, the recovery model is listed in the 'status' column.

lloyd

lebi,

hmmmm i recently came across a similar problem.  however mine was slightly different in that i was trying to hand out general day to day checks to the TSD (technical support desk)...

laura,

the public role is a database level role, every database user belongs to it and cannot be removed from it.  it provides access to all system level objects and exists in every...

make sure the corresponding database user isn't a member of the fixed database role db_denydatareader within the database you are trying to view.

ll

nitin,

just to clarify, when you say the following:

"We have a Web application that uses a common ID to connect to the DB and then we have secutiy implemented based on...

tom,

i use a set of tools by Red Gate, called the Red Gate SQL Bundle, it consists of the following tools and is very competitively priced:

SQL Compare v 2.03

Compares...

Linda,

when you view the Job History, have you checked the 'Show step details' checkbox on the top right of the Job History dialog?  when you select the job step in...

yogiberr,

for remote admin and development i have started to give some of our developers 'Microsoft SQL Web Data Administrator'

http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en

it has a jazzy security admin tool, allowing you to create...

i've experienced the same issues with table width size as Jonas has mentioned, in extreme cases it can make an article almost unreadable.  here is an example of a recent...