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.

I would also double check if there is no concurrent full database backup running at the same time. Although the errormsg doesn't state it explicitly ... I would just check...

Don't rush in to...

I really don't want to kick a fallen peer, but this is near to the up most mistake people make when designing tables.

Use the correct data type for your...