Technics:Microsoft SQL Server - Revision history

Admin at 07:26, 10 July 2019

2019-07-10T07:26:23Z

← Older revision		Revision as of 08:26, 10 July 2019
Line 19:		Line 19:
	More information at http://msdn.microsoft.com/en-us/library/ms175046.aspx.		More information at http://msdn.microsoft.com/en-us/library/ms175046.aspx.

	===Microsoft SQL Server ~~2008 R2 /~~ 2012 / 2014===		===Microsoft SQL Server 2012 / 2014 / 2016 / 2017===
	The ''xp_cmdshell'' option can be enabled via Facets (context menu on the SQL Server node in SQL Server Mangement Studio):		The ''xp_cmdshell'' option can be enabled via Facets (context menu on the SQL Server node in SQL Server Mangement Studio):

Admin at 10:35, 22 February 2016

2016-02-22T10:35:01Z

← Older revision		Revision as of 11:35, 22 February 2016
Line 19:		Line 19:
	More information at http://msdn.microsoft.com/en-us/library/ms175046.aspx.		More information at http://msdn.microsoft.com/en-us/library/ms175046.aspx.

	===Microsoft SQL Server ~~2008 /~~ 2008 R2 / 2012 / 2014===		===Microsoft SQL Server 2008 R2 / 2012 / 2014===
	The ''xp_cmdshell'' option can be enabled via Facets (context menu on the SQL Server node in SQL Server Mangement Studio):		The ''xp_cmdshell'' option can be enabled via Facets (context menu on the SQL Server node in SQL Server Mangement Studio):

Admin at 14:44, 15 December 2015

2015-12-15T14:44:23Z

← Older revision		Revision as of 15:44, 15 December 2015
Line 19:		Line 19:
	More information at http://msdn.microsoft.com/en-us/library/ms175046.aspx.		More information at http://msdn.microsoft.com/en-us/library/ms175046.aspx.

	===Microsoft SQL Server 2008 / 2008 R2 /2012 / 2014===		===Microsoft SQL Server 2008 / 2008 R2 / 2012 / 2014===
	The ''xp_cmdshell'' option can be enabled via Facets (context menu on the SQL Server node in SQL Server Mangement Studio):		The ''xp_cmdshell'' option can be enabled via Facets (context menu on the SQL Server node in SQL Server Mangement Studio):

Admin at 14:44, 15 December 2015

2015-12-15T14:44:02Z

@@ Line 19: / Line 19: @@
 More information at http://msdn.microsoft.com/en-us/library/ms175046.aspx.
-===Microsoft SQL Server 2005===
+===Microsoft SQL Server 2008 / 2008 R2 /2012 / 2014===
 The ''xp_cmdshell'' option can be enabled via Facets (context menu on the SQL Server node in SQL Server Mangement Studio):
@@ Line 61: / Line 55: @@
 |}
-===Microsoft SQL Server 2005===
+===Microsoft SQL Server===
 After confirming EULA, additional setup files will be installed. Afterwards setup scans the configuration of the computer. Confirm the welcome screen with next. You can ignore the warnings of the system configuration check, if they are important for a server installation. At components to install, please choose ''workstation components, online documentation and development tools''.
@@ Line 75: / Line 69: @@
 You will finish the setup with ''Next''. Please don't forget the service packs.
 __NOEDITSECTION__

Admin at 07:53, 19 July 2010

2010-07-19T07:53:17Z

