t-sqldotnetnukekeyworddotnetnuke-5
Where is DotNetNuke page keywords stored in database?
Which SQL Server table can I locate keywords associated with a page in DotNetNuke?
Solution
Took me awhile to find it...
Keywords information for a single page is stored in a "Keywords" field within a table called, somewhat unintuitively named, Tabs
Keywords are updated through a sproc named AddTab.
Found it through DotNetNuke source code.
- How can I group time by hour or by 10 minutes?
- SSIS Error: External Column for Source out of sync with Data Source columns; How do I remove External Columns?
- TSQL Calculate week number of the month
- SQL Proc Modification Question
- TSQL Pseudo Random text generator
- T-SQL SELECT DISTINCT & ROW_NUMBER() OVER Ordering Problem
- Sort Month Name in SQL Query
- What does the new stored procedure default content mean?
- When should I use semicolons in SQL Server?
- SQL Server TRY...CATCH Is Not Catching An Error
- Truncate (not round) decimal places in SQL Server
- How to use SET XACT_ABORT ON the right way
- Find if any row parameter value was equal to 1 in period of time
- How to best write a TSQL script to create or alter a stored procedure that has a table-value type as parameter, preserving GRANTs
- How to get identity of another table record inside after insert trigger caused by a transaction for current scope and Session?
- There is already an object named '#columntable' in the database
- How to alter a function with dozens of dependencies?
- Getting a count dynamically for Customers first time orders and also orders lost after last order date + 4 months, per year and month
- Replacing RAISERROR with THROW
- Paging with TSQL, MVC3 and SubSonic?
- Problem with SQL Query Tracking
- How can I get TSQL from easy MS Access SQL with little to no handiwork?
- Each GROUP BY expression must contain at least one column that is not an outer reference
- How do I perform a GROUP BY on an aliased column in SQL Server?
- SQL Server pivoting on data without an aggregate
- SQL Server PRINT SELECT (Print a select query result)?
- "Dynamic" tables in SQL?
- SQL Merge SOURCE order and OUTPUT order
- Output of update statement does not show correct row number
- Date and time range filter in SQL