Describe command.

Hi,

I have some (OLD) college notes that say if I type

Describe tablename;
Name NOT NULL? Type

in my SQL code window in access once run it will give me the structure of the table.

When I try to run I get a Invalid SQL statement error 'DELETE', 'INSERT'...

Where am I going wrong.

Thanksoh, it's simple, your old notes are wrong, access doesn't support that commandsql

Deploying updated report but still seeing old version

Hi,
I have looked up information about my problem in this group but couldn't
find any fitting solution.
I have deployed a report to the report server. I've added a textbox to the
report and delpoyed it again. When openening the report in the reportserver i
still get to see the old report (the one without the textbox). I have tried
the clearsession argument but did not work. I have cleared my IE cache,
restarted IIS, Deleted the whole map in the reports manager and deplyed the
report again, I don't cache any reports, but still i get to see the old
report. What could be the problem? I don't know where to look any more.
Thnx in advance.
StanleyAre you deploying from Visual Studio? I question whether it has been
deployed. The most I have ever had to do if this happens to me is to clost
IE and re-open IE. I have never had to do anything with IIS.
1. Do the following. Open up a new IE. Go to where the reports are and click
on the show details and look at the Modified Date.
2. Deploy
3. Redo #1 (new IE). Is the Modified Date column being updated?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stanley" <Stanley@.discussions.microsoft.com> wrote in message
news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> Hi,
> I have looked up information about my problem in this group but couldn't
> find any fitting solution.
> I have deployed a report to the report server. I've added a textbox to the
> report and delpoyed it again. When openening the report in the
reportserver i
> still get to see the old report (the one without the textbox). I have
tried
> the clearsession argument but did not work. I have cleared my IE cache,
> restarted IIS, Deleted the whole map in the reports manager and deplyed
the
> report again, I don't cache any reports, but still i get to see the old
> report. What could be the problem? I don't know where to look any more.
> Thnx in advance.
> Stanley|||I just deployed an update of 2 reports and a new report and all I did when
viewing the details list was to hit the refresh button in IE and it showed
the modified date and it showed the new report both.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> Are you deploying from Visual Studio? I question whether it has been
> deployed. The most I have ever had to do if this happens to me is to clost
> IE and re-open IE. I have never had to do anything with IIS.
>
> 1. Do the following. Open up a new IE. Go to where the reports are and
click
> on the show details and look at the Modified Date.
> 2. Deploy
> 3. Redo #1 (new IE). Is the Modified Date column being updated?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > Hi,
> >
> > I have looked up information about my problem in this group but couldn't
> > find any fitting solution.
> >
> > I have deployed a report to the report server. I've added a textbox to
the
> > report and delpoyed it again. When openening the report in the
> reportserver i
> > still get to see the old report (the one without the textbox). I have
> tried
> > the clearsession argument but did not work. I have cleared my IE cache,
> > restarted IIS, Deleted the whole map in the reports manager and deplyed
> the
> > report again, I don't cache any reports, but still i get to see the old
> > report. What could be the problem? I don't know where to look any
more.
> >
> > Thnx in advance.
> >
> > Stanley
>|||Hi Bruce,
I have deployed the reports and saw that the modified date indeed changed.
And i just noticed that the textbox was not showing on the same place as
where i had put it in desgin mode. The textbox was showing a the bottom of
the chart instead of on the chart where i had put it. That's why i assumed
that it was showing the old report. But than i have another problem which
also made me assume that is was showing the old report. I have some custom VB
code which select a default value for the month parameter. It selects the
current month and pre-sets that month as the default value when openening the
report. In preview mode it works fine, but when i deploy it, it doesn't wor.
I still have to select the value manually.
This is the VB code:
public function GetMonth() as string
GetMonth = Format(Now(),"MMMM")
end function
The parameter in the MDX query accepts the whole month name like:
[Period].[All Period].[2005].[January]
The report contains also a Year parameter which works just fine with VB Code
(to get this year value). Only the month parameter doens't work.
You know why?
Thanks for your help.
Stanley
"Bruce L-C [MVP]" wrote:
> I just deployed an update of 2 reports and a new report and all I did when
> viewing the details list was to hit the refresh button in IE and it showed
> the modified date and it showed the new report both.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> > Are you deploying from Visual Studio? I question whether it has been
> > deployed. The most I have ever had to do if this happens to me is to clost
> > IE and re-open IE. I have never had to do anything with IIS.
> >
> >
> > 1. Do the following. Open up a new IE. Go to where the reports are and
> click
> > on the show details and look at the Modified Date.
> > 2. Deploy
> > 3. Redo #1 (new IE). Is the Modified Date column being updated?
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> > news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > > Hi,
> > >
> > > I have looked up information about my problem in this group but couldn't
> > > find any fitting solution.
> > >
> > > I have deployed a report to the report server. I've added a textbox to
> the
> > > report and delpoyed it again. When openening the report in the
> > reportserver i
> > > still get to see the old report (the one without the textbox). I have
> > tried
> > > the clearsession argument but did not work. I have cleared my IE cache,
> > > restarted IIS, Deleted the whole map in the reports manager and deplyed
> > the
> > > report again, I don't cache any reports, but still i get to see the old
> > > report. What could be the problem? I don't know where to look any
> more.
> > >
> > > Thnx in advance.
> > >
> > > Stanley
> >
> >
>
>|||I thin k it's better if i create a new thread for this.
"Stanley" wrote:
> Hi Bruce,
> I have deployed the reports and saw that the modified date indeed changed.
> And i just noticed that the textbox was not showing on the same place as
> where i had put it in desgin mode. The textbox was showing a the bottom of
> the chart instead of on the chart where i had put it. That's why i assumed
> that it was showing the old report. But than i have another problem which
> also made me assume that is was showing the old report. I have some custom VB
> code which select a default value for the month parameter. It selects the
> current month and pre-sets that month as the default value when openening the
> report. In preview mode it works fine, but when i deploy it, it doesn't wor.
> I still have to select the value manually.
> This is the VB code:
> public function GetMonth() as string
> GetMonth = Format(Now(),"MMMM")
> end function
> The parameter in the MDX query accepts the whole month name like:
> [Period].[All Period].[2005].[January]
>
> The report contains also a Year parameter which works just fine with VB Code
> (to get this year value). Only the month parameter doens't work.
> You know why?
> Thanks for your help.
> Stanley
> "Bruce L-C [MVP]" wrote:
> > I just deployed an update of 2 reports and a new report and all I did when
> > viewing the details list was to hit the refresh button in IE and it showed
> > the modified date and it showed the new report both.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> > > Are you deploying from Visual Studio? I question whether it has been
> > > deployed. The most I have ever had to do if this happens to me is to clost
> > > IE and re-open IE. I have never had to do anything with IIS.
> > >
> > >
> > > 1. Do the following. Open up a new IE. Go to where the reports are and
> > click
> > > on the show details and look at the Modified Date.
> > > 2. Deploy
> > > 3. Redo #1 (new IE). Is the Modified Date column being updated?
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> > > news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > > > Hi,
> > > >
> > > > I have looked up information about my problem in this group but couldn't
> > > > find any fitting solution.
> > > >
> > > > I have deployed a report to the report server. I've added a textbox to
> > the
> > > > report and delpoyed it again. When openening the report in the
> > > reportserver i
> > > > still get to see the old report (the one without the textbox). I have
> > > tried
> > > > the clearsession argument but did not work. I have cleared my IE cache,
> > > > restarted IIS, Deleted the whole map in the reports manager and deplyed
> > > the
> > > > report again, I don't cache any reports, but still i get to see the old
> > > > report. What could be the problem? I don't know where to look any
> > more.
> > > >
> > > > Thnx in advance.
> > > >
> > > > Stanley
> > >
> > >
> >
> >
> >

