text: USE Test_Logins;
  USE Test_Logins
  SELECT SUSER_NAME() LoginName
  , USER_NAME() UserName
  , IS_SRVROLEMEMBER('sysadmin') IsSysAdmin
  , IS_ROLEMEMBER('db_owner') IsDBOwner 
  
  
  select 'Before', count(*) from PublicTable;
   
  
  declare @sql nvarchar(max) = N'Delete top (100) PublicTable;';
  exec  sys.sp_executesql @sql;
  select 'After Delete', count(*) from PublicTable;
  
  SET @sql  = N'INSERT PublicTable values(10000, ''PublicTable''),(10001, ''PublicTable''),(10002, ''PublicTable'');'
  exec   Sys.sp_executesql @sql
  select 'After Insert', count(*) from PublicTable;
  