Build 9.0.3050

I downloaded SP2 on March 10, 2007, and applied it. The system to which I applied it reports 9.0.3050 as the version number, not 9.0.3042. Is this due to the post-SP2 fix?My system, which was updated with the bugged SP2, and then the subsequent hotfix, also reports 9.0.3050. So that seems like a reasonable assumption.|||

refer this link for latest fixes in SQL Server 2005...

http://support.microsoft.com/kb/933508

SP2 Release version was --9.00.3042.00

Latest version with this fix(Mar 05) is -- 9.00.3050.00

Madhu

BUG in Microsoft Learning Resources VB Express Lesson 9 (Database Fails to Update).

I recently downloaded Visual Studio 2005 Express along with the Learning Resources for Visual Basic Express video. First let me say that the Learning Resources is an excellent resource for beginners to become familiar with Visual Studio, Database and programming concepts. Although the series is probably too basic for experienced developers you may find it reveals a number of tricks in the Visual Studio 2005 interface.

http://msdn.microsoft.com/vstudio/express/vb/default.aspx

Problem

I downloaded the VB Lesson 9 Visual Basic Project from Microsoft Learning Resources. With out making any changes to the project I compiled and ran it, making changes to the data and saving the changes. Every thing look great until you run it a second time and see that the changes to the data are all lost.

Observations:

1. Changes made to the data from within Visual Studio (Show Table Data) do take effect.

2. The in-memory data (DataSet) is changed as you move from row to row.

3. The TableAdapter.Update call returns 1, ostensibly indicating the number of rows updated.

4. The data in the database is not changed by the TableAdapter.Update call.

Operating System: Windows XP Pro Service Pack 2

Other Software installed on this system

20SQL Server 2005 Express

Visual Web Developer 2005 Express

Visual Studio 6.0 Enterprise

Visual Studio .net Enterprise

Microsoft .NET Framework SDK

Microsoft Office 2003

If anyone can help me understand the cause of this problem I would greatly appreciate it.

Thanks

Bob

Allow Nulls is a problem for Edit - Update

I have found the if you leave the Allow Nulls for any fields the Update will not work.

If any knows of a way to leave the Allow Nulls on some fields and have the Update work please let me know.

Thanks

Bob

Buffer Leaks

I've had this a few times.

Can someone explain what a buffer leak is, and how are they avoided.

I downloaded the ExtraSort demo and in non-debug mode I get loads of errors saying the buffer leaked?

How do I plug the whole? Do I need a big cork?

Simon

Well there are 2 leak messages the buffer manager gives and since you didn't specify the exact message I don't know which one you are getting and they happen in very different scenarios. I will explain them both but they are both a component coding error.

1. This buffer has been orphaned...
This is when the engine is shutting down but a component still has a reference to a buffer. This usually mean the component has actually leaked a buffer since when the engine is shutting down everything else in the dataflow has already finished.

2. A call to ProcessInput unexpectedly kept a reference...
This is when a component calls AddRef on a buffer that it was passed in a process input call. This is not allowed. A component that needs to keep a buffer around that it was passed on process input must call clone on the buffer not addref.

You can't do anything about this problem. The component author must fix their component to resolve these problems.

HTH,
Matt

Brand new / totally confused / am I in the right place?

I downloaded MS SQL Server 2005 Express Edition. The MS site said that it was "easy to install, use and manage." However I'm totally confused. I'm not a total neophyte but I can't even seem to launch the program.

I have an MS SQL database powering my website. I view the database on my home computer using MS Access 2000 with an ODBC connection. MS Access 2000 however, does not let me make changes to the structure of the database. I can't add, delete or modify fields in my current tables. I can't add or delete tables. Is MS SQL Server 2005 Express Edition the proper software to perform these functions? If it is, is there a guide to helping me launch the program, connect to my MS SQL database and perform these functions? If this is not the right software, what is?

I would greatly appreciate any guidance anyone can offer.

Thanks!

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=196509&SiteID=1

HTH

Bought and installed VS2005 professional - There is no Management studio got installed in

Hi Friends,

I have a question. At my home computer i downloaded and
installed VWD. As usual it also installed Sqlexpress as part of the
installation(i checked the option). Later on i downloaded Management
studio separately so i am fine with my home computer as every thing is free.

But at work we decided to develop application using VS 2005 and Sqlserver 2005. So we bought and installed VS2005 professional edition at work and it also installed Sqlexpress during the installation as a defualt desktop engine. I am fine with that too. But i am not
understing where do i get the Management studio? Is it some thing i
could get it off the web for free or what? I am not sure we would have an option while installing the VS 2005 professional that also does install management studio and we need to check that option. I am not sure if we could get the management studion off the web for free and and evelop applications.

Please advise.
Thanks
-L

Off the SQL Server 2005 CD. I believe there is a Management Studio Express as well available for download from MS. Kind of a braindead way to do things, as I expect that a lot of VS 2005 Professionals will be in the same situation as me that I develop on SQL Express, and then push to SQL Server 2005 (I also need to manage SQL Server 2000 and 2005 machines as well). It would have been nice if they just put Management Studio in VS 2005 from the start. Management Studio can work with SQL Express, 2005, and most of 2000 (Optional DTS download needed).|||

Yes we can download the Management Studio Express for free from MS website. I did the same thing on my personal laptop. But can we develop applications using free downloaded Management Studio and deploy later on with the free stuff at work?

Or else like you have mentioned may be i want to get it off Sql server 2005.

May be you can help me figuring out where i can get it off

Its kind of confusing what to install of all the CDs we got when we bought the software.

Please bear with me the list of CDs we have is:

1).Microsoft Visual Studio 2005 Professional Edition (Disc1 & Disc 2)

2)Microsoft Visual Studio 2005 Professional Edition (SQL Server 2005 Developer Edition 32-bit Cd1 & CD2)

3).Microsoft SQL Server 2005 Developer Edition (32 bit) (Disc1 & Disc 2)

4).Microsoft Visual Studio 2005 Professional Edition (SQL Server 2005 Developer Edition IA 64-bit CD1 and CD2)

5).Microsoft Sql server 2005 Developer Edition for Itanium-based Systems (Disc 1 & Disc 2)

6).Microsoft Sql server 2005 Developer Edition (X64) (Disc 1 & Disc 2)

7).Microsoft Visual Studio 2005 Professional Edition (Sql server 2005 Developer Edition 64-bit CD1 & CD2)

My work machine runs on Windows XP Prof . Of all the above CDs I installed Visual Studio 2005 Professional alone. So i have VS 2005 installed and also SQL Express.

Like you said can use #2 set of CDs to get Management Studio or #3 set of CDs(i have windows XP professional installed on my work machine)?

We have already ordered another development box from Dell and we are going to have Windows 2003 server on that. Correct me if i am wrong, #4,5, and 6 set of CDs are designed for 64-bit Windows 2003 server.

what is IA in #4 set of CDs and Itanium-based system in #5 respectively?

Am i getting you confusing with lot of stupid questions here :)?

I have lot of questions with the new stuff.

Thanks

-L

|||Wish I could help you. Unfortunately, I don't have a set of retail disks. My home machine has .ISO's I downloaded from MSDN (I have a personal MSDN Subscription), and at work, they install whatever I tell them to, but they lock up the disks and licenses.