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...

Can you post version information of your sqlserver .

Select @@version

or

Select Serverproperty( 'BuildClrVersion' ) as BuildClrVersion

, Serverproperty( 'Collation' ) as Collation

, Serverproperty( 'CollationID' ) as CollationID...

This one takes way to long !!!

Select RIGHT(F.[Number]+1000000000,9) as TheMissingKey

from ( Select substring(T1.TheMeaningfullKey, 1,4) as YYRR , max(T1.TheMeaningfullKey) as max_TheMeaningfullKey

from @YourTable T1

group by substring(T1.TheMeaningfullKey, 1,4) ) M

cross apply...

Oh boy, I messed up pretty well :blush:

I'll get back on this if I find some time today ...

For sure this way it will work, although it may take a...

- Can you connect from the witness to the principal or mirror using management studio and just execute some queries ?

- can you do the same using the witnesses service...

it is for a range of dates..

test with this and you'll find its begin and end values.

declare @startdate datetime, @enddate datetime

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

...

Because of the way sqlserver log files work, you can only shrink up to the last chunck in use.

Considering the error you got, I'd say enlarge the log with a...

- did you change e.g. sqlagent service account recently ?

- did you remove e.g. builtin\administrators from you sql instance before altering sqlagent service account ?