← Older revision		Revision as of 08:53, 19 July 2010
Line 82:		Line 82:

	===Microsoft SQL Server 2005===		===Microsoft SQL Server 2005===
	Feature Pack ~~für~~ Microsoft SQL Server 2005 - Dezember 2008		Feature Pack for Microsoft SQL Server 2005 - Dezember 2008
	http://www.microsoft.com/downloads/details.aspx?displaylang=de&FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075		http://www.microsoft.com/downloads/details.aspx?displaylang=de&FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075

	===Microsoft SQL Server 2008===		===Microsoft SQL Server 2008===
	Feature Pack ~~für~~ Microsoft SQL Server 2008, April 2009		Feature Pack for Microsoft SQL Server 2008, April 2009
	http://www.microsoft.com/downloads/details.aspx?displaylang=de&FamilyID=b33d2c78-1059-4ce2-b80d-2343c099bcb4		http://www.microsoft.com/downloads/details.aspx?displaylang=de&FamilyID=b33d2c78-1059-4ce2-b80d-2343c099bcb4

	===Microsoft SQL Server 2008 R2===		===Microsoft SQL Server 2008 R2===
	Feature Pack ~~für~~ Microsoft® SQL Server® 2008 R2 in ~~der~~ Community Technology Preview-Version ~~für~~ November		Feature Pack for Microsoft® SQL Server® 2008 R2 in Community Technology Preview-Version for November
	http://www.microsoft.com/downloads/details.aspx?familyid=020EE0D5-BCE4-4A45-9D64-B0C49C8831E5&displaylang=de		http://www.microsoft.com/downloads/details.aspx?familyid=020EE0D5-BCE4-4A45-9D64-B0C49C8831E5&displaylang=de

Admin at 11:31, 15 July 2010

2010-07-15T11:31:31Z

← Older revision		Revision as of 12:31, 15 July 2010
Line 78:		Line 78:
	==Important URLs==		==Important URLs==

	===Service Packs ~~und kumulative~~ Updates===		===Service Packs and cumulative Updates===
	You find an overview of all SQL server version including service packs and links to downloads on http://sqlserverbuilds.blogspot.com.		You find an overview of all SQL server version including service packs and links to downloads on http://sqlserverbuilds.blogspot.com.

Admin at 11:30, 15 July 2010

2010-07-15T11:30:20Z

← Older revision		Revision as of 12:30, 15 July 2010
Line 62:		Line 62:

	===Microsoft SQL Server 2005===		===Microsoft SQL Server 2005===
	~~Nach dem Bestätigen der~~ EULA ~~werden die Unterstützungsdateien für das Setup installiert~~. ~~Anschließend wird vom Setup die Konfiguration des Rechners gescannt~~. ~~Den Willkommensbildschirm mit Weiter bestätigen~~. ~~Die Warnungen der Systemkonfigurationsüberprüfung können ignoriert werden~~, ~~falls sie nur für eine Server-Installation von Bedeutung sind~~.		After confirming EULA, additional setup files will be installed. Afterwards setup scans the configuration of the computer. Confirm the welcome screen with next. You can ignore the warnings of the system configuration check, if they are important for a server installation. At components to install, please choose ''workstation components, online documentation and development tools''.
	~~Bei den zu installierenden Komponenten wählt man~~ ''~~Arbeitsstationskomponenten~~, ~~Onlinedokumentation und Entwicklungstools~~'':

	[[Image:T_Auswahl der zu installierenden Komponenten (SQL Server 2005 Setup) .jpg\|thumb\|center\|~~Technik~~, ~~Auswahl der zu installierenden Komponenten~~ (SQL Server 2005 Setup) ]]		[[Image:T_Auswahl der zu installierenden Komponenten (SQL Server 2005 Setup) .jpg\|thumb\|center\|Technics, Selection of components to install (SQL Server 2005 Setup) ]]

	~~Mit der Schaltfläche~~ ''~~Erweitert~~'' ~~kann man die zu installierenden Komponenten im Detail auswählen:~~		With the button ''extended'' xou can choose the components to install in detail.

	~~[[Image:T_Featureauswahl (SQL Server 2005 Setup).jpg\|thumb\|center\|Technik, Featureauswahl (SQL Server 2005 Setup)]]~~

	~~Die Online-Dokumentation kann man weglassen~~, ~~da diese der Dokumentation im~~ MSDN ~~entspricht~~. ~~Auch das Software Development Kit und die Legacykomponenten werden im Normalfall nicht benötigt~~.		[[Image:T_Featureauswahl (SQL Server 2005 Setup).jpg\|thumb\|center\|Technics, Selection(SQL Server 2005 Setup)]]

			You can drop the online documentation, because it is like the MSDN documentation.

			You will finish the setup with ''Next''. Please don't forget the service packs.

	~~Anschließend ''Weiter'' bis zum Abschließen des Setups. Nicht auf die Installation des SQL Server Service Packs vergessen.~~

	==Important URLs==		==Important URLs==

	===Service Packs und kumulative Updates===		===Service Packs und kumulative Updates===
	~~Eine Übersicht aller~~ SQL ~~Server Versionen ab 7.0 inklusive Service Packs und aller Zwischenstände sowie Links zu den Downloads findet man auf~~ http://sqlserverbuilds.blogspot.com.		You find an overview of all SQL server version including service packs and links to downloads on http://sqlserverbuilds.blogspot.com.

	===Microsoft SQL Server 2005===		===Microsoft SQL Server 2005===

