Salakhetdinov Shamil
mcp2004 at mail.ru
Mon Apr 6 00:25:38 CDT 2009
Hi Mike, I have never tried to install SSMS2005 after SSMS2005EE. I believe you it could be a trouble. BTW, I have worked with SS2005 Express and SSMS2005EE developing quite large ASP.NET project with a db with millions records in some tables and that my development environment was good enough - I mean if you can't get installed SSMS2005 then just forget it for now until you'll find time to reinstall from scracth: then first install MS SQL 2005 (2008) and after that Visual Studio... -- 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: Sun, 5 Apr 2009 13:53:37 -0400 Subject: Re: [dba-VB] SCRUM: Applying .sql > Shamil, > > I meant the Management Studio for 2005 > From what I've read, after SSMS2005EE is installed, SSMS2005 is stripped of > some features. > The install, thereafter, is blocked without some fooling around. > > - > 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 12:14 PM > Subject: Re: [dba-VB] SCRUM: Applying .sql > > > > Hi Mike, > > > > You can use > > > > Right-Click database -> New Query... > > > > and the combo will get enabled. > > > > <<< > >> I tried to install Management Studio by changing setup, but it's not > >> there > >>>> > > Not sure what do you mean here? MS SQL Server 2005 Management Studio > > Express? Or MS SQL Server 2005 Management Studio? > > > > -- > > 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: Sun, 5 Apr 2009 11:34:51 -0400 > > Subject: Re: [dba-VB] SCRUM: Applying .sql > > > >> Hi Shamil, > >> > >> Oh cool! > >> I was going to ask where the debug/step (F8) was, but if I can execute > >> seperate lines then that works great! > >> You are right about the SQL Editor being there, but it is greyed-out no > >> matter what I do. > >> I tried to install Management Studio by changing setup, but it's not > >> there > >> ... > >> "Developer Version" ??? > >> - > >> 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 10:55 AM > >> Subject: Re: [dba-VB] SCRUM: Applying .sql > >> > >> > >> > > >> > Hi Mike, > >> > > >> > OK, it worked for you but I still think there is a shorter way. > >> > > >> > I do use MS SQL Server 2005 Management Studio - it may happen MS SQL > >> > Server 2005 Express doesn't have the toolbar/combo - try > >> > > >> > View->Tollbars->SQL Editor > >> > > >> > - the latter toolbar should have a combo with the list of databases. > >> > > >> > Another way is to Right-Click on database in the treeview of databases > >> > and > >> > then select New Query... entry , get new empty query window opened and > >> > paste SQL script into it. It will run in context of the db you > >> > right-clicked on. > >> > > >> > To execute you can use F5. > >> > > >> > BTW, you can select any part of query in the query window and execute > >> > it > >> > (F5) - and only selected part will be executed - nice and useful > >> > "trick", > >> > which isn't described in the docs? (I have got it quite some time ago > >> > from > >> > one SQL master)... > >> > > >> > > >> > -- > >> > 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: Sun, 5 Apr 2009 10:33:08 -0400 > >> > 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 files > >> >> > >> >> - 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 > >> > > >> > > > > _______________________________________________ > > dba-VB mailing list > > dba-VB at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/dba-vb > > http://www.databaseadvisors.com > > > > >