Error when gropuping by bit field

Error when gropuping by bit fieldSELECT CONVERT(TINYINT, BitColumn)
...
GROUP BY CONVERT(TINYINT, BitColumn)
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Rick" <williams@.scmv.com> wrote in message
news:01a701c3c4db$36cf40e0$a501280a@.phx.gbl...
>sql

Error using Reporting Services On windows 64 bit

I get the following error when i try to acces to the reporting services web
site.
Attempted to load a 64-bit assembly on a 32-bit platform. Use
ReflectionOnlyLoad() instead if trying to load for reflection purposes.
I have no idea of the source of the error (it is really a 64 bit edition of
windows)
If you have an idea,
ThanksAre you sure that you are not using a 32 bits version of SQRS on a 64 bits
machine?
In this case, have a look to this article
http://msdn2.microsoft.com/ms143293.aspx
Med Bouchenafa
"Cyprien Autexier" <autexi_c@.3ie.org> a écrit dans le message de news:
uqBrolOJGHA.3224@.TK2MSFTNGP09.phx.gbl...
>I get the following error when i try to acces to the reporting services web
>site.
> Attempted to load a 64-bit assembly on a 32-bit platform. Use
> ReflectionOnlyLoad() instead if trying to load for reflection purposes.
> I have no idea of the source of the error (it is really a 64 bit edition
> of windows)
> If you have an idea,
> Thanks
>

Error trying to copy stored procedures from one db to another

Hello,

The export menu in DTS is a bit confusing for me. I have some stored procedures in one SQL Server and want to copy them to another. The username is the same for both SQL Servers. When I try copying the stored procedure with defaul settings, I get a progress bar (24 percent ccompleted, 62 percent completed...), then when its done it says "failed to copy objects from sql server to sql server". When I double click the error for details it says "User or role '[username]' already exists in the current database". Then I try again, unchecking "use default options" for my export. I go in to alter the options, uncheck "copy database users and database groups" (I've also tried unchecking "copy object-level permissions"), run it, get progress bar (like above), and then get another error that says "There is no such user or group '[username]'".

My user name is correct, I am able to access both Sql Servers with this username, and I should have all of the appropriate permissions.

I think maybe there is a checkbox I'm not unchecking or something stupid like that.

Thanks in advance for any feedback.Wild guess here: the user who owns the sp is not dbo ?|||Wild guess here: the user who owns the sp is not dbo ?

Sorry, your msg is a bit cryptic for me. What are "sp" and "dbo"? My guess on the latter is "database owner". I will check with the administrator to find out if I can get a username with more privileges. It is a shared Sql Server with a web hosting company and there are dozens of databases that I can see in there, but do not have access to, so users and permissions are a little hairy, i'm sure.