Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 12244
Home > Codes > Sql Server

Sql Server Codes (1211) - Page 9

Code snippets submitted by registered members. You can also post a code snippet or tips and win monthly prizes as well as gain community credit points.

1211 records found.
 
Post
how to know the users who has CREATE TABLE permission in the database
Posted by Professionaluser on 3/21/2016 under Sql Server category | Views: 1151
List all permission of a user in current database
Posted by Professionaluser on 3/21/2016 under Sql Server category | Views: 1195
List out the which user has which permissions on specific table
Posted by Professionaluser on 3/21/2016 under Sql Server category | Views: 1256
Revert back specific permission/privileges of a user
Posted by Professionaluser on 3/21/2016 under Sql Server category | Views: 1187
Enable FILESTREAM Support in SQL Server
Posted by Professionaluser on 3/22/2016 under Sql Server category | Views: 1243
create User Defined Type table
Posted by Professionaluser on 3/22/2016 under Sql Server category | Views: 1297
Pass tables to Stored Procedures as input
Posted by Professionaluser on 3/22/2016 under Sql Server category | Views: 1166
    • calling/executing a Stored Procedure which has UDT as input
    Posted by Professionaluser on 3/22/2016 under Sql Server category | Views: 1287
    grant a user execute and select privileges on specific schema to an user in SQL Server
    Posted by Professionaluser on 3/22/2016 under Sql Server category | Views: 1130
    add a file group with FILESTREAM support to a database
    Posted by Professionaluser on 3/22/2016 under Sql Server category | Views: 1220
    list out the columns and tables which has FILESTREAM option
    Posted by Professionaluser on 3/22/2016 under Sql Server category | Views: 1359
    Listing All stored procedures which got MODIFIED in last 7 days
    Posted by Professionaluser on 3/25/2016 under Sql Server category | Views: 1225
    List out All SPs who has been CREATED in last 7 days
    Posted by Professionaluser on 3/25/2016 under Sql Server category | Views: 1198
    Trace DB changes in SQL Server
    Posted by Professionaluser on 3/25/2016 under Sql Server category | Views: 1482
    List the User-Defined Functions which got modified in last 7 days
    Posted by Professionaluser on 3/25/2016 under Sql Server category | Views: 1379
    finding blocking session/query details
    Posted by Professionaluser on 3/28/2016 under Sql Server category | Views: 1471
    filtering sp_who2 results
    Posted by Professionaluser on 3/28/2016 under Sql Server category | Views: 1864
    storing/inserting hierarchical type data in SQL Server
    Posted by Professionaluser on 3/28/2016 under Sql Server category | Views: 1378
    Add/insert managers under CEO in an Employees table by using HIRARCHYID column
    Posted by Professionaluser on 3/28/2016 under Sql Server category | Views: 1494
    Dollar Sign at the end of table name causes problem in SQL CMD
    Posted by Professionaluser on 3/29/2016 under Sql Server category | Views: 2087