MSSQL manager error

[cca]

Error When trying to view tables/stored proceedures etc:
Error: Object variable or With block variable not set.
Source: Microsoft.VisualBasic

Ticket:ISX-74139-415

Anyone else getting errors trying to view tables etc in mssql manager....and why can i see a whole bunch of db's that don't belong to the db owner.

 

[Stephen]

cca,

you see DBs because people have added "public" to their database.

As for the error, it is stripping possible "malicious" code out, its a pain, and why I never recommend using the web based manager, I'd highly recommend using aqua data studio.

 

[tanmaya]

Try using Internet Explorer. MS-SQL manager heavily relies on VBScript that is less to not supported on other browsers:
http://www.mozilla.org/support/firefox/faq.html#mozvsie

 

[Typ0]

cca,

you see DBs because people have added "public" to their database.

As for the error, it is stripping possible "malicious" code out, its a pain, and why I never recommend using the web based manager, I'd highly recommend using aqua data studio.

why would they do that?

 

[Stephen]

I don't know, but they do, it is developers Security is the last thing on some developers minds. I know first hand from some requests we get. Others are very good and think about it, many simply don't, until they are defaced.

 

[Typ0]

I don't know, but they do, it is developers Security is the last thing on some developers minds. I know first hand from some requests we get. Others are very good and think about it, many simply don't, until they are defaced.

it's silly and an inconvenience for everyone that has to wait to download all that metadata.