It has been a pleasure meeting you at sqlpass, as well as meeting Grant, Steve, Andy and other renowned names at SSC.

Thank you for sharing a...

Oh yes, I see, Sorry for re-opening an old thread but it served a good cause 😀

Grant in action at SQLPASS 2010

It was very nice meeting him and going to his sessions.

Job well done !

Thanks for this addition Sean :Wow:

OP: Keep in mind it is not because you can do something in a certain way, you should. Think about the consequences.

great... now you've had two answers saying No and Yes ...

That's what makes these fora good, you'll get alternatives and test hints.

I don't have time right now, but go on...

Ware still restricted to 0 and 1 😉

If you can, just do it right now to the full size. This will not take more backup space !, but you'll neede the space if you restore.

If you...

I'm pretty confident SQLserver doesn't sort wrong.

Have a look at the binary values of your columns and it'll be clear why sorting is resulting in the set you get to...

raj acharya (11/11/2010)

can you help me for how to set data file or log file autogrowth.

actually till now we never faced problem of autogrowth most of database are set to...

With mirroring, only one of both databases can be available at an instance at a single point in time.

So the other is awaiting for log entries, hence in "restoring"...

I don't think so. simple reason ... this cannot be "at run time" but must be persisted, so a trigger is the only way.

I'm sorry I couldn't reply earlier, but I was in class the rest of the day.

As always I'm glad others jumped in and helped out.:cool:

- have a look at Jeff Modens article on tally tables or moving averages.

Those should get you started. http://www.sqlservercentral.com/Authors/Articles/Jeff_Moden/80567/

- maybe row_number() can get you a good enough solution. Check books...

Define "copy":

if that is the same objects without content, just script out your full db ( rightclick in your object browser hovering over the dbname, choose "all tasks" select generate...

The kb addresses sql2005 having this issue.

OP stated his server is sql2008.

But it is indeed a good hint on posting the @@version info of this instance.