Good point Lynn....

Ofcourse there is some extra code in script,but it makes sure that when i run it in different environments, it never fails.sometimes the proc may just not be there in...

Most likely, length of data from your select table exceeds the lenght of data in your test table. Check for lengths of columns in both tables.

25 indexes on an OLTP table is quite high. You may also want to look for partial duplicate indexes which can be merged with other indexes.

But carmellabanker, I can see your comments.........

Ok, i'll try that out...

SQLEnthusiast (4/17/2012)

---

It's not a script as such, but Visual Studio 2010 Premium and Ultimate has a schema compare facility which will do what you want.

You don't...

You may sit and consider how you are going to search your data. based on that ,create proper indexes and stats and that should reduce your problem to half.

Then you...

You can certainly automate it. Just search for sliding window partitioning in google and you'll get an idea to automate it.

Thanks Gail. I was thinking if there can be a way out for this so that I don't have to create a role in several databases I have 🙂

Hi Gail

So it means that if change compatibility level in sql 2008 to 90(sql 2005), then it will support syntex for 2005 as well as 2008 in my TSQL. If...

I got it resolved. Looks like it has to do with the Local Loging I was giving while creating the linked server. I used an administrator id there and it...

If you don't want anybody to make any updates, then making it read only should be good.

If you don't want even to read from data, then setting it to single...

To make it clear, you want a list of columns which anywhere contains a unicode character, right?

Thanks Jeff and Gail for your valuable inputs. You make me learn new things even in simple things...almost everytime 🙂

And Gail, when you say "actual executions ", doesn't it mean that I might see different objects(e.g. indexes) being used in actual execution plan. Whereas they were not used in...