Category: SQL

Install a new SQL Server Instance from Command Prompt

I was having some issues doing a standard install of SQL Server 2005 SP2 (Standard). No matter what I did, the install complained about versioning issues. I knew you could blindly run a full install from command promt but I had never needed/wanted to. Out of desperation I decided to give the install a try from command the prompt and had great succcess.

setup.exe /qb INSTANCENAME=EGPS ADDLOCAL=SQL_Engine SAPWD=***** AGTACCOUNT=ComputerName\Services AGTPASSWORD=***** SQLACCOUNT=ComputerName\Services SQLPASSWORD=***** SQLAUTOSTART=1 SECURITYMODE=SQL

Read more...

0 comments - Posted by Russell Brown at 11:55 PM - Categories: SQL | Windows XP | Development

How to find a table based on a column name

I've been asked how to do this about a dozen times by developers who were not very entrenched with SQL and I've had to do it my self a handful of times.

I know the column name (or at least part of it) but I have no idea what table in this massive DB it lives in; how do I find it?

A simple query will net you the results you need:

SELECT
    so.name AS [Table], sc.name AS [Column],
    so.xType AS [Table Type], st.name AS [Data Type]
FROM dbo.syscolumns AS sc
    LEFT JOIN dbo.sysobjects AS so
        ON so.id = sc.id
    LEFT JOIN dbo.systypes AS st
        ON st.xtype = sc.xType
WHERE sc.name LIKE '%Partial Column Name Here%'
ORDER BY so.xType, so.name, sc.name

Read more...

0 comments - Posted by Russell Brown at 11:31 AM - Categories: Debugging | SQL | Development

iPod and iTunes - Parsing the XML Library

I ran across an interesting blog entry from Peter DeBetta where he shows us how to parse the iTunes library with T-SQL. I'm not really sure what to do with this information yet, but I like it non the less...

0 comments - Posted by Russell Brown at 7:52 AM - Categories: iTunes | SQL | Development