Northwind Database In SQL Server Express Is Busted And Gone,after SqlCommand Fails In VB2005Express-How To Prevent It Happen?

Northwind Database In SQL Server Management Studio Express Is Lost Or Used/processed By VB 2005 Express:How To Locate/return It
Hi all,
 
In the last one and half years, I used the Northwind Database in SQL Server Management Studio Express (SSMSE) to learn the programming of SqlConnections, Data sources, Database Exploere, ADO.NET 2.0, etc. via VB 2005 Express. 

The Northwind Database in my SSMSE got lost very often, but I was not aware of it.  How can I know where the Northwind Database is used or processed by my VB 2005 Express projects that were the examples of some tutorial books or my trial projects? How can I release the Northwind Database back to my SSMSE from the VB 2005 Express projects?  Please help and advise.
 
Thanks in advance,
Scott Chang

View Replies !

---

Cannot Install Northwind Database In SQL Server Express
Hi,

I tried to install the Northwind database into SQl Server Express via the instnwnd.sql script using the command line:

osql -E -i instnwnd.sql

after a time out though I get this message:

"[SQL Native Client]Named Pipes Provider: Could not open a connection to SQL
Server [2].
[SQL Native Client]Login timeout expired
[SQL Native Client]An error has occurred while establishing a connection to
the server. When connecting to SQL Server 2005, this failure may be caused by
the fact that under the default settings SQL Server does not allow remote
connections."

I already granted access to the administrator account on my machine.

Anyone knows what I need to do more?

Thanks in advance

 

greetings from Belgium,

Anthony

 

View Replies !

---

Repair Northwind Database In SQL Server Management Studio Express
Hi all,

Long time ago, I downloaded the Northwind and pubs databases from the Microsoft website (I do not remember the details of it)  and installed these two databases together into the SQL Server Management Studio Express of my PC (Microsoft Windows XP Pro). I tried to learn an example of using "User Instance" (source code was from a book) on the Northwind database located in my SQL Server Management Studio Express.  I just find out that my Northwind database has the title only and no tables at all. If I click on the "+" in front of the "Northwind", I got the following error message:

       Microsoft SQL Server Management Studio Express

     

        Failed to retrieve data for this request.(Microsoft SqlServer.Express.SmoEnum)

 

        Additional information:

         One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from backup. (Microsoft SQL Server, Error: 5173)..

 

Please help and tell me how I can repair this Northwind database in my  SQL Server Management Studio Express.

 

Scott Chang

 

P. S.

 

I deleted the name 'Northwind' in my SQL Server Management Studio Express,  executed the "SQL2005DBScriptsInstnwind" program and I got the following error message:    Msg 1802, Level 16, State 4, Line 1

                   CREATE DATABASE failed. Some file name listed could not be created. Checked related errors.

                   Msg 5170, Level 16, state 1, Line 1

                   Cannot create file 'c:Program FilesMicrosoft SQL ServerMSSQL.1DATAorthwindorthwind.ldf' because it already exist. Change the file path or the file name, and retry the operation.

                   Msg 15100, Level 16, State 1, Procedure sp_dboption, Line 64

                   The database 'Northwind' does not exist. Use sp_helpdb to show available database.

                   Msg 911, Level 16, State 1, Line 1

                   Could not locate entry in sysdatabases for database 'Northwind'. No entry found with that name. Make sure that name is entered correctly  

View Replies !

---

How Can I Re-install The Northwind Database In SQL Server Management Studio Express?Use SqlDataSet && The .Fill Method Properly?
Hi all,

In my VB 2005 Express, I created a Windowds Form application "shcDataSet" that used 1 SqlConnection, 1 SqlDataSet and 3 SqlDataAdapters associated with the Northwind Database in my SQL Server Management Studio Express. The SqlConnection had "User Instance" in the following ConnectionString: Data Source=.SQLEXPRESS;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataorthwnd.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True. The 3 SqlDataAdapters were for the Northwind files "Customers", "Orders" and "Order Details" used in the SQLDataSet "AllOrders" with a AllOrders.xsd file. I ran the "shcDataSet" applicatyion and it worked fine. After the execution of "shcDataSet", I checked the Northwind database in my SQL Server Management Studio Express and clicked on "+" in front of Northwind database-I did not see any file showed up and I got the following error message:  Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)  Additional information: one or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup. (Microsoft SQL Server, Error:5173).  If I executed the "shcDataSet" application again, I got a new error: SqlException was unhandled - Cannot open user default database. Login failed. Login failed for user 'myPC##myName' ------->daCustomers.Fill(AllOrders11, "Customers").  I have 3 questions to ask: (1)  How can I re-install the Northwind database in SQL Server Management Studio Express? (2) When I use the .Fill Method,  do I have to tell the SQL Server Management Studio Express to load and/or unload the Northwind files "Customers", "Orders" and "Order Details"? (3) After I executed the "shcDataSet", should I Upload the 3 Northwind files back to the SQL Server Management Studio Express?  Please help and advise. Thanks, Scott Chang

View Replies !

---

NORTHWIND Database Was Re-created From A Different Database:How Can I Change The Entry In Sysdatabases For Database 'NORTHWIND'?
Hi all,
 
From the http://msdn.microsoft.com/en-us/library/bb384469.aspx (Walkthrough: Creating Stored Procedures for the Northwind Customers Table, I copied the following sql code:
 
--UpdateSPforNWcustomersTable.sql--

USE NORTHWIND

GO

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'SelectCustomers' AND user_name(uid) = 'dbo')

DROP PROCEDURE dbo.[SelectCustomers]

GO

CREATE PROCEDURE dbo.[SelectCustomers]

AS

SET NOCOUNT ON;

SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax FROM dbo.Customers

GO

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'InsertCustomers' AND user_name(uid) = 'dbo')

DROP PROCEDURE dbo.InsertCustomers

GO

CREATE PROCEDURE dbo.InsertCustomers

(

@CustomerID nchar(5),

@CompanyName nvarchar(40),

@ContactName nvarchar(30),

@ContactTitle nvarchar(30),

@Address nvarchar(60),

@City nvarchar(15),

@Region nvarchar(15),

@PostalCode nvarchar(10),

@Country nvarchar(15),

@Phone nvarchar(24),

@Fax nvarchar(24)

)

AS

SET NOCOUNT OFF;

INSERT INTO [dbo].[Customers] ([CustomerID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax]) VALUES (@CustomerID, @CompanyName, @ContactName, @ContactTitle, @Address, @City, @Region, @PostalCode, @Country, @Phone, @Fax);

SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax FROM Customers WHERE (CustomerID = @CustomerID)

GO

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'UpdateCustomers' AND user_name(uid) = 'dbo')

DROP PROCEDURE dbo.UpdateCustomers

GO

CREATE PROCEDURE dbo.UpdateCustomers

(

@CustomerID nchar(5),

@CompanyName nvarchar(40),

@ContactName nvarchar(30),

@ContactTitle nvarchar(30),

@Address nvarchar(60),

@City nvarchar(15),

@Region nvarchar(15),

@PostalCode nvarchar(10),

@Country nvarchar(15),

@Phone nvarchar(24),

@Fax nvarchar(24),

@Original_CustomerID nchar(5)

)

AS

SET NOCOUNT OFF;

UPDATE [dbo].[Customers] SET [CustomerID] = @CustomerID, [CompanyName] = @CompanyName, [ContactName] = @ContactName, [ContactTitle] = @ContactTitle, [Address] = @Address, [City] = @City, [Region] = @Region, [PostalCode] = @PostalCode, [Country] = @Country, [Phone] = @Phone, [Fax] = @Fax WHERE (([CustomerID] = @Original_CustomerID));

SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax FROM Customers WHERE (CustomerID = @CustomerID)

GO

====================================================================================
I executed the above code in my SQL Server Management Studio Express (SSMSE) and I got the following error messages:  

Msg 911, Level 16, State 1, Line 1

Could not locate entry in sysdatabases for database 'NORTHWIND'. No entry found with that name.

Make sure that the name is entered correctly.

===============================================================================================================
I know I recreated the NORTHWIND Database from a different Database before and I did not do anything for the entry in sysdatabases.  How can I change the entry in sysdatabases for database 'NORTHWIND' now?  Please help and advise.
 
Thanks in advance,
Scott Chang
 

View Replies !

---

Calling Stored Procedures From ADO.NET-VB 2005 Express:1)Compile Errors && Warnings,2)Northwind Database In Database Explorer?
Hi all,

I try to learn "How to Access Stored Procedures with ADO.NET 2.0 - VB 2005 Express: (1) Handling the Input and Output Parameters and (2) Reporting their Values in VB Forms".  I found a good article "Calling Stored Procedures from ADO.NET" by John Paul Cook in http://www.dbzine.com/sql/sql-artices/cook6.  I downloaded the source code into my VB 2005 Express:

 

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Public Class Form_Cook

Inherits System.Windows.Form.Form

#Region " Windows Form Designer generated code "

Public Sub New()

MyBase.New()

'This call is required by the Windows Form Designer.

InitializeComponent()

'Add any initialization after the InitializeComponent() call

End Sub

'Form overrides dispose to clean up the component list.

Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)

If disposing Then

If Not (components Is Nothing) Then

components.Dispose()

End If

End If

MyBase.Dispose(disposing)

End Sub

'Required by the Windows Form Designer

Private components As System.ComponentModel.IContainer