deployed report, reverting to old report

I have since modified a deployed report by putting a pie chart on it. I run
the report on my develpoment PC and it shows fine, i deploy the new reoprt
and it is not showing the updated information. I have tried deleting the the
old report and uploading the new report, but still i get the old report
format.
I have uploaded the report to another directory and it shows the updated
report. I have tried moving the report from this directory to the directory i
want it in but still it does not show the updated format.Close(exit) IE and open up a new one.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Shaun Longhurst" <ShaunLonghurst@.discussions.microsoft.com> wrote in
message news:8D96956A-A190-4985-8883-87BEE0D7E603@.microsoft.com...
> I have since modified a deployed report by putting a pie chart on it. I
run
> the report on my develpoment PC and it shows fine, i deploy the new reoprt
> and it is not showing the updated information. I have tried deleting the
the
> old report and uploading the new report, but still i get the old report
> format.
> I have uploaded the report to another directory and it shows the updated
> report. I have tried moving the report from this directory to the
directory i
> want it in but still it does not show the updated format.|||If using URL access you can also append the following to the URL to force RS
to render the report with session:
&rs:ClearSession=true
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OL%23OUwy9EHA.3756@.TK2MSFTNGP14.phx.gbl...
> Close(exit) IE and open up a new one.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shaun Longhurst" <ShaunLonghurst@.discussions.microsoft.com> wrote in
> message news:8D96956A-A190-4985-8883-87BEE0D7E603@.microsoft.com...
>> I have since modified a deployed report by putting a pie chart on it. I
> run
>> the report on my develpoment PC and it shows fine, i deploy the new
>> reoprt
>> and it is not showing the updated information. I have tried deleting the
> the
>> old report and uploading the new report, but still i get the old report
>> format.
>> I have uploaded the report to another directory and it shows the updated
>> report. I have tried moving the report from this directory to the
> directory i
>> want it in but still it does not show the updated format.
>|||thanks that worked.
"Bruce L-C [MVP]" wrote:
> Close(exit) IE and open up a new one.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shaun Longhurst" <ShaunLonghurst@.discussions.microsoft.com> wrote in
> message news:8D96956A-A190-4985-8883-87BEE0D7E603@.microsoft.com...
> > I have since modified a deployed report by putting a pie chart on it. I
> run
> > the report on my develpoment PC and it shows fine, i deploy the new reoprt
> > and it is not showing the updated information. I have tried deleting the
> the
> > old report and uploading the new report, but still i get the old report
> > format.
> >
> > I have uploaded the report to another directory and it shows the updated
> > report. I have tried moving the report from this directory to the
> directory i
> > want it in but still it does not show the updated format.
>
>|||I get the same issue when trying to deploy from VStudio...Sometimes I have to
delete the reports and deploy 4 or 5 times before the change appears
Regards,
Dean Nero
Momentum Healthware Inc.
"Bruce L-C [MVP]" wrote:
> Close(exit) IE and open up a new one.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shaun Longhurst" <ShaunLonghurst@.discussions.microsoft.com> wrote in
> message news:8D96956A-A190-4985-8883-87BEE0D7E603@.microsoft.com...
> > I have since modified a deployed report by putting a pie chart on it. I
> run
> > the report on my develpoment PC and it shows fine, i deploy the new reoprt
> > and it is not showing the updated information. I have tried deleting the
> the
> > old report and uploading the new report, but still i get the old report
> > format.
> >
> > I have uploaded the report to another directory and it shows the updated
> > report. I have tried moving the report from this directory to the
> directory i
> > want it in but still it does not show the updated format.
>
>

