Undocumented Sp & Xp

Jul 24, 2002

Does anyone know where I can get information about undocumented stored procedures and extended stored procedures? I found 'xp_dirtree' and I think I've figured out how to use this one but there are others and I'd like some insight into what they do.

Sidney

View 1 Replies


ADVERTISEMENT

Where Can I Get Undocumented Stored Procedures,Is It Safe To Use Undocumented Sp's.

Feb 28, 2008

Hi All


Undocumented SP's like 'Sp_Msforeachdb',.

What are all the USP's availble,how for it is safe to use SP's

View 6 Replies View Related

Undocumented Feature

Jan 21, 2004

Dig this....



USE Northwind
GO

CREATE TABLE ItemInformation([Description] varchar(80))
GO

INSERT INTO ItemInformation([Description])
SELECT 'CHOCOLATE CHIP‚' UNION ALL
SELECT '‚COOKIES‚' UNION ALL
SELECT '‚CROISSANTS *PLAIN*‚' UNION ALL
SELECT '‚DONUTS‚' UNION ALL
SELECT '‚DONUTS *DOZEN*‚' UNION ALL
SELECT '‚MUFFINS‚' UNION ALL
SELECT '‚BAGELS‚' UNION ALL
SELECT '‚ROLLS‚' UNION ALL
SELECT '‚CUPCAKES‚' UNION ALL
SELECT '‚CRISPIES‚' UNION ALL
SELECT '‚DANISH/SWEET ROLLS‚' UNION ALL
SELECT '‚FUDGE BROWNIES‚' UNION ALL
SELECT '‚PUFF PASTRIES/ECCLES‚' UNION ALL
SELECT '‚STICKY BUNS‚' UNION ALL
SELECT '‚TURNOVERS‚' UNION ALL
SELECT '‚BLACK & WHITE COOKIES‚' UNION ALL
SELECT '‚LINZER TARTS‚' UNION ALL
SELECT '‚SCONES/BISCUITS‚' UNION ALL
SELECT '‚SCUFFINS‚' UNION ALL
SELECT '‚SINFULL BITS‚'
GO

SELECT * FROM ItemInformation
GO

UPDATE ItemInformation
SET [Description] = REPLACE([Description],',','')
GO

SELECT [Description], LEN([Description]) FROM ItemInformation
GO

SELECT REPLACE([Description],',','')
FROM ItemInformation

SELECT REPLACE([Description],'C','')
FROM ItemInformation

SELECT CHARINDEX(',',[Description])
FROM ItemInformation
GO

DECLARE @x varchar(80)
SELECT @x = '‚COOKIES‚'
SELECT @x
SELECT REPLACE(@x,',','')
GO

DELETE FROM ItemInformation
GO

INSERT INTO ItemInformation([Description])
SELECT 'CHOCOLATE, CHIP‚' UNION ALL
SELECT 'CHOCOLATE, CHIP‚' UNION ALL
SELECT ',CHOCOLATE, CHIP‚' UNION ALL
SELECT ',CHOCOLATE, CHIP‚ ' UNION ALL
SELECT ',CHOCOLATE, CHIP‚ A' UNION ALL
SELECT ',CHOCOLATE, CHIP‚ , '
GO

SELECT REPLACE([Description],',','')
FROM ItemInformation
GO

DROP TABLE ItemInformation
GO





BIZZARO WORLD

View 14 Replies View Related

Undocumented Error Code !!

Jun 25, 1998

I found a error that is not documented when i run a long SP.
Error 3621 its not in the books
and any one help me ???
thanks

View 1 Replies View Related

Undocumented System Procedures

May 21, 2015

I am trying to determine which are undocumented system procedures used to satisfy our company's security audit. Well, the nature of undocumented system procedures is it's undocumented. Hence, it's hard to find.

So, is there a way I can get a list of SQL Server documented system procedures?

View 10 Replies View Related

Undocumented System Stored Procedures

May 15, 2007

I know there are a lot of undocumented system stored procedures such as xp_ntsec_enumdomains, xp_instance_regread etc, that exist on SQL Server.



Does anyone know of any good websites that contain descriptions of what these stored procedures do? In particular I know that a default installation of SQL Server 2000 leaves permission to execute many of these granted to public and I am interested in finding out what the implications of each one of these are? I have tried Googling this topic but there doesn't seem to me much or there (or what is there is in Chinese and I don't really want to click on to!)



Once again thanks for the help.

View 3 Replies View Related

What Does The (seemingly Undocumented) FileNameRetrieval Property Of ForEachLoop Container Do?

Oct 4, 2007

Just wondering.

View 1 Replies View Related

Strange Situation With Windows Authentication And Undocumented Function GET_SID

Dec 21, 2004

SQL Server 2000
Windows 2000 Advanced Server

We recently moved our servers from one domain to another. Now, we can't grant Windows users access to any databases. We CAN create the user IDs successfully via Enterprise Manager, and get a corresponding row in MASTER..SYSXLOGINS, but can't click on the Database Access tab in the SQL Server Login Properties dialog and grant accesss to any databases. When we try to do so, we get error 15401, "Windows user or group xxx not found". The underlying call is to MASTER..SP_GRANTDBACCESS, and running that via Query Analyzer returns the same error (naturally)

Looking through the code of SP_GRANTDBACCESS, I've determined that what is failing is a call to the undocumented TSQL function GET_SID. This proc takes two parameters, the first is either G<nt group name> or U<nt user name> and the second is NULL in the call in SP_GRANTDBACCESS. If I execute

SELECT GET_SID('U<valid user>', NULL)

it returns NULL, however, if I run

SELECT SUSER_SID(<valid user>)

then I get the Windows SID of whatever valid user name I supply.

We have 3 servers in question, namely production, development and test. We noticed the problem on production. Curiously enough, development and test worked fine.

NOW THE PLOT THICKENS. If I run this query on the dev box....

SELECT SUSER_SID(<id>), GET_SID('U<id>',NULL)

...the first function returned the SID, BUT THE SECOND FUNCTION DID NOT!!! How could that be? Clearly GET_SID was working inside of SP_GRANTDBACCESS, but not as a discrete call. So I went into the master database and added code to print out the SID returned by GET_SID to the proc. Lo and behold, SP_GRANTDBACCESS promptly failed with a 15401 error. It continues to get 15401s now, even after I returned it to the original code. What gives? Now my dev box has the same error production has, and all I did was recompile SP_GRANTDBACCESS a couple of times. FWIW, I did *not* ever make any changes to SP_GRANTDBACCESS on production.

Why doesn't GET_SID() work outside of SP_GRANTDBACCESS?
Why did recompiling SP_GRANTDBACCESS break it permanently?

It almost seems like the query compiler can't correctly link a call to GET_SID to the correct function in some DLL, except I thought that the compiled code didn't survive a restart, and all TSQL procs were recompiled the first time they were called after a restart. If that's the case, then the compiler is - or at least was - producing a functioning compiled version of SP_GRANTDBACCESS after every restart.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved