Try the link below for some code sample on using XML with SQL Server.  Hope this helps.

http://msdn.microsoft.com/msdnmag/issues/05/06/DataPoints/default.aspx

Kind regards,

Gift Peddie

I think the standard comes with less features than the Enterprise edition, the Developer and the Enterprise are the same but you cannot deploy with the developer edition.  And you...

Try the link below for a detailed tutorial on SQL Server Using SQL Authentication in ASP.NET 2.0.   And Small Business Server 2003 comes with SQL Server 2000 for 75 concurrent users.  Hope...

SQL Server should be added to the Domain as a member server not a Domain Controller because the only users who should be using the server SQL Server is installed...

If your application is using .NET the system may be seeing Smallint as SByte type  and it is not CLS-compliant, you are asked to use int16 instead of SByte. 

Value types are...

EDIT

SQL Server is not supposed to be part of your Active directory, Microsoft knows this but leave it for you to find out if you choose to get certified or...

I am sorry in .NET you don't use OLEDB to connect to SQL Server you use ADO.NET, OLEDB is for Access and Excel.  Try the link below for a SQL...

I am assuming you also know Full Text search is dependent on Microsoft search service so you have to populate the catalog to get expected results from CONTAINS, CONTAINSTABLE, FREETEXT...

Time related programming in SQL Server can get complex because time interval is not implemented in SQL Server. But there is a starter kit with most of the code you...

The ODBC standard is old so funny things happen with Microsoft generic ODBC driver, try the links below the first to test drive a third party driver that connects to...

Try these links to create time span in SQL Server and you should get the expected result.  Hope this helps.

http://www.stanford.edu/~bsuter/sql-datecomputations.html  

http://www.novicksoftware.com/UDFofWeek/Vol1/T-SQL-UDF-Volume-1-Number-38-udf_DT_AddTime.htm  

Kind regards,

Gift Peddie

There is no ON clause in JOINS you can add ON to the FROM clause but that is old you now use the where clause and use AND operator to...

To run DTSRUN with xp_cmdshell require SQL Server Agent installed with a Service account.  Try the links below for configuration information.  Hope this helps

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_4jxo.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_8sdm.asp

Kind regards,

Gift Peddie

Try the links below to get started, I would not buy any book out now because the new System.Nullables will affect CLR stored procs so any book without that class...

If you did not write the application connecting to SQL Server it is recommended you use both Named Pipes and TCP/IP because any part of the application can call socket...