[dba-VB] SCRUM: Applying .sql

Hi Mike,

You probably didn't set current db to NorthwindNet: in the left top corner of SQL Management Studion Express there a combo to select current db.

Or you can put

use NorthwindNet
go

before the SQL Script's text.

Putting such use directive in front of all the scripts isn't practical as the name of the database can be changed...

--
Shamil


-----Original Message-----
From: "Mike Mattys" <mmattys at rochester.rr.com>
To: "Salakhetdinov Shamil" <mcp2004 at mail.ru>,"Discussion concerning Visual Basic and related programming issues." <dba-vb at databaseadvisors.com>
Date: Sat, 4 Apr 2009 22:44:20 -0400
Subject: Re: [dba-VB] SCRUM: Applying .sql

> Hi Team,
> 
> I've just figured out that I can use SQL Management Studio 2005 Express to
> connect with my SQL2005 db engine and that the Query Editor is actually
> an upgrade to the 2000 Query Analyzer.
> 
> So I opened the file 0001_vw_CustomerOrdersProducts.sql and tried to 
> execute.
> I received the following error:
> "Msg 208, Level 16, State 1, Procedure vw_CustomerOrdersProducts, Line 3 
> Invalid object name 'dbo.Customer'."
> Why?
> 
> -
> Michael R Mattys
> MapPoint and Database Dev
> www.mattysconsulting.com
> -
> ----- Original Message ----- 
> From: "Salakhetdinov Shamil" <mcp2004 at mail.ru>
> To: "Discussion concerning Visual Basic and related programming issues." 
> <dba-vb at databaseadvisors.com>
> Sent: Saturday, April 04, 2009 7:09 PM
> Subject: Re: [dba-VB] SCRUM: Sprint - 2nd week plan
> 
> 
> >
> > Hi SCRUM Team,
> >
> > I have made the following reports:
> >
> > - Alphabetical List of Products
> > - Product By Category
> >
> > but the second one is not yet finished - looking for a way to make it 
> > multi-column. Any proposals?
> >
> > Current solution is uploaded to the server.
> > Please always look at \!Documents\Notes.txt file after you update your 
> > code from server to find are there any new SQL scripts to apply - here is 
> > the current list:
> >
> > 0001_vw_CustomerOrdersProducts.sql
> > 0002_vw_CustomerOrderTotals.sql
> > 0003_vw_CustomerCountries.sql
> > 0004_vw_AlphabeticalListOfProductsReport.sql
> >
> > Please add your SQL scripts' file names to this list if you'll create 
> > some.
> >
> > Please put all the scripts into \Datasets\SQL subfolder named using 
> > numeric prefix to have the scripts sorted inthe sequence they were 
> > created.
> >
> > Please note how I made SimpleReportsDataSet to keep 'Alphabetical List of 
> > Products' and 'Product by Category' reports' sources. I used the same 
> > vw_AlphabeicalListOfProductsReport view for both reports but I have 
> > renamed table objects in dataset to allow in the future to substitute the 
> > database object e.g with stored procedure etc. without the need to rename 
> > anything in the code/forms/reports, which are using this dataset.
> >
> > Thank you.
> >
> > --
> > Shamil
>