Haven't seen this anywhere. It sounds like an issue with the Oracle driver from MS, you might need to contact them.

Hey, if you build one, send it in (articles@sqlservercentral.com). Be a good thing for our next book to help others out with.

Are you looking for a form to give to users so they can request a DB?

I don't have one handy, but we used to ask for size(data), guess at transactions...

There isn't a good way to do this. Some of the 3rd party vendors like Red Gate, have figured this out for their Compare tools, but they haven't published a...

Just install SQL on one of the servers, people can connect via IP or the NetBIOS name.

check the tables involved you may have conrruption in one of them.

Jimmy, the index thing seemed like a good guess. If it's just the display, I'm not sure what's wrong there. If it's really bugging you perhaps you want to contact...

What does your sproc look like? Why are you passing in the query? I'd expect the sproc takes a parameter for the price and you only pass in the 10.

I received this as a post with a long explanation of why it didn't work. It seemed reasonable to me and honestly I didn't setup a test for 4200 Unicode...

http://www.sqlservercentral.com/columnists/sjones/moveyourmaster.asp

http://www.sqlservercentral.com/columnists/sjones/movingmsdb.asp

http://www.sqlservercentral.com/columnists/sjones/atemporarymove.asp

Please keep the comments on topic and professional. What may be "nuts" to you, may solve a problem nicely for another.

Marshall, the PK is the unique set of values in...

Apologise for the miswording. I changed Jonathan's wording slghtly because it wasn't clear to me. Apparently, my choice wasn't much clearer. It's been reworded to be (I hope) more clear.

good catch, it's corrected.

CREATE PROCEDURE ListMyTable( @Op As Integer, @ParamValue As Integer)

AS

IF @Op = 1

select table_id from mytable WHERE COL1 = @ParamValue

ELSE IF @Op = 2

select table_id from mytable WHERE COL2...

Select the public role, right click, properties, then permissions button.