i dont think we have a handle. We're likely not going to be able to explain why it runs on one server and not another. BTW the link...

Lowell, this isnt specifically for you but I just learned from a peer that he got one of our test servers to run ssis in 64 bit mode with only...

hate to be a pain Lowell but are you running dtexec as 64 bit (from the non x86 directory) and bringing/reading excel 2007 data into your ssis buffer?

thx. How 'bout 64 bit ssis pkgs. Do they run with excel. I think you would know if you are running 64 bit ssis by seeing that...

thx. Will this step on what was probably a 32 bit engine he already installed? The reason I ask is that if we find this doesnt work, we...

good questions. I'm in a situation (potentially) where an auditing firm is grading us on how well we comply with Sarbanes. Somehow (maybe indirectly) they've talked one of...

thx Anthony. That didnt seem to work. I see my peer is a member of the deny data writer role. That makes me believe I set that...

EXECUTE AS didnt seem to offer any kind of help. It seems to me that a person still needs the grant which overrides the credentials of the acct...

thx. Any creative safeguard might help. For instance the documentation on EXECUTE AS looks to me like it will defer to permissions at the table level, not the...

thanks for clarifying Matt.

Thanks Jeff.

That's my point. If something can generate both a negative and positive number 2, they may look random but abs reverses that effect.

Also, it seems to us that...

is this a better choice guys? RAND(checksum(newid())) ?

perhaps because it increases randomness by not allowing dupes between negatives and positives? Perhaps also because...

does anybody know if excel can work with views? Or will sps be the only recourse in that situation?

I'm also a little interested in snapshots and snapshot history. I cant for the life of me see where RS keeps the actual data, but I'll leave that for...

I'm not sure but it looks like what I was after is a database called ReportServer right on the DB Engine instance.

It contains a number of tables that at first...