<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>public static void TimeOnMyHands()</title><link>http://www.dotnetjunkies.com/WebLog/cykophysh/default.aspx</link><description>.net, tips,tutorials and rantings of a developer</description><dc:language>en-GB</dc:language><generator>CommunityServer 1.0 (Build: 1.0.1.50214)</generator><item><title>new blog spot</title><link>http://www.dotnetjunkies.com/WebLog/cykophysh/archive/2006/09/12/146911.aspx</link><pubDate>Tue, 12 Sep 2006 18:31:00 GMT</pubDate><guid isPermaLink="false">58df7014-fd75-437c-9641-150997716d1c:146911</guid><dc:creator>Cykophysh</dc:creator><slash:comments>0</slash:comments><comments>http://www.dotnetjunkies.com/WebLog/cykophysh/comments/146911.aspx</comments><wfw:commentRss>http://www.dotnetjunkies.com/WebLog/cykophysh/commentrss.aspx?PostID=146911</wfw:commentRss><description>To all my fan (I know my wife reads this blog once in a while) I have just started my new blog located at &lt;a href="http://threenineconsulting.com/forum/blogs/default.aspx"&gt;http://threenineconsulting.com/forum/blogs/default.aspx &lt;/a&gt;&lt;br&gt;
&lt;br&gt;&lt;img src="http://www.dotnetjunkies.com/WebLog/aggbug.aspx?PostID=146911" width="1" height="1"&gt;</description></item><item><title>To the Nob End who is trying to post comments about Gay Movies.</title><link>http://www.dotnetjunkies.com/WebLog/cykophysh/archive/2006/08/29/145407.aspx</link><pubDate>Tue, 29 Aug 2006 13:30:00 GMT</pubDate><guid isPermaLink="false">58df7014-fd75-437c-9641-150997716d1c:145407</guid><dc:creator>Cykophysh</dc:creator><slash:comments>0</slash:comments><comments>http://www.dotnetjunkies.com/WebLog/cykophysh/comments/145407.aspx</comments><wfw:commentRss>http://www.dotnetjunkies.com/WebLog/cykophysh/commentrss.aspx?PostID=145407</wfw:commentRss><description>&lt;h1&gt;&lt;span&gt;STOP IT!!&lt;/span&gt;&lt;br&gt;&lt;/h1&gt;&lt;br&gt;&lt;h3&gt;I have to approve comments before they get posted so they'll never get up there so it's basically pointless, so stop wasting your time ! as it's quick and easy to delete your postings so they will never see the light of day!!&lt;/h3&gt;&lt;br&gt;&lt;img src="http://www.dotnetjunkies.com/WebLog/aggbug.aspx?PostID=145407" width="1" height="1"&gt;</description></item><item><title>What does windows do when it's scraping your hard drive?</title><link>http://www.dotnetjunkies.com/WebLog/cykophysh/archive/2006/08/24/144293.aspx</link><pubDate>Thu, 24 Aug 2006 09:56:00 GMT</pubDate><guid isPermaLink="false">58df7014-fd75-437c-9641-150997716d1c:144293</guid><dc:creator>Cykophysh</dc:creator><slash:comments>4</slash:comments><comments>http://www.dotnetjunkies.com/WebLog/cykophysh/comments/144293.aspx</comments><wfw:commentRss>http://www.dotnetjunkies.com/WebLog/cykophysh/commentrss.aspx?PostID=144293</wfw:commentRss><description>This is a question I ask myself when, I click on something and wait while windows seems to go in a bit of a unresponsive mode, and the hard drive light flashes away!!&lt;br&gt;&lt;br&gt;Does anybody have an answer to this, because there is no pattern to it&lt;br&gt;&lt;img src="http://www.dotnetjunkies.com/WebLog/aggbug.aspx?PostID=144293" width="1" height="1"&gt;</description></item><item><title>New range of Technical articles</title><link>http://www.dotnetjunkies.com/WebLog/cykophysh/archive/2006/06/28/141288.aspx</link><pubDate>Wed, 28 Jun 2006 12:50:00 GMT</pubDate><guid isPermaLink="false">58df7014-fd75-437c-9641-150997716d1c:141288</guid><dc:creator>Cykophysh</dc:creator><slash:comments>0</slash:comments><comments>http://www.dotnetjunkies.com/WebLog/cykophysh/comments/141288.aspx</comments><wfw:commentRss>http://www.dotnetjunkies.com/WebLog/cykophysh/commentrss.aspx?PostID=141288</wfw:commentRss><description>I am about to commence on a range of technical articles detailing a
variety of subjects in the very intresting world of computer
programming/ Application development.&lt;br&gt;
&lt;br&gt;
&lt;h5&gt;&lt;span&gt;Why is this mad man doing this ?&lt;/span&gt;&lt;/h5&gt;
&lt;p&gt;Well basically the answer is a five fold one&lt;/p&gt;
&lt;ol&gt;
  &lt;li&gt;I wanted to refresh/extend my knowledge on a variety of subjects&lt;/li&gt;
  &lt;li&gt;I wanted to improve my writing capabilities&lt;/li&gt;
  &lt;li&gt;I wanted a quick reference for myself , for answers to a variety of typical interview/consultative questions&lt;/li&gt;
  &lt;li&gt;Assist my Peers.&lt;/li&gt;
  &lt;li&gt;Have you seen the price of books these days?&lt;br&gt;
  &lt;/li&gt;
&lt;/ol&gt;
&lt;h5&gt;&lt;span&gt;When this thing happening&lt;/span&gt;&lt;br&gt;
&lt;/h5&gt;
The First of these will be available in the next couple days, and I plan to do one a week after that.&lt;br&gt;
&lt;br&gt;
&lt;h5&gt;&lt;span&gt;Ok so why you telling me?&lt;/span&gt;&lt;/h5&gt;
I would like some comments and suggestions on the items I discuss&lt;br&gt;

