Hi,
We screwed up (actually Alex did)
Our All-In-One Wonder Database building/upgrading tool has gone a bit rogue and has created every NVARCHAR column with the DEFAULT contraint of (N'#BLANK#') due to a bug.
But nobody noticed and one of the clients is live ¬¬;
Does anybody know where that string is stored in the sys tables so we can run an UPDATE query to make it go away? So far the only thing we can do is use enterprise manager to go remove them all by hand... :'(
Cheers,
Jim.
We screwed up (actually Alex did)
Our All-In-One Wonder Database building/upgrading tool has gone a bit rogue and has created every NVARCHAR column with the DEFAULT contraint of (N'#BLANK#') due to a bug.
But nobody noticed and one of the clients is live ¬¬;
Does anybody know where that string is stored in the sys tables so we can run an UPDATE query to make it go away? So far the only thing we can do is use enterprise manager to go remove them all by hand... :'(
Cheers,
Jim.