Extended Stored Procedures

public access to extended SP's

• by Mani Singh

• SQLServerCentral.com

• T-SQL

• Script

check public access to extended stored procedures

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

Log in or register to rate

You rated this post out of 5. Change rating

2008-08-08 (first published: 2008-06-16)

918 reads

• Discuss

Create a SQL Server Data Dictionary in Seconds using Extended Properties

• by Additional Articles

• MSSQLTips.com

• Extended Stored Procedures

• Article

I need a way to create a data dictionary that will stay up to date. I make many changes to the database and I spend more time trying to keep the documentation updated than doing database administration.

2008-05-27

6,370 reads

Using xp_ReadErrorLog in SQL Server 2005

• by Additional Articles

• SQLTeam.com

• SQL Server 2005

• Article

I would like to share some interesting parameters I found for the undocumented extended stored procedure xp_ReadErrorLog. In doing some testing with this extended stored procedure I found four very interesting parameters. Adding to some of the articles already on the web that discuss undocumented stored procedures, in this article I will explain my testing, use and some examples of the procedure.

2008-05-21

3,165 reads

RE: Thanks for taking the test!

• by mimorr

• SQLServerCentral.com

• Reply

I liked the test...I'm disappointed in what I don't know...but I keep learning everyday. ON the question 14 about changing your SQL Server login's password, I chose the wrong answer because there wasn't a (') after MYLogin and so I figured it wasn't the correct answer. Otherwise, Thanks and keep them coming!

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-29

1 reads

RE: auto grow

• by Jeff Weisbecker

• SQLTeam.com

• Reply

E-Mail me... I have a solution in place that monitors file growth and alerts me prior to it happening. Jeff

2003-05-28

RE: CASE with Numbers in a VARCHAR field...

• by Ian-Scarlett

• MSSQLTips.com

• Reply

SQL Server has to decide what the data type of your [Production Ratio] column should be. To do this, it looks at all the possible data types in your case statement, and chooses one according to a precedence list. VARCHAR comes right near the bottom of the list, so SQL Server chose DECIMAL. There is […]

2003-05-21