Interestingly I created the table on second table from same script as in main server. So i don't think there is any kind of column data length mismatch issue.

Can someone help on it ?

Got it. Thanks experts. There was one new column which has unnecessary kept me occupied. I should have tested that in first place. however there is new error "String data,...

Thanks for clearing my point Grant. That certainly says that in my scenario, "with recompile" option is required. However in this case how can I stop SQL to create efficient...

Hi Grant. As per my understanding the 'with recompile' option to be used only when there are different range of parameters passed to the procedure. As long as there are...

Thanks a lot Gail. This is exactly what I was looking for. Thanks one again for sharing this link.

I'ev checked a lots of them already but don't understand which values to use for checking memory pressure while running my code.

Thanks Anthony for pointing that out. I closely checked and founf that there were few files having same name for both databases and that's why it was giving some value...

Exactly and thats what my point is...

USE DB1

SELECT * FROM DB1.dbo.Table1

and

USE DB2

SELECT * FROM DB1.dbo.Table1

gives same result [as they both refer to smae table in DB1]. Same way the following...

Seems I missed that condition. Thanks for the amendmend Andy.

Cheers. 🙂

SQLKnowItAll (4/4/2012)

---

It is because you are still referencing the view in Database1 by fully qualifying it. If you want the USE keyword to do anything, you have to change Database1.sys.database_files...

For Dev environment, it's better to have any audat extra column having host_name as default value. I am using it at my environment and it's working fine for me. Even...

Here are few useful links:

http://technet.microsoft.com/en-US/library/ms345368(v=SQL.90).aspx

http://technet.microsoft.com/en-US/library/ms175527(v=sql.90).aspx

http://msdn.microsoft.com/en-us/library/ms190768.aspx

Check if this helps.

select * from #table1

where (ItemID like 'LGE%' or ItemID like 'SAM%' OR ItemID like 'HTC%')

and (ItemID like '%-S' or ItemID like '%-R' or ItemID like '%-IR')

and...

Sorry for the delayed response. There seems to be issue in the input file.