The easiest way to convert an Access database to SQL Server is to use the Upsizing Wizard. Step 1 Preserves database structure, including data, indexes, and default settings. Automatically converts Access validation rules and default settings to the appropriate SQL Server equivalents. Maintains table relationships and referential integrity after you upsize. Step 2 To […]
Step 1 You will need to create the following stored procedure: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 […]
Step 1 The following stored procedure can be very handy when you need to change the ownership of a table or any other object on your MS SQL database: 1 EXEC sp_changeobjectowner Step 2 Here is the Syntax: 1 EXEC sp_changeobjectowner ‘USERname.OBJECTname’, ‘dbo’ This example changes the owner of the TEST table owned by […]
A DSN-less connection avoids the overhead of a datasource/DSN connection. It is a faster and recommended way to access your database. Please refer to this article on ASPFAQ.com for detailed information. <!– –>
Hyper-V VPS Video Tutorials & Article Index (Additional tutorials are located here) IIS 7 Configuration – Backup and Restore How to configure an IP address in Windows Server 2008 Installing DotNetNuke (DNN) using WebPI Installing DNS Part 1 – Installation Installing DNS Part 2 – Configuration Getting to Know Expression Studio Getting to Know […]
1. Log onto a Windows machine 2. Open up a command prompt and use the following syntax shutdown /r /m \servername.appliedi.net This will send a remote reboot command to the host you’ve specified. If the user you are logged in as does not match the server’s admin user or password; open up a network share […]
After being migrated from the Virtuozzo environment to Hyper-V, you need to run the Plesk Reconfigurator so that Plesk picks up new settings.Please follow all steps below.Launch the Plesk Reconfigurator by going to your Start Menu, and then All Programs -> Parallels -> Plesk ReconfiguratorFirst, click the ‘Change server IP addresses’ link. We won’t be […]
In Windows Server 2003, you could right-click on an application or batch script and select “run as…” to select a different user to run the application under. This feature is not part of Windows Server 2008 by default. It is included in later versions of Windows Server R2, but not as obvious to use. If […]
This tutorial will show you how to install and configure DNS services on your dedicated server or VPS server. This tutorial assumes you are not using a control panel system such as Helm or Plesk (if you are then the DNS setup is automatically done for you when you add a domain to your server […]
You can add users to your server to either password protect web pages or to allow FTP access.To add a user to your server, go to the ‘Computer Management’ tool under Start -> Control Panel -> Administrative Tools:Expand the ‘Local Users and Groups’ folder and right-click on ‘Users’ and select ‘New User…’:Fill in the information […]