Technical Article

Getting Information about Database Objects

It is sometimes necessary to have information regarding the database objects like stored procedures and triggers for e.g. we need to get information about a stored procedure like what paramters it has and so on.The sp_help system stored procedure comes in handy.What this store procedure does is that it returns result set. The result will […]

2003-08-07

174 reads

Blogs

Azure Cosmos DB – HTAP using Azure Synapse Link

By

I haven’t done much blogging in the last 6 months. My last article was...

Azure Cosmos DB – HTAP using Synapse Analytics

By

I haven’t done much blogging in the last 6 months. My last article was...

Power BI Meets Programmability – TOM, XMLA, and C#

By

For anyone who read the title of this and immediately thought, “Oh no, I...

Read the latest Blogs

Forums

AlwaysON on one Node

By Arsh

Hi friends, Is it possible to configure ALwaysON with two instances on one node...

SQL Server Single Instance FCI - Failover Error

By Shivkumar

I have the following setup. 3 Node WSFC Cluster hosted on EC2 in three...

Disabling all access to the server

By Alex John

Hello everyone! We have a small group of users (4) using MS Access 2000...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers