Viewing 15 posts - 7,996 through 8,010 (of 9,253 total)
then add the shared HDD to both VM's and share the SCSI bus on each VM accordingly
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
May 4, 2010 at 6:06 am
Are both VM's on the same host?
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)...
May 1, 2010 at 4:43 pm
under what context does your sql server service run user account or local system?
May 1, 2010 at 11:41 am
hey, you're welcome!
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...
May 1, 2010 at 8:02 am
ColeTrain (5/1/2010)
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?
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!
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 [' +...
April 30, 2010 at 1:45 pm
Ratheesh.K.Nair (4/30/2010)
no use perry ..its still the same.
sorry, yes on the 2008 sql instance builtin admins group is no longer provisioned into sql server, but on the sql 2005 instance...
April 30, 2010 at 1:36 pm
Brandie Tarvin (4/30/2010)
manoj2001 (7/9/2009)
enterprise manager and create and register new instance by giving name...
April 30, 2010 at 1:32 pm
AppemanKotze (4/30/2010)
I have a different problem. When i run the installer again i never get an option for creating a new instance. (i'm installing entaprise edition)
what do you see when...
April 30, 2010 at 4:08 am
Viewing 15 posts - 7,996 through 8,010 (of 9,253 total)