'NOTE: The following procedure is required by the Windows Form Designer

'It can be modified using the Windows Form Designer.

'Do not modify it using the code editor.

Friend WithEvents GroupBox1 As System.Windows.Forms.GroupBox

Friend WithEvents labelPAF As System.Windows.Forms.Label

Friend WithEvents labelNbrPrices As System.Windows.Forms.Label

Friend WithEvents UpdatePrices As System.Windows.Forms.Button

Friend WithEvents textBoxPAF As System.Windows.Forms.TextBox

Friend WithEvents TenMostExpensive As System.Windows.Forms.Button

Friend WithEvents grdNorthwind As System.Windows.Forms.DataGrid

Friend WithEvents groupBox2 As System.Windows.Forms.GroupBox

<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

Me.GroupBox1 = New System.Windows.Forms.GroupBox()

Me.labelPAF = New System.Windows.Forms.Label()

Me.labelNbrPrices = New System.Windows.Forms.Label()

Me.textBoxPAF = New System.Windows.Forms.TextBox()

Me.UpdatePrices = New System.Windows.Forms.Button()

Me.groupBox2 = New System.Windows.Forms.GroupBox()

Me.TenMostExpensive = New System.Windows.Forms.Button()

Me.grdNorthwind = New System.Windows.Forms.DataGrid()

Me.GroupBox1.SuspendLayout()

Me.groupBox2.SuspendLayout()

CType(Me.grdNorthwind, System.ComponentModel.ISupportInitialize).BeginInit()

Me.SuspendLayout()

'

'GroupBox1

'

Me.GroupBox1.Controls.AddRange(New System.Windows.Forms.Control() {Me.labelPAF, Me.labelNbrPrices, Me.textBoxPAF, Me.UpdatePrices})

Me.GroupBox1.Location = New System.Drawing.Point(8, 8)

Me.GroupBox1.Name = "GroupBox1"

Me.GroupBox1.Size = New System.Drawing.Size(240, 112)

Me.GroupBox1.TabIndex = 9

Me.GroupBox1.TabStop = False

'

'labelPAF

'

Me.labelPAF.Location = New System.Drawing.Point(8, 16)

Me.labelPAF.Name = "labelPAF"

Me.labelPAF.Size = New System.Drawing.Size(112, 32)

Me.labelPAF.TabIndex = 2

Me.labelPAF.Text = "Enter Price Adjustment Factor"

'

'labelNbrPrices

'

Me.labelNbrPrices.Location = New System.Drawing.Point(8, 80)

Me.labelNbrPrices.Name = "labelNbrPrices"

Me.labelNbrPrices.Size = New System.Drawing.Size(216, 16)

Me.labelNbrPrices.TabIndex = 5

'

'textBoxPAF

'

Me.textBoxPAF.Location = New System.Drawing.Point(120, 16)

Me.textBoxPAF.Name = "textBoxPAF"

Me.textBoxPAF.TabIndex = 0

Me.textBoxPAF.Text = ""

'

'UpdatePrices

'

Me.UpdatePrices.Location = New System.Drawing.Point(8, 48)

Me.UpdatePrices.Name = "UpdatePrices"

Me.UpdatePrices.Size = New System.Drawing.Size(88, 23)

Me.UpdatePrices.TabIndex = 6

Me.UpdatePrices.Text = "Update Prices"

'

'groupBox2

'

Me.groupBox2.Controls.AddRange(New System.Windows.Forms.Control() {Me.TenMostExpensive, Me.grdNorthwind})
 
<Part 1----To be continued due to the length of this post> 

View Replies !

---

Using Northwind Database In VB 2008 Express Tutorial
I have been following the Visual Basic Guided Tour for VB 2008 Express and I'm having a problem with the following part.
 

ms-help://MS.VSCC.v90/MS.msdnexpress.v90.en/dv_vbcnexpress/html/48fcb538-d8c7-4299-a2bf-a5b6f80d879d.htm
Creating LINQ to SQL Classes: Using the O/R Designer

 
I am getting the error "Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.", when I get to the Test Connection button.
 
I have found the following help page,
 

ms-help://MS.VSCC.v90/MS.msdnexpress.v90.en/SqlExpressBol/html/85385aae-10fb-4f8b-9eeb-cce2ee7da019.htm

 
but I have no idea how to use this information as it assumes the user knows what they are doing!
The solution appears to involve running a scipt of some sort, but where would that be run?
I have looked at the SQL server Express information, but can't find how to run sp_configure.
Your help would be much appreciated.

View Replies !

---

Checkpoints: FTP Task Download FTP Files Fails In Between Then What Will Happen?
Hi,

I have a FTP task in my control flow that download files from a FTP server. This ftp task is inside a foreach container that loops over a ADO recordset for the file name. The files that the ftp task pulls are huge. If the FTP task fails then I want the FTP task to restart and only download those files that have not been downloaded. Is this possible?

What possible configurations do I have to make to the foreach container and the filetask?

Thanks a lot in advance for your help and time.

Regards,

$wapnil

View Replies !

---

Northwind DB For Sql Server Express 2005
Hi all,Does anyone know where I can find the Northwind database for SQL Server 2005 Express edition?Everywhere I look I get redirected to the AdventureWorks database, but it must be available because this article which is based on 2005 references it...http://weblogs.asp.net/scottgu/archive/2006/01/15/435498.aspxThanks 

View Replies !

---

How To Connect To My Sql Server Express,also Pubs And Northwind For Sql Server Express
1, I have installed VWD express,sql server 2005 express.I also install management studio and adventureswork db.In the management studio I can able to connect and view adventurework db.But I can't manage to make a connection string to my db server when connecting to management studio server name is "KAMRANSHAHIDSQLEXPRESS".I wants a connection string with respect to this server.2,Is there new database for pubs and northwind for sql server 2005.Or they are of old sql server 2000.I have installed sample databases but can't find script for pubs and northwind nor it install automatically.I wan't to use tutorial's sample.

View Replies !

---

New Install Of Sql Server Express Fails To Restore Master Database
Hello,

I have a fresh install of sqlExpress and Management Studio Express on my test server. I want to restore my master database from backup.

From the command prompt I set the Sqlservr -s SQLEXPRESS -m

Then I opened another comand prompt and ran my SQLCMD script to restore the Master Database.

here is the sql script:
RESTORE DATABASE [Master] FROM  DISK = N'E:COPLEYNEWSDATABASEBACKUPMaster.bak' WITH  FILE = 1,  MOVE N'mastlog' TO N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAMaster_1.ldf',  NOUNLOAD,  STATS = 10
GO

I recieve the following error.

Msg 3154, Level 16, State 4, Server COPLEYNEWSSQLEXPRESS, Line 1
The backup set holds a backup of a database other than the existing 'Master' dat
abase.
Msg 3013, Level 16, State 1, Server COPLEYNEWSSQLEXPRESS, Line 1

How do I restore a Master Database on SQL Express?

View Replies !

---

SQL Server 2005 Express Adv. SP2 Setup Fails To Install SQL Server Database Serices Only.
I run setup using GUI. It upgrades all components of the existing installation w/out any problems except the last component.  That is, it proceeds with the installation of SQL Server Database Serices and at the end fails to shut down the SQL Server and aborts the installation reporting the following:

"Service 'Computer_NameSQLEXPRESS' could not be stopped. Verify that you have sufficient privileges to stop system services. The error code is (16386)".

I am running Windows XP SP2 with both .NET 2.0  and .NET 3.0 installed on it.  I am logged in as a system administrator.

The most puzzling to me things are:

- the setup starts AND STOPS w/out any problems SQL Server Reporting Services and SQL Server VSS Writer (thus finding enough privileges for both).

- the setup starts the SQL Server w/out any problems (thus it finds enough privileges to START A SYSTEM SERVICE) and then fails as described above 'lucking privileges".

During installation before failing the setup displays following:

"Run as Normal User. RANU instance Shutdwon in progress: MSSQL$SQLEXPRESS".  The "normal user" puzzles me too, unless the SQL Server itself is meant here.

Any suggestions would be appreciated.  I can provide the installation log file as well.

Thanks.

 

View Replies !

---

Unattended Re-install Of SQL Server 2005 Express Fails To Re-create Database!
Hi,

I have a script that performs an unattended installation of SQL Server and works fine. 

However, if I un-install via the control panel all the files are removed apart from the databases that are created by me when SQl server was installed.  This is good and ensures data is not deleted. 

The files left over are in the following directory:
    C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData
and contains:
    MyDatabase.mdf
    MyDatabase_log.LDF

The problem I have is after performing the re-installtion of SQL server (unattended) I am unable to create a new database with the same name (in this instance called "myDatabase").

The actual files are physically there so this is the reason a new database with the same name cannot be creacted.

Again this is ok again because it ensures I cannot overwrite existing data.  However I am unable to re-attach this database to SQl server so I can continue to use it!

The question is:

How do I make this database usable again after an unattended install?  Is there a parameter I am missing?

Below are the commands I use that are passed to the installation of SQL Server as command line parameters:

