Monday, April 28, 2008

adding extended procedure

USE master
EXEC sp_addextendedproc xp_ndo_enumusergroups, 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xp_ndo.dll'
GO
GRANT EXECUTE ON [xp_ndo_enumusergroups] TO PUBLIC

GO

USE master

EXEC sp_addextendedproc xp_ndo_enumusersids, 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xp_ndo.dll'

GO GRANT EXECUTE ON [xp_ndo_enumusersids] TO PUBLIC

GO

Monday, April 7, 2008

Updatiing my knowledge

After some stagnation point in career I pursued my MCDBA which gave lot of Boost.

Some I am baffled as to how should I prospect my future learning and where I should divert it.

as there are so many glittering opportunities when it come to DBMS. like DB2 and Oracle.

But my recent endeavor getting my greater attention and it is capabilities are getting me more and more into it.

Hence I have decided to write my leanings over here which will be largely used for reference in one place.

I am also planning to take up to 70445 and 70446 to get MCITS in Business Intelligence