All data file creation/extension options will use instant initialization for data files created on NTFS volumes when SQL Server 2005 is running on Windows XP or Windows 2003 Server. Its...

Its called Database File Initialization

http://msdn.microsoft.com/en-us/library/ms175935.aspx

MJ

Have you included Showplan XML EventClass in profiler trace? Include it and then click on that row and right click on it and chose Extract Event Data and save plan...

Nope it won't work, you need to rename the existing one.

MJ

Try this:

--http://www.sqlservercentral.com/scripts/Administration/63841/

USE MASTER

GO

BEGIN

IF LEFT(CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR(1)),1) = '9'

IF EXISTS (

SELECT TOP 1 *

FROM Tempdb.sys.objects (nolock)

WHERE name LIKE '#TUser%')

DROP TABLE #TUser

ELSE IF LEFT(CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR(1)),1) =...

Try this:

1. Restart WMI service.

If still not resolved then tell me where exactly are you getting this message on client machine or only on server?

MJ

Try this:

select c.name,c.length,c.xusertype,lc.name,lc.length,lc.xusertype from sysobjects o inner join syscolumns c

on o.id=c.id

,[DestServerName].northwind.dbo.sysobjects lo join [DestServerName].northwind.dbo.syscolumns lc

on lo.id=lc.id

where c.name =lc.name

and o.name='orders'

and lo.name='orders'

I wrote this test code for comparing northwind database orders table...

Did you try this:

In order to change the dynamic port of the server to the static port in the clustered named instance of the sql server 2005 we need to...

Nope file won't get renamed by this. Downtime is still there as you are going to rename the existing database. Better detach the existing one and rename its files and...

It worked like a charm. Thanks a lot guys.

Manu

Actually you can't have DAC from object explorer.

DAC is not supported for the object explorer, only for the query window.

Manu

Try this:

Go to File menu-->New-->Database Engine Query.

Select Database engine and then enter ADMIN:Servername.

This time it shld work.

HTH!

Manu

Make sure sql browser service is started and remote connections are allowed in case of remote DAC connection.

I am able to get DAC connection by following the info in the...

What is actually slow?

If the application is responding slowly then have you tried running the queries ran by application manually under query analyzer? What is the Index structure and index...

There is no such reason tht I don't want to specify but I just wanted to know when do we need to specify it and when its not required.

Basically I...