Viewing 15 posts - 601 through 615 (of 639 total)
Thanks I will be starting next week or a dev SQL 2005 then March for production.
December 29, 2007 at 7:10 am
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...
December 28, 2007 at 10:42 am
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
...
December 28, 2007 at 8:36 am
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...
December 27, 2007 at 8:58 am
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...
October 4, 2007 at 9:24 am
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...
October 2, 2007 at 9:59 am
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...
October 1, 2007 at 10:21 am
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 >...
October 1, 2007 at 7:27 am
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...
September 30, 2007 at 8:19 am
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...
September 30, 2007 at 6:46 am
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...
September 30, 2007 at 6:31 am
Thanks for login orphans i had one for sql 2000 was looking for one with 2005
September 30, 2007 at 6:25 am
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...
September 30, 2007 at 6:19 am
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...
September 30, 2007 at 6:05 am
I will try the flag.
Thanks everyone.....for your guidance and help.
September 20, 2007 at 11:30 am
Viewing 15 posts - 601 through 615 (of 639 total)