Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. USE [master]
  2. GO
  3. CREATE DATABASE [PROYECTOSPRUEBAAPP_DATABD.MDF]
  4. CONTAINMENT = NONE
  5. ON PRIMARY
  6. ( NAME = N'bd', FILENAME = N'C:UsersMC.coverDesktopPruebabd.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
  7. LOG ON
  8. ( NAME = N'bd_log', FILENAME = N'C:UsersMC.coverDesktopPrueba_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
  9. GO
  10.  
  11. SELECT *
  12. FROM sys.fn_my_permissions(NULL, 'SERVER')
  13. WHERE [permission_name] = 'ALTER ANY DATABASE';
  14. SELECT *
  15. FROM sys.fn_my_permissions('PROYECTOSPRUEBAAPP_DATABD.MDF', 'DATABASE')
  16. WHERE [permission_name] = 'ALTER';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement