New stored procedure call

Hi,
Actually the stored procedure ' Update ' is being called when ever I
click new button or edit button . But when i click the save button in the
grid the record is commited. But it is taken care by framework.Now when i
click the save button i must get the message as the record saved.
Thanks,
Jyothsna.Hi Jyothsna
Probably u are using a stored procedure to update the records. Introduce a
return parameter to the stored procedure and return a certain number when th
e
record is sucess and some number when record fails ex. 1 and -1 respectively
try to catch the return value when the button is clicked. Based on the
result display the message.
best Regards,
Chandra
http://chanduas.blogspot.com/
---
"Jyothsna" wrote:

>
> Hi,
> Actually the stored procedure ' Update ' is being called when ever
I
> click new button or edit button . But when i click the save button in the
> grid the record is commited. But it is taken care by framework.Now when i
> click the save button i must get the message as the record saved.
> Thanks,
> Jyothsna.
>
>

New Query with Current Connection

I am missing "New Query with Current Connection" button in SQL Editor in the
SQL management studio. Few posts on the Web refer explain that this button
should allow me to open a new query in the existing window.
I've checked "Add Remove Buttons" for SQL editor but I still cannot find it.
Any ideas?
Bojan Kuhar wrote:
> I am missing "New Query with Current Connection" button in SQL Editor in the
> SQL management studio. Few posts on the Web refer explain that this button
> should allow me to open a new query in the existing window.
> I've checked "Add Remove Buttons" for SQL editor but I still cannot find it.
> Any ideas?
I'm not sure it can be done, but "Ctrl-N" will give you the "New query
with current connection".
Regards
Steen
|||Fantastic.
Now, one more. Is there something like "Open Query with Current Connection".
I'd like to avoid the Connect to Database Enginde dialog.
More-less like Qury Analyzer that allows you to open a new query in the
existing window.
Regards
Bojan
"Steen Persson (DK)" wrote:

> Bojan Kuhar wrote:
> I'm not sure it can be done, but "Ctrl-N" will give you the "New query
> with current connection".
> Regards
> Steen
>
|||My fault. The button was called New Query with Current Connection in one of
the betas. The released version renamed it to New Query. I changed most of
the references, but I missed a few. I think I got rid of them all by web
release 1 of Books Online though.
The New Query button will use the connection that has focus when you click
it. Either Object Explorer, or an existing Query Editor window. If your
current context has no connection, then it will pop up the Connect to Server
dialog box.
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Bojan Kuhar" <BojanKuhar@.discussions.microsoft.com> wrote in message
news:01230DB5-BEE5-4452-B89E-470DCCE488F2@.microsoft.com...
>I am missing "New Query with Current Connection" button in SQL Editor in
>the
> SQL management studio. Few posts on the Web refer explain that this
> button
> should allow me to open a new query in the existing window.
> I've checked "Add Remove Buttons" for SQL editor but I still cannot find
> it.
> Any ideas?
|||Bojan Kuhar (BojanKuhar@.discussions.microsoft.com) writes:
> Fantastic.
> Now, one more. Is there something like "Open Query with Current
> Connection". I'd like to avoid the Connect to Database Enginde dialog.
> More-less like Qury Analyzer that allows you to open a new query in the
> existing window.
What Steen said, CTRL-N is the key. Provided one thing: under Tools->
Options->Keyboard select SQL 2000 instead of Standard.
The New Query button also works if you are in a query window or Object
Explorer, and so does File->New->Query with Current Connection.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

new local printing with "error on page"

Hallo
I have a problem with local printing with SP2. As administrator I can
press the new button and receive the question about Security and then
the ActiveX Control RSClientPrint is installed.
As an ordinary user I receive an error on page. "Object doesn't support
this property or method" and the ActiveX Control isn't installed.
Has anybody a good idea how I can install the Control on a computer as
user and not as administrator?
Thanks!This is not a RS issue, but one to do with the permissions granted to
oridnary users, possibly through your Group profile. You could have a look
in IE at the Custom Level Security Settings under "Internet Options" but if
you are in a work environment you need to speak to the network admins. If
you are the network admin, try posting in their group. If this has only
happened since installing SP2 go back to the Security Settings for ActiveX
controls and have a look at the settings.
--
Mary Bray [SQL Server MVP]
Please reply only to newsgroups
<linus@.dplanet.ch> wrote in message
news:1116705736.745994.168630@.f14g2000cwb.googlegroups.com...
> Hallo
> I have a problem with local printing with SP2. As administrator I can
> press the new button and receive the question about Security and then
> the ActiveX Control RSClientPrint is installed.
> As an ordinary user I receive an error on page. "Object doesn't support
> this property or method" and the ActiveX Control isn't installed.
> Has anybody a good idea how I can install the Control on a computer as
> user and not as administrator?
> Thanks!
>

New Folder button missing

After installing reporting services we noticed that the New Folder button is
missing as well as the contents tab. This has worked on several other systems
that we installed. We referenced reporting services by typing in the browser
http://localhost/reports.
Any ideas on why or how to diagnose this problem?You might want to make sure that your permissions for your user name are
correct and that your role is "CONTENT MANAGER"
"DBA449" <DBA449@.discussions.microsoft.com> wrote in message
news:426BA9FE-6A94-48F0-9F9E-0A7DC3CFB23E@.microsoft.com...
> After installing reporting services we noticed that the New Folder button
> is
> missing as well as the contents tab. This has worked on several other
> systems
> that we installed. We referenced reporting services by typing in the
> browser
> http://localhost/reports.
> Any ideas on why or how to diagnose this problem?

New Data-driven Subscription 'Button'

