Grant EXECUTE permission to users

This procedure will assist in granting execute rights to a database user to all the stored procedures in a database The parameters to this procedure are the databasename and the username to whom EXECUTE rights need to be given to The assumption here is that the user already has access rights to the database mentioned […]

2005-05-05 (first published: )

201 reads

Blogs

Sorting in Stored Procedures – Food for Thought

By

We know that sorting can be one of the most expensive things in an...

Trace Query in Extended Events

By

The ability to quickly and easily trace a query is important to database professionals....

Using Erik Darling’s sp_pressure_detector to resolve CPU issues

By

Last Friday I spent my lunch break going through some links I had marked...

Read the latest Blogs

Forums

How to import Excel with XML

By itmasterw 60042

Hi, I have an Excel sheet that I have to import into SQL Server....

Recursive CTE - Batches

By koti.raavi

Hi Folks I'm trying to group rows into batch and adding batch to query...

XQuery - Use column value to display correct node

By Norty303

Hi All First time with XQuery and despite trying to read as many guides...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers