Windows 2003 or Windows 2008 cluster?

then group them and create roles for each group of users

so are you saying that each of the 100 users needs entirely different permissions?

Dude Hamidi

The document is designed to help someone set up a test system from scratch. Your system is already configured so use your own ip addresses, etc.

hamidi 97216 (5/26/2010)

---

in...

I would create a database role and put...

I think Jeff's expo pretty much explains it in laymans terms as well as you possibly can!

Hi

try

USE yourdb

--get securables permissions assigned

SELECT

CONVERT(NVARCHAR(10), state_desc) COLLATE Latin1_General_CI_AS + ' ' +

CONVERT(NVARCHAR(10), permission_name) COLLATE Latin1_General_CI_AS +

' ON [' + sch.name + '].[' + obj.name + '] TO...

Hi check the sys.backup_devices table for these and get the physical filenames.

to add to Lowell's entry, you can also launch the account provisioning immediately after installing the SQL Server service pack (click the check box before clicking finish)

slightly confusing, so is the question about size or throughput?

Truncate will also reset seed values where delete won't

The document will differ based on your host set up. You should be following the section that installs the SQL Server 2008 failover cluster.

Raju The Leader (5/24/2010)

---

RESTORE DATABASE UK

FROM DISK = '\\SQLSERVER\Backup\Newfull.bak'

WITH REPLACE,

MOVE 'LIST_New' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\UK.mdf',

MOVE 'LIST_Log' TO

'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\UK_log.mdf'

WHEN I AM EXECUTING THIS COMMAND I AM GETTING...

the only way to upgrade your sql 2000 system databases to sql 2005 is to carry out in place upgrade on the instance.

If you want a side by side...

your welcome