Jump to content

Unable to see SQL table following failed update script


Martin_S
 Share

This topic is 2534 days old. Please don't post here. Open a new topic instead.

Recommended Posts

OK, so I have two SQL tables in my solution, and overnight the password for the SQL access account expired. I have changed the account to non-expiring and reset the password, but when running the two update scripts, one works perfectly, the other runs instantly yet completes. Stepping through the script, It goes to the SQL layout, and that is empty, so it can't put data from the SQL table into the holding table. Of the two tables (these are in-fact Views) which contain the data (both are correct and contain data on the SQL server), only one of the two is populated.

The only change I am aware of is switching the source database table to unicode - could this be the issue?

Thanks

Martin

Link to comment
Share on other sites

The unicode question is not relevant - the other view that I can see also has fields in unicode and these work perfectly. I did also adapt my view to cast the columns back to varchar, but that made no difference.

 

How come I can see one view from the same database, but not the other?

 

Thanks

 

Martin

Link to comment
Share on other sites

This topic is 2534 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.