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 ......
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 ......
A Survey of Microsoft SQL Server 2000 XML Features from Andrew Conrad
This describes latest features on XML with SQL Server with abstract example - Worth of reading
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexxml/html/xml03172004.asp
Find these cool BizTalk Server Installation 1) Windows 2000 Server / Advanced / Professional 2) Service pack 1 is mandatory 3) Must add Windows 2000 user account to the Administrators group before you install any software. 4) Message Queuing Service is mandatory. 5) Internet Information Service (IIS) is mandatory. 6) NTFS partition is recommended. 7) To avoid problems accessing and saving specifications to the BizTalk Server 2000 repository, you must turn off the Enable Authoring option in Internet ......
Data Reader: Forward-only data read Equivalent to: Recordset's CursorType = adOpenForwardOnly, LockType = adLockReadOnly (often referred to as a "fire-hose" cursor) DataReader Four Execute Methods through Command object: ExecuteReader - Simply executes the SQL query against the database, using the Read() method to traverse through data, as illustrated below ExecuteNonQuery - Used whenever you work with SQL stored procedures with parameters, as illustrated in the Stored Procedures section below ExecuteScalar ......
Using C#: using System.Data.SqlClient;...Sq... oSQLConn = new SqlConnection();oSQLConn.Co... = "Data Source=(local);" + "Initial Catalog=mySQLServerDBName;" + "Integrated Security=SSPI";oSQLConn.Ope... Using VB.NET: Imports System.Data.SqlClient...Dim oSQLConn As SqlConnection = New SqlConnection()oSQLConn.Con... = "Data Source=(local);" & _ "Initial Catalog=mySQLServerDBName;" & _ "Integrated Security=SSPI"oSQLConn.Open() If connection to a remote server (via ......
http://www.lumigent.com/go/... Find Data-Recovery and Best Practices white paper from By Stephen Wynkoop, Microsoft SQL Server MVP(Founder The SQL Server Worldwide User’s Group) Tips on Triggers Encrypting Trigger DefinitionsIf you want to ensure that other users cannot view the trigger definition, you can use the WITH ENCRYPTION clause. The trigger definition is then stored in an unreadable form.Once encrypted, the definition of the trigger cannot be decrypted and cannot be viewed by anyone, ......
SQL Server 2000's Coolest Features Just when you think you have a handle on SQL Server 7.0, Microsoft ships a new SQL Server release. SQL Server 2000 might skip 1,993 release numbers, but you won't find the same degree of difference between SQL Server 2000 and 7.0 as you found between SQL Server 7.0 and 6.5. Even so, this latest release is full of new functionality. Here are seven of my favorite new SQL Server 2000 features. 7. Integrated XML Support XML support is key to Microsoft's push to Web-enable ......