Viewing 15 posts - 7,921 through 7,935 (of 9,244 total)
Windows 2003 or Windows 2008 cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2010 at 1:15 pm
then group them and create roles for each group of users
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2010 at 9:14 am
so are you saying that each of the 100 users needs entirely different permissions?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2010 at 4:19 am
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2010 at 1:49 am
Ratheesh.K.Nair (5/25/2010)
Thanks a ton PerryWhat if we have 100+ users?
I need to get the same of each and every user in a database.
I would create a database role and put...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2010 at 1:41 am
I think Jeff's expo pretty much explains it in laymans terms as well as you possibly can!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2010 at 1:36 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 25, 2010 at 11:13 am
saghbash (5/24/2010)
tassFULL{CF7B9AF2-6610-4412-A8CD-D01B04A895EE}3ISVS-SQL\TASStassFULL{CF7B9AF2-6610-4412-A8CD-D01B04A895EE}3ISVS-SQL\TASS
tassFULL{13688B9A-585F-41FF-A598-B9FDF4483108}3ISVS-SQL\TASS
tassFULL{13688B9A-585F-41FF-A598-B9FDF4483108}3ISVS-SQL\TASS
Hi check the sys.backup_devices table for these and get the physical filenames.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 25, 2010 at 10:47 am
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 25, 2010 at 10:36 am
slightly confusing, so is the question about size or throughput?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 25, 2010 at 10:31 am
Truncate will also reset seed values where delete won't
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 25, 2010 at 10:29 am
The document will differ based on your host set up. You should be following the section that installs the SQL Server 2008 failover cluster.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 25, 2010 at 3:38 am
Raju The Leader (5/24/2010)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 24, 2010 at 10:50 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 22, 2010 at 9:59 am
your welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 22, 2010 at 2:59 am
Viewing 15 posts - 7,921 through 7,935 (of 9,244 total)