[dba-VB] SCRUM: Applying .sql

Please note that this may be permissions or file access because I did get 
this
'helpful' error message that I googled and found to be (possible) 'By 
Design' security:

Msg 233, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server.
(provider: Shared Memory Provider, error: 0 - No process is on the other end 
of the pipe.)

-
Michael R Mattys
MapPoint and Database Dev
www.mattysconsulting.com
-

----- 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>
Sent: Sunday, April 05, 2009 10:33 AM
Subject: Re: [dba-VB] SCRUM: Applying .sql


> Hi Shamil,
>
> Since there is no combo in the left-hand corner, that cannot be the 
> answer.
> What I did is
>
> - View ... Toolbars ... Query Designer
> - Open File (*.sql)
> - Copy the content of the .sql file
>
> - expand Programmability
> - right-click on Stored Procedures
> - select New Stored Procedure
>
> - Paste in sql file content
> - right-click and Execute
>
> Receive message:
> Command(s) completed successfully.
>
> Refreshing the Views category now shows the new View.
>
> Michael R Mattys
> MapPoint and Database Dev
> www.mattysconsulting.com
> -
> ----- Original Message ----- 
> From: "Salakhetdinov Shamil" <mcp2004 at mail.ru>
> To: "dba-VB" <dba-vb at databaseadvisors.com>
> Sent: Sunday, April 05, 2009 4:06 AM
> Subject: Re: [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
>>>
>>
>> _______________________________________________
>> dba-VB mailing list
>> dba-VB at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/dba-vb
>> http://www.databaseadvisors.com
>>
>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>