&lt;br&gt;&lt;img src="http://www.dotnetjunkies.com/WebLog/aggbug.aspx?PostID=141288" width="1" height="1"&gt;</description></item><item><title>Microsoft Unhelpful help files</title><link>http://www.dotnetjunkies.com/WebLog/cykophysh/archive/2006/06/11/140148.aspx</link><pubDate>Sun, 11 Jun 2006 21:40:00 GMT</pubDate><guid isPermaLink="false">58df7014-fd75-437c-9641-150997716d1c:140148</guid><dc:creator>Cykophysh</dc:creator><slash:comments>0</slash:comments><comments>http://www.dotnetjunkies.com/WebLog/cykophysh/comments/140148.aspx</comments><wfw:commentRss>http://www.dotnetjunkies.com/WebLog/cykophysh/commentrss.aspx?PostID=140148</wfw:commentRss><description>After some adventures in playing around with ASP.net 2.0, and using the helpfiles that go along with it , it kind of makes me sick that Microsoft actually get away with releasing such shoddy help files for thier systems. When all thier marketing hype is done and all the adverts have done thier trick and all companies move forward with the New MS dev tool, it is left to us developers to take Advantage of the "productivity gains" that come with the new development tool. &lt;br&gt;&lt;br&gt;I am a developer with a vast eperience of MS dev tools, and I must say&amp;nbsp; the helpfiles associated with 2.0 have got to be the worst I have ever come across.&amp;nbsp; This&amp;nbsp; takes my mind back to when I have worked with other developers who have turned to MS help files as an absolute last resort in order to get things to work. I have always seen a copy of WROX, Apress, SAMS or a one of million other help resources for MS tools, occasionally I might see a copy of the MS press book too. These are the tools developers turn too to get assistance in thier new "Time Saving tool" and not the help files. I think one of the major contributers to Googles Success has got to developers trowling the internet for some article that will help them in the problem. I often hear the term, "Google it", when somebody encounters a problem with MS kit.&lt;br&gt;&lt;br&gt;Don't the guys in the MS help files department , have any pride in thier work? Don't they get embarrassed that somebody outside of MS can write better help material than they actually can? &lt;br&gt;&lt;br&gt;To me the value of a product is it's ease in learning and the assitance it provides in the learning curve, this is something MS never seem to get right, and yet we still use thier tools? Who's the stupid ones here?&lt;br&gt;&lt;br&gt;&lt;img src="http://www.dotnetjunkies.com/WebLog/aggbug.aspx?PostID=140148" width="1" height="1"&gt;</description></item><item><title>Community Server and IE7 tool loss</title><link>http://www.dotnetjunkies.com/WebLog/cykophysh/archive/2006/05/23/138706.aspx</link><pubDate>Tue, 23 May 2006 12:45:00 GMT</pubDate><guid isPermaLink="false">58df7014-fd75-437c-9641-150997716d1c:138706</guid><dc:creator>Cykophysh</dc:creator><slash:comments>0</slash:comments><comments>http://www.dotnetjunkies.com/WebLog/cykophysh/comments/138706.aspx</comments><wfw:commentRss>http://www.dotnetjunkies.com/WebLog/cykophysh/commentrss.aspx?PostID=138706</wfw:commentRss><description>&lt;h6&gt;IE7 and Community Server don't work together&lt;br&gt;
&lt;/h6&gt;
Appollogies for the slack formatting of some of my posts, but I am used
IE7, to access my Blog adding utility&amp;nbsp; and the control community
server use, to allow you put up posts doesn't seem to work on any other
browser other than IE6, I think it must be something to do with the
Browser sniffing Unitility. As the tool also deosn't work in Opera.&lt;br&gt;
Anyhow I have resolved the problem by using my Firefox browser to do my Blog Posting now.&lt;br&gt;&lt;br&gt;
&lt;h6&gt;A Point about Firefox&lt;br&gt;
&lt;/h6&gt;
While I am on this subject I had a little giggle the other day while I
was watching a WebCast by Fritz Onion, from his series of ASP.net 2.0,
I noticed that when he was running his web apps, he had Firefox as his
default browser, so all his applications were being demonstrated in
FireFox. It made me laugh that even MS MVP's prefer Firefox&amp;nbsp; :-)&lt;br&gt;
&lt;br&gt;
&lt;br&gt;&lt;img src="http://www.dotnetjunkies.com/WebLog/aggbug.aspx?PostID=138706" width="1" height="1"&gt;</description></item><item><title>Using Javascript and Ajax as a Bridge</title><link>http://www.dotnetjunkies.com/WebLog/cykophysh/archive/2006/05/23/138705.aspx</link><pubDate>Tue, 23 May 2006 12:20:00 GMT</pubDate><guid isPermaLink="false">58df7014-fd75-437c-9641-150997716d1c:138705</guid><dc:creator>Cykophysh</dc:creator><slash:comments>0</slash:comments><comments>http://www.dotnetjunkies.com/WebLog/cykophysh/comments/138705.aspx</comments><wfw:commentRss>http://www.dotnetjunkies.com/WebLog/cykophysh/commentrss.aspx?PostID=138705</wfw:commentRss><description>I have just recently discovered the joys of AJAX (I didn't realise it was more than just toilet cleaner!). Ihave jsut recently completed a small batch of development, where the requirement was for small modal windows to pop up on a webform, where the user can change some data and the the updates needed to be displayed on the parent form, The basics of this I knew what I wanted to do, however I was worried about the effect looking clean, and I was really trying to replicate the functionality one would experience in a windows application.  After reading so much hype of late about AJAX, (and also being asked about it from a junior) I thought I would start taking a look at this - little known soccer team from Amsterdam - and I must say I really enjoyed mucking about with it, and I think the effect has been quite awesome on our application, even though this has been a small implementation, I can see that we will start using it more often in our application.&lt;br&gt;&lt;br&gt;

The Following is a small tutorial of bigger Idea I used. &lt;br&gt;
First port of call would be to go to &lt;a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html/ASPNetSpicedAjax.asp"&gt;Spiced Ajax Example&lt;/a&gt;
I downloaded the AJAX.net, the author of the library has updated it which can be found here
&lt;a href="http://www.ajaxpro.info/default.aspx?old=ajax"&gt;Updated Library&lt;/a&gt;

I used the first library and things worked fine for me, but I have started to play with the latest library, but that will be another lesson :-)

You need to set a reference to the Library, the tutorial in Spiced will tell you how, this is not in scope with this little article.
&lt;br&gt;
&lt;br&gt;
I have been playing with the idea of uploading a detailed exmaple with source code, to help explain the idea a bit better, I may put this up on &lt;a href="www.codeproject.com"&gt;Code Project&lt;/a&gt;

I got to get back to work will update later&lt;img src="http://www.dotnetjunkies.com/WebLog/aggbug.aspx?PostID=138705" width="1" height="1"&gt;</description></item><item><title>Thoughts for the Day - Computers the Bane of our Existence</title><link>http://www.dotnetjunkies.com/WebLog/cykophysh/archive/2006/05/12/138332.aspx</link><pubDate>Fri, 12 May 2006 08:43:00 GMT</pubDate><guid isPermaLink="false">58df7014-fd75-437c-9641-150997716d1c:138332</guid><dc:creator>Cykophysh</dc:creator><slash:comments>0</slash:comments><comments>http://www.dotnetjunkies.com/WebLog/cykophysh/comments/138332.aspx</comments><wfw:commentRss>http://www.dotnetjunkies.com/WebLog/cykophysh/commentrss.aspx?PostID=138332</wfw:commentRss><description>&lt;p&gt;I've had a rather intresting week this week, and have certainly had
many things to ponder about. Mostly about how Computers and Software
are encroaching on every possible aspect of our human existence, and as
a programmer/ Developer/ Geek/ (insert suitable title here ), am I
happy about it? &lt;br&gt;
&lt;/p&gt;
&lt;p&gt;&lt;br&gt;
Well the answer is , in my humble opinion , I am not totally sure.&lt;br&gt;
&lt;/p&gt;
&lt;p&gt;Indedd software seems to be everywhere these days, but not all of it
seems to be a decent quality, I am not only talking about the millions
of Business applications or Web sites out there, I'm talking about
software in Motor vehicles, Micro wave ovens, digital pets, and other
bizaar places one can find should one look hard enough for it. &lt;/p&gt;

