Technology Insights

Get physical path to SQL Server 2005 data files

To get the path where SQL Server 2005 stores data files for databases, you can use the following T-SQL script: USE master GO DECLARE @data_path nvarchar(256) SET @data_path = (SELECT SUBSTRING(physical_name, 1, CHARINDEX(N’master.mdf’, LOWER(physical_name)) – 1) FROM master.sys.master_files WHERE database_id = 1 AND file_id = 1) SELECT @data_path AS DataPath It uses the built-in “master”…

Technology Errors

Business Objects gives error “class com.businessobjects.wp.tc.TCMain not found”

When upgrading from SAP Business Objects XI R2 service pack 1 to service pack 2, I got the following error in the Java runtime console when trying to create new or use existing Web Intelligence reports: load: class com.businessobjects.wp.tc.TCMain not found. java.lang.ClassNotFoundException: com.businessobjects.wp.tc.TCMain at sun.applet.AppletClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.applet.AppletClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source)…

Technology Insights

Install git-svn on Windows

The git-svn tool is a simple conduit for changesets between Subversion and Git. It provides a bidirectional flow of changes between a Subversion and a Git repository. The latest msysgit distribution of Git for Windows (version 1.6.1 preview 20081227 at the time of this writing), does not come bundled with the the git-svn tool. This…