Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 2429
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: 1136
List all permission of a user in current database
Posted by Professionaluser on 3/21/2016 under Sql Server category | Views: 1186
List out the which user has which permissions on specific table
Posted by Professionaluser on 3/21/2016 under Sql Server category | Views: 1234
Revert back specific permission/privileges of a user
Posted by Professionaluser on 3/21/2016 under Sql Server category | Views: 1159
Enable FILESTREAM Support in SQL Server
Posted by Professionaluser on 3/22/2016 under Sql Server category | Views: 1215
create User Defined Type table
Posted by Professionaluser on 3/22/2016 under Sql Server category | Views: 1278
Pass tables to Stored Procedures as input
Posted by Professionaluser on 3/22/2016 under Sql Server category | Views: 1131
    • calling/executing a Stored Procedure which has UDT as input
    Posted by Professionaluser on 3/22/2016 under Sql Server category | Views: 1263
    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: 1106
    add a file group with FILESTREAM support to a database
    Posted by Professionaluser on 3/22/2016 under Sql Server category | Views: 1200
    list out the columns and tables which has FILESTREAM option
    Posted by Professionaluser on 3/22/2016 under Sql Server category | Views: 1340
    Listing All stored procedures which got MODIFIED in last 7 days
    Posted by Professionaluser on 3/25/2016 under Sql Server category | Views: 1214
    List out All SPs who has been CREATED in last 7 days
    Posted by Professionaluser on 3/25/2016 under Sql Server category | Views: 1188
    Trace DB changes in SQL Server
    Posted by Professionaluser on 3/25/2016 under Sql Server category | Views: 1460
    List the User-Defined Functions which got modified in last 7 days
    Posted by Professionaluser on 3/25/2016 under Sql Server category | Views: 1371
    finding blocking session/query details
    Posted by Professionaluser on 3/28/2016 under Sql Server category | Views: 1461
    filtering sp_who2 results
    Posted by Professionaluser on 3/28/2016 under Sql Server category | Views: 1836
    storing/inserting hierarchical type data in SQL Server
    Posted by Professionaluser on 3/28/2016 under Sql Server category | Views: 1359
    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: 1483
    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: 2044