Useful Stored procedures in SQL Server Part 1 (dotnetvj.com)

submitted by KadiyalavjKadiyalavj(580) 3 years ago

There are several predefined stored procedures are available in SQL Server which we are using in our day-to-day life to resolve some of the issues like below. 1) I want to see the all columns of the tables. 2) I want to see who are all logged into Database. 3) I want to see the Constraint information. 4) I want to see all the indexes which are created on a table. 5) I want to rename the objects etc.

add a comment |category: |Views: 15

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
Comments:

No comments so far

information Login or create an account to comment on this story