All Questions
Tagged with kentico sql-server
16
questions
0
votes
1
answer
230
views
Can't get to next stage of Kentico application configuration
I'm trying to get my web application up and running. It uses Kentico. I connected to the admin page which is taking me through the initial database ans site setup. It ran through "Creating ...
0
votes
1
answer
783
views
Failure to to connect after Adding Kentico into ASP.NET MVC project
My ASP.NET MVC was in middle of development, so I researched about how to add media into the project and I come across the Kentico libraries.
And I tried to add Kentico.Content.Web.Mvc, Kentico....
1
vote
1
answer
415
views
Copy Kentico's production database to development
We have Kentico 11.0.26 with MVC.
Was trying to set up a development instance of Kentico database by copying the production tables. Created new database using SSMS, and then using import data wizard ...
0
votes
1
answer
3k
views
Hint 'noexpand' on object 'View_CMS_Tree_Joined'
I'm about to try an upgrade from Kentico 9 to 10. I had to change a column from varchar to nvarchar.
To do this I had to update an index so it didn't use the column and then remove a view, then added ...
0
votes
1
answer
156
views
Displaying SSRS Reports in Kentico Results in ClientID Errors, How to Interpret Documented Solution?
So I have deployed a report in SSRS, and I can view it at its hosting location at localhost. Now I'm trying to get the report to display in a ReportViewer control in a Kentico webpart. I get the error:...
0
votes
3
answers
412
views
fill asp dropdown list with SQL records by using kentico API calls
okay, it seems that no one is explaining the process of this issue completely, even kentico's documentations are not well organized and clear. My problem is that i have more than 50 records in a table ...
0
votes
1
answer
2k
views
GridView Disappears on Update Button Click, Doesn't Update Record
So I have a c# page with a GridView. For some reason, after adding the label and the template for editing, when I click the update button in the edit column, the GridView disappears and none of the ...
0
votes
0
answers
149
views
SQL Server hosting Kentico DB has high CPU
I am a DBA. I see that the SQL instance on the dedicated server has an average 50% CPU being consumed and all by the SQL server. There are few queries which have very high CPU usage. I have looked ...
0
votes
1
answer
72
views
My Kentico version 7 to version 8 upgrade script is still executing after 72 hours. Is this typical?
We're following the Kentico guidelines for upgrading our CMS from version 7 to 9 by way of Version 8 and 8.1 in hops.
72 hours ago the upgrade script was initiated. It's still executing at a steady ...
0
votes
1
answer
221
views
Can we add extra column to unigrid for default cms modules in kentico
I want to add a "timezone" column to the grid shown above. The "Countries" module is under the "Configuration" section. How can I add the column? Is it possible?
0
votes
1
answer
155
views
List Kentico 7 published pages
I inherited a CMS with some pages that are hidden or archived with published pages beneath those and I'm trying to get a scope for pages that are available to be viewed that are linked via other pages ...
2
votes
5
answers
1k
views
SQL Order by DESC on alphanumeric field with numbers before words
I have a column in a SQL table I'm trying to do an order by on. The data needs to be in desc so it shows more recent years first.
Sample Data Expect Output
----------- -------------
...
13
votes
2
answers
43k
views
how do I change schema owner in ms sql server?
I currently have a website hosted developed with kentico 7. I tried importing the exported website into my localhost and that failed. In my findings, i realised that each table in the online version ...
6
votes
3
answers
12k
views
SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. The specified LocalDB instance does not exist
EDIT: One important detail that I original left out (because I didn't know it was important) is that we were running these sites in full IIS, not from IIS Express.
We're trying to setup local dev ...
0
votes
3
answers
711
views
ERROR: Error importing 'System tables' objects (Ecommerce - SKU) in Kentico
I am having problems importing from a file created by Kentico running locally using sa loggin, to an instance of Kentico running at a hosted site using a hosting space login.
The following error ...