#define SQL_SILENT                    "-q /passive /norebootchk /qn reboot=ReallySuppress"
#define SQL_USERNAME             "username=MyUserName"
#define SQL_COMPANYNAME      "companyname=MyCompanyName"
#define SQL_ADDLOCAL               "addlocal=ALL"
#define SQL_DISABLENETWORKPROTOCOLS   "disablenetworkprotocols=0"
#define SQL_INSTANCENAME       "instancename=MSSQLSERVER"
#define SQL_SQLAUTOSTART       "SQLAUTOSTART=1"
#define SQL_SECURITYMODE       "SECURITYMODE=SQL"
#define SQL_SAPWD                     "SAPWD=#Password#"
#define SQL_SAVESYSDB             "1"
#define SQL_USESYSDB               ""
#define SQL_INSTALLSQLDIR         ""
#define SQL_INSTALLDATADIR       ""

#define SQL_PARAMETERS    SQL_SILENT + " " + SQL_USERNAME + " " + SQL_COMPANYNAME + " " + SQL_ADDLOCAL + " " + SQL_DISABLENETWORKPROTOCOLS + " " + SQL_INSTANCENAME + " " + SQL_USESYSDB + " " + SQL_INSTALLSQLDIR + " " + SQL_INSTALLDATADIR + " " + SQL_SAVESYSDB + " " + SQL_SQLAUTOSTART + " " + SQL_SECURITYMODE + " " + SQL_SAPWD


The last four commands I have played around with but for some reason SQL Server service will not start when these are used! (This is a different issue though!).


Any advice would be gratefully accepted.

Thanks

Paul

View Replies !

---

Can't Connect To SQL Server Northwind Database
I am trying to connect to SQL 7.0 northwind database via visual studio2005. But I can't open the connection. I get an error saying remoteaccess is not allowed. But the remote access is ok. I can used the samelogin and connect to the sql server via enterprise manage.SqlConnection conn = new SqlConnection("DataSource=(sqlserver:1433);Initial Catalog=Northwind;UserID=me;Password=mypassword");The above is the string I am trying to use.Is there a way to do this in Visual studio thanks

View Replies !

---

How To Prevent Database Drops In SQL Server 2000
 

Does anyone have a good strategy or technique for preventing database drops in SQL Server 2000?  I know in 2005 DDL triggers rock, but in 2000 what can you do to audit who drops a database why keeping the same permissions intact.
 
Jason

View Replies !

---

Trying To Connect To Northwind Database, On SQL Compact Server 3.5, An Error Generated, 'The Event Log Is Full'
 

View Replies !

---

The Best Overloaded Method Match For 'System.Data.SqlClient.SqlCommand.SqlCommand Error
Hi,I'm new to ASP.NET, and am currently looking into XML.I'm trying to write XML using data from an SQL Server 2000 table.  But I seem to be getting the following error regarding the SQL Server connection:Compiler Error Message: CS1502: The best overloaded method match for 'System.Data.SqlClient.SqlCommand.SqlCommand(string, System.Data.SqlClient.SqlConnection)' has some invalid argumentsSource Error:Line 23: {
Line 24: SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
Line 25: mySqlDataAdapter.SelectCommand = new SqlCommand(queryString, connString);
Line 26: mySqlDataAdapter.Fill(myDataSet);
Line 27: return myDataSet;Source File: c:InetpubwwwrootmappingcreateGeoRSSFile.aspx.cs    Line: 25 This is my code:using System;
using System.Data;
using System.Data.SqlClient ;
using System.Configuration;
using System.Collections;
using System.Text;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Xml;

public partial class createGeoRSSFile : System.Web.UI.Page
{
protected void Page_Load(object sender, DataSet myDataSet, EventArgs e)
{
string connString = "server=SQLSERV1;database=Historical_Statistics;UID=dbuser;PWD=Password";
string queryString = "SELECT Town, PostCode, Latitude, Longitude FROM UKPostCodes";

using (SqlConnection mySqlConnection = new SqlConnection(connString))
{
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
mySqlDataAdapter.SelectCommand = new SqlCommand(queryString, connString);
mySqlDataAdapter.Fill(myDataSet);
return myDataSet;
}

// Create a new XmlTextWriter instance
XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Encoding.Unicode);

// Start writing!
writer.WriteStartDocument();
writer.WriteStartElement("item");

// Creating the <town> element
writer.WriteStartElement("town");
writer.WriteElementString("PostCode",myDataSet .Tables[1].Columns("PostCode"));
writer.WriteElementString("geo:lat",myDataSet.Tables[1].Columns("Latitude"));
writer.WriteElementString("geo:lon", myDataSet.Tables[1].Columns("Longitude"));
writer.WriteEndElement();

writer.WriteEndElement();
writer.WriteEndDocument();
writer.Flush();
writer.Close();

}
}What seems to be causing this error?Thanks. 

View Replies !

---

Attached Northwind To SQL Express But No Data In Tables
I installed Northwind sample database by running the install script within server management sudio express and the database and tables show up, but there are no records.  Once executed, it says it was successful.

Am I missing something?

 

View Replies !

---

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

View Replies !

---

Passing An SQLcommand To A Asp.net Web Service As Sqlcommand
Hi
 
Is it possible To pass an SQL command to a ASp.net web service as system.data.SQLclient.sqlcommand?
 
 
That means is ispossible to pass the actuall sql command instead of just the string?
 
If yes how can you do that??
 
Cheers
 

View Replies !

---

The Northwind Database?
I want use the the Northwind database do some example! I had installed the Visual Web Deveplopment Express Edition and installed the SQL Server 2005 Express Edition .but I build one new Website and connect the Northwind database but i can't find the it from the Database Explorer.why?

View Replies !

---

Where To Get Northwind Database
i need links from where i can  download northwind database both access and sql format thanx 

View Replies !

---

Northwind Database
I have to do an exercize where i am using Northwind sample database.  I am normally accustomed to linking to a database on another server.  Is there a way i can just include the Northwind database to my project.  In general, I need to find out how to link to the Northwind db so I can start querying and processing data.  thanks for your help

View Replies !

---

Northwind Database
sara writes "Dear Sir/Madam,
I use Sql Server 2005.I want to use Northwind Database & I have it but I could not Execute That It is the error:
Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'NorthwindCS'. No entry found with that name. Make sure that the name is entered correctly.


Would you please help me with that?

Regards,
Sara"

View Replies !

---

SQL Server Express Fails To Install
I have tried multiple times, and many hours, to install SQL Server Express without success. I have included (what I think is) the relevant log file below. I would appreciate any help.
 
Seth
 
