April 21, 2009 at 7:06 am
Hi all,
I'm new to SQL Server and this forum so please go easy on me 🙂
I've been asked by my company to build a system using SQL Server 2005, bought the Microsoft DB Essentials Step By Step book and have installed SQL Server 2005 on my laptop. I'm struggling to get past Chapter Two ! as the book wants me to use the AdventureWorksDB. In the Management Studio I can select "Modify" on a table and can see all the details (ie. field type, length etc) however when I try and "Open" any table to see what data it contains I get an "Unspecified Error" message which is really annoying and exceptionally "useful" :w00t: as it doesn't give you any indication of where the problem lies. 0 rows are returned. Any advice appreciated. Thanks in advance, Rhodri.
Version details :-
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.1433
Operating System 5.1.2600
April 21, 2009 at 2:14 pm
rhodri.davies (4/21/2009)
Hi all,I'm new to SQL Server and this forum so please go easy on me 🙂
I've been asked by my company to build a system using SQL Server 2005, bought the Microsoft DB Essentials Step By Step book and have installed SQL Server 2005 on my laptop. I'm struggling to get past Chapter Two ! as the book wants me to use the AdventureWorksDB. In the Management Studio I can select "Modify" on a table and can see all the details (ie. field type, length etc) however when I try and "Open" any table to see what data it contains I get an "Unspecified Error" message which is really annoying and exceptionally "useful" :w00t: as it doesn't give you any indication of where the problem lies. 0 rows are returned. Any advice appreciated. Thanks in advance, Rhodri.
Version details :-
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.1433
Operating System 5.1.2600
I would recommending downloading and applying SP3 for 2005 first -
Next I would grab the latest copies of the AdventureWorks database samples for 2005 from CodePlex -
Tommy
Follow @sqlscribeApril 21, 2009 at 10:42 pm
I believe the URL u are looking for is
http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004
Here you can download the relevant adventure works DB:-D - I see the links above both points to SP3:-P
April 22, 2009 at 2:54 am
Thanks both, I shall give it a go 😎
April 23, 2009 at 1:46 am
Tried these installs, no joy, some of the service pack failed :crying: There must be something on my laptop that is causing the problems. Took a different approach and installed VMWARE and created a Windows 2000 virtual machine, installed SQL here and hey presto no problems. Ahh well at least I have a working environment to progress, maybe a rebuild of the laptop is in order :unsure: thanks for you support, I'm sure I'm going to have further questions. All the best, Rhodri.
May 12, 2009 at 10:25 am
Ty using IP address rather than hostname. I've had this problem twice, and it was resolved each time using IP address
May 14, 2009 at 5:32 am
You could update Internet Explorer. For security reasons, not for SQL
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply