Modified Report not rendering over an existing one

Hi,
Is it posible to overwwrite an existing report (in the same folder) with a
newly modified one. I recently made some changes to an existing report,
deployed it to the same report folder in the report manager but the new
changes failed to overwrite the old one. May be I should delete the old one?
Thx
ChuckMost likely session snapshots or execution caching were involved when you
did not see the updated report on the first rendering in report manager.
Hitting Ctrl+F5 should re-render the report.
Note: when republishing over an existing report, report parameter
information and data source information will *not* be overwritten on the
report server.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chuck" <Chuck@.discussions.microsoft.com> wrote in message
news:8CB60C27-A7D3-43E9-8777-2140EF8BE85A@.microsoft.com...
> Hi,
> Is it posible to overwwrite an existing report (in the same folder) with a
> newly modified one. I recently made some changes to an existing report,
> deployed it to the same report folder in the report manager but the new
> changes failed to overwrite the old one. May be I should delete the old
one?
> Thx
> Chuck|||Thx Robert for answering my question however, I did try hitting Ctrl + F5 to
no avail; would it be possible to have the execution cach flushed in order to
render the updated report?
"Robert Bruckner [MSFT]" wrote:
> Most likely session snapshots or execution caching were involved when you
> did not see the updated report on the first rendering in report manager.
> Hitting Ctrl+F5 should re-render the report.
> Note: when republishing over an existing report, report parameter
> information and data source information will *not* be overwritten on the
> report server.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Chuck" <Chuck@.discussions.microsoft.com> wrote in message
> news:8CB60C27-A7D3-43E9-8777-2140EF8BE85A@.microsoft.com...
> > Hi,
> > Is it posible to overwwrite an existing report (in the same folder) with a
> > newly modified one. I recently made some changes to an existing report,
> > deployed it to the same report folder in the report manager but the new
> > changes failed to overwrite the old one. May be I should delete the old
> one?
> >
> > Thx
> >
> > Chuck
>
>

missing system databases folder from management studio

Hi All
My view of database on management studio does not have folder with system
databases. I am sysadmin on server and member of local admins group. Do you
know what could be a problem?In Management Studio take a look at Tools, Options, Hide system objects in
Object Explorer. Is the box checked?
Hope this helps,
Ben Nevarez
"Gene." wrote:
> Hi All
> My view of database on management studio does not have folder with system
> databases. I am sysadmin on server and member of local admins group. Do you
> know what could be a problem?|||Hi Gene
There is an option available that turns system objects visible or invisible.
Look at the Options in the Tools menu. The General tab has the checkbox
"Hide system objects in Object Explorer"
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:FAEC8F2B-9E3E-467C-B368-756773D1BD16@.microsoft.com...
> Hi All
> My view of database on management studio does not have folder with system
> databases. I am sysadmin on server and member of local admins group. Do
> you
> know what could be a problem?|||Hi Ben, Kalen
This is genious!
I did not change those settings but that was a fix!
Thank you so much. I am happy again now.
"Kalen Delaney" wrote:
> Hi Gene
> There is an option available that turns system objects visible or invisible.
> Look at the Options in the Tools menu. The General tab has the checkbox
> "Hide system objects in Object Explorer"
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://blog.kalendelaney.com
>
> "Gene." <Gene@.discussions.microsoft.com> wrote in message
> news:FAEC8F2B-9E3E-467C-B368-756773D1BD16@.microsoft.com...
> > Hi All
> > My view of database on management studio does not have folder with system
> > databases. I am sysadmin on server and member of local admins group. Do
> > you
> > know what could be a problem?
>
>
>

Missing Snapshot agents

