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 ?

There can be any number of databases in sqlserver.

You have 4 system databases:

-master

-msdb

-model

-tempdb

(you can have some more in a distribution context)

All other databases are user databases.

So you need to...

This is typical abuse...

Dugi (9/15/2008)

---

Interesting ... but little bit confused couz for the moment I haven't any idea how to use it in my column ...my column is not datetime it is just...