and make the

part distinctive !

(so you don't update the same 1000 rows every time and again...

declare @startdate datetime, @enddate datetime

SELECT @startdate = dateadd(dd, (-6 - DATEPART (dw, getdate())),DATEADD(dd,DATEDIFF(dd,0,getdate()),0))

, @enddate = DATEADD(dd,DATEDIFF(dd,0,getdate())+ 1 ,0)

--print...

are you using the same service account for all the instances ?

if not, you need to grant loging for all service accounts to all the instances

SELECT object_name(i.object_id) as Table_Name

, i.name as Index_Name

, i.index_id

, STATS_DATE(i.object_id, i.index_id) as Statistics_Date

FROM sys.objects o

INNER JOIN sys.indexes i

ON o.object_id = i.object_id

order by Table_Name, i.index_id ;

GO

You can also inspect the last time stats have been updated :

SELECT i.name as Index_Name

, STATS_DATE(i.object_id, i.index_id) as Statistics_Date

FROM sys.objects o

INNER JOIN sys.indexes i

ON o.object_id = i.object_id;

GO

here's another test with the timestamp datatype:

/****** test script timestamp ******/

set nocount on

go

/*

@@DBTS returns the last-used timestamp value of the current database.

A new timestamp value is generated when a...

I'm sorry for the xpost.

I originally posted in the wrong forum (sql2005)

Please reply to the sql2000 forum at

http://www.sqlservercentral.com/Forums/Topic571090-48-1.aspx

select dateadd(wk,36,master.dbo.fn_ALZDBA_convert_date2WeekRangeALZDBA ('20080104', 'F'))

, dateadd(wk,37,master.dbo.fn_ALZDBA_convert_date2WeekRangeALZDBA ('20080104', 'F'))

, dateadd(wk,38,master.dbo.fn_ALZDBA_convert_date2WeekRangeALZDBA ('20080104', 'F'))

, dateadd(wk,39,master.dbo.fn_ALZDBA_convert_date2WeekRangeALZDBA ('20080104', 'F'))

it depends ..... What's your week 1 ??

Microsoft starts week 1 at 1/1 :crazy:

In my company, week 1 is the week which containns Jan 4th.

So we always need to check...

Jason Selburg (9/16/2008)

---

I have a PK on the table, and the original file's line number is all that is important. That is, I'm not concerned how it is stored in...

Bulk will ...

But you recipient table may have a clustering index, needing to reorder the rows.

Will sqlserver retrieve in the same order than you've put it in the table.

Most certainly...

the sqlserver service account needs to have access to the backup file location (so don't use a mapped drive, but use unc if possible)

IMO it is IO related so I would say 8 pages (i.e. 64KB )

However a table should have a primary key (and most tables have)

Also keep in mind, a unique...

Steve Jones - Editor (9/16/2008)

---

There is a password policy in SQL Server 2005, and if the host OS supports it, SQL Server can respect that. I thought the SA...

I would have performed that leaving the stand alone up and running.

Just install an extra on your cluster env. and then copy the users (ssis task) and move all databases.

Are...