Register
Login
Register
Login
Search
Home
Applications
Content Management System
Custom DNN Modules
Business Directory
Restaurant Menu Manager
Custom Database Reporting
Distributor Locator
Gift Certificates
Date Time Calculator
Consulting
Design
Surveillance Systems
Business Links
Support
Knowledge Base
Contact
SQL Scripts
Support
/
Knowledge Base
/
Microsoft SQL Server
/
SQL Scripts
Snippets
Current Articles
|
Archives
|
Search
SQL Scripts
NO Image:
20
How To Clear All Containers And Themes From Pages And Modules In DNN
DNN Expert
posted on February 20, 2024 15:06
Clear all page level skins in a Portal update {databaseOwner}{objectQualifier}Tabs set skinsrc=null where SkinSrc is not null and PortalID=0 ...
[Read the rest of this article...]
Posted in:
DNN
,
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
01
SQL Function to Lookup DNN Profile Values
DNN Expert
posted on February 01, 2021 15:20
CREATE FUNCTION GIBS_GetProfileElement ( @userID as int, @portalID as int, @ProfilePropertyName as nvarchar(100) ) RETURNS nvarchar(4000) AS B...
[Read the rest of this article...]
Posted in:
DNN
,
Stored Procedures
,
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
23
Disable DNN Popup Windows
DNN Expert
posted on September 23, 2020 06:19
UPDATE PortalSettings SET SettingValue = 'False' WHERE SettingName = 'EnablePopUps'
DNN Popup Windows
Posted in:
DNN
,
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
05
Remove any leading or following spaces as well as any carriage returns
DNN Expert
posted on December 05, 2018 08:05
UPDATE YourTable SET YourColumn = RTRIM(LTRIM(REPLACE(REPLACE(YourColumn, CHAR(10), ''), CHAR(13), '')))
Posted in:
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
20
Update NBrightBuy Image Path when upgrading from V2
DNN Expert
posted on December 20, 2016 06:08
-- Used this great tool (https://github.com/FabioParigi/NBrightBuyMigrate ) but ran into a problem with images -- Create a SP to verify the old strin...
[Read the rest of this article...]
Posted in:
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
23
Order By Domain Name from Email Address
DNN Expert
posted on April 23, 2016 05:09
SELECT UserID, Username, FirstName, LastName, IsSuperUser, AffiliateId, Email, DisplayName, UpdatePassword, ...
[Read the rest of this article...]
DNN Users
Posted in:
DNN
,
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
Page 1 of 3
First
Previous
[1]
2
3
Next
Last
Archives
Azure (1)
C Sharp - C# (37)
..private void function() (11)
CraigsList (0)
CSS (15)
DNN (58)
..Modules (21)
....Core Modules (6)
....Custom Modules (34)
..Resource Links (2)
..Skin Objects (2)
..Social (1)
DNS (0)
E-Mail (3)
IIS (3)
Malware (1)
Microsoft SQL Server (17)
..Azure SQL Database (1)
..SQL Scripts (16)
..SQL Server 2008 R2 (11)
..SQL Server 2014 (1)
..Stored Procedures (6)
Networking Problems (7)
Operating Systems (1)
..Windows 7 (3)
..Windows Server 2003 (1)
..Windows Server 2008 (2)
..Windows Server 2012 (2)
..Windows Vista (2)
..Windows XP (4)
PCI DSS Compliance (1)
SSRS (1)
Technology (139)
VbScript (3)
Web Design (7)
Web.Config (5)