Admin at 11:17, 15 July 2010

2010-07-15T11:17:18Z

← Older revision		Revision as of 12:17, 15 July 2010
Line 47:		Line 47:
	</source>		</source>

	==Business Intelligence Development Studio ~~installieren~~==		==Business Intelligence Development Studio Installation==
	~~In diesem Abschnitt wird die Installation des~~ Business Intelligence Development Studio ~~auf Client-Rechnern beschrieben und gilt zum größten Teil auch für eine Nachinstallation am Server~~. ~~Das~~ Business Intelligence Development Studio ~~gehört zu den Arbeitsplatzkomponenten und wird mit dem~~ SQL Server Setup ~~installiert~~.		This chapter describes the installation of Business Intelligence Development Studio on the client computer and the majority of them are for a rewiring within the installation on the server. The Business Intelligence Development Studio belongs to the workstation components and will be installed with the SQL Server Setup.

	{\| {{Bausteindesign1}}		{\| {{Bausteindesign1}}
	\|-		\|-
	\| <span style="color: darkblue;">'''~~Hinweis~~'''</span>  ~~Nach dem Installieren über das Setup muss unbedingt das zum SQL Server passende Service Pack installiert werden~~. ~~Dieses ist auch für die Aktualisierung der Arbeitsstationskomponenten zuständig~~.		\| <span style="color: darkblue;">'''Hint'''</span>  After installing you have to install the right service pack. This is also responsible for the workstation components.
	\|}		\|}

Line 58:		Line 58:
	{\| {{Bausteindesign1}}		{\| {{Bausteindesign1}}
	\|-		\|-
	\| <span style="color: darkblue;">'''~~Hinweis~~'''</span>  ~~Das~~ Business Intelligence Development Studio ~~ist ein angepasstes~~ Visual Studio. ~~Das~~ Visual Studio ~~ist über ein separates Service Pack zu aktualisieren (bei Bedarf)~~. ~~Das Service Pack für den~~ SQL ~~Server aktualisiert nur die~~ BI-~~Komponenten (Designer für Analysis, Integration und Reporting Services)~~.		\| <span style="color: darkblue;">'''Hint'''</span>  The Business Intelligence Development Studio is an adapt Visual Studio. If necessary, Visual Studio update is a separate service pack. The SQL server service pack refreshes only the BI-components.
	\|}		\|}

Admin at 08:43, 15 July 2010

2010-07-15T08:43:11Z

← Older revision		Revision as of 09:43, 15 July 2010
Line 2:		Line 2:

	===General Information===		===General Information===
	An overview about all SQL Server versions from 7.0 including service packs and other intermediate releases as well as download links is available at http://sqlserverbuilds.blogspot.com.		An overview about all SQL Server versions from 7.0 including service packs and other intermediate releases as well as download links is available at http://sqlserverbuilds.blogspot.com. The Microsoft SQL Server is required for the [[Technics:CoPlanner-Server\|CoPlanner Server]].

	===Enable xp_cmdshell===		===Enable xp_cmdshell===

Admin at 08:41, 15 July 2010

2010-07-15T08:41:41Z

← Older revision		Revision as of 09:41, 15 July 2010
Line 96:		Line 96:
	[[Category:Technics\|Microsoft SQL Server]]		[[Category:Technics\|Microsoft SQL Server]]

	[[de:Technik:~~Datenbanken~~]]		[[de:Technik:Microsoft_SQL_Server]]