SQL2K5 headscratcher

[jkellington]

I have what I'm sure is a stupid problem with SQL2K5. Ive an extremely simple table as follows:

ServiceID (int, pk, identity)
Name (varchar[50])
IsPublic (bit)

When I open the table in Management Studio and attempt to enter the value for IsPublic in a new row, it doesn't like what I enter, and gives me an error message about the changed value in the not being recognized as valid, and that String was not recognized as a valid Boolean.

I've tried entering 1, 0, YES, NO, Y, N, etc, etc. to no avail. Can someone out there tell me what the heck I'm doing wrong here?

Thanks,
Jason

 

[jkellington]

Never mind, the problem wasn't stupid, I was. Who would have thought 'true' and 'false' woudl be the required values in a boolean field? Yikes, I need a holiday. Sorry if you;ve wasted your time reading this one.

 

[mrdenny]

Keep in mind that this is now a Visual Studio GUI. So there is all sorts of weird little things like this for us DBAs to get used to.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com