I don't think it is a good idea to run SQL Server without service packs because service packs fix existing problems with the product.  I have opened service pack 3...

I am sorry I forgot there is a .NET method ReadXML you can use.  Try the link below for the FCL(framework class library) 1.1 ReadXML method, in the link check...

Try these links to get started and also check out more links at the end of the first link.  Hope this helps.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsql/ac_openxml_759d.asp

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

Kind regards,

Gift Peddie

There is a fixed table position for OUTER JOIN in ANSI SQL, the text below is from chapter five of SQL Performance Tuning By Peter Gulutzan and Trudy Pelzer published 2003. ...

I think you should create an Update Trigger and use sp_executesql but remove the cursor and recursive part of the Trigger.  Try the link below for Update Trigger code with...

Some restrictions apply when creating Unique index on multiple columns, try the links below for more info.  Hope this helps.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_05_8185.asp

http://www.aspfaq.com/show.asp?id=2509

Kind regards,

Gift Peddie

I am not sure about infinite loop but the performance part is covered by Erland on his web page click on Dynamic SQL for more info.  Hope this helps.

http://www.sommarskog.se/arrays-in-sql.html...

Right click in the object browser  in the Query Analyzer to generate the create table statement, it includes the collation.  The error could be because you are doing column level...

The known problems with Outer Joins in SQL Server before version 2000 giving just wrong answers is covered in SQL Performance Tuning by Peter Gulutzan, Trudy Pelzer.  And known problems...

The unexpected results of OUTER JOIN is covered by ANSI SQL and Peter Gultuzan, unexpected results of VIEWS was covered by Joe Celko and unexpected results of ISNULL is covered...

I think you need sp_help.  Run a search for sp_help in the BOL (books online).  Hope this helps.

sp_help [ [ @objname = ] name ]

Kind regards,

Gift Peddie

Quick and easy change your datatype to SmallDatetime it has less resolution so you will not get seconds.  Try the link below for more info.  Hope this helps.

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

Kind...

In SQL Server it is easier right click on the table in the object browser in Query Analyzer then click on script object to new window then select create and you...

Try the thread below for links to configure SQL Server Agent with the correct permissions to run xp_cmdshell.  Hope this helps.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=223910#bm224009

Kind regards,

Gift Peddie

The following is from the BOL (books online) about the ISNULL function and yes this is a remark but there are known issues with that function.  The point I was...