anzekrpic

select mf.name, count(*)as 'Element count' from modelelementdata med
join modelmanifest mf on mf.modelid = med.modelid
	where mf.VersionBuildNo between 1000 and 3999
	group by mf.name

anzekrpic

CREATE LOGIN [<SQL_login_name, sysname, login_name> ]
    WITH PASSWORD = N'<password, sysname, Change_Password>';
 
GO
CREATE USER [<SQL_login_name, sysname, login_name> ] FOR LOGIN [<SQL_login_name, sysname, login_name> ] WITH DEFAULT_SCHEMA=[dbo]
GO
EXEC sp_addrolemember 'db_datareader', '<SQL_login_name, sysname, login_name> ';
EXEC sp_addrolemember 'db_datawriter', '<SQL_login_name, sysname, login_name> ';

anzekrpic

CREATE LOGIN [mySampleWeb]
    WITH PASSWORD = N'NePovem';

GO
CREATE USER [mySampleWeb] FOR LOGIN [mySampleWeb] WITH DEFAULT_SCHEMA=[dbo]
GO
EXEC sp_addrolemember 'db_datareader', 'mySampleWeb';
EXEC sp_addrolemember 'db_datawriter', 'mySampleWeb';