then add the shared HDD to both VM's and share the SCSI bus on each VM accordingly

bad idea, consult your domain administrator and see if they are able to help you

😉

Are both VM's on the same host?

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)...

under what context does your sql server service run user account or local system?

hey, you're welcome!

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...

ColeTrain (5/1/2010)

---

Hello, I'm having issues creating two stored procs. I would like to create one that creates and resets the password for a defined type of user on the system....

if you're referring to SQL server resources then no, set up should do all that for you?

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!

don't forget to include the schema and use

SELECT'GRANT SELECT ON [' +...

sorry, yes on the 2008 sql instance builtin admins group is no longer provisioned into sql server, but on the sql 2005 instance...

Brandie Tarvin (4/30/2010)

---

manoj2001 (7/9/2009)

---

But if i am not wrong we could add instances in SQL Server 2000, by right clicking

enterprise manager and create and register new instance by giving name...

what do you see when...