• Interests: Vedic Maths

Technical Article

To retrieve Stored Procedure Parameters with Description

Use this procedure to get parameters for your stored procedure with data type,length, parameter position and also the mode of parameter (Input or Output). Can be used to populate the dynamic parameters for any procedure. Mohit NayyarMCP (.Net), MCSD, MCDBA

5 (2)

You rated this post out of 5. Change rating


924 reads

Technical Article

Get the Table Structure using a simple query

This query will solve problems related to Table structure. Using this query you can have the complete table structure for all the user tables with Table Name, Column Name, Data Type, and Null attributes of a column.You can run this script in Query Analyzer or make use of it in your front-end to give table […]

4.5 (2)

You rated this post out of 5. Change rating


4,720 reads


Penetration Testing your SQL Server, Part 1 – The Recon Mission


Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...

SQL Saturday Denver 2023–VCS Primer for the Database slides


My slides are here: VCS Primer Denver 2023 This was an overview of what...

Future Data Driven 2023 is This Week


The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...

Read the latest Blogs


upgrade evalution editon reporting services to Stanadard

By Shivrudra

Hi All, I installed reporting services evaluation edition for testing purpose, but now 180...

cost threshold for parallelism value to be set

By bobrooney.81

Hi Everyone, Why and when should be set 'cost threshold for parallelism'? We are...

Master Data - Relational or Dimensional modeling?

By river1

Dears, In my company, we have certain master data domains like customer; Vendor; Product;...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers