Thanks a bunch for replying quickly. I have made sure the login executing the ps script is sysadmin and has access to the directories. This is what I see

Name ...

Paul - This might sound daft, can you tell me if I should populate the xml file beforehand? I tried executing the PowerShell script to log ship a database, but...

Do you mean to say you need something like this? Try executing this piece (in text mode) on your database, it will generate create user scripts only for those users...

Hello Steve,

here's an example (probably sketched with too much detail :-))

--Create a Login and a corresponding user

USE master

GO

CREATE LOGIN aG WITH PASSWORD = 'somepwd',CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF

USE...

I'm aware this is an old post, But I feel there may be a small error in the schema script section.

that section will result in an out put something like...

http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/09/15/policy-based-management-and-the-unknown-loginmode.aspx

http://sqlblog.com/blogs/tibor_karaszi/archive/2010/09/15/watch-out-for-old-stuff.aspx

(I guess your question was already answered on MSDN forums, I thought it would be cool to share them with SSC readers! 🙂 )

Cheers!!