Deploy successful, but updated report not showing...

Using VS2005 to deploy an updated report on a machine running SQL 2005
Reporting Services.
VS states that the deployment was successful, but the old version of the
report is what's getting run.
Can't reset the Default Website on that machine as it's running the web
services behind our application.
What have I missed?
Kyle JedrusiakOn Dec 4, 11:47 am, "Kyle Jedrusiak"
<kjedrus...@.princetoninformation.com> wrote:
> Using VS2005 to deploy an updated report on a machine running SQL 2005
> Reporting Services.
> VS states that the deployment was successful, but the old version of the
> report is what's getting run.
> Can't reset the Default Website on that machine as it's running the web
> services behind our application.
> What have I missed?
> Kyle Jedrusiak
Try deleting the report and re-deploying it. It worked for me.

Dependencies are lost when alter an object

Hello,
I have an old problem but now it became ugly...
I have an object (for example a function) that is used in some views. If I am looking on dependencies, it shows me the 8 views whcih depends on it. But if I edit the function in Query Analyser and run the script (no modification on the script), it deletes
all the dependencies for the 8 views on it... The problem is worst because when I generate the initial snapshot for a merge replication, it will affect the generation order of the scripts and I get error when trying to create the views (on subscriber), s
aying that the function doesn't exist in database...
Any ideea how can I preserve the dependencies?
Thanks in advance
Catalin,
I've also wondered what is the cause of this. There was mention a while back
that it is caused by using enterprise manager to do certain changes to
objects rather than using QA. Also, it has been mentioned that renaming
objects can corrupt dependencies.
I haven't found a definitive article explaining this, but as a workaround,
if you have this problem, you might want to run sp_refreshview on your views
prior to replication.
HTH,
Paul Ibison
|||I don't work with EM, only with QA.
For example: I run this script, to create 2 functions:
CREATE FUNCTION dbo.Child () RETURNS TABLE RETURN (SELECT 1 AS Col)
GO
CREATE FUNCTION dbo._Parent () RETURNS TABLE RETURN (SELECT * FROM dbo.Child ())
GO
As you can see _Parent depens on Child.
At this moment everything is fine on dependencies (each one shows the other)
But if I execute the next script:
ALTER FUNCTION dbo.Child () RETURNS TABLE RETURN (SELECT 1 AS Col)
I loose all the referencies. And I need to generate the initial snapshot for a replication. And because no dependencies found, it will create the function in the order of names (and "_Parent" is before "Child") and when it tries to create the database (on
subscriber) I get the error because it tries to create _Parent before Child...
|||Hi Catalin,
If you don't have very many complex dependencies among functions, you may be
able to restore the dependency information by altering _Parent after you
alter Child.
HTH
-Raymond
"Catalin" <anonymous@.discussions.microsoft.com> wrote in message
news:0D8E0108-CACC-4491-A1B2-DFCD4FE641C6@.microsoft.com...
> I don't work with EM, only with QA.
> For example: I run this script, to create 2 functions:
> CREATE FUNCTION dbo.Child () RETURNS TABLE RETURN (SELECT 1 AS Col)
> GO
> CREATE FUNCTION dbo._Parent () RETURNS TABLE RETURN (SELECT * FROM
dbo.Child ())
> GO
> As you can see _Parent depens on Child.
> At this moment everything is fine on dependencies (each one shows the
other)
> But if I execute the next script:
> ALTER FUNCTION dbo.Child () RETURNS TABLE RETURN (SELECT 1 AS Col)
> I loose all the referencies. And I need to generate the initial snapshot
for a replication. And because no dependencies found, it will create the
function in the order of names (and "_Parent" is before "Child") and when it
tries to create the database (on subscriber) I get the error because it
tries to create _Parent before Child...
|||Yes, but... unfortunately I have a database with more that 1000 objects and I need to replicate it... In this case I need to "reconstruct" the dependencies tree. The simplest way that I think is to develop a small VB application that will try to re-establ
ish the order (trying each script to execute in a blank database and to determine the missing object)...

