SQL Server Extended Procedure- usage of Built-in

http://www.devarticles.com/... Authors gives good brief on 10 cool features in SQL Server repository. xp_fileexist filename [, OUTPUT]exec master..xp_fileexist 'c:\test.file' xp_regread root_key, path_key, key_valuemaster..xp_regread 'HKEY_LOCAL_MACHINE', 'SYSTEM\Setup', 'SystemPartition' exec master..xp_repl_encrypt @cardNumber1 output exec master..xp_dirtree 'c:\mydir'set @xml = '' exec sp_xml_preparedocument @id output, @xmlselect ......

Posted On Thursday, September 9, 2004 3:41 PM

SQL Server Extended Procedure- usage of Built-in

http://www.devarticles.com/... Authors gives good brief on 10 cool features in SQL Server repository. xp_fileexist filename [, <file_exists INT> OUTPUT]exec master..xp_fileexist 'c:\test.file' xp_regread root_key, path_key, key_valuemaster..xp_regread 'HKEY_LOCAL_MACHINE', 'SYSTEM\Setup', 'SystemPartition' exec master..xp_repl_encrypt @cardNumber1 output exec master..xp_dirtree 'c:\mydir'set @xml = '<people><person name="John ......

Posted On Thursday, September 9, 2004 3:40 PM