On this page....

BI review & help

Want to understand what is BI & DWH? Need help with your DWH design, Analysis Services, Panorama or MDX queries? Just call me.

Call now

10$

November 2008

Sun

Mon

Tue

Wed

Thu

Fri

Sat

Aggregate Me!

Profile

Name:
   Miky Schreiber
Occupation:
   BI, Web & .Net Programmer
Location:
   Israel

more...

Sites I write in

Jewish Quote

"The most remarkable thing about my mother is that for thirty years she served the family nothing but leftovers. The original meal has never been found."

-Calvin Trillin

My Skype Status:

Mail me

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

Wednesday, July 23, 2008

Manually Starting the SQL Server Services on your Machine

When you practice on SQL Server on your local machine you don't want that its services will start up with the computer. As I mentioned before, you should declare the startup method of these services as manual (see here). After that, you can build two simple batch files that will start and stop the services. Believe me - it's very comfotable to start and stop the services with only one mouse click. The first batch file (I called it sql.bat) contains only two lines:

net start MSSQLSERVER
net start MSSqlServerOLAPService

The second one (sqlend.bat) looks like that:

net stop MSSQLSERVER
net stop MSSqlServerOLAPService

Note that I only start/stop the SQL Server and analysis services, but you can do whatever you like.

Have fun.

BI | SQL Server 2005 | SQL Server 2008 | Tips & Tricks

Thursday, July 24, 2008 5:19:08 AM (Jerusalem Daylight Time, UTC+03:00)

Comments [0] | Trackback Related posts:
Finding the AdomdServer assembly
The MdxInjection Program - continued
The MdxInjection Program
DRY Principle in BI Development
Non Deterministic Aggregation in SSIS ?
Panorama and Excel Issue

Name
E-mail
Home page

	Remember Me
Comment (HTML not allowed)
Enter the code shown (prevents robots):