Changing in permissions causing "Unable to cast object of type 'System.DBNull' to type 'System.String'." error

[elijj]

Hi,

I had been succesfully running schemazen routinely like this:

SchemaZen.exe script --server serverName --database dbName --scriptDir "c:\Users\.." -o

with no issues and finally today i am catching

"Unable to cast object of type 'System.DBNull' to type 'System.String'." error

any ideas what is going on? I am thinking possibly my permissions changed on the server. If so what permissions are required to run? Please let me know if I can provide any more helpful information.

[keith-hall]

if you're able to run a sql trace you could maybe see which query is returning null and causing this problem, or if the stack trace shows any details like filename, line number etc. we could guess what sql object you need view permission on.

[PedroMiguelFigueiredo]

Hello. I have the exact same problem... any news on this?