Anup Shah on WPF and Silverlight (Programming Garden): Create ASPNETDB database using aspnet_regsql tool

Anup Shah on WPF and Silverlight (Programming Garden): Create ASPNETDB database using aspnet_regsql tool: What is ASPNETDB? Microsoft has introduced a powerful default database schema in ASP.Net 2.0 as ASPNETDB.mdf database. This database fil...

Read More »

SQL SERVER QUERY Part-1 Script to find database role given to logins in all the databases.

/* Description     : Script to find database role given to logins in all the databases. Parameters    : NONE. Returns    : NA Create date : 4/May/2016 */      create table ##t2(      DBname varchar(300),      DBrole_name varchar(300),      Type_dbrole varchar(300),      Grantee varchar(300))             insert into ##t2 exec      ...

Read More »