Thanks for the info, guys. I definitely understand that SQL is generally the wrong place to manipulate the diplay of data. But our company just lost one of...

**A column can only return one datatype**

It seems reasonable that a table column could only hold one data-type, but I thought I could force a result-set to be more flexible.

I...

Oops, one slip of the mouse and the previous incomplete message posted.

Desired result set:

ACME 10/29/07 .77

BETA ...

Sorry, my description was incomplete.

The procedure captures averages and stores them in a table as floats. When I call up a result-set from that table I would like to...

Thanks for the help.

Can I substitute a windows type login (Domain\Name) for the "sa" in the sp_changedbowner proc? We don't assign anyting to sa.

Elliott

The MDF and LDF files are integral to the database. They are dynamic and they reflect each change to the database since inception.

The TRN and BAK files are optional:...

Thanks Mike and Andras.

That's the answer.  I guess I should have researched server variables instead of stored procedures.

Cheers,

Elliott

Hello Thom,

The advice from Andras to look up the documentation is sound.  Also, here's a step-by-step that might be helpful to you.

First, some prep work:  Place the backup file (.bak)...

Did you check to see that the new server service accounts for MSSQL and Agent are appropriate for the Owners of the Jobs?  Even though MSDB lists the owners, until...

Update:

I'm not sure yet that this is the reason the CPU was pegging, but I discovered that a domain password change had left the Witness server disconnected from the mirroring...

Not sure if this is relevant, but we are also running one SQL 2000 and one SQL 2005 virtual server on the same Windows 2003 server.  The virtual servers have...

Yes, taking the run-time environment out of 64 bit immediately fixed the problem. 

As Steve suggested, in Design time right-click on the Project (in Solution Explorer) to expose Properties.  Then under...

I will be back in the office on Wednesday.  I'll try to change the run-time environment and will post the results then.

Thanks again,

Elliott

Steve--

Good catch.  We have 64 bit Enterprise Edition. 

So what do I do to cause the package to execute under some other environment? 

Halfway there,

Elliott

Ah yes.  I had forgotten about that one.  Do you think Microsoft is going to deprecate sp_MSforeachdb anytime soon?

Thanks,

Elliott