First disable the Foreign keys http://sqlserverpedia.com/blog/transact-sql-t-sql/how-can-i-disable-all-the-foreign-key-constraints-defined-for-a-database/ and do the rest of work

it might be because of schema/definition discrepancy.i ran you script on my system it doesn't show any issue/error related to sql 2008

Did you that exe restart it again ?

this link can help you to apply any sql script on multiple DBs one time

http://www.ssmstoolspack.com/

Bill "Bojangles" Robinson (12/17/2010)

---

are there any tools that can go through all the stored procedures on the server and automatically build showplan that can help us identify table scans and...

duplicate post reply here http://www.sqlservercentral.com/Forums/Topic1036335-391-1.aspx?Update=1

gupta.sreekanth (12/16/2010)

---

hi,

can any one tell how to transfer data from a table in one database to another table in another database.....if any one knows....please write sample query for...

removed

Are you observing any memory pressure ?

because Clearing the plan cache causes a recompilation of all subsequent execution plans and can cause a sudden, temporary decrease in query performance.

Thanks i got the point

Don't trust DBAs trust "F5"

It means that application is able to connect with sql server but it throws error inside it so i think debugging application...

On safer side i would say create some relevant indexes otherwise you can De-normalize some tables and then put some indexes.

instead you should keep '1900-01-01' for '000000'

though your requirement is not so clear but still i tried

declare @t table (

item_id int,

dates datetime,

qty int ,

Amount int ,

Status char(1)

)

insert into @t (item_id,dates,qty,Amount,Status)

select 1, '10/10/2010', 10, 250,...