Viewing 15 posts - 7,981 through 7,995 (of 9,241 total)
Gianluca Sartori (5/5/2010)
Basically, you just have to move the indexes.
Clustered!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2010 at 10:30 am
This is a Windows 2003 cluster and so will support ESX shared HDD's \SCSI bus!
The OP barely has the skills to add a shared virtual HDD let alone deploy a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 5, 2010 at 3:09 pm
The virtual disk you are sharing needs to be attached to both VM's. Create a single HDD on each VM and use SCSI 0 as the controller, this will be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 5, 2010 at 10:08 am
then add the shared HDD to both VM's and share the SCSI bus on each VM accordingly
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 4, 2010 at 6:07 am
rjoseph (5/4/2010)
I went ahead and gave the object domain admins access:
bad idea, consult your domain administrator and see if they are able to help you
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 4, 2010 at 6:06 am
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 3, 2010 at 8:09 am
Are both VM's on the same host?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 3, 2010 at 8:08 am
Bryan
the script that George mentions is probably the best way to generate create login scripts.
Your script has NULLs because the script is pulling Windows logins (which have no password)...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2010 at 4:43 pm
under what context does your sql server service run user account or local system?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2010 at 11:41 am
hey, you're welcome!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2010 at 10:17 am
to rename a files logical name you need to use the following
Get the logical names for your chosen database using
select f.name from sys.databases d
inner join sys.master_files f on d.database_id...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2010 at 8:02 am
ColeTrain (5/1/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2010 at 5:24 am
if you're referring to SQL server resources then no, set up should do all that for you?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2010 at 5:00 am
check the event logs and post back the error message produced when trying to start the service. Most likely the log is corrupt so will need restoring or resetting!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2010 at 4:58 am
Maninder S. (4/30/2010)
you can even do something like this:SELECT 'GRANT SELECT ON '+quotename(table_name)+' to '+'Maninder' FROM Information_Schema.Tables
WHERE Table_Type='BASE TABLE'
don't forget to include the schema and use
SELECT'GRANT SELECT ON [' +...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2010 at 1:45 pm
Viewing 15 posts - 7,981 through 7,995 (of 9,241 total)