My note related to "change platform target from 'Any CPU' to 'x86' " was for build when we generate dll to make 3rd party SSIS data flow component. You...

Soorya,

Did you put it at Program Files (x86)\...\100\DTS\Pipeline Components or Program Files\...\100\DTS\Pipeline Components. Also does your component reference SQL Server 2008 or SQL Server 2005 dll? I have...

I want to let everyone knows that this issue is now fixed. It turns out that when we want to force an application to behave in 32 bit mode,...

Yes, That is how I was able to manually run in 32 bit debug mode using the following method: http://dougbert.com/blogs/dougbert/archive/2009/03/16/debug-your-package-in-32-bit-or-64-bit-mode.aspx

--sopheap

Thank you Julie. I am able to manually run this package on a 64 bit server in debug mode. Todd's blog doesn't describe if there is any behavior...

lmu92,

Thank you for sending that link to rusanu.com for this sample piece. I am new to service broker and it seems like there is a disconnect as to what...

I would recommend that you follow this link resource:

http://www.mssqltips.com/category.asp?catid=11

I have read through most of these documents and I have to say that they are pretty good.

--sopheap

The answer are still the same "It depends."

What HA/DR technique are you comfortable with, is there an in house expert on that technology, or do you rely on consultant?

How...

Niyala,

Are you planning to run 1 cluster with multiple sql instance (not sure if this is possible)? or are you planning to run 1 pair of cluster with multiple cluster...

After reading conversation on this topic, I think the biggest issue is trust. It is something that both SQL DBAs and Server Admins need to learn about each other's...

Thank you Steve

It looks to me that the server could not find master file. It is looking for it at: F:\MSSQL\OVOPS\Datafiles\master.mdf Can you verify that you actually move master.mdf to...

How about start sql server with minimal configuration and single user mode -m and -f. Once your server is restart, you could alter the database and set the right...

Don't forget to get a quote with and without SA (Software Assurance). There are advantage and disadvantage with this option, I am not an expert in this area, but...

Hi,

Correct me if I am wrong, but I think SQL Server 2005 comes in 2 cds, the 2nd cd holds client tools. You might want to look for your...