Showing posts with label fighting. Show all posts
Showing posts with label fighting. Show all posts

Thursday, March 29, 2012

Alternate Methods of Exporting Data?

Hi all,
I have been fighting with the Copy SQL Server Objects task for a couple of
days. I have been trying to copy an entire database. I am trying to set
the Destination Database name dynamically ( I have used the Dynamic
Properties Task, Code, etc...)
Nothing works. I am continually prompted with an error that states that the
database is not in the databases collection. Of course not, it hasn't been
created yet...that's what the export is supposed to do and no matter of
Googling on the error has helped.
Anyone have any clues or suggestions for alternative ways to copy an entire
database AND provide the name dynamically for it?If this is a one time task, you could restore a backup copy of the database.
If you need to continually copy data you could look into both replication
and log shipping.|||Sorry, I didn't read your question carefully.
"Bianca Blount" <blountb@.noemail.com> wrote in message
news:u8OYoDWqDHA.976@.tk2msftngp13.phx.gbl...
> If this is a one time task, you could restore a backup copy of the
database.
> If you need to continually copy data you could look into both replication
> and log shipping.
>

Monday, February 13, 2012

All users can edit security!

I've been fighting for 2 days trying to figure out how to block general user
s from being able to edit security on reports/folders. I have myself set up
as Content Manager and the groups Everyone and Users set up as Browsers. C
an someone please tell me w
hat I am missing? Thanks.OOPs. Should've put this in Reporting Services area. Sorry.
"BrianW" wrote:

> I've been fighting for 2 days trying to figure out how to block general users from
being able to edit security on reports/folders. I have myself set up as Content Ma
nager and the groups Everyone and Users set up as Browsers. Can someone please tell
me
what I am missing? Thanks.