Have a look at Red Gate's SQL Data Compare 6 (alpha). While it says it is an alpha version, it is very stable. It can read backup files, and show...

I mentioned that table variables are not logged in the transaction log, and that unlike temp tables, procs that contain them can be precompiled. However, this does not necessarily improve...

You you can use the previous backup, and the subsequent log backups. While the full backups contain part of the log that is relevant to the period of the full...

You could do:

DECLARE @ScorecardTemp table (

businessDate datetime null,

Cycle char (5) NULL ,

daypart smallint NULL ,

EarnedHours money NULL ,

ActualHours money NULL ,

ForecastHours money NULL ,

ScheduleHours money NULL ,

ActualDayParts smallint NULL...

Kyle,

do you mean how many error logs SQL Server will keep before deleting the last one? You can find out the currently set number by:

declare @NumErrorLogs int

exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer',...

Kirti,

have a look at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=396141

Peter Larsson posted:

SELECT a.*

FROM OPENROWSET('SQLNCLI', 'Server=(local);Trusted_Connection=yes;', 'exec sp_spaceused') AS a

Andras

"All things are difficult before they are easy."

    Dr. Thomas Fuller (1654 - 1734), Gnomologia, 1732

I'm glad your problem is solved,

Andras

In your query above you check for PreFix, and you drop PostFix.

Could that be the problem? Or is it something that got in while copy/pasting here?

Regards,

Andras

EXEC sp_xml_preparedocument @hdoc OUTPUT, @x

    SELECT nodeData, nodeName
      FROM OPENXML(@hdoc, '//nodeData',1)
           ...

Among others this keeps track of the SQL Server instances installed, and their port numbers. So unless you are running the named instances on fixed ports, this service helps to...

You are right Jeff. This is what I remembered too, but looked up the BOL for the compact edition. However, in both of the cases the important thing is that...

Is SQL Server Browser Service running?

Andras

Nice,

Although it will return the generated name (with the underscores and the number at the end), so you would need to get rid...

NAVJOAT is on the right track, and Gail is right about the temptable having a name that is generated in the tempdb. This name includes the name of the temptable,...

You could also execute restore with no backup files, to finish the recovery process (this saves the delete).

RESTORE DATABASE mydatabase WITH RECOVERY

Andras