ComponentRegister(ComponentId={1F3316BE-825B-4390-A9D2-AF3EECCAE9F6},KeyPath=<Microsoft.NetEnterpriseServers.ExceptionMessageBox,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.3042.0",State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (8C:90) [22:25:17:718]: MSCOREE not loaded loading copy from system32
MSI (s) (8C:90) [22:25:17:734]: Assembly Error:Function not defined in specified DLL.
MSI (s) (8C:90) [22:25:17:734]: Note: 1: 1935 2:  3: 0x8002802F 4:  5: CreateAssemblyNameObject 6: Microsoft.NetEnterpriseServers.ExceptionMessageBox,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.3042.0"
MSI (s) (8C:90) [22:25:17:734]: Product: Microsoft SQL Server Setup Support Files (English) -- Error 2908. The installer has encountered an unexpected error. The error code is 2908. Could not register component {1F3316BE-825B-4390-A9D2-AF3EECCAE9F6}.
MSI (s) (8C:90) [22:25:17:750]: Executing op: ComponentRegister(ComponentId={52723CBD-3400-458C-988A-4D012E6CAEDB},KeyPath=<Microsoft.SqlServer.WizardFrameworkLite,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.3042.0",State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
Error 2908. The installer has encountered an unexpected error. The error code is 2908. Could not register component {1F3316BE-825B-4390-A9D2-AF3EECCAE9F6}.
MSI (s) (8C:90) [22:25:17:765]: Assembly Error:Function not defined in specified DLL.
MSI (s) (8C:90) [22:25:17:765]: Note: 1: 1935 2: {52723CBD-3400-458C-988A-4D012E6CAEDB} 3: 0x8002802F 4:  5: CreateAssemblyNameObject 6: Microsoft.SqlServer.WizardFrameworkLite,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.3042.0"
MSI (s) (8C:90) [22:25:17:765]: Product: Microsoft SQL Server Setup Support Files (English) -- Error 1935. An error occurred during the installation of assembly 'Microsoft.SqlServer.WizardFrameworkLite,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.3042.0"'. Please refer to Help and Support for more information. HRESULT: 0x8002802F. assembly interface: , function: CreateAssemblyNameObject, component: {52723CBD-3400-458C-988A-4D012E6CAEDB}
Error 1935. An error occurred during the installation of assembly 'Microsoft.SqlServer.WizardFrameworkLite,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.3042.0"'. Please refer to Help and Support for more information. HRESULT: 0x8002802F. assembly interface: , function: CreateAssemblyNameObject, component: {52723CBD-3400-458C-988A-4D012E6CAEDB}
MSI (s) (8C:90) [22:25:17:765]: User policy value 'DisableRollback' is 0
MSI (s) (8C:90) [22:25:17:765]: Machine policy value 'DisableRollback' is 0
Action ended 22:25:17: InstallFinalize. Return value 3.
MSI (s) (8C:90) [22:25:17:812]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=925152041,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (8C:90) [22:25:17:812]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (8C:90) [22:25:17:812]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server Setup Support Files (English))
MSI (s) (8C:90) [22:25:17:812]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (8C:90) [22:25:17:812]: Executing op: ActionStart(Name=ProcessComponents,Description=Updating component registration,)
MSI (s) (8C:90) [22:25:17:812]: Executing op: ProductInfo(ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},ProductName=Microsoft SQL Server Setup Support Files (English),PackageName=SqlSupport.msi,Language=1033,Version=150997986,Assignment=1,ObsoleteArg=0,ProductIcon=ARPIcon.ico,PackageMediaPath=Setup,PackageCode={BEFE6789-8AE1-4E45-B1F7-E3D6B30A51C8},,,InstanceType=0,LUASetting=0,RemoteURTInstalls=0)
MSI (s) (8C:90) [22:25:17:812]: Executing op: ComponentUnregister(ComponentId={63E949F6-03BC-5C40-C01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:843]: Executing op: ComponentUnregister(ComponentId={63E949F6-03BC-5C40-A01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:843]: Executing op: ComponentUnregister(ComponentId={9457ED28-F3FC-BCC8-D01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:859]: Executing op: ComponentUnregister(ComponentId={98CB24AD-52FB-DB5F-B01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:875]: Executing op: ComponentUnregister(ComponentId={98CB24AD-52FB-DB5F-C01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:875]: Executing op: ComponentUnregister(ComponentId={98CB24AD-52FB-DB5F-A01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:875]: Executing op: ComponentUnregister(ComponentId={66332652-9C28-58B1-C01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:875]: Executing op: ComponentUnregister(ComponentId={66332652-9C28-58B1-A01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:875]: Executing op: ComponentUnregister(ComponentId={946F6004-4E08-BCAB-D01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:875]: Executing op: ComponentUnregister(ComponentId={97F81AF1-0E47-DC99-B01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:890]: Executing op: ComponentUnregister(ComponentId={97F81AF1-0E47-DC99-C01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:890]: Executing op: ComponentUnregister(ComponentId={97F81AF1-0E47-DC99-A01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:906]: Executing op: ComponentUnregister(ComponentId={946F6004-4E08-BCAB-E01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:906]: Executing op: ComponentUnregister(ComponentId={059D90B4-0150-436B-B9D8-B261229E6B64},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:906]: Executing op: ComponentUnregister(ComponentId={87944102-39A6-4E0E-B162-9367A083E257},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:906]: Executing op: ComponentUnregister(ComponentId={595992AD-43E5-4130-8583-98F9F357FAAC},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:906]: Executing op: ComponentUnregister(ComponentId={E4B47CED-7E97-45BC-968A-04B752B85120},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:906]: Executing op: ComponentUnregister(ComponentId={B3C58830-1820-42E5-B115-1B9A521EF462},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:906]: Executing op: ComponentUnregister(ComponentId={BC55F500-00C5-4198-ACE1-03CEABE11AE5},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:906]: Executing op: ComponentUnregister(ComponentId={F12F1390-EDC6-4D29-8814-E0E29ADCC8D8},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:906]: Executing op: ComponentUnregister(ComponentId={3E4EDF17-D7EA-4F36-8436-E81D49FFDB95},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:984]: Executing op: ComponentUnregister(ComponentId={6746C12E-607A-4270-BE87-473A8033B29C},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: ComponentUnregister(ComponentId={FD324E23-C3C3-413D-91BD-2AD180781C28},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: ComponentUnregister(ComponentId={36FB71AA-9DB6-4F0E-9D67-1A7FA3D6D71B},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: ComponentUnregister(ComponentId={6EF46374-C444-4E0A-AE9B-D54E75BE824F},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: ComponentUnregister(ComponentId={63B0B8BC-D916-4256-A03A-D03C8FC724F2},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: ComponentUnregister(ComponentId={3CE74AA8-ADD6-41CF-AE3B-C261504386D4},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: ComponentUnregister(ComponentId={053A9093-3FB8-4EE0-ADF5-9A6690561F82},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: ComponentUnregister(ComponentId={715A71E2-375D-4FE0-BB44-1CDABB31973D},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: ComponentUnregister(ComponentId={ECC96BE9-D40C-4EF3-B815-1A455D8A793F},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: ComponentUnregister(ComponentId={C3603B13-8645-4D5D-885D-62072C95577D},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=0)
MSI (s) (8C:90) [22:25:18:015]: Error in rollback skipped. Return: 5
MSI (s) (8C:90) [22:25:18:281]: No System Restore sequence number for this installation.
MSI (s) (8C:90) [22:25:18:281]: Unlocking Server
MSI (s) (8C:90) [22:25:18:281]: PROPERTY CHANGE: Deleting UpdateStarted property. Its current value is '1'.
Action ended 22:25:18: INSTALL. Return value 3.
Property(S): ProductCode = {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
Property(S): ProductLanguage = 1033
Property(S): Manufacturer = Microsoft Corporation
Property(S): DesktopFolder = C:Documents and SettingsAll UsersDesktop
Property(S): ProductVersion = 9.00.3042.00
Property(S): UpgradeCode = {3A91FA19-A197-467C-850F-0AFE90899371}
Property(S): SqlPatchLevel = 9.2.3042
Property(S): ReleaseProductVersion = 9.00.3042.00
Property(S): ARPPRODUCTICON = ARPIcon.ico
Property(S): ARPHELPLINK = http://go.microsoft.com/fwlink/?LinkId=52154
Property(S): DefaultUIFont = Tahoma8
Property(S): VersionNT = 501
Property(S): ALLUSERS = 1
Property(S): ARPNOMODIFY = 1

View Replies !

---

SQL Server Express Fails To Install
I have tried several times to install SSEE and SSEE
with Advanced Services.  Each time it fails early in the
installation.  I am running XP SP2 with 1GB memory.  There
was no previous install of SSEE.  The error reads, "SQL Server
Setup unexpectedly fialed. For more information, review the Setup
summary log file...".  The log file follows:



Microsoft SQL Server 2005 Setup beginning at Thu May 04 20:58:25 2006

Process ID      : 2000

c:a9b2b8f496f31ae4f8a6setup.exe Version: 2005.90.2047.0

Running: LoadResourcesAction at: 2006/4/4 20:58:24

Complete: LoadResourcesAction at: 2006/4/4 20:58:24, returned true

Running: ParseBootstrapOptionsAction at: 2006/4/4 20:58:24

Loaded DLL:c:a9b2b8f496f31ae4f8a6xmlrw.dll Version:2.0.3609.0

Complete: ParseBootstrapOptionsAction at: 2006/4/4 20:58:25, returned false

Error: Action "ParseBootstrapOptionsAction" failed during execution.  Error information reported during run:

Could not parse command line due to datastore exception.

  Source File Name: utillibpersisthelpers.cpp

Compiler Timestamp: Wed Oct 26 16:38:20 2005

     Function Name: writeEncryptedString

Source Line Number: 124

----------------------------------------------------------

writeEncryptedString() failed

      Source File Name: utillibpersisthelpers.cpp

    Compiler Timestamp: Wed Oct 26 16:38:20 2005

         Function Name: writeEncryptedString

    Source Line Number: 123

    ----------------------------------------------------------

            Error Code: -2146893813

Windows Error Text: Key not valid for use in specified state.



  Source File Name: cryptohelpercryptsameusersamemachine.cpp

Compiler Timestamp: Wed Oct 26 16:37:25 2005

     Function Name: sqls::CryptSameUserSameMachine::ProtectData

Source Line Number: 50



2148073483

Could not skip Component update due to datastore exception.

  Source File Name: datastorecachedpropertycollection.cpp

Compiler Timestamp: Wed Oct 26 16:37:20 2005

     Function Name: CachedPropertyCollection::findProperty

Source Line Number: 130

----------------------------------------------------------

Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "2000"} in cache

      Source File Name: datastorepropertycollection.cpp

    Compiler Timestamp: Wed Oct 26 16:37:21 2005

         Function Name: SetupBootstrapOptionsScope.InstallMediaPath

    Source Line Number: 44

    ----------------------------------------------------------

    No collector registered for scope: "SetupBootstrapOptionsScope"

Running: ValidateWinNTAction at: 2006/4/4 20:58:25

Complete: ValidateWinNTAction at: 2006/4/4 20:58:25, returned true

Running: ValidateMinOSAction at: 2006/4/4 20:58:25

Complete: ValidateMinOSAction at: 2006/4/4 20:58:25, returned true

Running: PerformSCCAction at: 2006/4/4 20:58:25

Complete: PerformSCCAction at: 2006/4/4 20:58:25, returned true

Running: ActivateLoggingAction at: 2006/4/4 20:58:25

Error: Action "ActivateLoggingAction" threw an exception during execution.  Error information reported during run:

Datastore exception while trying to write logging properties.

  Source File Name: datastorecachedpropertycollection.cpp

Compiler Timestamp: Wed Oct 26 16:37:20 2005

     Function Name: CachedPropertyCollection::findProperty

Source Line Number: 130

----------------------------------------------------------

Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache

      Source File Name: datastorepropertycollection.cpp

    Compiler Timestamp: Wed Oct 26 16:37:21 2005

         Function Name: SetupStateScope.primaryLogFiles

    Source Line Number: 44

    ----------------------------------------------------------

    No collector registered for scope: "SetupStateScope"

00DECFC0Unable to proceed with setup, there was a command line parsing error. : 2

        Error Code: 0x80070002 (2)

Windows Error Text: The system cannot find the file specified.



  Source File Name: datastorepropertycollection.cpp

Compiler Timestamp: Wed Oct 26 16:37:21 2005

     Function Name: SetupBootstrapOptionsScope.InstallMediaPath

Source Line Number: 44



Class not registered.

View Replies !

---

SQL Server Express Fails During Installation
Installing SQL Server Express on Vista, directly after the "Compatibility Issues" dialogue, I get the error:


SQL Server setup unexpectedly failed. For more information, review the setup summary log file in %Program Files%Microsoft SQL Server90Setup BootstrapLOGSummary.txt

This file mentioned is virtually blank, but the Files subdirectory of LOG contains a setup log which contains:


Microsoft SQL Server 2005 Setup beginning at Sat Jun 23 12:44:49 2007
Process ID      : 5068
C:UsersdajaboDesktop8c1e33f5803c0da83setup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2007/5/23 12:44:49
Complete: LoadResourcesAction at: 2007/5/23 12:44:49, returned true
Running: ParseBootstrapOptionsAction at: 2007/5/23 12:44:49
Loaded DLL:C:UsersdajaboDesktop8c1e33f5803c0da83xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/5/23 12:44:49, returned falseError: Action "ParseBootstrapOptionsAction" failed during execution.  Error information reported during run:Could not parse command line due to datastore exception.
  Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Oct 26 16:38:20 2005
     Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
      Source File Name: utillibpersisthelpers.cpp
    Compiler Timestamp: Wed Oct 26 16:38:20 2005
         Function Name: writeEncryptedString
    Source Line Number: 123
    ----------------------------------------------------------
            Error Code: 0x80070005 (5)
Windows Error Text: Access is denied.

  Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Wed Oct 26 16:37:25 2005
     Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50

5
Could not skip Component update due to datastore exception.
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "5068"} in cache
      Source File Name: datastorepropertycollection.cpp
    Compiler Timestamp: Wed Oct 26 16:37:21 2005
         Function Name: SetupBootstrapOptionsScope.InstallMediaPath
    Source Line Number: 44
    ----------------------------------------------------------
    No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/5/23 12:44:49
Complete: ValidateWinNTAction at: 2007/5/23 12:44:49, returned true
Running: ValidateMinOSAction at: 2007/5/23 12:44:49
Complete: ValidateMinOSAction at: 2007/5/23 12:44:49, returned true
Running: PerformSCCAction at: 2007/5/23 12:44:49
Complete: PerformSCCAction at: 2007/5/23 12:44:49, returned true
Running: ActivateLoggingAction at: 2007/5/23 12:44:49
Error: Action "ActivateLoggingAction" threw an exception during execution.  Error information reported during run:
Datastore exception while trying to write logging properties.
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
      Source File Name: datastorepropertycollection.cpp
    Compiler Timestamp: Wed Oct 26 16:37:21 2005
         Function Name: SetupStateScope.primaryLogFiles
    Source Line Number: 44
    ----------------------------------------------------------
    No collector registered for scope: "SetupStateScope"
038DCFACUnable to proceed with setup, there was a command line parsing error. : 2
        Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

  Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
     Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.

Can anyone help?

View Replies !

---

SQL Server Express Fails To Install
 Hi, there!

I tried to install SSE 2005 and I got the following message:

SQL Server Setup unexpectedly failed. For more information, review the Setup summary log file in...

The log file has the content below. Can someone help me to fix this problem, please?

I have no idea about what is going on!

Thank you for the help!

Microsoft SQL Server 2005 Setup beginning at Sun Jul 23 12:52:54 2006
Process ID      : 2420
c:97830b63babac24aedb48a81be43976asetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/6/23 12:52:53
Complete: LoadResourcesAction at: 2006/6/23 12:52:53, returned true
Running: ParseBootstrapOptionsAction at: 2006/6/23 12:52:53
Loaded DLL:c:97830b63babac24aedb48a81be43976axmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/6/23 12:52:54, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution.  Error information reported during run:
Could not parse command line due to datastore exception.
  Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
     Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
   Source File Name: utillibpersisthelpers.cpp
 Compiler Timestamp: Fri Jul 29 01:13:55 2005
      Function Name: writeEncryptedString
 Source Line Number: 123
 ----------------------------------------------------------
         Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

  Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
     Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "2420"} in cache
   Source File Name: datastorepropertycollection.cpp
 Compiler Timestamp: Fri Jul 29 01:13:50 2005
      Function Name: SetupBootstrapOptionsScope.InstallMediaPath
 Source Line Number: 44
 ----------------------------------------------------------
 No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2006/6/23 12:52:54
Complete: ValidateWinNTAction at: 2006/6/23 12:52:54, returned true
Running: ValidateMinOSAction at: 2006/6/23 12:52:54
Complete: ValidateMinOSAction at: 2006/6/23 12:52:54, returned true
Running: PerformSCCAction at: 2006/6/23 12:52:54
Complete: PerformSCCAction at: 2006/6/23 12:52:54, returned true
Running: ActivateLoggingAction at: 2006/6/23 12:52:54
Error: Action "ActivateLoggingAction" threw an exception during execution.  Error information reported during run:
Datastore exception while trying to write logging properties.
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
   Source File Name: datastorepropertycollection.cpp
 Compiler Timestamp: Fri Jul 29 01:13:50 2005
      Function Name: SetupStateScope.primaryLogFiles
 Source Line Number: 44
 ----------------------------------------------------------
 No collector registered for scope: "SetupStateScope"
00E2CFC4Unable to proceed with setup, there was a command line parsing error. : 2
        Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

  Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
     Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2420"} in cache
   Source File Name: datastorepropertycollection.cpp
 Compiler Timestamp: Fri Jul 29 01:13:50 2005
      Function Name: SetupBootstrapOptionsScope.HostSetup
 Source Line Number: 44
 ----------------------------------------------------------
 No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

View Replies !

---

SQL Server And Express Install Fails
I have a server version of SQL Server, but I need a local SQL Server Express version as well for dev.
 
When I install express and the full set of SQL Server management tools, I can see my Express instance in configuration manager, but Management Studio says the instance is broken. I have tried both SA and windows authentication. I turned on all the protocols in both server and client, but no luck.
 
The error returned is Error 26 Error locating server instance specified, but I am selecting the instance from the dropdown box, so it is not a typo. I have tried quite a few variations with no success.
 
The install is on XP-pro
 
Thanks,
 
Michael

View Replies !

---

SQL Server Express Fails To Install
I'm experiencing a problem installing SQL Server Express 2005. I thought I had the same problem as Tom from a recent thread but his error file is quite different from mine. The Visual Basic Express
package properly installed everything except SQL Server. I've run
it many times, but the service fails
to start. I also downloaded the separate installation package for
SQL Server Express and ran it several times, which also failed.
It gets to a point where the services are installed, but when I try to
manually start the SQL service it says that the service started and
then stopped. The event
viewer shows this error:

Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.

The error log is:

2006-05-02 16:10:58.07 Server Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
Apr 14 2006 01:12:25
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

2006-05-02 16:10:58.08 Server (c) 2005 Microsoft Corporation.
2006-05-02 16:10:58.08 Server All rights reserved.
2006-05-02 16:10:58.09 Server Server process ID is 816.
2006-05-02 16:10:58.09 Server Logging SQL Server messages in file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2006-05-02 16:10:58.09 Server This instance of SQL Server last reported using a process ID of 2748 at 5/2/2006 4:10:29 PM (local) 5/2/2006 9:10:29 PM (UTC). This is an informational message only; no user action is required.
2006-05-02 16:10:58.15 Server Registry startup parameters:
2006-05-02 16:10:58.15 Server -d c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2006-05-02 16:10:58.15 Server -e c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2006-05-02 16:10:58.16 Server -l c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2006-05-02 16:10:58.28 Server Error: 17311, Severity: 16, State: 1.
2006-05-02 16:10:58.28 Server SQL Server is terminating because of fatal exception c000001d. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).
2006-05-02 16:10:58.30 Server Using 'dbghelp.dll' version '4.0.5'
2006-05-02 16:10:58.36 Server **Dump thread - spid = 0, PSS = 0x00000000, EC = 0x00000000
2006-05-02 16:10:58.36 Server ***Stack Dump being sent to c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0005.txt
2006-05-02 16:10:58.36 Server * *******************************************************************************
2006-05-02 16:10:58.36 Server *
2006-05-02 16:10:58.36 Server * BEGIN STACK DUMP:
2006-05-02 16:10:58.36 Server * 05/02/06 16:10:58 spid 0
2006-05-02 16:10:58.36 Server *
2006-05-02 16:10:58.36 Server * ex_handle_except encountered exception C000001D - Server terminating
2006-05-02 16:10:58.36 Server *
2006-05-02 16:10:58.36 Server *
2006-05-02 16:10:58.36 Server * MODULE BASE END SIZE
2006-05-02 16:10:58.36 Server * sqlservr 01000000 02BCEFFF 01bcf000
2006-05-02 16:10:58.36 Server * ntdll 7C900000 7C9AFFFF 000b0000
2006-05-02 16:10:58.36 Server * kernel32 7C800000 7C8F3FFF 000f4000
2006-05-02 16:10:58.36 Server * MSVCR80 78130000 781CAFFF 0009b000
2006-05-02 16:10:58.36 Server * msvcrt 77C10000 77C67FFF 00058000
2006-05-02 16:10:58.37 Server * MSVCP80 7C420000 7C4A6FFF 00087000
2006-05-02 16:10:58.37 Server * ADVAPI32 77DD0000 77E6AFFF 0009b000
2006-05-02 16:10:58.37 Server * RPCRT4 77E70000 77F00FFF 00091000
2006-05-02 16:10:58.37 Server * USER32 77D40000 77DCFFFF 00090000
2006-05-02 16:10:58.37 Server * GDI32 77F10000 77F56FFF 00047000
2006-05-02 16:10:58.37 Server * CRYPT32 77A80000 77B13FFF 00094000
2006-05-02 16:10:58.37 Server * MSASN1 77B20000 77B31FFF 00012000
2006-05-02 16:10:58.37 Server * Secur32 77FE0000 77FF0FFF 00011000
2006-05-02 16:10:58.37 Server * MSWSOCK 71A50000 71A8EFFF 0003f000
2006-05-02 16:10:58.37 Server * WS2_32 71AB0000 71AC6FFF 00017000
2006-05-02 16:10:58.37 Server * WS2HELP 71AA0000 71AA7FFF 00008000
2006-05-02 16:10:58.37 Server * USERENV 769C0000 76A72FFF 000b3000
2006-05-02 16:10:58.37 Server * opends60 333E0000 333E6FFF 00007000
2006-05-02 16:10:58.37 Server * NETAPI32 5B860000 5B8B3FFF 00054000
2006-05-02 16:10:58.37 Server * SHELL32 7C9C0000 7D1D4FFF 00815000
2006-05-02 16:10:58.37 Server * SHLWAPI 77F60000 77FD5FFF 00076000
2006-05-02 16:10:58.37 Server * OCMAPIHK 10000000 1000CFFF 0000d000
2006-05-02 16:10:58.37 Server * comctl32 773D0000 774D1FFF 00102000
2006-05-02 16:10:58.37 Server * comctl32 5D090000 5D126FFF 00097000
2006-05-02 16:10:58.37 Server * psapi 76BF0000 76BFAFFF 0000b000
2006-05-02 16:10:58.37 Server * instapi 48060000 48069FFF 0000a000
2006-05-02 16:10:58.37 Server * sqlevn70 4F610000 4F7A3FFF 00194000
2006-05-02 16:10:58.37 Server * dbghelp 03000000 03112FFF 00113000
2006-05-02 16:10:58.37 Server *
2006-05-02 16:10:58.37 Server * Edi: 0075C528: 000E1068 00000000 00000000 00000000 0075C548 00000000
2006-05-02 16:10:58.37 Server * Esi: 00000000:
2006-05-02 16:10:58.37 Server * Eax: 0075C40C: 000042AC 00000000 00000000 7C81EB33 00000000 0000000C
2006-05-02 16:10:58.37 Server * Ebx: 0000003F:
2006-05-02 16:10:58.38 Server * Ecx: 0075CA7C: 00000000 0001001F 00000000 00000000 00000000 00000000
2006-05-02 16:10:58.38 Server * Edx: 0000003D:
2006-05-02 16:10:58.38 Server * Eip: 7C81EB33: 10C2C95E 0FFF8500 FED0E68E FC558BFF 0F0C5589 7D8B16B7
2006-05-02 16:10:58.38 Server * Ebp: 0075C45C: 0075C4A0 02187744 000042AC 00000000 00000000 00000000
2006-05-02 16:10:58.38 Server * SegCs: 0000001B:
2006-05-02 16:10:58.38 Server * EFlags: 00080246:
2006-05-02 16:10:58.38 Server * Esp: 0075C408: 00000000 000042AC 00000000 00000000 7C81EB33 00000000
2006-05-02 16:10:58.38 Server * SegSs: 00000023:
2006-05-02 16:10:58.38 Server * *******************************************************************************
2006-05-02 16:10:58.38 Server * -------------------------------------------------------------------------------
2006-05-02 16:10:58.38 Server * Short Stack Dump
2006-05-02 16:10:58.50 Server 7C81EB33 Module(kernel32+0001EB33)
2006-05-02 16:10:58.50 Server 02187744 Module(sqlservr+01187744)
2006-05-02 16:10:58.51 Server 0218B600 Module(sqlservr+0118B600)
2006-05-02 16:10:58.51 Server 0218B1AD Module(sqlservr+0118B1AD)
2006-05-02 16:10:58.51 Server 023F4109 Module(sqlservr+013F4109)
2006-05-02 16:10:58.51 Server 7C862CD3 Module(kernel32+00062CD3)
2006-05-02 16:10:58.57 Server 7C83AA6B Module(kernel32+0003AA6B)
2006-05-02 16:10:58.60 Server Stack Signature for the dump is 0xDF483EDE
2006-05-02 16:10:59.33 Server External dump process return code 0x20000001.
External dump process returned no errors.

Any thoughts? Thanks.

View Replies !

---

Installing The Northwind Database
Hi I have just started using the  SQL Server 2005 Express Edition and wondering how to install the InstNwnd.sql from the sql file.  I can't find any way to insert the database
 
Any help would be very appreciated
Thanks

View Replies !

---

Northwind Database Question
I'm installing Northwind Database onto Local Computer. The Computer's Name is (Localhost)The Installation Menu is asking to for the [Enter Name of the (Server)] "______________________" Am I correct in assuming  to Enter  Localhost - for the [Enter Name of the (Sever)]. "___Localhost_____" Can someone comfirm as to whether this is correct or not... Thank You.

View Replies !

---

No Northwind Database In My MSDE...
OK

I've loaded MSDE and its running OK

I've run config.exe to install the sample .net databases,

......but I cannot find northwind or anyother db on the server!


I've never done any db work befor so may be I'm being a bit of a tit!!! sorry in advance if i am...

stuart

View Replies !

---

Northwind Database Extra SQL Needs
I have asked for the following questions and I need your advises.Utilizing the Northwind database suppied with SQL Server, create SQL tosolve each of the exercises listed.1.I want to contact all customers who have received over $1,000 indiscounts on orders this year. Give me the name and phone number of theperson to contact at the customers site. Also, list the orders wherethe total discount was greater than $100. Remember, discount is apercentage of the price.2.Give me a list of suppliers and products where we do not have thestock on hand to fill the orders to be shipped. List out the customerand order information for each of the products involved.3.Give me a list of all orders that were shipped after the requireddate for the week of Jan 7, 2001. I want to know the name of theemployees that were responsible for the orders.4.We are having a golf tournament and I need some prizes. Give me alist of the top 5 shippers by dollar amount in the last year.5.Some customers are taking us for a ride on shipping. Give me a listof customers and the orders involved where more than ½ of their ordersare being shipped to a region other than their home region.Please advise ...thanks a lot

View Replies !

---

Can't Access Northwind Database
I'm using XP Pro and I have the Developer's version of SQL Server installed. I downloaded SQLXML 3.0 and created a virtual directory named nwind.

I then entered the following on my IE browser:

http://<IIServer>/nwind?sql=SELECT FirstName, LastName FROM Employees FOR XML AUTO&root=root

the result is:
"The page cannot be displayed..."


I'd appreciate any help.

Thanks,
Pat

View Replies !

---

What Happen To My Sql Server 2000
 im using Vb2005 and Sql server 2000.when i open enterprise manager n try to make the connection, then i got error msg like this" A connection could not be established to (LOCAL)Reason: SQL server does not exists or access denied.ConnectionOpen (Connect()) ..Please verify SQL Server is running and check your SQK Server registration properties (by right-clicking on the (LOCAL) node) and try again" When i open sql server service manager and try to start my sql, its do not change from stop to start.. and one more thing is, if  i plan to use sql server 2005..do i need to uninstall sql server 2000? 

View Replies !

---

SQL Server Express 2005 Fails To Install
I am trying to install MS SQL Server Express but the installation always fails. I have copied the summary log below and can provide more details if you require. Web Developer and C# Express install OK.

I have been trying to install this for around 2 weeks now with no luck ... I even had the PC formatted and rebuilt but the install still fails. If it installed and worked before, i cannot understand why it doesn't work now. The summary log is provided below:


Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version      : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time            : Thu Jun 22 10:42:08 2006
 
GLKD2396800 : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
Machine         : GLKD2396800
Product         : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine         : GLKD2396800
Product         : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine         : GLKD2396800
Product         : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine         : GLKD2396800
Product         : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_MSXML6_1.log
--------------------------------------------------------------------------------
Machine         : GLKD2396800
Product         : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine         : GLKD2396800
Product         : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLNCLI_2.log
--------------------------------------------------------------------------------
Machine         : GLKD2396800
Product         : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_MSXML6_2.log
--------------------------------------------------------------------------------
Machine         : GLKD2396800
Product         : SQL Server Database Services
Error           : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
--------------------------------------------------------------------------------
Machine         : GLKD2396800
Product         : SQL Server Database Services
Error           : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
--------------------------------------------------------------------------------
Machine         : GLKD2396800
Product         : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install         : Failed
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQL.log
Last Action     : InstallFinalize
Error String    : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is  (1067) The process terminated unexpectedly.
Error Number    : 29503
--------------------------------------------------------------------------------
Machine         : GLKD2396800
Product         : Microsoft SQL Server 2005 Tools Express Edition
Product Version : 9.00.1399.06
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Tools.log
--------------------------------------------------------------------------------

 SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.


Time            : Thu Jun 22 10:46:19 2006


List of log files:
 C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Core(Local).log
 C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLSupport_1.log
 C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLNCLI_1.log
 C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SqlWriter_1.log
 C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_MSXML6_1.log
 C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLSupport_2.log
 C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLNCLI_2.log
 C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_MSXML6_2.log
 C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQL.log
 C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Tools.log
 C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Datastore.xml
 C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_.NET Framework 2.0.log
 C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SNAC.log
 C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Core.log
 C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
 C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Support.log
 C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SCC.log
 c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG

View Replies !

---

Install SQL Server Express 2005 Fails: .NET 2.0?
In C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFiles SQLSetup0001_MYSERVER_Core(Local).log I have the following error:
=============
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 3
        Error Code: 0x80070003 (3)
Windows Error Text: The system cannot find the path specified.
  Source File Name: sqlchainingsqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
     Function Name: sqls::ReportChainingResults:erform
Source Line Number: 3521
---- Context -----------------------------------------------
sqls::HostSetupPackageInstallerSynch:ostCommit
sqls::HighlyAvailablePackage:reInstall
led due to cancel code received from cancel source: 29539
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_MYSERVER_.NET Framework 2.0.log" to cab file : "C:SQLEXPRsetup.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2008/2/18 18:14:45
Message pump returning: 3
============
The file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_MYSERVER_.NET Framework 2.0.log" does not exist.
 
What I've tried so far:
1. Using Add/Remove Programs, uninstall the following:
  A. Microsoft SQL Server Native Client
  B. Microsoft SQL Server Setup Support Files (English)
  C. Microsoft SQL Server VSS Writer
  D. Microsoft .NET Framework 2.0 (based on a post elsewhere that this resolved someone else problem)
2. Verified that the following Registry Keys were removed:
  A. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer
  B. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server
  C. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Native Client
(If they were not, I deleted them manually.)

When I was asked to help, the SSE installation had already been attempted 4 times. Part of their resolution attempts had been to install .NET 3.0, but I have not yet re-installed that.
It appears that .NET is still the culprit. Here is some information on the system:
Host Name:                 MYSERVER
OS Name:                   Microsoft(R) Windows(R) Server 2003, Standard Edition
OS Version:                5.2.3790 Service Pack 2 Build 3790
OS Manufacturer:           Microsoft Corporation
OS Configuration:          Standalone Server
OS Build Type:             Multiprocessor Free
Registered Owner:          User
Registered Organization:   MY LLC
Product ID:                69712-OEM-4411902-02111
Original Install Date:     8/30/2007, 3:29:16 PM
System Up Time:            0 Days, 2 Hours, 1 Minutes, 56 Seconds
System Manufacturer:       Dell Computer Corporation
System Model:              PowerEdge 840
System Type:               X86-based PC
Processor(s):              2 Processor(s) Installed.
                           [01]: x86 Family 6 Model 15 Stepping 2 GenuineIntel ~2133 Mhz
                           [02]: x86 Family 6 Model 15 Stepping 2 GenuineIntel ~2133 Mhz
BIOS Version:              DELL   - 1
Windows Directory:         C:WINDOWS
System Directory:          C:WINDOWSsystem32
Boot Device:               DeviceHarddiskVolume2
System Locale:             en-us;English (United States)
Input Locale:              en-us;English (United States)
Time Zone:                 (GMT-07:00) Mountain Time (US & Canada)
Total Physical Memory:     4,095 MB
Available Physical Memory: 3,626 MB
Page File: Max Size:       5,976 MB
Page File: Available:      5,665 MB
Page File: In Use:         311 MB
Page File Location(s):     C:pagefile.sys
Domain:                    WORKGROUP
Logon Server:              \MYSERVER
Hotfix(s):                 79 Hotfix(s) Installed.
                           [01]: File 1
                           [02]: File 1
                           [03]: File 1
                           [04]: File 1
                           [05]: File 1
                           [06]: File 1
                           [07]: File 1
                           [08]: File 1
                           [09]: File 1
                           [10]: File 1
                           [11]: File 1
                           [12]: File 1
                           [13]: File 1
                           [14]: File 1
                           [15]: File 1
                           [16]: File 1
                           [17]: File 1
                           [18]: File 1
                           [19]: File 1
                           [20]: File 1
                           [21]: File 1
                           [22]: File 1
                           [23]: File 1
                           [24]: File 1
                           [25]: File 1
                           [26]: File 1
                           [27]: File 1
                           [28]: File 1
                           [29]: File 1
                           [30]: File 1
                           [31]: File 1
                           [32]: File 1
                           [33]: File 1
                           [34]: File 1
                           [35]: File 1
                           [36]: File 1
                           [37]: Q147222
                           [38]: KB933854 - QFE
                           [39]: Q936181
                           [40]: IDNMitigationAPIs - Update
                           [41]: NLSDownlevelMapping - Update
                           [42]: KB925398_WMP64
                           [43]: KB937143-IE7 - Update
                           [44]: KB938127-IE7 - Update
                           [45]: KB939653-IE7 - Update
                           [46]: KB942615-IE7 - Update
                           [47]: KB944533-IE7 - Update
                           [48]: KB921503 - Update
                           [49]: KB924667-v2 - Update
                           [50]: KB925876 - Update
                           [51]: KB925902 - Update
                           [52]: KB926122 - Update
                           [53]: KB927891 - Update
                           [54]: KB929123 - Update
                           [55]: KB930178 - Update
                           [56]: KB931784 - Update
                           [57]: KB932168 - Update
                           [58]: KB933360 - Update
                           [59]: KB933729 - Update
                           [60]: KB933854 - Update
                           [61]: KB935839 - Update
                           [62]: KB935840 - Update
                           [63]: KB936021 - Update
                           [64]: KB936357 - Update
                           [65]: KB936782 - Update
                           [66]: KB937143 - Update
                           [67]: KB938127 - Update
                           [68]: KB941202 - Update
                           [69]: KB941568 - Update
                           [70]: KB941569 - Update
                           [71]: KB941644 - Update
                           [72]: KB942763 - Update
                           [73]: KB943055 - Update
                           [74]: KB943460 - Update
                           [75]: KB943485 - Update
                           [76]: KB944653 - Update
                           [77]: KB946026 - Update
                           [78]: KB948496 - Update
                           [79]: XpsEPSC

My next thought is to try this: 
http://groups.google.com/group/microsoft.public.windowsupdate/msg/4d76de7769d04493 
Does anyone have any better suggestions?
Is the .NET Framework the likely problem here?
 
TIA,
Brian

View Replies !

---

SQL Express Server Fails To Install During Extraction
 

I've tried downloading SQL Server Express several times and installing. Every time it fails during extraction. I have a Vista machine with .NET Framework 3.0 already installed. I'm using MS Expression Web, MS Access, and have also downloaded and installed MS Visual Web Developer 2008 Express Edition. Why can't I even get SQL Server Express to extract from the downloaded file?

View Replies !

---

SQL Server Express 2005 Fails To Install
I am trying to install MS SQL Server Express but the installation always fails. I have copied the summary log below and can provide more details if you require.

Hardware:P4 1.7G CPU,30G HDD space,1G memory


Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version      : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time            : Fri Jul 21 15:08:24 2006
 
Machine         : YANGNAN
Product         : Microsoft SQL Server 安装程åº?支æŒ?文件(英语)
Product Version : 9.00.2047.00
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine         : YANGNAN
Product         : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine         : YANGNAN
Product         : Microsoft SQL Server VSS 编写器
Product Version : 9.00.2047.00
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine         : YANGNAN
Product         : MSXML 6.0 分æž?程åº?
Product Version : 6.00.3883.15
Install         : Successful
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_MSXML6_1.log
--------------------------------------------------------------------------------
Machine         : YANGNAN
Product         : SQL Server Database Services
Error           : The computer running SQL Server Setup does not meet minimum system requirements for this SQL Server release.Microsoft SQL Server is not supported on this operating system. For details, see Hardware and Software Requirements in the readme or in SQL Server Books Online.
--------------------------------------------------------------------------------
Machine         : YANGNAN
Product         : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install         : Failed
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SQL.log
Last Action     : DetectSKUOS
Error String    : The computer running SQL Server Setup does not meet minimum system requirements for this SQL Server release.Microsoft SQL Server is not supported on this operating system. For details, see Hardware and Software Requirements in the readme or in SQL Server Books Online.
Error Number    : 28018
--------------------------------------------------------------------------------

View Replies !

---

SQL Server Express Edition Fails To Install On Windows Server 2003, R2, SP2
I cant figure out why this is happening.. its a fresh 2003 x64 R2 sp2
server, during the installation of the SQL Server Database Services the server hangs
and displays Setting File Security.  I let the install run for over 45 mins and it still hangs... the log file is useless..
i cant find any clues as to why ...


any thoughts..

View Replies !

---

Does Anyone Have Northwind Database File For SQLExpress ?
Hello.Does anyone have Northwind database file for SQLExpress ? I really need it for learning purpose now.Thanks in advanced.

View Replies !

---

SQL Northwind End To End Database Solutions (examples)
Does anyone know where I can find a Northwind end to end database solutions (examples) written in ASP.NET (VB). I would like to reverse engineer this project to learn more about ASP.NET?

Thanks.

View Replies !

---

Does The MSDE2000 Sp3a Come With Northwind Database
I just downloaded and installed MSDE2000 sp3a for winform and asp.net
quickstart tutorial. But I found it has no sample database such as pubs
and northwind. It used to have these databases. At least in last September
when .Net web Matrix came out.

If this is the case, can someone tell me where to get the sql scripts
to create Northwind database in MSDE?
Becasue the winform tutorial uses this database.

Thanks in advance!

Lei Xu

View Replies !

---

NorthWind Database Practice Questions
HiDoes anyone know of a "test bank" for the Northwind (or any otherfreely available ) database? I'd like to go through some practicequestions to sharpen my SQL skills.thankschet

View Replies !

---

SQl Server 2005 Express Edition Install Fails
 
Hii
 
I am trying to setup Sql server 2005 express edition but ı getting an error message that cannot install. The Logfile is below. 
 
Thanks...
 
Cagri
 
 
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version      : Home Edition  (Build 6000)
Time            : Tue Sep 04 22:44:28 2007
 
Machine         : QUIETUS-PC
Product         : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install         : Successful
Log File        : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_QUIETUS-PC_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine         : QUIETUS-PC
Product         : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install         : Successful
Log File        : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_QUIETUS-PC_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine         : QUIETUS-PC
Product         : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install         : Successful
Log File        : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_QUIETUS-PC_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine         : QUIETUS-PC
Product         : SQL Server Database Services
Error           : SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'QUIETUS-PCSQLServer2005MSSQLUser$QUIETUS-PC$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.
--------------------------------------------------------------------------------
Machine         : QUIETUS-PC
Product         : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install         : Failed
Log File        : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_QUIETUS-PC_SQL.log
Last Action     : InstallFinalize
Error String    : SQL Server Setup failed to execute a command for server configuration. The error was {Microsoft}{SQL Native Client}{SQL Server}Windows NT user or group 'QUIETUS-PCSQLServer2005MSSQLUser$QUIETUS-PC$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.
Error Number    : 29521

--------------------------------------------------------------------------------

View Replies !

---

SQL Server 2005 Express SP2 On Vista RTM Fails To Install
When I was trying to SQL Server 2005 Express SP2 (November CTP) on Vista RTM, setup failed on the Database Services component with the following log messages:

SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connectionsService MSSQL$SQLEXPRESS started at Sat Nov 18 09:21:28 2006SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connectsqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'.sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL Native Client][SQL Server]Changed language setting to us_english.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'default language' changed from 0 to 0. Run the RECONFIGURE statement to install.sqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'default full-text language' changed from 1033 to 1033. Run the RECONFIGURE statement to install.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.SQL_ERROR (-1) in OdbcStatement::execute_batchsqlstate=42000, level=11, state=1, native_error=15401, msg=[Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' not found. Check the name again.sqlstate=42000, level=16, state=1, native_error=15007, msg=[Microsoft][SQL Native Client][SQL Server]'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' is not a valid login or you do not have permission.        Error Code: 0x80073c29 (15401)Windows Error Text:   Source File Name: libodbc_statement.hCompiler Timestamp: Wed Aug  2 16:21:02 2006     Function Name: OdbcStatement::execute_batch@CnfgSQL@80Source Line Number: 91---- Context -----------------------------------------------Connecting to SQL ServerExecuteSqlCommandsUSE [master      ]<Started SQL statement: Sat Nov 18 09:21:28 2006>declare @ServerName nvarchar(255) if not exists (select * from sysservers) begin select @ServerName = Convert(nvarchar(255), SERVERPROPERTY(N'ServerName')) execute sys.sp_addserver @ServerName, local end<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>ALTER DATABASE model SET RECOVERY SIMPLE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sp_configure N'show advanced options', 1 RECONFIGURE WITH OVERRIDE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>DECLARE @Name AS nvarchar(128), @LangID AS smallint SELECT @Name=name, @LangID=langid FROM syslanguages WHERE lcid=1033 EXEC sp_defaultlanguage N'sa', @Name EXEC sp_configure N'default language', @LangID EXEC sp_configure N'default full-text language', 1033 RECONFIGURE WITH OVERRIDE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sp_configure N'show advanced options', 0 RECONFIGURE WITH OVERRIDE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sys.sp_grantlogin N'BUILTINAdministrators' EXEC sys.sp_addsrvrolemember N'BUILTINAdministrators', N'sysadmin'<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sys.sp_grantlogin N'NT AUTHORITYSYSTEM' EXEC sys.sp_addsrvrolemember N'NT AUTHORITYSYSTEM', N'sysadmin'<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sys.sp_grantlogin N'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' EXEC sys.sp_addsrvrolemember N'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS', N'sysadmin'Originial error was 80073c29 (15401)Do_sqlScriptSqlScriptHlprError Code: 15401MSI (s) (98:50) [09:21:30:219]: I/O on thread 3236 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3300 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3652 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3424 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3244 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3544 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3064 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3428 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 2000 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 1740 could not be cancelled. Error: 1168MSI (s) (98!78) [09:21:30:219]: Product: Microsoft SQL Server 2005 -- Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.

TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS exists and contains NT AUTHORITYNETWORK SERVICE when the error occurs.

Any suggestions on how to get SQL Server to install on Vista?

View Replies !

---

How To Getback Original Copy Of Northwind Database?
Hi,Good morning to All.
While doing practice I did some modifications to some tables in Northwind database.Now, how can I get my original tables back again?
Take Oracle for example:We can modify table data. But when we run demobld.sql script then all tables will replaces with original entries.
Like this I want in SQL Server also. Is there any such facility available in SQL Server?
Thanks in advance,Ashok kumar.

View Replies !

---

Why Does 'alter Database NorthWind SET ENABLE_BROKER' Take Forever?
I am trying to execute the following query , in Management Studio. But it takes forever. Can someone tell me why is this happening? I am running the query in 'NorthWind' database.The windows account  under which I am logged into WinXP (windows authentication is enabled for the SQL Server database) is the database owner for NorthWind database.
alter database NorthWind SET ENABLE_BROKER

View Replies !

---

Stored Proc Error By Northwind Database
i try create this example:http://www.codeproject.com/KB/webforms/ReportViewer.aspxI have Northwind database added in the SQL server management and i select Northwind databse in drop box and I push Execute!ALTER PROCEDURE  ShowProductByCategory(@CategoryName nvarchar(15)
)ASSELECT  Categories.CategoryName, Products.ProductName,        
Products.UnitPrice, Products.UnitsInStockFROM    Categories INNER JOIN
Products ON         Categories.CategoryID = Products.CategoryIDWHERE  
CategoryName=@CategoryNameRETURNbut error is:Msg 208, Level 16, State 6, Procedure
ShowProductByCategory, Line 11Invalid object name
'ShowProductByCategory'.on web not so clear what is issue pls. help 

View Replies !

---

Can't Open Northwind's Database Diagrams Node In SQL MSE
Hi.I'm very new to this so I apologise in advance for asking the blindibly obvious. I have installed SQL Express and SQL Server Management Studio Express and I have downloaded and attached the Northwind sample database. I can see and edit the data in the tables but when I try to open the Database Diagram node I get the following message:Database diagram support objects cannot be installed because this database does not have a valid owner.  To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.I have no idea what a valid logon would be. Can somebody help?  Thanks

View Replies !

---

Installing Northwind Database By Instnwnd.sql Does Not Work?!
Hi all,
 
I downloaded the Northwind database install script (SQL2000SampleDb.msi) and ran instnwnd.sql in my SQL Server Management Studio Express.  I got the following error messages:

Msg 5105, Level 16, State 2, Line 1

A file activation error occurred. The physical file name 'northwnd.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation.

Msg 1802, Level 16, State 1, Line 1

CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

Msg 15010, Level 16, State 1, Procedure sp_dboption, Line 64

The database 'Northwind' does not exist. Use sp_helpdb to show available databases.



Msg 15010, Level 16, State 1, Procedure sp_dboption, Line 64

The database 'Northwind' does not exist. Use sp_helpdb to show available databases.



Msg 911, Level 16, State 1, Line 1

Could not locate entry in sysdatabases for database 'Northwind'. No entry found with that name. Make sure that the name is entered correctly.

Msg 3726, Level 16, State 1, Line 2

Could not drop object 'dbo.Customers' because it is referenced by a FOREIGN KEY constraint.

Msg 3726, Level 16, State 1, Line 2

Could not drop object 'dbo.Employees' because it is referenced by a FOREIGN KEY constraint.

Msg 2714, Level 16, State 6, Line 1

There is already an object named 'Employees' in the database.

Msg 1913, Level 16, State 1, Line 1

The operation failed because an index or statistics with name 'LastName' already exists on table 'dbo.Employees'.

Msg 1913, Level 16, State 1, Line 1

The operation failed because an index or statistics with name 'PostalCode' already exists on table 'dbo.Employees'.

Msg 2714, Level 16, State 6, Line 1

There is already an object named 'Customers' in the database.

Msg 1913, Level 16, State 1, Line 1

The operation failed because an index or statistics with name 'City' already exists on table 'dbo.Customers'.

Msg 1913, Level 16, State 1, Line 1

The operation failed because an index or statistics with name 'CompanyName' already exists on table 'dbo.Customers'.

Msg 1913, Level 16, State 1, Line 1

The operation failed because an index or statistics with name 'PostalCode' already exists on table 'dbo.Customers'.

Msg 1913, Level 16, State 1, Line 1

The operation failed because an index or statistics with name 'Region' already exists on table 'dbo.Customers'.

(1 row(s) affected)

............................................etc.
 
Please help and advise me how to get the Northwind database installed in my SQL Server Management Studio Express.
 
Thanks in advance,
Scott Chang

View Replies !

---