User Profile
ggp_92020
Copper Contributor
Joined Nov 16, 2022
User Widgets
Recent Discussions
Re: Database Level Collation Issues
carlwalk Thanks, it has been reliable 65% (about 80+ times so far) of the time, and to be clear, it does change all objects down to table/column and all other dependencies. So, my ask is what is a better method for large enterprise-based databases sing SQL Server?45Views0likes0CommentsDatabase Level Collation Issues
Some background information. In the past we had a database where we didn't really care about collation at the database, table/column, functions and views. Though now we have a requirement due to a technology acquisition, requires SQL_Latin1_General_CP1_CI_AS. Microsoft seems to not have a simple method that guarantees changing the collation throughout the database on complex DBs with large amounts of tables, columns, functions, etc... specially with high dependencies, FKs and PKs and not affect any of the data (no moving the data is not simple). I have a command, where I stop all of the SQL services and any connections to the DB and use the following command line to change the collation to the one I specify. The issue is this command only works about 65% of the time and no clue to the why it fails the other 35%. The command used is: The parameter "-s" is necessary only if you have a named instance, remove the -s if no instance. sqlservr -m -T4022 -T3659 -s"SQL2019" -q"SQL_Latin1_General_CP1_CI_AS" or sqlservr -m -T4022 -T3659 -q"SQL_Latin1_General_CP1_CI_AS" When this does not work, I have a set of 6 SQL scripts to tear the database apart in a complex method to get them operational. Does anybody have any idea why the hit and miss on the command? Or a better method / way to fully change the DB collation?137Views0likes2CommentsNew Outlook Calendar events notification not working.
Using the New Outlook (understand it is like the web version) I no longer receive event notifications in Windows and have missed some meetings. Now other parts of the New Outlook do hook into Windows like day\night so it can and does interact with the desktop. Why are no notifications raised for meetings? - this is a huge issue. I checked and double-checked, all of the notification settings are enabled. Help!654Views1like1CommentNew Outlook Delete Email on Close
Previously when I closed the original Outlook all emails in the Deleted Items would be deleted. This is not working in New Outlook. Though they have changed the words to the Settings to "delete on sign out" - how cares on sign-out. I have hundreds of emails a day in the deleted items. How do I get the deleted emails to "delete" on close again? Tried all of the hype I found in a search, no joy!Solved6.9KViews0likes3Comments
Recent Blog Articles
No content to show