I'd like to install the 64-bit SMO objects on a 64-bit OS that we have 32-bit
SQL Server Instances installed on.

I've written an application using SMO to do some scripting and restoring of
schemas and permissions, that I want to call using cmdexec on a job.

It complains it has the wrong version of the batch parser
(Microsoft.SqlServer.BatchParser.dll ).


I understand that I can get the 64-bit version in the Feature Pack for 2005:
Microsoft SQL Server 2005 Management Objects Collection

Is it ok to install this on my system with 32-bit SQL Server Instances?

I've seen this on a blog (http://blogs.msdn.com/mwories/pages/smofaq.aspx):


"Q: Will SMO work on 64 bit systems?
A: Yes, SMO is compiled neutral and will JIT to 32 or 64 bits. Note there is
one machine dependent SMO component: Microsoft.SqlServer.BatchParser.dll
which will be installed in the GAC as both 32 and 64 bits."

But doesn't quite answer my question.

I've got a nice app using SMO, but don't want to take any risks with our
system!

thanks!
Steve
Portland, OR

lost sa password due to loss of employee
Backup using the proxy account in SQL2005
BCP genric error
Problem on scripting stored procedures
What is 'asdb' and whether or not it should be backed up