Advertisement
ghx8

Untitled

Oct 21st, 2018
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.49 KB | None | 0 0
  1. USE [master]
  2. CREATE DATABASE [btg0dev]
  3. GO
  4. CREATE LOGIN [btg0dev] WITH PASSWORD=N'tg0dev', DEFAULT_DATABASE=[btg0dev], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
  5. GO
  6. USE [btg0dev]
  7. EXEC sp_changedbowner [btg0dev]
  8.  
  9.  
  10. USE [master]
  11. CREATE DATABASE [btg1prod]
  12. GO
  13. CREATE LOGIN [btg1prod] WITH PASSWORD=N'tg1prod', DEFAULT_DATABASE=[btg1prod], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
  14. GO
  15. USE [btg1prod]
  16. EXEC sp_changedbowner [btg1prod]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement