Display a report in fullscreenmode

Hello,
is it possible to open a report in fullscreenmode automatically? Perhaps there might be a http parameter?

Current view:

Now a click on the button on the right side. This is the view i want to see when i open a report.

Did anyone have an idea how i can achieve my goal?

Thanks for your help!
Christian Niehaves

Use the url http://servername/ReportServer instead of http://servername/Reports|||Great.
Thanks for your help.

Discover exactly what is causing a block

Hi. We are experiencing significant prolonged blocking when loading multiple
files in through a partitioned view. Before we start working on a resolution
we want to identify exactly what resource is causing the block.
We can see which processes are being blocked by using sp_who2. But how do we
determine exactly which lock on which object is causing the blocking?
Thanks!
McGy
[url]http://mcgy.blogspot.com[/url]sp_lock2 (it's out there on the internet) will tell you by spid which
database resources are being locked up.
This will be a good starting point.|||Also take a look at aba_lockinfo written by SQL Server MVP Erland
Sommarskog
Source code is available from the link below
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
Denis the SQL Menace
http://sqlservercode.blogspot.com/
McGy wrote:
> Hi. We are experiencing significant prolonged blocking when loading multip
le
> files in through a partitioned view. Before we start working on a resoluti
on
> we want to identify exactly what resource is causing the block.
> We can see which processes are being blocked by using sp_who2. But how do
we
> determine exactly which lock on which object is causing the blocking?
> Thanks!
> --
> McGy
> [url]http://mcgy.blogspot.com[/url]|||> We can see which processes are being blocked by using sp_who2. But how do
> we determine exactly which lock on which object is causing the blocking?
1) Execute sp_lock for the blocked spid. For example:
EXEC sp_lock 51
2) Identify the row with status WAIT and note the ObjId and indid
3) Determine the object/index
USE MyDatabase
SELECT
OBJECT_NAME(id) AS TableName,
name AS IndexName
FROM sysindexes
WHERE
id = 10000 --ObjId from sp_lock
AND indid = 1 --indid from sp_lock
Hope this helps.
Dan Guzman
SQL Server MVP
"McGy" <anon@.anon.com> wrote in message
news:eoPC9chiGHA.4512@.TK2MSFTNGP02.phx.gbl...
> Hi. We are experiencing significant prolonged blocking when loading
> multiple files in through a partitioned view. Before we start working on a
> resolution we want to identify exactly what resource is causing the block.
> We can see which processes are being blocked by using sp_who2. But how do
> we determine exactly which lock on which object is causing the blocking?
> Thanks!
> --
> McGy
> [url]http://mcgy.blogspot.com[/url]
>
>|||Thank you very much for all of your tips. They have been invaluable!!
McGy
[url]http://mcgy.blogspot.com[/url]
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:OUyKp8iiGHA.4056@.TK2MSFTNGP02.phx.gbl...
> 1) Execute sp_lock for the blocked spid. For example:
> EXEC sp_lock 51
> 2) Identify the row with status WAIT and note the ObjId and indid
> 3) Determine the object/index
> USE MyDatabase
> SELECT
> OBJECT_NAME(id) AS TableName,
> name AS IndexName
> FROM sysindexes
> WHERE
> id = 10000 --ObjId from sp_lock
> AND indid = 1 --indid from sp_lock
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "McGy" <anon@.anon.com> wrote in message
> news:eoPC9chiGHA.4512@.TK2MSFTNGP02.phx.gbl...
>

disappearing "database maintenance plan"

When I try to view the properties of a database
maintenance plan in Enterprise Manager, it flashes on the
screen and disappears. I have tried it on the local
machine as well as other machines with Enterprise
Manager. Other server registrations work just fine. I
can build database maintenance plans without any trouble
but can't go back to edit them.
Thanks for the help.Hi Robert,
Thank you for using the newsgroup and it is my pleasure to help you with
you issue.
From the information you provided, in one of your computer, in the
enterprise manager, when you right-click one maintenance plan and want to
see the properties of it, it is flashed and disappear so you cannot view
it, right?
You could look at the following articles for reference,
Unable to View the Properties for a Database Maintenance Plan
http://support.microsoft.com/?id=323607
Hope this helps. If you still have questions, please feel free to post
message here and I am ready to help.
Thanks
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Hi Robert,
Have you seen the article in my last reply? Do you still have any question
about it? I am glad to help for any more questions.
Looking forward to hearing from you.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

disappearing "database maintenance plan"

When I try to view the properties of a database
maintenance plan in Enterprise Manager, it flashes on the
screen and disappears. I have tried it on the local
machine as well as other machines with Enterprise
Manager. Other server registrations work just fine. I
can build database maintenance plans without any trouble
but can't go back to edit them.
Thanks for the help.Hi Robert,
Thank you for using the newsgroup and it is my pleasure to help you with
you issue.
From the information you provided, in one of your computer, in the
enterprise manager, when you right-click one maintenance plan and want to
see the properties of it, it is flashed and disappear so you cannot view
it, right?
You could look at the following articles for reference,
Unable to View the Properties for a Database Maintenance Plan
http://support.microsoft.com/?id=323607
Hope this helps. If you still have questions, please feel free to post
message here and I am ready to help.
Thanks
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Hi Robert,
Have you seen the article in my last reply? Do you still have any question
about it? I am glad to help for any more questions.
Looking forward to hearing from you.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Disable Sysadmin to view metadata in SQL2005

Hi Everyone,
Is there any way we can disable sysadmin/sa to view metadata on a
particular database in SQL2005?
Thanks,
DexThere better not be an option to do that; it would be insane to do it.
Tim S
"Dex" <dplaras@.hotmail.com> wrote in message
news:1153253585.004826.199140@.75g2000cwc.googlegroups.com...
> Hi Everyone,
> Is there any way we can disable sysadmin/sa to view metadata on a
> particular database in SQL2005?
> Thanks,
> Dex
>|||Hi Tim,
There's a SQL statement in 2005 that disables users view access of the
metadata. I think it's View Any Database / View Server State/ View
Definition. My question is that if we can disable SA account to view
the metadata (tables, columns, etc)?
Thanks,
Dex
Tim Stahlhut wrote:[vbcol=seagreen]
> There better not be an option to do that; it would be insane to do it.
> Tim S
> "Dex" <dplaras@.hotmail.com> wrote in message
> news:1153253585.004826.199140@.75g2000cwc.googlegroups.com...|||You cannot deny permissions to a sysadmin, so you cannot prevent him to
access information that, by definition, he is supposed to access.
You can, however, restrict who is a sysadmin and if you need other users to
perform administrative tasks, look at granting only the minimal permissions
required to perform those tasks. If the permissions are not granular enough,
look at granting access via signed code - this way you can avoid granting
the permissions required by the operation and instead you can grant EXECUTE
permission on code that "packs" the access to the operation.
Thanks
Laurentiu Cristofor [MSFT]
Software Design Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dex" <dplaras@.hotmail.com> wrote in message
news:1153258018.919768.201370@.m79g2000cwm.googlegroups.com...
> Hi Tim,
> There's a SQL statement in 2005 that disables users view access of the
> metadata. I think it's View Any Database / View Server State/ View
> Definition. My question is that if we can disable SA account to view
> the metadata (tables, columns, etc)?
> Thanks,
> Dex
> Tim Stahlhut wrote:
>|||Thank you so much! So what do you recommend/best practices in
deploying a system to another clients so that they won't see database
schemas, given the fact that they have sysadmin rights to that box? In
the data layer, we're implementing encryption in a couple of key fields
so that even sysadmin won't be able to see those info?
Thanks again for your help!
Dex
Laurentiu Cristofor [MSFT] wrote:[vbcol=seagreen]
> You cannot deny permissions to a sysadmin, so you cannot prevent him to
> access information that, by definition, he is supposed to access.
> You can, however, restrict who is a sysadmin and if you need other users t
o
> perform administrative tasks, look at granting only the minimal permission
s
> required to perform those tasks. If the permissions are not granular enoug
h,
> look at granting access via signed code - this way you can avoid granting
> the permissions required by the operation and instead you can grant EXECUT
E
> permission on code that "packs" the access to the operation.
> Thanks
> --
> Laurentiu Cristofor [MSFT]
> Software Design Engineer
> SQL Server Engine
> http://blogs.msdn.com/lcris/
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "Dex" <dplaras@.hotmail.com> wrote in message
> news:1153258018.919768.201370@.m79g2000cwm.googlegroups.com...|||In this case, you are looking for a DRM solution for your database. SQL
Server does not provide such a solution. This issue has also been discussed
in the following threads:
http://forums.microsoft.com/MSDN/Sh...=52094&SiteID=1
http://forums.microsoft.com/MSDN/Sh...371562&SiteID=1
Thanks
Laurentiu Cristofor [MSFT]
Software Design Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dex" <dplaras@.hotmail.com> wrote in message
news:1153259304.913735.140010@.p79g2000cwp.googlegroups.com...
> Thank you so much! So what do you recommend/best practices in
> deploying a system to another clients so that they won't see database
> schemas, given the fact that they have sysadmin rights to that box? In
> the data layer, we're implementing encryption in a couple of key fields
> so that even sysadmin won't be able to see those info?
> Thanks again for your help!
> Dex
> Laurentiu Cristofor [MSFT] wrote:
>

Disable dependence checks when creating view

Is it possible to disable checks for existance of referenced tables(views,
user functions) when creating new view
Thanks in advance.Only way would be through CREATE SCHEMA:
CREATE SCHEMA AUTHORIZATION ross
create view v as select * from t
create table t(c1 int)
More information in Books Online.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Amid" <Amid@.discussions.microsoft.com> wrote in message
news:DEFF0F05-66DD-4ABF-A483-9D934E8A529C@.microsoft.com...
> Is it possible to disable checks for existance of referenced tables(views,
> user functions) when creating new view
> Thanks in advance.|||Thanks for the quick reply.
What if i'm unable to create table [t] within the same statement where [v]
is created?
I need to create it much later.
Any help will be appreciated.
"Tibor Karaszi" wrote:

> Only way would be through CREATE SCHEMA:
> CREATE SCHEMA AUTHORIZATION ross
> create view v as select * from t
> create table t(c1 int)
> More information in Books Online.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Amid" <Amid@.discussions.microsoft.com> wrote in message
> news:DEFF0F05-66DD-4ABF-A483-9D934E8A529C@.microsoft.com...
>|||You can't do that. When a view is created, SQL Server need to populate the s
ystem tables
(syscolumns) with the columns that the view has (the SELECT in the view defi
nition). SQL Server
cannot do that if the table(s) that the view uses doesn't exist.
Why do you have this need? Sounds like a strange requirement to me...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Amid" <Amid@.discussions.microsoft.com> wrote in message
news:2C520E2E-FE0C-41D7-95C8-DA19CB87A78F@.microsoft.com...
> Thanks for the quick reply.
> What if i'm unable to create table [t] within the same statement where [v]
> is created?
> I need to create it much later.
> Any help will be appreciated.
> "Tibor Karaszi" wrote:
>|||I need to make copy of the database structure (tables, views, sp, uddt, uf,
constraints etc) with several modifications. Unfortunately original database
may me inconsistent (views, user functions in it may refer to the others
database tables or views). Now I cant gain access to that tables but
structure has to be copied. Thus I need to create views and user function
(sp) without actually having needed tables or views.
Thanks.
"Tibor Karaszi" wrote:

> You can't do that. When a view is created, SQL Server need to populate the
system tables
> (syscolumns) with the columns that the view has (the SELECT in the view de
finition). SQL Server
> cannot do that if the table(s) that the view uses doesn't exist.
> Why do you have this need? Sounds like a strange requirement to me...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Amid" <Amid@.discussions.microsoft.com> wrote in message
> news:2C520E2E-FE0C-41D7-95C8-DA19CB87A78F@.microsoft.com...
>

disable automatic execution and rendering

I use asp.net page to view the reports. Some of my reports take parameters
and I set them default to '%' as while cards.
When a report link is clicked, the report is executed and rendered when the
new page is open. Some of them returns really quite some records so it takes
a while to have the page rendered.
Is there a setting somewhere that the reports are not executed and rendered
when the hosting page is open and the process will start only when the "View
Report" button is clicked?
Thank you.You need at least one parameter to not have a default. Otherwise it renders
automatically. I would prefer this behaviour to be different. I haven't
checked 2005 to see if it has changed but this is the way it works in 2000.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ZWeng" <ZWeng@.discussions.microsoft.com> wrote in message
news:32F0A618-C751-479F-9FE1-7CF542E71A35@.microsoft.com...
>I use asp.net page to view the reports. Some of my reports take parameters
> and I set them default to '%' as while cards.
> When a report link is clicked, the report is executed and rendered when
> the
> new page is open. Some of them returns really quite some records so it
> takes
> a while to have the page rendered.
> Is there a setting somewhere that the reports are not executed and
> rendered
> when the hosting page is open and the process will start only when the
> "View
> Report" button is clicked?
> Thank you.
>|||It still works the same way in RS 2005... It would be nice to have a
No-Autorender flag...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Bruce L-C [MVP]" wrote:
> You need at least one parameter to not have a default. Otherwise it renders
> automatically. I would prefer this behaviour to be different. I haven't
> checked 2005 to see if it has changed but this is the way it works in 2000.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ZWeng" <ZWeng@.discussions.microsoft.com> wrote in message
> news:32F0A618-C751-479F-9FE1-7CF542E71A35@.microsoft.com...
> >I use asp.net page to view the reports. Some of my reports take parameters
> > and I set them default to '%' as while cards.
> >
> > When a report link is clicked, the report is executed and rendered when
> > the
> > new page is open. Some of them returns really quite some records so it
> > takes
> > a while to have the page rendered.
> >
> > Is there a setting somewhere that the reports are not executed and
> > rendered
> > when the hosting page is open and the process will start only when the
> > "View
> > Report" button is clicked?
> >
> > Thank you.
> >
> >
>
>