http://tallguywebdesigns.com/blog My Online Notepad Mon, 18 Aug 2008 16:15:04 +0000 http://backend.userland.com/rss092 en 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 http://tallguywebdesigns.com/blog/index.php/2008/08/18/the-log-file-for-database-dtspackagename-is-full/ 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 ... http://tallguywebdesigns.com/blog/index.php/2008/04/30/apache-how-to-disable-directory-browsing/ exec msdb..sp_enum_dtspackages http://tallguywebdesigns.com/blog/index.php/2008/04/29/how-to-obtain-a-list-of-dts-packages/ 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 http://tallguywebdesigns.com/blog/index.php/2008/04/17/how-to-take-ownership-of-a-file-or-folder-in-windows-xp/ ' Rename File from Connection Option Explicit Function Main() Dim oFSO Dim sFileName sFilename = DTSGlobalVariables.Parent.Connections("Text File (Source)").DataSource Set oFSO = CreateObject("Scripting.FileSystemObject") ' Check for file and return appropriate result If oFSO.FileExists(sFilename) Then 'Main = DTSTaskExecResult_Success Main = DTSStepScriptResult_ExecuteTask Else 'Main = DTSTaskExecResult_Failure Main = DTSStepScriptResult_DontExecuteTask End If Set oFSO = Nothing End Function http://tallguywebdesigns.com/blog/index.php/2008/04/14/dts-package-check-for-file-before-importing-into-database/ ' Rename File from Connection Option Explicit Function Main() Dim oPkg Dim oConn Dim oFSO Dim oFile Dim sFilename Dim sFileDestination Dim sMonth Dim sDay Dim sYear Dim sHour Dim sMinute Dim sSecond ' Get reference to the current Package object Set oPkg = DTSGlobalVariables.Parent ' Get reference to the named connection Set oConn = oPkg.Connections("Text File (Source)") ' Get the filename from the connection sFilename = ... http://tallguywebdesigns.com/blog/index.php/2008/04/14/dts-package-move-imported-data-file-to-an-archive-directory/ I found out today that if IE security (Tools-> Internet options-> Security -> Internet or Intranet -> Custom level -> User authentication) is set to anonymous logon, you will get the above error. I didn’t find any mention for this cause so here it is. http://tallguywebdesigns.com/blog/index.php/2008/04/04/another-cause-to-error-while-trying-to-run-project-unable-to-start-debugging-on-the-server-for-aspnet-application/ The solution that worked for me: Open your Internet Information Services manager and from the [your machine]/Web Sites/ Default Web Site node select the virtual folder which stores your project. Right Click and select Properties to select the ASP.NET tab page. Make sure the correct version ASP.NET Version is selected. http://tallguywebdesigns.com/blog/index.php/2008/04/01/error-while-trying-to-run-project-unable-to-start-debugging-on-the-web-server-2/ sp_help_job returns information about jobs that are used by SQLServerAgent service to perform automated activities in SQL Server. EXEC MSDB.DBO.SP_HELP_JOB http://tallguywebdesigns.com/blog/index.php/2008/03/26/sql-server-retrieve-information-of-sql-server-agent-jobs/ List all the database on SQL Servers. SQL SERVER 2005 System Procedures EXEC sp_databases EXEC sp_helpdb SQL 2000 Method still works in SQL Server 2005 SELECT name FROM sys.databases SELECT name FROM sys.sysdatabases http://tallguywebdesigns.com/blog/index.php/2008/03/26/sql-server-2005-list-all-the-database/