select o.name,

i.name

from sysobjects o,

sysindexes i

where i.id=o.id

and...

...to_date('31-JAN-2009','ddMONYYYY' ' )... syntax is not correct.

It should be like to_date('31-JAN-2009','dd-mon-yyyy')

I assume you are talking about a wild, non-secure development box.

Shutdown the suspected databases, wait three month, if nobody comes crying foul take a full backup and drop it.

Mike Levan (3/22/2009)

---

yes i did but i am looking for a script which move tables from primary file group to secondary file group.

or i can put it this way..

I would...

iqtedar (3/20/2009)

---

I just need to do data refresh..just data for the tables...i tried all possible ways never works properly...here is wat i did.

i) disable foreign keys EXEC sp_MSForEachTable 'ALTER TABLE...

Please also describe your backup strategy and what you did while trying to restore.

As previous poster asked, post log files.

I'm sorry for not being clear.

Let me translate my previous post: 100% 😀

SQL Server would extend a datafile when space is needed and no space is availabe in any...

danielmonro (3/19/2009)

---

I am trying to install a certain database onto a different named instance by detaching the file copying it and pasting it to the desired directory which the named...

:w00t: Buffer overload?

Please check this http://blogs.msdn.com/sqlprogrammability/archive/2007/01/17/10-0-plan-cache-flush.aspx

yeah... we know issue started sometime after SQL Server startup -which is what log is showing - but, you may want to pin-point the issue a little more carefully....

You just answered you question, call a couple of hardware vendors and ask for the BEST they can...

sbk (3/20/2009)

---

[p]I want to know, when is the transaction logs are committed to the database? Like after taking transaction log backup or after succesful full backup? And when will...

There is nothing wrong with Secondary.

I really doubt you know in which physical order rows are stored in a table, what makes you think you know how they got stored?

If...

30 Gig is a small size database meaning you shouldn't see backend performance issues providing data modeling and physical implementation are reasonable well done. Most of your performance issues...

I do not think the information you are asking for is public domain but experience suggests there is not such a threshold.

The most likely scenario is that SQL Server would...