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

http://www.sqlservercentral.com/articles/SQL+Puzzles/findinggapsinasequentialnumbersequence/2336/

http://www.sqlservercentral.com/articles/Datetime+Manipulation/61822/

I would say their windows firewall isn't opened to use the sqlserver ports.

it's better you don't.

Leave formatting to the client application !

p.s. only use Nvarchar if strictly needed !

well.... use the correct datatype !

In this case datetime.

This way one cannot enter invalid data in the first place.

Now you're stuck with character columns containing data that is invalid...

Here are some urls I've used just to investigate some scenarios:

http://blogs.msdn.com/lcris/archive/2006/10/19/sql-server-2005-an-example-for-how-to-use-counter-signatures.aspx

http://blogs.msdn.com/lcris/archive/2005/12/16/504692.aspx

http://www.lakesidesql.com/articles/?p=15

And I think even BOL has some nice examples.