To redirect browser requests to another folder or Web site: Start IIS Manager. Click to expand * server name, where server name is the name of the server. Right-click either the Web site or the folder that you want to redirect, and then click Properties. Click one of the following tabs that is appropriate to […]
Author: Melvin
Categories
sp_rename
Changes the name of a user-created object (i.e. table, column, or user-defined data type) in the current database. Rename a table This example renames the customers table to custs. EXEC sp_rename ‘customers’, ‘custs’ Rename a column This example renames the contact title column in the customers table to title. EXEC sp_rename ‘customers.[contact title]’, ‘title’, ‘COLUMN’
Error Failed to save package file “C:\TEMP\tmp18D.tmp” with error 0x8002802B “Element not found”. Turns out that this is due to MSXML6 not being registered. Solution To register MSXML 6.0. From the Start menu, click Run. Enter the following command: regsvr32 %windir%\system32\msxml6.dll Click OK
Good article that uses VS 2005 to create an ASP.NET 2.0 web site that can create and send an calendar appointment to add to an Outlook 2007 calendar. Examples in both VB.NET and C# http://msdn.microsoft.com/en-us/library/bb655909.aspx
The cause of this problem is the SQL server has been configured to operate in “Windows Authentication Mode (Windows Authentication)” and doesn’t allow the use of SQL accounts. This was the default setting in my case, I got the error after installing a new instance of SQL Server 2005. I was able to solve this […]
DTS error: The log file for database ‘dtsPackageName’ is full. Back up the transaction log for the database to free up some log space. Solution: backup log epack_dev with TRUNCATE_ONLY
Categories
Getting Database Stats
You could use sp_helpdb [ [ @dbname= ] ‘name’ ]
Find and open Apache’s configuration file: httpd.conf Using a editor like notepad++ , edit the httpd.conf file and scroll until you find a line like this: Options All Indexes FollowSymLinks MultiViews To disable directory browsing carefully remove the line that says: Indexes and leave the line like this: Options All FollowSymLinks MultiViews Restart your apache […]
exec msdb..sp_enum_dtspackages
I keep getting the error message below, so I did a search and found the solution at the link below. Error: You do not have permission to view or edit the current permission settings for (filename), but you can take ownership or change auditing settings. Solution: http://support.microsoft.com/kb/308421