Viewing 4 posts - 1 through 4 (of 4 total)
SQL Server 2019 now supports UTF-8 you can check if you have UTF-8 collations by running the following query :
SELECT Name, Description FROM fn_helpcollations() WHERE Name LIKE...
January 13, 2022 at 2:22 pm
Thanks for the article, very interresting.
Basically, your "other Unpivot" technique is a brillant way to use the new (from 2008) Table Value Constructor
Using the same method, from your first example...
August 2, 2012 at 7:01 am
Removing UAC will only deactivate the warning ("Do you want to allow ...") I receive everytime I "Run as Administrator". It does not resolve my problem.
But thanks for the idea.
January 28, 2011 at 12:44 pm
Thanks for your answers. I have solved my problem.
I executed [msdb].[dbo].[sp_maintplan_delete_log] to cleanup old log files. Then I shrink the database and it worked.
September 29, 2009 at 12:33 pm
Viewing 4 posts - 1 through 4 (of 4 total)