It aslo calculates a start time in the future:

server_up_time_minserver_up_time_hrserver_up_time_dayapprox_server_start_utc_datetime

-26332.06-438.87-18.292012-01-13 08:47:00

HTH -- Mark D Powell --

I think Perry has a point about security. I was looking at this yesterday and it would appear that you can join the database sysusers to the instance server_principals...

Nice, but this script has the same basic problem any fully automatic user re-sync script has, namely it assumes that the @UserNamePattern and @LoginName are the same. Just this...

I also think you can skip the update statistics after a rebuild based on BOL topic Using Statistics to Improve Query Performance, "Operations such as rebuilding, defragmenting, or reorganizing an...

I agree as otherwise I am getting the last file group twice.

Mark D Powell

I was going to post the same quote. The execution plan itself is both re-entrant and reusable. The fact each execution also has 'private' areas does not change...

>> I think I know why they can get away with it. It's because Oracle's even harder to use <<

No, I have found Oracle to be way easier to...

I think the answer is wrong on 2005. Look at the following:

select

sum(row_count)

from

sys.dm_db_partition_stats

where

object_id = object_id('dibs_tmb_saalist') and

(index_id = 0 or index_id = 1)

...

I also figured the syntax error was a typo and went ahead and worked out one row would get inserted. I did not think to see if the answer...

I think of instead of 'It Depends' the last choice should have been collation dependent. By itself 'It depends' is not much of an answer.

-- Mark D Powell...

I copied it into notepad and used the edit/replace option to replace a copy/paste of the stupid little squate box to space. That seemed to work but I got...

I have not read all the code yet but doesn't #db03632 need to be defined somewhere?

Mark D Powell

In which case the insert statement data would not be present unless it had completed prior to the backup ending.

The key word in the question is restored. As I...

Lynn, after a restore of a database in full backup mode the database reflects both the contents of the database and the transactions recovered from the log files since you...

I will disagree with the official answer because the question did not ask if the transaction was included in the backup file but rather asked if the data would exist...