Running Win2k & SQL 2K
This AM when I checked my SQL servers, I had a red 'X' on
the snapshot folder of my central server. When I
expanded it, there were no snapshot agents. I have 45 or
so publications on this server and know each one has a
snapshot agent.
HELP!!!!
How do I get them back?
TIA,
Larry..
check to see if you can find these jobs in the jobs folder. If you can't
these agents where never created. Something is very wrong.
If they are there, its a visibility problems. This problem is most likely
caused when you deploy the publication via a script and don't use unique
publication or snapshot agent names. your best bet is to drop all
publications and rebuild them. You could try to script them out and
carefully modify them so the publications have different names, and leave
the snapshot_agent and distribution_agent parameters blank.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"larry" <anonymous@.discussions.microsoft.com> wrote in message
news:406b01c4aa1b$6a22f010$a601280a@.phx.gbl...
> Running Win2k & SQL 2K
> This AM when I checked my SQL servers, I had a red 'X' on
> the snapshot folder of my central server. When I
> expanded it, there were no snapshot agents. I have 45 or
> so publications on this server and know each one has a
> snapshot agent.
> HELP!!!!
> How do I get them back?
> TIA,
> Larry..
|||Hilary,
They are in the jobs folder. The snapshot agents also
are in the Publication folder for each publication. What
gives? Does it really matter that they do not appear in
the Snapshot folder? Dropping the publications and
recreatiing them is not an option. Any othere ideas?
Larry...
|||believe it or not, it really doesn't matter. You just don't have the
visibility when your snapshot agents fail, which isn't often.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
<anonymous@.discussions.microsoft.com> wrote in message
news:1e9a01c4aa38$941a0440$a501280a@.phx.gbl...
> Hilary,
> They are in the jobs folder. The snapshot agents also
> are in the Publication folder for each publication. What
> gives? Does it really matter that they do not appear in
> the Snapshot folder? Dropping the publications and
> recreatiing them is not an option. Any othere ideas?
> Larry...

Missing Elements in Report Manager

Has anyone run across this before? I'm missing the Contents and Properties tab along with the button bar containing the "New Folder", "New Data Source", "Upload File" and "Show Details" buttons in the Report Manager. Also, which I think may be related, when I attempt to deploy a report I get the error: "A connection could not be made to the report server http://MyServer/Reports.

I can connect to the SQL Server without problem, and I can browse to the URL containing report manager

Interestingly, I had access to all of this a couple of weeks ago and then all of this suddenly happened. All the other developers have no problems and I am a member of the group which has access.

Any ideas?

Thanks in advance!

JohnMIt sounds like the permission are not set correctly. Perhaps you user account has been specified with more restrictive permissions?|||

Hi John,

