Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 2196
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: 1187
List all permission of a user in current database
Posted by Professionaluser on 3/21/2016 under Sql Server category | Views: 1214
List out the which user has which permissions on specific table
Posted by Professionaluser on 3/21/2016 under Sql Server category | Views: 1271
Revert back specific permission/privileges of a user
Posted by Professionaluser on 3/21/2016 under Sql Server category | Views: 1199
Enable FILESTREAM Support in SQL Server
Posted by Professionaluser on 3/22/2016 under Sql Server category | Views: 1266
create User Defined Type table
Posted by Professionaluser on 3/22/2016 under Sql Server category | Views: 1308
Pass tables to Stored Procedures as input
Posted by Professionaluser on 3/22/2016 under Sql Server category | Views: 1176
    • calling/executing a Stored Procedure which has UDT as input
    Posted by Professionaluser on 3/22/2016 under Sql Server category | Views: 1300
    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: 1141
    add a file group with FILESTREAM support to a database
    Posted by Professionaluser on 3/22/2016 under Sql Server category | Views: 1240
    list out the columns and tables which has FILESTREAM option
    Posted by Professionaluser on 3/22/2016 under Sql Server category | Views: 1379
    Listing All stored procedures which got MODIFIED in last 7 days
    Posted by Professionaluser on 3/25/2016 under Sql Server category | Views: 1244
    List out All SPs who has been CREATED in last 7 days
    Posted by Professionaluser on 3/25/2016 under Sql Server category | Views: 1212
    Trace DB changes in SQL Server
    Posted by Professionaluser on 3/25/2016 under Sql Server category | Views: 1500
    List the User-Defined Functions which got modified in last 7 days
    Posted by Professionaluser on 3/25/2016 under Sql Server category | Views: 1403
    finding blocking session/query details
    Posted by Professionaluser on 3/28/2016 under Sql Server category | Views: 1490
    filtering sp_who2 results
    Posted by Professionaluser on 3/28/2016 under Sql Server category | Views: 1885
    storing/inserting hierarchical type data in SQL Server
    Posted by Professionaluser on 3/28/2016 under Sql Server category | Views: 1398
    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: 1514
    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: 2113