&lt;p&gt;It just seems to pop up everywhere, but sadly in a few of the
circumstances that have cropped up lately, in my circumstance&amp;nbsp; it
has been more of a pain than beneficiary, rather holding me to ransom.
The first instance of this, is software in my motor vehicle, I drive a
renault clio, (nothing fancy), anyway I have had this car for about 4
years now, and I must say I am reasonably happy with it, until the last
few weeks. Ever since I have had the car it has suffered from an
irregular abnormality&amp;nbsp; that occured rather infrequently, but when
it does it is at most in oppurtune moments, it seems to cut out and is
unable to start again for another 30 minutes. No matter how many times
I try start the car it just cranks over but just won't fire, but then
on the stroke of 30 minutes, vroom there it goes again.&amp;nbsp; Well
anyway this problem only really manifested&amp;nbsp; itself maybe once or
twice a year, so I haven't really paid it much mind until the other
day. I took my car for it's yearly MOT test, when it decided to do it's
little trick on the Mechanic, he couldn't get it to start, he tried and
tried, until he called me, I went down to garage to see if I could be
of any help, and maybe have a chat about it, to see if there is
anything we could do to fix this anomoly. I was dismayed to find out
that unfortunately there was nothing we could do, unless I took the car
to renault, the mechanic told me that this is quite a common problem on
the renault clio and&amp;nbsp; it has something to do with the immobiliser,
which is governed by the onboard computer. &lt;br&gt;
&lt;/p&gt;
&lt;p&gt;I asked him if there was the possibility of plugging in his
computer, as he had one there that he uses for just that task, he said
no unfortunately things aren't so simple anymore because of the way
renault have set the computer up, I needed to go to renault. He said
gone are the old days where you could actually do something to a car,
he said mostly these days the only thing he can do to a car, was
basically change the oil, and the plugs, and a few minor tweaks here
and there, he could also download "service packs" from the
manufacturers to service the onboard computers. &lt;br&gt;
&lt;/p&gt;
&lt;p&gt;After hearing his tales of woe, I decided I would go to renault, to
see what could be done, after all it is thier equipment, it's gone
wrong they should be able to fix it. After a chat with the guys down
there, they said yes it's a common fault, they can fix it, but
unfortunatly they would need to charge me a flat charge of £45.00, just
to link up my car to the computer, to do some test, if they find any
problems, there will be additional costs, but they said they couldn't
tell me what those costs would be until they found out what the problem
was, (now if this doesn't sound like a line to set you up for a mugging
nothing does). I said well I'm a software developer by trade, and I
work for a consultancy, and those rates don't even come close as to
what I can charge for an hours work, let alone 20 minutes. Thier reply
was that it's a standard charge and thier is nothing they can do about
it. &lt;br&gt;&lt;br&gt;Well you guessed it , I left there with my car still witht
the same problem, and the £45 still in my back pocket. I am also in the
market for a car that has no onboard computer!!&lt;br&gt;
&lt;/p&gt;
&lt;h5&gt;Update: 12/06/06&lt;br&gt;
&lt;/h5&gt;
The car has decided to do it's little trick again, so I have taken the plunge and taken the car in to see what can be done!&lt;br&gt;
&lt;br&gt;&lt;img src="http://www.dotnetjunkies.com/WebLog/aggbug.aspx?PostID=138332" width="1" height="1"&gt;</description></item><item><title>Difference between Set and Select</title><link>http://www.dotnetjunkies.com/WebLog/cykophysh/archive/2006/04/04/136611.aspx</link><pubDate>Tue, 04 Apr 2006 14:26:00 GMT</pubDate><guid isPermaLink="false">58df7014-fd75-437c-9641-150997716d1c:136611</guid><dc:creator>Cykophysh</dc:creator><slash:comments>0</slash:comments><comments>http://www.dotnetjunkies.com/WebLog/cykophysh/comments/136611.aspx</comments><wfw:commentRss>http://www.dotnetjunkies.com/WebLog/cykophysh/commentrss.aspx?PostID=136611</wfw:commentRss><description>&lt;P&gt;I found this article found it intresting so I pasted it here for another source for the article incase the guy took it off&lt;/P&gt;
&lt;P&gt;&lt;FONT&gt;&lt;FONT&gt;Traditionally, SQL Server database developers are accustomed to using SELECT for assigning values to variables. This was fine and a perfectly valid practice right until SQL Server 6.5. Microsoft released SQL Server 7.0 in 1999. SQL Server 7.0 introduced the new SET statement for initializing and assigning values to variables. SQL Server 7.0 Books Online also stated: &lt;I&gt;"It is recommended that SET @local_variable be used for variable assignment rather than SELECT @local_variable."&lt;/I&gt;&lt;BR&gt;&lt;BR&gt;This caused some confusion in the database developer community, as Microsoft never mentioned, why SET is recommended over SELECT for assigning values to variables. In this article, I will highlight all the major differences between SET and SELECT, and things you should be aware of, when using either SET or SELECT.&lt;BR&gt;&lt;BR&gt;If you are completely new to T-SQL, then the following examples give you an idea of what I am talking about:&lt;BR&gt;&lt;BR&gt;/* Declaring variables */&lt;/FONT&gt;&lt;BR&gt;&lt;FONT&gt;DECLARE @Variable1 AS int, @Variable2 AS int&lt;/FONT&gt;&lt;/FONT&gt;&lt;BR&gt;&lt;BR&gt;&lt;FONT&gt;&lt;FONT&gt;/* Setting @Variable1 to a value of 1 using SELECT */&lt;BR&gt;&lt;/FONT&gt;&lt;FONT&gt;SELECT @Variable1 = 1 &lt;/FONT&gt;&lt;/FONT&gt;&lt;BR&gt;&lt;BR&gt;&lt;FONT&gt;&lt;FONT&gt;/* Setting @Variable2 to a value of 2 using SET */&lt;BR&gt;&lt;/FONT&gt;&lt;FONT&gt;SET @Variable2 = 2 &lt;/FONT&gt;&lt;/FONT&gt;&lt;BR&gt;&lt;BR&gt;&lt;FONT&gt;&lt;FONT&gt;Now coming to the differences between SET and SELECT! Are standards important to you? If your answer is 'yes', then you should be using SET. This is because, SET is the ANSI standard way of assigning values to variables, and SELECT is not.&lt;BR&gt;&lt;BR&gt;Another fundamental difference between SET and SELECT is that, you can use SELECT to assign values to more than one variable at a time. SET allows you to assign data to only one variable at a time. Here's how:&lt;BR&gt;&lt;BR&gt;/* Declaring variables */&lt;/FONT&gt;&lt;BR&gt;&lt;FONT&gt;DECLARE @Variable1 AS int, @Variable2 AS int&lt;/FONT&gt;&lt;/FONT&gt;&lt;BR&gt;&lt;BR&gt;&lt;FONT&gt;&lt;FONT&gt;/* Initializing two variables at once */&lt;BR&gt;&lt;/FONT&gt;&lt;FONT&gt;SELECT @Variable1 = 1, @Variable2 = 2&lt;/FONT&gt;&lt;/FONT&gt;&lt;BR&gt;&lt;BR&gt;&lt;FONT&gt;&lt;FONT&gt;/* The same can be done using SET, but two SET statements are needed */&lt;BR&gt;&lt;/FONT&gt;&lt;FONT&gt;SET @Variable1 = 1&lt;/FONT&gt;&lt;/FONT&gt;&lt;BR&gt;&lt;FONT&gt;SET @Variable2 = 2&lt;/FONT&gt;&lt;BR&gt;&lt;BR&gt;&lt;FONT&gt;So far so good. But if you ever wrote error handling code in T-SQL, you most probably are aware that, the system variables @@ERROR and @@ROWCOUNT must be captured in one statement, immediately after a data manipulation (DML) statement like INSERT, UPDATE, DELETE, or else, these system variables get reset to 0. So, if you want to stick to the standards and use SET in this scenario, you are out of luck. The following example demonstrates the problem:&lt;BR&gt;&lt;BR&gt;&lt;/FONT&gt;&lt;FONT&gt;&lt;FONT&gt;&lt;FONT&gt;DECLARE @Error int, @RowCount int&lt;BR&gt;SELECT price/0 FROM dbo.titles&lt;BR&gt;SET @RowCount = @@ROWCOUNT&lt;BR&gt;SET @Error = @@ERROR&lt;BR&gt;SELECT @Error AS Error&lt;BR&gt;GO&lt;BR&gt;&lt;BR&gt;&lt;/FONT&gt;If you run the above piece of code in pubs database, the value of @@ERROR system variable will be displayed as 0, even though the 'division by zero' resulted in error 8134. So, in this particular scenario, forget about standards and use SELECT, as shown below:&lt;BR&gt;&lt;BR&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;FONT&gt;&lt;FONT&gt;&lt;FONT&gt;DECLARE @Error int, @RowCount int&lt;BR&gt;SELECT price/0 FROM dbo.titles&lt;BR&gt;SELECT @RowCount = @@ROWCOUNT, @Error = @@ERROR&lt;BR&gt;SELECT @Error AS Error&lt;BR&gt;&lt;BR&gt;&lt;/FONT&gt;But if you insist on using SET even in this scenario, there's always a way out. Here's one example, though not readable and recommended:&lt;BR&gt;&lt;BR&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;FONT&gt;&lt;FONT&gt;&lt;FONT&gt;DECLARE @ErrorAndRowcount AS varchar(25), @Error int, @RowCount int&lt;BR&gt;SELECT price/0 FROM dbo.titles&lt;BR&gt;&lt;BR&gt;&lt;FONT&gt;/* Capturing @@ERROR and @@ROWCOUNT into a dot separated string */&lt;/FONT&gt;&lt;BR&gt;SET @ErrorAndRowcount = CAST(@@ERROR AS varchar(12)) + '.' + CAST(@@ROWCOUNT AS varchar(12))&lt;BR&gt;&lt;BR&gt;&lt;FONT&gt;/* One way to separate the string into error and rowcount variables */&lt;/FONT&gt;&lt;BR&gt;SET @Error = CAST(PARSENAME(@ErrorAndRowcount, 2) AS int)&lt;BR&gt;SET @RowCount = CAST(PARSENAME(@ErrorAndRowcount, 1) AS int)&lt;BR&gt;SELECT @Error AS Error, @RowCount AS Row_Count&lt;BR&gt;&lt;BR&gt;&lt;FONT&gt;/* Another way of splitting the string into error and rowcount variables */&lt;/FONT&gt;&lt;BR&gt;SET @Error = CAST(LEFT(@ErrorAndRowcount, CHARINDEX('.', @ErrorAndRowcount)-1) AS int)&lt;BR&gt;SET @RowCount = CAST(RIGHT(@ErrorAndRowcount, CHARINDEX('.', REVERSE(@ErrorAndRowcount))-1) AS int)&lt;BR&gt;SELECT @Error AS Error, @RowCount AS Row_Count&lt;BR&gt;GO&lt;BR&gt;&lt;BR&gt;&lt;/FONT&gt;Moving on to other differences between SET and SELECT: When using a query to populate a variable, SET will fail with an error, if the query returns more than one value. But SELECT will assign one of the returned rows and mask the fact that the query returned more than one row. As a result, bugs in your code could go unnoticed with SELECT, and this type of bugs are hard to track down too. Here is an example:&lt;BR&gt;&lt;BR&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;FONT&gt;&lt;FONT&gt;&lt;FONT&gt;/* Consider the following table with two rows */&lt;/FONT&gt;&lt;BR&gt;&lt;FONT&gt;SET NOCOUNT ON&lt;BR&gt;CREATE TABLE #Test (i int, j varchar(10))&lt;BR&gt;INSERT INTO #Test (i, j) VALUES (1, 'First Row')&lt;BR&gt;INSERT INTO #Test (i, j) VALUES (1, 'Second Row')&lt;BR&gt;GO&lt;BR&gt;&lt;BR&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;FONT&gt;&lt;FONT&gt;/* Following SELECT will return two rows, but the variable gets its value from one of those rows, without an error.&lt;BR&gt;This may not be what you were expecting. Since no error is returned, &lt;BR&gt;you will never know that two rows existed for the condition, WHERE i = 1 */&lt;/FONT&gt;&lt;BR&gt;&lt;FONT&gt;DECLARE @j varchar(10)&lt;BR&gt;SELECT @j = j FROM #Test WHERE i = 1&lt;BR&gt;SELECT @j&lt;BR&gt;GO&lt;BR&gt;&lt;BR&gt;&lt;FONT&gt;/* If you rewrite the same query, but use SET instead, for variable initialization, you will see the following error */&lt;/FONT&gt;&lt;BR&gt;DECLARE @j varchar(10)&lt;BR&gt;SET @j = (SELECT j FROM #Test WHERE i = 1)&lt;BR&gt;SELECT @j&lt;BR&gt;&lt;BR&gt;&lt;FONT&gt;Server: Msg 512, Level 16, State 1, Line -1074284106&lt;/FONT&gt;&lt;BR&gt;&lt;FONT&gt;Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, &amp;lt;, &amp;lt;= , &amp;gt;, &amp;gt;= or when the subquery is used as an expression.&lt;/FONT&gt;&lt;BR&gt;&lt;BR&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;FONT&gt;Based on the above results, when using a query to populate variables, I suggest you always use SET, if you want to be sure that only one row is returned. If you hate SET for some reason, you could get the same behavior of SET, using SELECT, as shown below:&lt;BR&gt;&lt;BR&gt;&lt;/FONT&gt;&lt;FONT&gt;&lt;FONT&gt;&lt;FONT&gt;DECLARE @j varchar(10)&lt;BR&gt;SELECT @j = (SELECT j FROM #Test WHERE i = 1)&lt;BR&gt;SELECT @j&lt;BR&gt;&lt;BR&gt;&lt;/FONT&gt;Here is another difference with respect to assigning values based on a query, especially when the query doesn't return any rows. Run the following example in the pubs database, and you will see what I mean:&lt;BR&gt;&lt;BR&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;FONT&gt;&lt;FONT&gt;&lt;FONT&gt;/* Returns NULL */&lt;/FONT&gt;&lt;BR&gt;&lt;FONT&gt;DECLARE @Title varchar(80)&lt;BR&gt;SET @Title = 'Not Found'&lt;BR&gt;&lt;BR&gt;SET @Title = &lt;BR&gt;(&lt;BR&gt;SELECT title&lt;BR&gt;FROM dbo.titles&lt;BR&gt;WHERE title_id = 'InvalitTitleID'&lt;BR&gt;)&lt;BR&gt;&lt;BR&gt;SELECT @Title&lt;BR&gt;GO&lt;BR&gt;&lt;BR&gt;&lt;FONT&gt;/* Returns the string literal 'Not Found' */&lt;/FONT&gt;&lt;BR&gt;DECLARE @Title varchar(80)&lt;BR&gt;SET @Title = 'Not Found'&lt;BR&gt;&lt;BR&gt;SELECT @Title = title&lt;BR&gt;FROM dbo.titles&lt;BR&gt;WHERE title_id = 'InvalitTitleID'&lt;BR&gt;&lt;BR&gt;SELECT @Title&lt;BR&gt;GO&lt;BR&gt;&lt;BR&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;FONT&gt;&lt;FONT&gt;Last, but not the least! Is there any performance difference between SET and SELECT? Is one faster or slower than the other? This is one question most database developers and DBAs are not so sure about. So I decided to conduct a test and come up with some conclusive results. I picked a development SQL Server for this test. Closed all applications, and stopped all unnecessary services running on that machine. Stopped SQL Server agent service, to make sure, no jobs kick in during the performance test. Also, unplugged the machine from the network. So, this is one isolated SQL Server box, with nothing but just SQL Server service running on it. Then I created a test script, that continuously assigns values to variables inside a loop (of configurable iterations) using SET, SELECT and measures the time taken to complete each loop.&lt;BR&gt;&lt;BR&gt;Here are the results:&lt;BR&gt;&lt;BR&gt;There is hardly any performance difference between SET and SELECT, when initializing/assigning values to variables. BUT, I made one startling discovery. As you all know, one single SELECT statement can be used to assign values to multiple variables. This very feature of SELECT makes it a winner over SET, when assigning values to multiple variables. A single SELECT statement assigning values to 3 different variables, is much faster than 3 different SET statements assigning values to 3 different variables. In this scenario, using a SELECT is at least twice as fast, compared to SET. So, the conclusion is, if you have a loop in your stored procedure that manipulates the values of several variables, and if you want to squeeze as much performance as possible out of this loop, then do all variable manipulations in one single SELECT statement (or group the related variables into few SELECT statements) as show below:&lt;BR&gt;&lt;BR&gt;&lt;FONT&gt;SELECT @TestVar1 = @TestVar1 + 1, @TestVar2 = @TestVar2 - 1, @CTR = @CTR + 1 &lt;/FONT&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;BR&gt;&lt;BR&gt;&lt;FONT&gt;I ran this test on SQL Server versions 7.0, 2000 and SQL Server 2005 (Yukon), and the results were consistent. I even tested this on single and multi-processor boxes, and the results were the same. If you want to test this yourself, feel free to use the following test script. A word of caution though, do not run this script on a production SQL Server, as it could lead to 100% CPU utilization for the duration of the test. Also, if you think the test is taking too long, reduce the value of the variable @TimesToLoop2, to reduce the number of iterations. At the end of the test, the script displays how much time (in Seconds) it took to assign values to variables using SET, SELECT and SELECT with multiple assignments. Here's the script:&lt;BR&gt;&lt;BR&gt;&lt;/FONT&gt;&lt;/P&gt;&lt;PRE&gt;&lt;FONT&gt;
&lt;FONT&gt;DECLARE @Test1 int,  @Test2 int, @Test3 int, @TestVar1 int, @TestVar2 int
DECLARE @Loop int, @Start datetime, @CTR int, @TimesToLoop1 int, @TimesToLoop2 int

