well, you have two main things you can do.

1. look for instmsdb.sql, within the default install binaries, [DRIVELETTER]\Program Files\Microsoft SQL SERVER\MSSQL.1\MSSQL\Install.

Search for the...

Here ya go, I was able to get through this and I hope either one of these will work for you if you come across this issue.

A.Prepare a dos window...

Thanks for the quick response.

I've tried doing the install with mixed mode using a 16 character based password as well as doing the install with windows authentication. But nothing...

unfortunately there are no dumps associated to this issue. Even the error log does not show anything related to this, i just have messages from my routine log backups.

But here...

Thanks for the reply. I came across an article that showed me how the uninstall process works. Appreciate it.

So, I should be able to call this store procedure and have reporting services format the result set into an excel format?

Hey thanks for the idea SSC. In this environment they have sql 2000 with the main db's and then their using sql 2005 reporting services for their reports.

The stored...

in looking further into this stored proc, it looks like it declares some type of table in memory, then proceeds to gather info from permanent tables and inserts this...

Hey thanks for detail on this, appreciate it. I've tried other simple tests and no problem...I can get the data I'm looking for formatted into excel. I just can't get...

pretty much the only message is 'invalid pointer'. i can assume from this that my column mapping is wrong. but when i checked under the transformation tab, the columns are...

Invalid Pointer.

I went ahead and created a blank spreadsheat with the four columns and then pointed the excel object to this file. Under the 'Destination Tab' I created a...

hi, i came across this posting and was wondering if anyone found out the resolution. i encountered the same problem today and came across this posting...from 2004.

i have an...

MattieNH,

you hit the nail on the head!! Thanks for the great help!

I was wondering if I could ask a question concernig the script? When you call the 'when'command :'when charindex('TWP',...

thanks everyone for your insight. what i did was to take this portion out, tweak it a little, and place it into a separate job that runs once a week...

sorry about that, the name of the table is 'curr_cost_model' not current_cost_model'.

so the this section of the code: select @drop_oldtbl = stuff(@tblnm , 17, 2, ltrim(str(DATENAME(ww,getdate()) - 6))), is actually...