Hi,
I am trying to set up a data-driven subscription. But the button is not
visible on the subscriptions tab. I have also made sure that
1) the report uses stored credentials.
2) A report that includes parameters.
3) The report server that is configured to use the e-mail delivery
extension.
4) SQL Agent service is running.
5) SQL Server database that contains subscriber information.
Can anybody help?
Snippet from books online:
To open this page, select a report, click the Subscriptions tab at the top
of the page, and then click New Data-driven Subscription. The report must
use stored credentials in order for this button to be enabled.
From this I was expecting to see a button nomatter what.Please read this related newsgroup thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=ba9997ba-d3c3-4ac5-bf9f-6881244ba961&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Phil Koay" <phil.koay@.hydro.com.au> wrote in message
news:%23ijs7P1AFHA.2112@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I am trying to set up a data-driven subscription. But the button is not
> visible on the subscriptions tab. I have also made sure that
> 1) the report uses stored credentials.
> 2) A report that includes parameters.
> 3) The report server that is configured to use the e-mail delivery
> extension.
> 4) SQL Agent service is running.
> 5) SQL Server database that contains subscriber information.
> Can anybody help?
> Snippet from books online:
> To open this page, select a report, click the Subscriptions tab at the top
> of the page, and then click New Data-driven Subscription. The report must
> use stored credentials in order for this button to be enabled.
> From this I was expecting to see a button nomatter what.
>|||Thanks for such a prompt and accurate response!
I am indeed using the standard edition of Reporting services and that is why
there is no option of "data driven subscriptions"
I have the following scenario:
I work in a company that has a number of SQL Enterprise licences. However I
would be unable to install Report service on any of these machines, or have
the report services database stored on these machine. Do you know if I can
legally:
1. Install Reporting Services Enterprise edition on seperate box (which has
MS SQL Server standard edition installed on it)
2. Use the local 'MS SQL Server standard edition' as the database for the
'Reporting Services Enterprise'
(from the books online is seems that this is ok to do technically see
'Edition compatibility', but is it legal, and will it have all the same
functionality as if stored on a SQL enterprise?)
Thanks!
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:eCrCHX1AFHA.3120@.TK2MSFTNGP12.phx.gbl...
> Please read this related newsgroup thread:
>
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlser
ver.reportingsvcs&mid=ba9997ba-d3c3-4ac5-bf9f-6881244ba961&sloc=en-us
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Phil Koay" <phil.koay@.hydro.com.au> wrote in message
> news:%23ijs7P1AFHA.2112@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > I am trying to set up a data-driven subscription. But the button is not
> > visible on the subscriptions tab. I have also made sure that
> >
> > 1) the report uses stored credentials.
> >
> > 2) A report that includes parameters.
> >
> > 3) The report server that is configured to use the e-mail delivery
> > extension.
> >
> > 4) SQL Agent service is running.
> >
> > 5) SQL Server database that contains subscriber information.
> > Can anybody help?
> >
> > Snippet from books online:
> >
> > To open this page, select a report, click the Subscriptions tab at the
top
> > of the page, and then click New Data-driven Subscription. The report
must
> > use stored credentials in order for this button to be enabled.
> >
> > From this I was expecting to see a button nomatter what.
> >
> >
>|||Note that if you are installing Enterprise you need an enterprise license
for that box. Having Enterprise SQL Servers somewhere else doesn't help. You
can use a remote DB as the object store (RS uses SQL Server to store lots of
things and has to have one around), i.e. RS can be on a different box than
the SQL Server used but as soon as you do that you have to purchase a
license.
I don't know if you can install Enterprise RS using Standard as the object
store. I never tried that. Just wanted to make sure you understand the
licensing.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Phil Koay" <phil.koay@.hydro.com.au> wrote in message
news:%23KGYe%232AFHA.824@.TK2MSFTNGP11.phx.gbl...
> Thanks for such a prompt and accurate response!
> I am indeed using the standard edition of Reporting services and that is
why
> there is no option of "data driven subscriptions"
> I have the following scenario:
> I work in a company that has a number of SQL Enterprise licences. However
I
> would be unable to install Report service on any of these machines, or
have
> the report services database stored on these machine. Do you know if I can
> legally:
> 1. Install Reporting Services Enterprise edition on seperate box (which
has
> MS SQL Server standard edition installed on it)
> 2. Use the local 'MS SQL Server standard edition' as the database for the
> 'Reporting Services Enterprise'
> (from the books online is seems that this is ok to do technically see
> 'Edition compatibility', but is it legal, and will it have all the same
> functionality as if stored on a SQL enterprise?)
> Thanks!
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:eCrCHX1AFHA.3120@.TK2MSFTNGP12.phx.gbl...
> > Please read this related newsgroup thread:
> >
>
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlser
> ver.reportingsvcs&mid=ba9997ba-d3c3-4ac5-bf9f-6881244ba961&sloc=en-us
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Phil Koay" <phil.koay@.hydro.com.au> wrote in message
> > news:%23ijs7P1AFHA.2112@.TK2MSFTNGP09.phx.gbl...
> > > Hi,
> > >
> > > I am trying to set up a data-driven subscription. But the button is
not
> > > visible on the subscriptions tab. I have also made sure that
> > >
> > > 1) the report uses stored credentials.
> > >
> > > 2) A report that includes parameters.
> > >
> > > 3) The report server that is configured to use the e-mail delivery
> > > extension.
> > >
> > > 4) SQL Agent service is running.
> > >
> > > 5) SQL Server database that contains subscriber information.
> > > Can anybody help?
> > >
> > > Snippet from books online:
> > >
> > > To open this page, select a report, click the Subscriptions tab at the
> top
> > > of the page, and then click New Data-driven Subscription. The report
> must
> > > use stored credentials in order for this button to be enabled.
> > >
> > > From this I was expecting to see a button nomatter what.
> > >
> > >
> >
> >
>