Do you run all the DTS packages in a job?  If so, use parameter and dynamic properties and when you move DTS package from server to server, you don't need...

I used dynamic task and it populated the subject line fine.

Don't use Cognos. It sucks.

Don't use Hyperion.  Oracle just bought it, you don't know what would happen to this product.

I used to work for a bank and the unit was student loan processing.  The bank did asked the employees to do a lot of community services at working hours...

the select statement, you had a '.' instead of ' at the end.

select 'Unmatched results as of (' + convert(varchar(30), getdate()) + ')'

I am not trying to defend Microsoft.  I used to work for a software development company, when the company announced the software released date, and you knew it was not ready, you...

I am asking which position in greater demand, so you are telling me more people looking for DBA than developers.

That is what I did using xp_cmdshell

EXEC master..xp_cmdshell 'DTSRun /S "ServerName" /E /N "PackageName"

/W "0"  /A ReportName:8="ReportName" '

Many IT positions have to be on-call too including the DBA. (Although in my last company, when I called the on-call DBA, no one ever answered my call.)

I was on-call...

You have to deallocate the cursor after you close the cursor.

Removes a cursor reference. When the last cursor reference is deallocated, the data structures comprising the cursor are released by...

CREATE TABLE #Temp (Field1 NVARCHAR(10))

INSERT INTO #Temp (Field1) SELECT '20'

SELECT '1'

UNION

SELECT '10'

UNION

SELECT '45'

UNION

SELECT '100'

UNION

SELECT '210'

UNION

SELECT 'abc'

UNION

SELECT '20'

DECLARE @LEN INT

SELECT @LEN=MAX(LEN(Field1)) FROM #Temp 

SELECT Field1...

1.        Depending on which company you work for, not all the IT guys get highest powered machine.  My PC at home has more power...

I put out a thread about 7 down sides of IT (same article), not many people responded.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=345848

I had the same problem and I could figure it out.  I am glad I saw your post and now mine is working.

But I don't understand why I need to...

Since my son is already in high school, so I don't get much interruption. When he comes home from school, the first thing he does is turn on his...