Hi Grant Fritchey,

Sorry if I didn't mention the issue clearly. I can explain the case here:

1. I have two servers( say A and B) , I have one stored procedure...

Hi Grant Fritchey thanks.

The settings are same, I will try updating the statistics. But then Im wondering if it is the problem with outdated statistics then how both are...

Hi Grant Fritchey, thanks for the reply.

I can confirm that both environment same code was ran for same set of parameters and getting same output. So the one thing...

Thanks IgorMi I will try this.

Ok, Thank you Gila.

I want to see the Index Key ( I know that it will be created on the Last Name and First Name ) and the Book Mark. I read how...

Thanks Gila, so that means there is no way to see the index is it? That is what I wanted to know, thanks for the reply.

Thanks all.

I have SQL 2008 and SQL 2012 in same machine and when I tried Start-->Run--> ssms it opened SQL 2008 not SQL 2012.

As people mentioned I might have...

Hi all,

I have installed SQL 2012 R0 and the SQL Server Management Studio property for SQL 2008 and SQL 2012 are showing different path as below:

SQL 2008

"C:\Program Files (x86)\Microsoft SQL...

Fine,

Let me try after installing it. Thanks to all once again.

Hi Koen,

Thanks for reply. Usually I open the management studio by typing the short cut in Run as below

SQL 2000 --> isqlw

SQL 2005 --> sqlwb

SQL 2008 --> ssms

So if I...

Thanks for the reply ,

But if we have both SQL 2008 and SQL 2012 , then will SSMS work ? In that case which one it will open?

Sorry to...

Hi,

I don’t think upgrading the .Net framework will help to resolve this. Here the problem is Excel 2003 will not support more than 65000 rows. The higher version supports more...

Hi gyoung,

Please try the below expression.

=Ceiling(Rownumber(Nothing)/10)

Deepak,

Yes it is possible, check the check box for repeating header in each page.

Hi Flo,

Thanks a lot for the explanation. 🙂 Now it is clear for me.