Interview Questions : In SQL Server 2008, if you have a server side trac

Interviews World

		.Net Framework(43)
		.Net Memory Management(2)
		.Net Web Service(6)
		.Net Remoting(30)
		.Net Security(2)
		.Net Threading(8)
		.Net Architecture(2)
		Basic C#(33)
		VB.Net(2)
		.Net Window Service(3)
		.Net Window Forms(14)
		Advanced C#(25)
		Visual Studio 2003(2)
		Visual Studio 2005(2)
		Visual Studio 2008(2)
		Visual Studio 2010(2)

		ASP.NET General(7)
		ASP.NET Caching(9)
		ASP.NET Ajax(13)
		ASP.NET Session(7)
		ASP.NET Localisation(2)
		ASP.NET 1.1(2)
		ASP.NET 2.0(2)
		ASP.NET 3.5(11)
		ASP.NET 4.0(2)

		SQL Server 2000(20)
		SQL Server 2005(24)
		SQL Server 2008(42)

General ADO.NET(7)

Object Oriented (27)

		Basic Object Oriented(19)
		Advanced Object Oriented(8)

MS Dynamics (1)

		MS Dynamics GP 9(2)
		MS Dynamics GP 10(1)
		MS Dynamics Soloman(2)
		MS Dynamics CRM 3.0(2)
		MS Dynamics CRM 4.0(2)
		MS Dynamics CRM 5.0(2)

Sharepoint (65)

		Basic SharePoint(35)
		SharePoint Server 2003(4)
		SharePoint Server 2007(25)
		SharePoint Server 2010(2)

Automation Testing(15)

Welcome to Interviews World


Question : In SQL Server 2008, if you have a server side trace running, and you run out of disk space, what happens?

Answer : Tracing stops, but the server continues to run. If you have a normal SQL Trace setup, and you run out of disk space, the server continues to run, but tracing stops. Full Details- http://msdn.microsoft.com/en-us/library/ms191443.aspx

Website Highlights

Newsleter

Enter your Email:

©2007-2008 interviewsworld.com All Rights Reserved. | About Us | Contact Us | Disclaimer | Privacy Policy | Terms Of Service
User-posted content, unless source quoted, is licensed under a Creative Commons Public Domain License