Thanks.  We just installed it and I was looking for it under Management or some other folder and couldn't find it.  I'm going to go look again.

I had just made a career move from data entry to networking and installed networks for about a year and a half.  I got tired of travelling and a position...

I just learned that the service must be installed first before I will be able to find it.  I am not amused.

Sorry for being so grumpy, not my day I...

Well, I just found a list of non supported XQuery features at http://msdn.microsoft.com/SQL/default.aspx?pull=/library/en-us/dnsql90/html/sql2k5_xqueryintro.asp#sql2k5_xqueryintro_topic11

And the ones I mentioned are on the list.

John Jakob:

Thanks for responding to my inquiry.  Please forgive me for not replying sooner.  I think I found the answer soon after I posted the question and that launched me...

Ok.  Is there any tutorial that shows creating an XML schema and then using the various commands available in SQL Server 2005 to insert data into XML columns bound to...

Thanks!  When I put that site into my browser I found that I had already been to the site and had started the tutorial, however I didn't finish it.  This...

I found this code at the end of a sample for creating XML Schema's.  I kept getting the same result when I executed and the one item...

I will look at that again.  The last time I looked at it and tried to use it, it seemed to require a schema name to work properly.

Good Article.  I really so heavily on everything provided by SQLServerCentral.com that I wasn't aware of Oracle's displeasure at one particular Database User Group until I read your article and...

Whenever I use text files I import them into a table before trying to manipulate them.  You could use a table as an intermediate table before inserting into the final...

I have had similar problems as what you mention and had to put everything into a SP to get it to work properly.  I don't know that you can assign...

If you are planning to use the connection in the ActiveX script where you plan to set the username and password then this code should do the trick:

     Logintoyourdb =...

Take all the code you posted after

Declare Year nvarchar(4)

set @year = ?

and place it in a stored procedure.  For the sake of an example I'll call the SP spYear

Now...

I am not sure what you are doing.  However, since you mentioned what you want to do allow me to give you an idea that could work for you if...