Grant Permission to Specific objects(e.g. SP's)
Grant permissions to specific objects in Database using dynamic SQL.
2008-08-01 (first published: 2008-06-08)
2,635 reads
Scripts
2008-08-01
842 reads
Quick table finder
This little script will search for all matching tables on the SQL Server instance
2008-07-30 (first published: 2007-10-15)
751 reads
2008-07-29 (first published: 2008-06-08)
1,292 reads
Find the row with the most data
This script is a quick throw together that tells you which rows in a table have the most data
2008-07-28 (first published: 2008-06-10)
845 reads
2008-07-23
484 reads
2008-07-23 (first published: 2008-06-05)
1,233 reads
2008-07-20
2,008 reads
2008-07-20
1,631 reads
2008-07-17
359 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers