Sometimes the messages lead you astray. I thought it was having trouble with the Big int in an SP. so I did not think I had missing parans....

Boy that was a tough one! I am such a bonehead.

I just recently posted another thread on this

http://www.sqlservercentral.com/Forums/Topic661860-149-1.aspx

I am running into the same situation. Whether it be a solution or a work around did anyone figure something...

the firewall was turned off but the service was still running. so I got the odbc to connect only to find that assemblies that were made in 05 are...

This is not an upgrade. It is a clean install. I also tried to connect using odbc and it will not allow me to connect.

I ended up finding this

SQLServer2005_SSMSEE.msi

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

I can still not upgrade the developers box but I got studio on it. So it is resolved.

The directory was deleted. how and what would I do to edit the registry to make this server upgrade.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx?PHPSESSID=0324345d45ef1bf1f764044e03584cd0

There are limitations like 4gb limit and others that can persuade you either way

That is basically what the timestamp is doing. I am trying to figure out how to let the users know what changed. It will not just be one...

I think you are asking about Collation

ms-help://MS.SQLCC.v9/MS.SQLMobile.v3.en/SSMProg3/html/eee6bae6-0c15-4959-9cd8-c8fe7c440bf0.htm

Depending how the DB is set up there is a default. If you want to change it you can do it at the...

I am not really sure but are there even 61 records in the table/page. Is it possible you have a trigger or something under the table running you do...

That will not be a for a while. nice thing about an SP is if it gives me grief I can change it to a @Table and be done....

So I have the results. Of course I do not have actual DBs that big. so in this query I actually did not get any records back since...

When I do the index wizard there are not any optimizations. also I think it is only within the SP itself since there is only one #. ##...

Yup I am just looking for exceptions. That solutions works. Thank you. I knew I was not putting something together