Aqua Data Studio 15.0.0-dev-34
Build #: 34708
Built on: 2013-Nov-05 10:05:29 AM
Database: MS SQL SERVER 2005
Step 1: Create logins test_login and test_login1
CREATE LOGIN [test_login]
WITH PASSWORD = 0x0100EC94C27A5FEF4A180E830BC36EBA522F8A9706C2B72402F7 HASHED,
SID = 0x013635C39CA78E4989A9049A8659E4FE,
DEFAULT_DATABASE = [Narendra13],
DEFAULT_LANGUAGE = [English],
CHECK_EXPIRATION = ON,
CHECK_POLICY = ON
GO
EXEC sp_addsrvrolemember N'test_login', N'sysadmin'
GO
CREATE LOGIN [test_login1]
WITH PASSWORD = 0x0100AA6C13754D5BB792991085429D5804074BA7DF9A83844F3A HASHED,
SID = 0xCE4F54DAA2173847BFC002E82EAE4A90,
DEFAULT_DATABASE = [saima],
DEFAULT_LANGUAGE = [English],
CHECK_EXPIRATION = ON,
CHECK_POLICY = ON
GO
EXEC sp_addsrvrolemember N'test_login1', N'sysadmin'
GO
Step 2:
Go to Security tree node-> Expand Logins folder-> Select multiple logins(test_login and test_login1) and Right click->
Select script object to windows as/new windows as/file as-> select create/drop option.
A new Script Create Object window opens,containing object name ,object type ,owner , database and server.
Please see attached screen shot.
In this window database and owner names are missing.
