Tag Archives: SQL Server

Finding all SQL Table References in a Database

Managing SQL server objects can sometimes be quite challenging. With tables references used in over 40 different object types, locating and isolating one particular table can be time consuming. The …

Tags: , , , , , , , | Posted under Programming/Coding | Leave a comment

Create ODBC DSN with WebsitePanel

ODBC DSNs are normally used by developers along with classic ASP applications. You can easily create them from within WebsitePanel (1) Login to DotNetPanel (2) Select Databases | ODBC DSNs

Tags: , , , , , , , , , , | Posted under DotNetPanel Administration, WebsitePanel Tutorials | Leave a comment

Using Excel to Update SQL Data

The other day a co-worker was trying to figure out how to help a client update a lot of individual fields in a SQL table.  He did not want to grant …

Tags: , , , , , , , | Posted under MSSQL, Programming/Coding | Leave a comment