Deny access to tables

Hi,
I was hoping someone could help me with a problem I have
in SQL 2000, I'm an old SQL7 DBA and I haven't used SQL
Server in a few years, so I'm quite rusty.
How do you allow a user access to a database but restrict
what tables they can see/edit. The problem I'm
experiencing is the Public role, I can't seem to delete
it and I don't want to change it's permissions as all the
other users need access to the tables it allows..
Any help - I'm probably missing something so basic and
will kick myself.
Many thanks in advance for any help received.
MichelleHi;
Have a look into DENY statement in Books online
Sample statement to deny all revilages on emp_master table from user : test
DENY all on emp_master to test
Thanks
Hari
MCDBA
"Michelle T" <anonymous@.discussions.microsoft.com> wrote in message
news:192e801c44c78$5252a170$a001280a@.phx
.gbl...
> Hi,
> I was hoping someone could help me with a problem I have
> in SQL 2000, I'm an old SQL7 DBA and I haven't used SQL
> Server in a few years, so I'm quite rusty.
> How do you allow a user access to a database but restrict
> what tables they can see/edit. The problem I'm
> experiencing is the Public role, I can't seem to delete
> it and I don't want to change it's permissions as all the
> other users need access to the tables it allows..
> Any help - I'm probably missing something so basic and
> will kick myself.
> Many thanks in advance for any help received.
> Michelle
>|||Hari,
Thanks for that, I thought that a script might be what
was required.
Thanks for all your help.
Michelle
>--Original Message--
>Hi;
>Have a look into DENY statement in Books online
>Sample statement to deny all revilages on emp_master
table from user : test
>DENY all on emp_master to test
>Thanks
>Hari
>MCDBA
>"Michelle T" <anonymous@.discussions.microsoft.com> wrote
in message
> news:192e801c44c78$5252a170$a001280a@.phx
.gbl...
have[vbcol=seagreen]
restrict[vbcol=seagreen]
the[vbcol=seagreen]
>
>.
>