Help with SQL 2005 solutions

nomad
If I understood you correctly
1) Open Solution within you have added .sql files (1-for SP,2-for Views)
2) When you click on the file it opens a object explorer windows
3) Add your object to opened window (relevant for object type) and save it.
So , the next time you open the file your script should be saved there
"nomad" <d.bedgood@.ntlworld.com> wrote in message
news:1172065721.265467.175850@.a75g2000cwd.googlegr oups.com...
> Hi,
> I want to be able to use source control from within SQL 2005. I know
> how to add a new solution with a project attached. And I know how to
> add existing .sql scripts to it. My quesiton is, how can I split them
> up so that I can add all stored procedure scripts into a folder called
> Stored Procedures, all views into a folder called Views etc instead of
> them all going into the Query folder.
> Appreciate any help on this.
>
Ahh, I see what you mean. I'm affraid you cannot do that
"nomad" <d.bedgood@.ntlworld.com> wrote in message
news:1172068385.736309.197940@.k78g2000cwa.googlegr oups.com...
> On 21 Feb, 14:16, "Uri Dimant" <u...@.iscar.co.il> wrote:
> I know how to do all of this. My question is, in the solution you
> have folders called Connections, Queries & Miscellaneous. I want to
> be able to add folders called Stored Procedures, Views etc so that I
> can add my SP .sql scripts into Stored Procedure folder, Views scripts
> into Views folder etc so that it is easier to differentiate between
> your scripts.
>

Help with MSDE Install

Installed MSDE on windowsxp pro.
When computer restarts, icon seen at System Tray.
Click on icon and SQL Server Service Manager.
Server field blank
Services field blank
typed in computername for Server field
select start/continue button.
error message that no service has been selected.
Where did I go wrong?
Walter Wu
Logfile:
2005-06-30 07:26:25.64 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
2005-06-30 07:26:25.64 server Copyright (C) 1988-2002 Microsoft
Corporation.
2005-06-30 07:26:25.64 server All rights reserved.
2005-06-30 07:26:25.64 server Server Process ID is 540.
2005-06-30 07:26:25.64 server Logging SQL Server messages in file
'G:\MSSQL$MYFIRSTSQLSERVER\LOG\ERRORLOG'.
2005-06-30 07:26:25.67 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2005-06-30 07:26:26.54 server SQL Server configured for thread mode
processing.
2005-06-30 07:26:26.54 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2005-06-30 07:26:26.70 spid2 Starting up database 'master'.
2005-06-30 07:26:27.07 server Using 'SSNETLIB.DLL' version '8.0.766'.
2005-06-30 07:26:27.07 spid5 Starting up database 'model'.
2005-06-30 07:26:27.10 spid2 Server name is 'MASTER\MYFIRSTSQLSERVER'.
2005-06-30 07:26:27.10 spid2 Skipping startup of clean database id 4
2005-06-30 07:26:27.21 server SQL server listening on Shared Memory.
2005-06-30 07:26:27.25 spid5 Clearing tempdb database.
2005-06-30 07:26:27.67 spid5 Starting up database 'tempdb'.
2005-06-30 07:26:27.75 spid2 Recovery complete.
2005-06-30 07:26:27.75 spid2 SQL global counter collection task is
created.
2005-06-30 07:26:28.57 server SQL Server is ready for client connections
"NoOne" <NoOne@.NoName.com> wrote in message
news:%238pclQQfFHA.268@.TK2MSFTNGP15.phx.gbl...
> Installed MSDE on windowsxp pro.
> When computer restarts, icon seen at System Tray.
> Click on icon and SQL Server Service Manager.
> Server field blank
> Services field blank
> typed in computername for Server field
> select start/continue button.
> error message that no service has been selected.
> Where did I go wrong?
>
> Walter Wu
>
|||hi Walter,
NoOne wrote:
> Installed MSDE on windowsxp pro.
> When computer restarts, icon seen at System Tray.
> Click on icon and SQL Server Service Manager.
> Server field blank
> Services field blank
> typed in computername for Server field
> select start/continue button.
> error message that no service has been selected.
> Where did I go wrong?
>
from your log file, your MSDE is runnig... but you probably installed MSDE
without network protocols support, and this unfortunately can cause the
corresponding instance not to show up in the SQL Server Service Manager, as
reported in http://support.microsoft.com/default...b;EN-US;814132
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||-
/kj
"NoOne" <NoOne@.NoName.com> wrote in message
news:ekke%23fQfFHA.2384@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> Logfile:
> 2005-06-30 07:26:27.10 spid2 Server name is 'MASTER\MYFIRSTSQLSERVER'.
> "NoOne" <NoOne@.NoName.com> wrote in message
> news:%238pclQQfFHA.268@.TK2MSFTNGP15.phx.gbl...
Trying entering
MASTER\MYFIRSTSQLSERVER
on the server line of SQL Server Manager, wait a painfully long time with
the hour glass, and eventually you should see your services state.
Unfortunately, you'll have to do this everytime as it won't stick. ( Don't
you wish you had shortened that instance name now? ;-) )
/kj
|||Change the instance name and removed the password and it works.
Thanks everyone.
"NoOne" <NoOne@.NoName.com> wrote in message
news:ekke%23fQfFHA.2384@.TK2MSFTNGP15.phx.gbl...
> Logfile:
> 2005-06-30 07:26:25.64 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
> 2005-06-30 07:26:25.64 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2005-06-30 07:26:25.64 server All rights reserved.
> 2005-06-30 07:26:25.64 server Server Process ID is 540.
> 2005-06-30 07:26:25.64 server Logging SQL Server messages in file
> 'G:\MSSQL$MYFIRSTSQLSERVER\LOG\ERRORLOG'.
> 2005-06-30 07:26:25.67 server SQL Server is starting at priority class
> 'normal'(2 CPUs detected).
> 2005-06-30 07:26:26.54 server SQL Server configured for thread mode
> processing.
> 2005-06-30 07:26:26.54 server Using dynamic lock allocation. [500] Lock
> Blocks, [1000] Lock Owner Blocks.
> 2005-06-30 07:26:26.70 spid2 Starting up database 'master'.
> 2005-06-30 07:26:27.07 server Using 'SSNETLIB.DLL' version '8.0.766'.
> 2005-06-30 07:26:27.07 spid5 Starting up database 'model'.
> 2005-06-30 07:26:27.10 spid2 Server name is 'MASTER\MYFIRSTSQLSERVER'.
> 2005-06-30 07:26:27.10 spid2 Skipping startup of clean database id 4
> 2005-06-30 07:26:27.21 server SQL server listening on Shared Memory.
> 2005-06-30 07:26:27.25 spid5 Clearing tempdb database.
> 2005-06-30 07:26:27.67 spid5 Starting up database 'tempdb'.
> 2005-06-30 07:26:27.75 spid2 Recovery complete.
> 2005-06-30 07:26:27.75 spid2 SQL global counter collection task is
> created.
> 2005-06-30 07:26:28.57 server SQL Server is ready for client
> connections
> "NoOne" <NoOne@.NoName.com> wrote in message
> news:%238pclQQfFHA.268@.TK2MSFTNGP15.phx.gbl...
>