Have you managed to resolve the issue? I have the exact same problem! :(

Kind Regards,

Casey.

|||

Has anyone figured this out? I have run into this exact issue and can not figure it out. All rights appear correct.

If there is a fix, can you please email me at mradomski@.lpsintegration.com

Missing Elements in Report Manager

Has anyone run across this before? I'm missing the Contents and Properties tab along with the button bar containing the "New Folder", "New Data Source", "Upload File" and "Show Details" buttons in the Report Manager. Also, which I think may be related, when I attempt to deploy a report I get the error: "A connection could not be made to the report server http://MyServer/Reports.

I can connect to the SQL Server without problem, and I can browse to the URL containing report manager

Interestingly, I had access to all of this a couple of weeks ago and then all of this suddenly happened. All the other developers have no problems and I am a member of the group which has access.

Any ideas?

Thanks in advance!

JohnMIt sounds like the permission are not set correctly. Perhaps you user account has been specified with more restrictive permissions?|||

Hi John,

Have you managed to resolve the issue? I have the exact same problem! :(

Kind Regards,

Casey.

|||

Has anyone figured this out? I have run into this exact issue and can not figure it out. All rights appear correct.

If there is a fix, can you please email me at mradomski@.lpsintegration.com

Missing Elements in Report Manager

Has anyone run across this before? I'm missing the Contents and Properties tab along with the button bar containing the "New Folder", "New Data Source", "Upload File" and "Show Details" buttons in the Report Manager. Also, which I think may be related, when I attempt to deploy a report I get the error: "A connection could not be made to the report server http://MyServer/Reports.

I can connect to the SQL Server without problem, and I can browse to the URL containing report manager

Interestingly, I had access to all of this a couple of weeks ago and then all of this suddenly happened. All the other developers have no problems and I am a member of the group which has access.

Any ideas?

Thanks in advance!

JohnMIt sounds like the permission are not set correctly. Perhaps you user account has been specified with more restrictive permissions?|||

Hi John,

Have you managed to resolve the issue? I have the exact same problem! :(

Kind Regards,

Casey.

|||

Has anyone figured this out? I have run into this exact issue and can not figure it out. All rights appear correct.

If there is a fix, can you please email me at mradomski@.lpsintegration.com

Missing dll folder in SQL Server 2005

Hello, I have have some instructions to put a dll file in the folder
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\dll" which I see on a
machine with SQL Server 2000. On machines with SQL Server 2005 you have 3
folders MSSQL.1, MSSQL.2, MSSQL.3 and none of them have a dll folder. Where
do you think I would be the dll.
ThanksHi Don,
Are these instructions from a specific application? Does it mention if it is
compatible with SQL Server 2005?
Ben Nevarez
"Don" wrote:
> Hello, I have have some instructions to put a dll file in the folder
> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\dll" which I see on a
> machine with SQL Server 2000. On machines with SQL Server 2005 you have 3
> folders MSSQL.1, MSSQL.2, MSSQL.3 and none of them have a dll folder. Where
> do you think I would be the dll.
> Thanks
>|||Exactly my thoughts, Ben. My guess is that it is an extended stored procedure, and if the
instructions doesn't say how to install it on 2005, we shouldn't assume it has been tested on 2005.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:D1FD01B8-51AC-4570-92C7-EB0254257714@.microsoft.com...
> Hi Don,
> Are these instructions from a specific application? Does it mention if it is
> compatible with SQL Server 2005?
> Ben Nevarez
>
>
> "Don" wrote:
>> Hello, I have have some instructions to put a dll file in the folder
>> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\dll" which I see on a
>> machine with SQL Server 2000. On machines with SQL Server 2005 you have 3
>> folders MSSQL.1, MSSQL.2, MSSQL.3 and none of them have a dll folder. Where
>> do you think I would be the dll.
>> Thanks|||Yes, it's for a extended stored procedure called xp_calendar. And there are
notes about having it work with SQl 2005 just not about were to put the dll.
I had installed it on a SQL Server 2000 as a test and xp_calendar worked
well, but when I went to install it at the client running 2005 I saw that it
does not have the dll folder.
http://www.sqlservercentral.com/articles/Miscellaneous/2985/
http://www.logicom-inc.com/xp_sql2exchange/xp_sql2exchange.html
Thanks
Don
"Tibor Karaszi" wrote:
> Exactly my thoughts, Ben. My guess is that it is an extended stored procedure, and if the
> instructions doesn't say how to install it on 2005, we shouldn't assume it has been tested on 2005.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> news:D1FD01B8-51AC-4570-92C7-EB0254257714@.microsoft.com...
> >
> > Hi Don,
> >
> > Are these instructions from a specific application? Does it mention if it is
> > compatible with SQL Server 2005?
> >
> > Ben Nevarez
> >
> >
> >
> >
> > "Don" wrote:
> >
> >> Hello, I have have some instructions to put a dll file in the folder
> >> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\dll" which I see on a
> >> machine with SQL Server 2000. On machines with SQL Server 2005 you have 3
> >> folders MSSQL.1, MSSQL.2, MSSQL.3 and none of them have a dll folder. Where
> >> do you think I would be the dll.
> >>
> >> Thanks
> >>
>
>|||I would add the files to the binn folder and then adjust the paths in the file "xp_add.sql"
accordingly. You would need to find what folder (MSSQL.1 etc) corresponds to your instance name,
check the below reg key for that:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Don" <Don@.discussions.microsoft.com> wrote in message
news:0AC640AC-92C5-478F-82EA-6DD80D9BB418@.microsoft.com...
> Yes, it's for a extended stored procedure called xp_calendar. And there are
> notes about having it work with SQl 2005 just not about were to put the dll.
> I had installed it on a SQL Server 2000 as a test and xp_calendar worked
> well, but when I went to install it at the client running 2005 I saw that it
> does not have the dll folder.
> http://www.sqlservercentral.com/articles/Miscellaneous/2985/
> http://www.logicom-inc.com/xp_sql2exchange/xp_sql2exchange.html
> Thanks
> Don
> "Tibor Karaszi" wrote:
>> Exactly my thoughts, Ben. My guess is that it is an extended stored procedure, and if the
>> instructions doesn't say how to install it on 2005, we shouldn't assume it has been tested on
>> 2005.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
>> news:D1FD01B8-51AC-4570-92C7-EB0254257714@.microsoft.com...
>> >
>> > Hi Don,
>> >
>> > Are these instructions from a specific application? Does it mention if it is
>> > compatible with SQL Server 2005?
>> >
>> > Ben Nevarez
>> >
>> >
>> >
>> >
>> > "Don" wrote:
>> >
>> >> Hello, I have have some instructions to put a dll file in the folder
>> >> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\dll" which I see on a
>> >> machine with SQL Server 2000. On machines with SQL Server 2005 you have 3
>> >> folders MSSQL.1, MSSQL.2, MSSQL.3 and none of them have a dll folder. Where
>> >> do you think I would be the dll.
>> >>
>> >> Thanks
>> >>
>>