As opc.three told, if you required to give permission for each sp, write an sp with UserName, Schema, and Permission parameters. Internally you can get the SPs under the schema...

Check the below links will help you or not.

http://blogs.msdn.com/b/bimusings/archive/2005/07/01/434659.aspx

http://vbcity.com/blogs/xtab/archive/2010/04/29/a-data-source-instance-has-not-been-supplied-for-the-data-source-error.aspx

You can use either CDC (Change Data Capture) or CT (Change Tracking) as per your requirement. Please find the following links for detailed explanation about this

http://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-(cdc)-in-sql-server-2008/

http://msdn.microsoft.com/en-us/library/cc280462.aspx

Most Welcome 🙂

Put that catalog view in a single quotes and do.

Eg. 'sys.conversation_endpoints'

Even though it is a vast subject, it is a common question in interviews. “Tell me something about SQL Server Architecture”. Do not know what he is expecting from this...

Ok. 🙁

In that article there is a sentence "It allows the user to limit the CPU and memory usage by a specific application or user. It would help in preventing...

Please check the following link for Resource Governor.

http://www.sqlservercentral.com/articles/Resource+Governor/64034/

I think, you can also try OUTPUT clause for this problem. Check the below link whether it is matching your requirement.

http://www.simple-talk.com/sql/learn-sql-server/implementing-the-output-clause-in-sql-server-2008/

One more thing...

If you are sure the first 3 names are static you can replace the select query as below. No need to hit the database to get that data.

SELECT...

use PIVOT

First right click on the stored procedure node and click refresh.

Still the sp is not there means, you have only saved the sp in a file, but you have...

If you can see the sp in the same place, right click on that sp and click execute. If it is working previously you might be chosen a different database...

Try this

----------

WITH CTE_First(Num_key, Name) AS

(

SELECT 1, Name FROM abc_test WHERE num_key = 9

UNION ALL

SELECT 2, Name FROM abc_test WHERE num_key = 7

UNION ALL

SELECT 3, Name FROM abc_test WHERE num_key =...

You have saved the procedure in a folder. But did you create the procedure in database?