SET @Test1 = 0
SET @Test2 = 0
SET @Test3 = 0
SET @Loop = 0
SET @TestVar2 = 0
SET @TimesToLoop1 = 10
SET @TimesToLoop2 = 50000
WHILE @Loop &amp;lt; @TimesToLoop1
BEGIN
	SET @Start = CURRENT_TIMESTAMP
	SET @CTR = 0

	&lt;FONT&gt;/* Testing the performance of SET */&lt;/FONT&gt;
	WHILE @CTR &amp;lt; @TimesToLoop2
	BEGIN
		SET @TestVar1 = 1
		SET @TestVar2 = @TestVar2 - @TestVar1
		SET @CTR = @CTR + 1
	END

	SET @Loop = @Loop + 1
	SET @Test1 = @Test1 + DATEDIFF(ms, @Start, CURRENT_TIMESTAMP)
END

SET @Loop = 0
SET @TestVar2 = 0
WHILE @Loop &amp;lt; @TimesToLoop1
BEGIN
	SELECT @Start = CURRENT_TIMESTAMP
	SELECT @CTR = 0

	&lt;FONT&gt;/* Testing the performance of SELECT */&lt;/FONT&gt;
	WHILE @CTR &amp;lt; @TimesToLoop2
	BEGIN
		SELECT @TestVar1 = 1
		SELECT @TestVar2 = @TestVar2 - @TestVar1
		SELECT @CTR = @CTR + 1
	END

	SELECT @Loop = @Loop + 1
	SELECT @Test2 = @Test2 + DATEDIFF(ms, @Start, CURRENT_TIMESTAMP)
