Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-08 Thread Dominique Louis
REATE* commands Dominique -Original Message- From: Farooq Mahmud (Hotmail) [mailto:farooq...@hotmail.com] Sent: 07 October 2009 22:44 To: 'General discussion for Windows Installer XML toolset.' Subject: Re: [WiX-users] Creating SQLServer Users/Logins Dominique, You should re

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-07 Thread Thomas Due
ahmud (Hotmail) [mailto:farooq...@hotmail.com] Sent: 7. oktober 2009 23:44 To: 'General discussion for Windows Installer XML toolset.' Subject: Re: [WiX-users] Creating SQLServer Users/Logins Dominique, You should really use the following in SQL Server 2008 to avoid additional rework o

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-07 Thread Michael Osmond
Farooq Thanks for that Michael From: Farooq Mahmud (Hotmail) [farooq...@hotmail.com] Sent: Thursday, 8 October 2009 7:44 AM To: 'General discussion for Windows Installer XML toolset.' Subject: Re: [WiX-users] Creating SQLServer Us

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-07 Thread Farooq Mahmud (Hotmail)
-farooq -Original Message- From: Michael Osmond [mailto:mosm...@baytech.com.au] Sent: Wednesday, October 07, 2009 1:01 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQLServer Users/Logins Dominique I think your right that the SPs ar

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-07 Thread Michael Osmond
Installer XML toolset. Subject: Re: [WiX-users] Creating SQLServer Users/Logins Thanks for sharing this with us. I think it may just be what I'm looking for. Which stored procs are not in SQL2008? From what I can tell they are still there, but have been marked for deprecation in future ver

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-07 Thread Dominique Louis
smond [mailto:mosm...@baytech.com.au] Sent: 07 October 2009 07:11 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQLServer Users/Logins Here's an example of how I create the user login for a database depending if the database is on the same server

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-07 Thread Thomas Due
Cool, thanks. /Thomas -Original Message- From: Michael Osmond [mailto:mosm...@baytech.com.au] Sent: 7. oktober 2009 08:11 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQLServer Users/Logins Here's an example of how I create the

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-06 Thread Michael Osmond
- SQL Scripts go here --- -Original Message- From: Thomas Due [mailto:thomas@scanvaegt.dk] Sent: Wednesday, 7 October 2009 4:04 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQLServer Users/Logins This one triggered me: >&g

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-06 Thread Thomas Due
on, or update. TYI /Thomas -Original Message- From: Michael Osmond [mailto:mosm...@baytech.com.au] Sent: 6. oktober 2009 23:32 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQLServer Users/Logins Louis You need to look at SqlDa

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-06 Thread Michael Osmond
[mailto:dominique.lo...@amxeurope.com] Sent: Wednesday, 7 October 2009 1:42 AM To: General discussion for Windows Installer XML toolset. Subject: [WiX-users] Creating SQLServer Users/Logins Hi all, I'm working on a script that attaches our database to an instance of SQLServer. It then creates a vi

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-06 Thread Blair
identify which group you need to target. -Original Message- From: Dominique Louis [mailto:dominique.lo...@amxeurope.com] Sent: Tuesday, October 06, 2009 8:42 AM To: General discussion for Windows Installer XML toolset. Subject: [WiX-users] Creating SQLServer Users/Logins Hi all, I&#

[WiX-users] Creating SQLServer Users/Logins....

2009-10-06 Thread Dominique Louis
Hi all, I'm working on a script that attaches our database to an instance of SQLServer. It then creates a virtual directory ( not under c:\Inetpub ) in IIS ( 6 or 7 ) and correctly sets the appropriate folder permissions so that the ASP.NET v2.x, can be viewed across the network. This all seems t