Showing posts with label own. Show all posts
Showing posts with label own. Show all posts

Tuesday, March 20, 2012

Open reports with report builder

Hi!

We have a "folder hiriarchy" in reporting services with permission for different users to only create reports in their own folder. However, it would be nice if they (in report builder) could open eachothers reports, modify them and then save them in theri own folder. In this case, if they find a useful report that someone else has created, they could just make their own small modifications and save it in their own folder.

The problem is that I cant't seem to find a securitysetting that allow this. Either they can create/modify/delete the reports in a "folder" or they can't even open them in report builder...

Is there a solution to my problem?

regards Andreas

It looks like you may have the qrong forum. Try your question here:

http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1

Friday, March 9, 2012

Open a MDF file withMicrosoft SQL Server Management Studio Express9.00.1399.00

It works fine and I see the system tables and can make my own tables.

But how do I open a standalone MDF file with it? Or maybe it is a restriction ?

I am trying to get to the database for my personal start kit.

Hi,

For Microsoft SQL Server Management Studio Express 9.00.1399.00 question, you

post their questions to one of the appropriate SQL Server forums at:

http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1

Or depend on what you plan to do, you can also use VS/VWD IDE to connect to the database as well.

Thanks,

Lan

|||

or you can attached it manually at command prompt:

>SQLCMD -S (local)\sqlexpress -E

> select physical_name from sys.database_files where name = 'master'

> go

> exec sp_attach_db @.dbname=N'aspnetdb', @.filename1=N'[physical path]\aspnetdb.mdf'

> go

it should show up in your Microsoft SQL Server Management Studio Express after you attached it.

Hope that helps,

Lan