Thanks I will be starting next week or a dev SQL 2005 then March for production.

So for the moving of databases from SQL 2000 to SQL 2005

Just do the

SP_MSFOREACHTABLE 'Update Statistics? WITH FULLSCAN'

No need to do the rebuild of indexes.

and then do...

I was trying to use

USE database_name

go

DECLARE tables_cursor CURSOR FOR

SELECT name FROM dbo.sysobjects WHERE OBJECTPROPERTY(id, 'IsUserTable') = 1

OPEN tables_cursor

DECLARE @tablename SYSNAME

FETCH NEXT FROM tables_cursor INTO @tablename

WHILE (@@FETCH_STATUS <> -1)

BEGIN

...

You mention the books which ones did you mean.

Buy a book. The microsoft books give you a no nonense insight into what the exam contains. its not that expensive, and...

Thanks for replying. Im the DBA and i done some web programming not to the iis pool level. So i will play around with the groups and pools...

Think im with you.

On the IIS can this be on virtual directory and (Many Groups defined here).

GROUP A GROUP B etc

Or would it have to...

From what i can understand he sets the Application Pool to use a domain\WEBGROUP which in AD is service account....then some users are in a group and assigned to this...

This this will do it.

DECLARE @SQL nVarchar (100), @DB VarChar (50), @SQL1 nVarchar (100),

@user-id Varchar (50)

DECLARE DBs CURSOR FOR SELECT [name] FROM sys.databases WHERE Database_id > 4

OPEN DBs

FETCH...

The web page is only using one Service account WEBGROUP

Then web guy would have no way to determine tracey belongs to WEBGROUP or belongs to WEBGROUPADMIN.

How would they pass one...

Trying to use NT rather than SQL.

Web App uses nt domain\EMPLOYEE_service_account.

AD Group called webgroup

In sql i add the domain\EMPLOYEE_service_account.

I grant data reader on the table.

This means who ever is in...

Hi there i installed sql 2005 a month ago i also noticed all these new accounts but we use ad and have specific account i.e SQL

I remember somewhere in...

Thanks for login orphans i had one for sql 2000 was looking for one with 2005

Hey there could you tell me why you use the kerbos.

We are trying to use AD with SQL Server and all web pages uses service accounts. I will be...

Is there a way to do this for all the logins after restore. I used to have a little problem for SQL 2000 that i run after restore...but cannot...

I will try the flag.

Thanks everyone.....for your guidance and help.