END

SET @Loop = 0
SET @TestVar2 = 0
WHILE @Loop &amp;lt; @TimesToLoop1
BEGIN
	SELECT @Start = CURRENT_TIMESTAMP, @CTR = 0

	&lt;FONT&gt;/* Testing the performance of SELECT with multiple variable assignments */&lt;/FONT&gt;
	WHILE @CTR &amp;lt; @TimesToLoop2
	BEGIN
		SELECT @TestVar1 = 1, @TestVar2 = @TestVar2 - @TestVar1, @CTR = @CTR + 1
	END

	SELECT @Loop = @Loop + 1, @Test3 = @Test3 + DATEDIFF(ms, @Start, CURRENT_TIMESTAMP)
END

SELECT 	(@Test1/CAST(@TimesToLoop1 AS decimal(7,2)))/1000.00 AS [SET], 
	(@Test2/CAST(@TimesToLoop1 AS decimal(7,2)))/1000.00 AS [SELECT], 
	(@Test3/CAST(@TimesToLoop1 AS decimal(7,2)))/1000.00 AS [SELECT with Multiple Assignments]
&lt;/FONT&gt;&lt;/FONT&gt;&lt;/PRE&gt;&lt;img src="http://www.dotnetjunkies.com/WebLog/aggbug.aspx?PostID=136611" width="1" height="1"&gt;</description></item><item><title>BookWiz same Con re-hashed</title><link>http://www.dotnetjunkies.com/WebLog/cykophysh/archive/2006/02/09/135153.aspx</link><pubDate>Thu, 09 Feb 2006 13:40:00 GMT</pubDate><guid isPermaLink="false">58df7014-fd75-437c-9641-150997716d1c:135153</guid><dc:creator>Cykophysh</dc:creator><slash:comments>1</slash:comments><comments>http://www.dotnetjunkies.com/WebLog/cykophysh/comments/135153.aspx</comments><wfw:commentRss>http://www.dotnetjunkies.com/WebLog/cykophysh/commentrss.aspx?PostID=135153</wfw:commentRss><description>&lt;P&gt;As some of you may know I have been a great professor that the BookWiz is nothing more than an absolute Con, but after some comments supporting this bunch of thieves appeared on my blog, I thought I would for a laugh,&lt;EM&gt;&amp;nbsp; &lt;/EM&gt;I thought I &amp;nbsp;would &lt;EM&gt;re-apply &lt;/EM&gt;for the program, as my Alter Ego Mr. Dirk Diggler, I set up an email account for mr Diggler and off I went to the Bookwiz website , filled out the same application as I did before, and I was shocked to see that in a matter of seconds my Site was up and running in a matter of seconds of applying.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I then waited a couple of days then I thought I would go check Dirk's email account, and as I had presumed the same emails that I had recieved 8 months ago, we there in Dirks account, the same news that the VP was looking to recruit some suckers for a promotion in my country, how there were limited seats available and that I could a chosen one to get one to one mentoring, to be the next Net Millionaire. &lt;/P&gt;
&lt;P&gt;The guys haven't changed the con. They are obviously sticking to the tried and tested formula, a pulling the suckers. It obviously works for them, but I will still be doing whatever I can to stop it working. I have had a couple of so called "pro" book wiz comments left on my blog, but to be honest I don't believe them, and I believe this some weak attempt by bookwiz to get some pro rallying on my blog, until somebody can actually give me some credible proof that it works I will not champion thier cause. They left some weak sob story I have reprinted here&lt;/P&gt;
&lt;P&gt;&lt;EM&gt;&lt;FONT&gt;i too am a single mother of two and i invested in this bookwiz program and have made that back and some i really don't know how the end results can be so opposite of one another what went wrong with your sites this is horrible to hear it be called a scam when it worked for me this in itself is unfair to do come on now people lets be the honest people we claim to be and have some mannors just because we did not succeed all in the same way we cant bash something we all don't get the same results from &lt;/FONT&gt;&lt;/EM&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT&gt;As one can make out this is nothing more than some weak attempt at a story to pull at the heart strings, a &lt;EM&gt;single of two, &lt;/EM&gt;what bollox. I have deleted these comments as it is just complete drivel. but I thought I would just aknowledge that I had recieved them, as I personally believe this is a weak attempt by the company themselves to get some pro bookwiz comments here. &lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Other Reports of bookwiz &lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;&lt;a href="http://dotnetjunkies.com/WebLog/cykophysh/archive/2005/09/20/132849.aspx"&gt;http://dotnetjunkies.com/WebLog/cykophysh/archive/2005/09/20/132849.aspx&lt;/A&gt; 
&lt;LI&gt;&lt;A href="http://www.ripoffreport.com/reports/ripoff112945.htm"&gt;http://www.ripoffreport.com/reports/ripoff112945.htm&lt;/A&gt; 
&lt;LI&gt;&lt;a href="http://dotnetjunkies.com/WebLog/cykophysh/archive/2005/09/06/132384.aspx"&gt;http://dotnetjunkies.com/WebLog/cykophysh/archive/2005/09/06/132384.aspx&lt;/A&gt; 
&lt;LI&gt;&lt;a href="http://dotnetjunkies.com/WebLog/cykophysh/archive/2005/11/09/133644.aspx"&gt;http://dotnetjunkies.com/WebLog/cykophysh/archive/2005/11/09/133644.aspx&lt;/A&gt;&lt;/LI&gt;&lt;/UL&gt;
&lt;P&gt;We&amp;nbsp;urge folks not to sign up with this bunch of crooks, try and spread the word as much as you can. &lt;/P&gt;
&lt;P&gt;If you require feel free to mail us at &lt;A href="http://www.threenineconsulting.com/contact.aspx"&gt;www.threenineconsulting.com&lt;/A&gt;&amp;nbsp; we will endeavour to assist you.&lt;/P&gt;&lt;img src="http://www.dotnetjunkies.com/WebLog/aggbug.aspx?PostID=135153" width="1" height="1"&gt;</description></item><item><title>Validation without postback</title><link>http://www.dotnetjunkies.com/WebLog/cykophysh/archive/2006/02/08/135115.aspx</link><pubDate>Wed, 08 Feb 2006 09:01:00 GMT</pubDate><guid isPermaLink="false">58df7014-fd75-437c-9641-150997716d1c:135115</guid><dc:creator>Cykophysh</dc:creator><slash:comments>0</slash:comments><comments>http://www.dotnetjunkies.com/WebLog/cykophysh/comments/135115.aspx</comments><wfw:commentRss>http://www.dotnetjunkies.com/WebLog/cykophysh/commentrss.aspx?PostID=135115</wfw:commentRss><description>&lt;p&gt;I was looking for a way to use the asp.net Validation controls without a postback. I knew this could be done because after all ASP.net is nothing but a container for everything javascript and &amp;nbsp;the validation controls are themselves only javascript. I had also read somewhere that the CausesValidation property of the command buttons is only an "interface" for a javascript validation method but I couldn't remember exactly what method that was. It took me a couple of hours of playing and fiddling but I eventually uncovered the method.&lt;/p&gt;
&lt;h3&gt;Thats cute honey but wheres the punch?&lt;/h3&gt;
&lt;p&gt;Some people may be questioning the value of doing this without a post back, well the answer is simple, if you would like to validate data but do not want to incur the extra overhead of posting back to the server, for instance in my case I wanted to validate that I had the correct dates in a textbox and that some fields where populated before I initiated a report, which was nothing more than opening a new browser window which is then redirected to my report page.&amp;nbsp; I didn't necessarily want to do a post back as strictly speaking the server did not need the information. &lt;/p&gt;
&lt;p&gt;So anyway without any further ado this is what I found&lt;/p&gt;
&lt;p&gt;An Example place a couple of Text boxes on a Webform , place validation controls on and and assign them to the textboxes as you normally would. then place an html button i.e &lt;code&gt;&amp;lt; 'INPUT onclick="return DoSomeValidation();" type=button value=Report'&amp;gt; &lt;/code&gt;
&lt;/p&gt;&lt;p&gt;(not an ASP.net button) on the form. write a script similar to the following and place in the Html view of your codethis script o&lt;/p&gt;
&lt;p&gt;funtion&amp;nbsp;DoSomeValidation()&lt;/p&gt;
&lt;p&gt;{&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;font color="#000000"&gt;&amp;nbsp;if (Page_ClientValidate() == true) &lt;/font&gt;&lt;/p&gt;
&lt;p&gt;&lt;font color="#000000"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;{&lt;/font&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;alert('I feel validated');&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;}&lt;/p&gt;
&lt;p&gt;}&lt;/p&gt;
&lt;h4&gt;&amp;nbsp;Update&lt;/h4&gt;&lt;p&gt;29/08/06&amp;nbsp; - I finally got round to writing a small tutorial for this on the code project it can be found here &lt;a href="http://www.codeproject.com/useritems/cykovalid.asp"&gt;Validation without postback&lt;/a&gt;&lt;br&gt;&lt;/p&gt;
&lt;p&gt;&lt;br&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;img src="http://www.dotnetjunkies.com/WebLog/aggbug.aspx?PostID=135115" width="1" height="1"&gt;</description></item><item><title>Well our rip off artist friends at Bookwiz are still at it !!</title><link>http://www.dotnetjunkies.com/WebLog/cykophysh/archive/2006/01/04/134564.aspx</link><pubDate>Wed, 04 Jan 2006 10:04:00 GMT</pubDate><guid isPermaLink="false">58df7014-fd75-437c-9641-150997716d1c:134564</guid><dc:creator>Cykophysh</dc:creator><slash:comments>0</slash:comments><comments>http://www.dotnetjunkies.com/WebLog/cykophysh/comments/134564.aspx</comments><wfw:commentRss>http://www.dotnetjunkies.com/WebLog/cykophysh/commentrss.aspx?PostID=134564</wfw:commentRss><description>&lt;p&gt;As you may know at this site we are not very happy with the Con Artists that call themselves The BookWiz a.k.a &lt;a href="http://www.zzfast.com/Electronics"&gt;www.ZZFast.com/Electronics&lt;/a&gt;. And some other names that they like to trade under. We have in the past uncovered that they are nothing more than just a rip off artists making money from the poor people who would like nothing more than starting thier own web based business from home. It has now come to our attention today that the little ****ers are attempting to try it again. We recieved an email from them this morning promising unbelievable offers again. This I must say is exactly they are totally unbelievable and you folks must stay totally clear of them.&lt;/p&gt;
&lt;p&gt;&lt;em&gt;I warn the good folks out there that is nothing but another attempt at stealing your money.&lt;/em&gt;&lt;/p&gt;
&lt;p&gt;Other Reports of bookwiz &lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;&lt;a href="http://dotnetjunkies.com/WebLog/cykophysh/archive/2005/09/20/132849.aspx"&gt;http://dotnetjunkies.com/WebLog/cykophysh/archive/2005/09/20/132849.aspx&lt;/a&gt; 
&lt;/li&gt;&lt;li&gt;&lt;a href="http://www.ripoffreport.com/reports/ripoff112945.htm"&gt;http://www.ripoffreport.com/reports/ripoff112945.htm&lt;/a&gt; 
&lt;/li&gt;&lt;li&gt;&lt;a href="http://dotnetjunkies.com/WebLog/cykophysh/archive/2005/09/06/132384.aspx"&gt;http://dotnetjunkies.com/WebLog/cykophysh/archive/2005/09/06/132384.aspx&lt;/a&gt; 
&lt;/li&gt;&lt;li&gt;&lt;a href="http://dotnetjunkies.com/WebLog/cykophysh/archive/2005/11/09/133644.aspx"&gt;http://dotnetjunkies.com/WebLog/cykophysh/archive/2005/11/09/133644.aspx&lt;/a&gt;&lt;/li&gt;&lt;/ul&gt;
&lt;p&gt;We urge folks not to sign up with this bunch of crooks, try and spread the word as much as you can. &lt;/p&gt;
&lt;p&gt;If you require feel free to check out the forums at &lt;a href="http://www.threenineconsulting.com/forum"&gt;www.threenineconsulting.com&lt;/a&gt;  we will endeavour to assist you.&lt;/p&gt;
&lt;p&gt;I have also just recently placed a Forum up so hopefully you will be able to discuss these crooks a bit more &lt;a href="http://threenineconsulting.com/forum/forums/22/ShowForum.aspx"&gt;
Book Wiz Forum&lt;/a&gt;&lt;/p&gt;
&lt;p&gt; &lt;/p&gt;
&lt;p&gt; &lt;/p&gt;
&lt;p&gt;&lt;/p&gt;&lt;img src="http://www.dotnetjunkies.com/WebLog/aggbug.aspx?PostID=134564" width="1" height="1"&gt;</description></item><item><title>MS Project OLEDB Provider</title><link>http://www.dotnetjunkies.com/WebLog/cykophysh/archive/2005/12/13/134288.aspx</link><pubDate>Tue, 13 Dec 2005 09:56:00 GMT</pubDate><guid isPermaLink="false">58df7014-fd75-437c-9641-150997716d1c:134288</guid><dc:creator>Cykophysh</dc:creator><slash:comments>1</slash:comments><comments>http://www.dotnetjunkies.com/WebLog/cykophysh/comments/134288.aspx</comments><wfw:commentRss>http://www.dotnetjunkies.com/WebLog/cykophysh/commentrss.aspx?PostID=134288</wfw:commentRss><description>&lt;P&gt;I have been experiencing problems with accessing the MS Project OLEDB provider, and I can't seem to figure out why. I m also amazed at the lack of support/documentation/help that is available for programatically accessing Project.&lt;/P&gt;
&lt;P&gt;We have a block of code that attempts to create a connection to the MS Project OLEDB provider. Out Block of code attempts to make a connection using 1 of 3 Drivers i.e Ms Project OLDB Provider 9,10 and 11. We don't seem to have the same problem every body else has , by accessing the dirver. It seems to be more a permissioned based problem we have. I believe our problem stems form the&amp;nbsp;permission rights between IUSR and ASPNET user accounts on the machine.&lt;/P&gt;
&lt;P&gt;IF we do the Following in our Web.Config File. &lt;/P&gt;&lt;FONT&gt;
&lt;P&gt;&lt;/FONT&gt;&lt;FONT&gt;&amp;lt;&lt;/FONT&gt;&lt;FONT&gt;authentication&lt;/FONT&gt;&lt;FONT&gt; &lt;/FONT&gt;&lt;FONT&gt;mode&lt;/FONT&gt;&lt;FONT&gt;="Windows"&lt;/FONT&gt;&lt;FONT&gt; &lt;/FONT&gt;&lt;FONT&gt;/&amp;gt;&lt;/FONT&gt;&lt;FONT&gt; &lt;/P&gt;
&lt;P&gt;&lt;/FONT&gt;&lt;FONT&gt;&amp;lt;&lt;/FONT&gt;&lt;FONT&gt;identity&lt;/FONT&gt;&lt;FONT&gt; &lt;/FONT&gt;&lt;FONT&gt;impersonate&lt;/FONT&gt;&lt;FONT&gt; &lt;/FONT&gt;&lt;FONT&gt;=&lt;/FONT&gt;&lt;FONT&gt; &lt;/FONT&gt;&lt;FONT&gt;"false"&lt;/FONT&gt;&lt;FONT&gt; &lt;/FONT&gt;&lt;FONT&gt;/&amp;gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT&gt;&lt;FONT&gt;This works fine our code that we use to create a connection to MS Project works fine and we can read all the information in a MS Project fine. Very Cool. This is becuase IIS instructs the ASPNET worker process. Which I believe has access to the OLEDB Provider&lt;/FONT&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;Now if I make the following change to our Web.Config file&lt;/P&gt;&lt;FONT&gt;&lt;FONT&gt;
&lt;P&gt;&lt;/FONT&gt;&lt;FONT&gt;&amp;lt;&lt;/FONT&gt;&lt;FONT&gt;authentication&lt;/FONT&gt;&lt;FONT&gt; &lt;/FONT&gt;&lt;FONT&gt;mode&lt;/FONT&gt;&lt;FONT&gt;="Windows"&lt;/FONT&gt;&lt;FONT&gt; &lt;/FONT&gt;&lt;FONT&gt;/&amp;gt;&lt;/FONT&gt;&lt;FONT&gt; &lt;/P&gt;
&lt;P&gt;&lt;/FONT&gt;&lt;FONT&gt;&amp;lt;&lt;/FONT&gt;&lt;FONT&gt;identity&lt;/FONT&gt;&lt;FONT&gt; &lt;/FONT&gt;&lt;FONT&gt;impersonate&lt;/FONT&gt;&lt;FONT&gt; &lt;/FONT&gt;&lt;FONT&gt;=&lt;/FONT&gt;&lt;FONT&gt; &lt;/FONT&gt;&lt;FONT&gt;"true"&lt;/FONT&gt;&lt;FONT&gt; &lt;/FONT&gt;&lt;FONT&gt;/&amp;gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT&gt;When I Set the web.config file&amp;nbsp; to this, things turn to pot. This is becuase IIS instructs the IUSR account, which I believe does not have access to the OLEDB provider. I thought things would be simple if I just ran a test and placed the IUSR account into the User Group. This still didn't work. So I thought I'd try place the IUSR account into the Administrator group, it still didn't work.&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT&gt;Any help would be appreciated on this.&lt;/P&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;img src="http://www.dotnetjunkies.com/WebLog/aggbug.aspx?PostID=134288" width="1" height="1"&gt;</description></item><item><title>Book Wiz and ZZ Fast</title><link>http://www.dotnetjunkies.com/WebLog/cykophysh/archive/2005/11/09/133644.aspx</link><pubDate>Wed, 09 Nov 2005 08:26:00 GMT</pubDate><guid isPermaLink="false">58df7014-fd75-437c-9641-150997716d1c:133644</guid><dc:creator>Cykophysh</dc:creator><slash:comments>0</slash:comments><comments>http://www.dotnetjunkies.com/WebLog/cykophysh/comments/133644.aspx</comments><wfw:commentRss>http://www.dotnetjunkies.com/WebLog/cykophysh/commentrss.aspx?PostID=133644</wfw:commentRss><description>&lt;P&gt;Well what a pleasant day it has been today, after weeks of not a single email or any correspondence from the BookWiz, (even though my site is still available) , I received an email from them this morning with yet another attempt to make me a Million dollars, for doing very little, besides send them a little money, a fraction of what I will earn I purchased them scheme. They also provlaim that they will offer the thier services to get my site into the top position in all search rankings.&lt;/P&gt;
&lt;P&gt;Well isn't it funny how my simple Blog achieves top position when searching for the book wiz? Is it funny how my blog beats thier site in most searches!! How good can thier services be when a simple Programmers blog can beat thiers to positioning and I have done no optimization to it!!&lt;/P&gt;
&lt;P&gt;The advice as usual is to stay away from this crowd of crooks.&lt;/P&gt;
&lt;P&gt;This Article Follows on from &lt;a href="http://dotnetjunkies.com/WebLog/cykophysh/archive/2005/09/06/132384.aspx#comments"&gt;http://dotnetjunkies.com/WebLog/cykophysh/archive/2005/09/06/132384.aspx#comments&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;Folks Could I ask you if you leave a comment and would like someone to get back to you, Please leave an email and we will get back to you as soon as possible. You can email &lt;A href="mailto:enquiries@threenineconsulting.com"&gt;enquiries@threenineconsulting.com&lt;/A&gt; if you would like more information.&lt;/P&gt;&lt;img src="http://www.dotnetjunkies.com/WebLog/aggbug.aspx?PostID=133644" width="1" height="1"&gt;</description></item><item><title>SQL Reporting Services</title><link>http://www.dotnetjunkies.com/WebLog/cykophysh/archive/2005/10/24/133392.aspx</link><pubDate>Mon, 24 Oct 2005 11:44:00 GMT</pubDate><guid isPermaLink="false">58df7014-fd75-437c-9641-150997716d1c:133392</guid><dc:creator>Cykophysh</dc:creator><slash:comments>0</slash:comments><comments>http://www.dotnetjunkies.com/WebLog/cykophysh/comments/133392.aspx</comments><wfw:commentRss>http://www.dotnetjunkies.com/WebLog/cykophysh/commentrss.aspx?PostID=133392</wfw:commentRss><description>&lt;a href="http://www.15seconds.com/issue/041013.htm"&gt;http://www.15seconds.com/issue/041013.htm
&lt;/a&gt;
Found this excellent Tutorial on SQL Reports. This site is a whole lot better and more intuitive than  the WROX book I tried to get through last week!!
I do not recommend the book as it. This site is brilliant got me up to speed a lot quicker than the book&lt;img src="http://www.dotnetjunkies.com/WebLog/aggbug.aspx?PostID=133392" width="1" height="1"&gt;</description></item></channel></rss>