Sorting Helm 3.x Database

andy18    Helm    

If you need to sort out the username, domain name and the package type hosted under a reseller, the following SQL query may help:

use HelmDBName
select PackageType.ResellerAccountNumber, Package.AccountNumber, HostDomain.DomainName,PackageType.PackageTypeName
from PackageType, HostDomain,Package
where PackageType.PackageTypeId = Package.PackageTypeId AND
Package.PackageId = HostDomain.PackageId AND
ResellerAccountNumber = ‘Reseller_Username‘ AND
HostDomain.SubDomainId = 0 AND
HostDomain.DomainAliasId = 0

Changing the default SQL 2005 data directory

andy18    SQL-related    

Default installation of SQL 2005 has the data directory set at C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. However, if you are looking to setup another RAID volume that separate the database(s) data directory from the default, you may do this by firing up the SQL Server
Management Studio > Right-click the server in the object explorer and select Properties > Database Settings. Change the Data and Log directory to the disk drive that you wish to or any other folders.