Embedding a reporting Services object

Hi,
Can I embedde a reporting services object in my web based application so the
clients can use the reporting seemlessly.
Thanks in advance,
BenjaminYes, you can. Take a look at the ReportViewer sample that Microsoft
includes.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"BenJ" <BenJ@.netvu.com> wrote in message
news:O3XVHB4HFHA.2456@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Can I embedde a reporting services object in my web based application so
> the
> clients can use the reporting seemlessly.
> Thanks in advance,
> Benjamin
>|||Check this example
http://www.rdlcomponents.com/ASPExamples/default.aspx
"Jeff A. Stucker" wrote:
> Yes, you can. Take a look at the ReportViewer sample that Microsoft
> includes.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "BenJ" <BenJ@.netvu.com> wrote in message
> news:O3XVHB4HFHA.2456@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > Can I embedde a reporting services object in my web based application so
> > the
> > clients can use the reporting seemlessly.
> >
> > Thanks in advance,
> > Benjamin
> >
> >
>
>

Embedded PDF and Excel Files

I want to upload PDF and Excel files to the Report Server database. I
would like to display them in a custom web application. When working
with the ReportViewer control, I can easily show reports. I can't
figure out the process on how to show a PDF to a user. In particular,
if the user selects a PDF ( I can check the MIMETYPE), then, how do I
get the file from Report Server so I can stream it to the user?On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> I want to upload PDF and Excel files to the Report Server database. I
> would like to display them in a custom web application. When working
> with the ReportViewer control, I can easily show reports. I can't
> figure out the process on how to show a PDF to a user. In particular,
> if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> get the file from Report Server so I can stream it to the user?
If you create a report that has the same format and output as the PDF
and Excel files, you could call the report and automatically render it
to PDF or Excel with a download prompt via URL. Here are a couple
examples.
http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Render&Param1=SomeValue&rs:Format=PDF
-or-
http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Render&Param1=SomeValue&rs:Format=Excel
Here's the URL format:
http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=Render&<ParameterName>=<ParameterValue>&rs:Format=<PDF/CSV/XML/Excel/MHTML>
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Oct 10, 8:36 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> > I want to upload PDF and Excel files to the Report Server database. I
> > would like to display them in a custom web application. When working
> > with the ReportViewer control, I can easily show reports. I can't
> > figure out the process on how to show a PDF to a user. In particular,
> > if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> > get the file from Report Server so I can stream it to the user?
> If you create a report that has the same format and output as the PDF
> and Excel files, you could call the report and automatically render it
> to PDF or Excel with a download prompt via URL. Here are a couple
> examples.http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=
=3DRend...
> -or-http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=3DRe=
nd...
> Here's the URL format:
> http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=3DR=
ende=ADr&<ParameterName>=3D<ParameterValue>&rs:Format=3D<PDF/CSV/XML/Excel/=MHTML>
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
These are generic PDF files, not based on a report so they cannot be
rendered. We are using Reporting Services to provide security not
only to reports, but also some ancillary PDF and Excel files.|||Where does an uploaded pdf get stored'
Our uploaded pdf changes every week and rather than reupload everytime I was
hoping we could just save changes to the location it was uploaded to.
Many Thanks
"google@.landy.net" wrote:
> On Oct 10, 8:36 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> >
> > > I want to upload PDF and Excel files to the Report Server database. I
> > > would like to display them in a custom web application. When working
> > > with the ReportViewer control, I can easily show reports. I can't
> > > figure out the process on how to show a PDF to a user. In particular,
> > > if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> > > get the file from Report Server so I can stream it to the user?
> >
> > If you create a report that has the same format and output as the PDF
> > and Excel files, you could call the report and automatically render it
> > to PDF or Excel with a download prompt via URL. Here are a couple
> > examples.http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Rend...
> > -or-http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Rend...
> >
> > Here's the URL format:
> > http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=Rende-r&<ParameterName>=<ParameterValue>&rs:Format=<PDF/CSV/XML/Excel/MHTML>
> > Hope this helps.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. Software Consultant
> These are generic PDF files, not based on a report so they cannot be
> rendered. We are using Reporting Services to provide security not
> only to reports, but also some ancillary PDF and Excel files.
>

embed SQL Express in app

I'm new to SQL Sever Express and wondering about using it for a desktop app.
I have a web server and SQL2005 with some web apps, and I'm thinking about
making desktop versions of some.
But, I want to protect the db structure and the way everything hangs
together. Assuming I can make a SQL Express version of the 2005 db, can I
combine that with something like a Flash front end and distribute it to
desktops without risking nosy people looking into what make them tick?
What would be great would be encryption of the db, and some lock to prevent
people from opening it in Enterprise mgr/SQL mgr.
CS
hi,
catsailor wrote:
> I'm new to SQL Sever Express and wondering about using it for a
> desktop app. I have a web server and SQL2005 with some web apps, and
> I'm thinking about making desktop versions of some.
> But, I want to protect the db structure and the way everything hangs
> together. Assuming I can make a SQL Express version of the 2005 db,
> can I combine that with something like a Flash front end and
> distribute it to desktops without risking nosy people looking into
> what make them tick?
> What would be great would be encryption of the db, and some lock to
> prevent people from opening it in Enterprise mgr/SQL mgr.
> CS
http://msdn.microsoft.com/library/de...xpuserinst.asp
http://msdn.microsoft.com/library/de...LExCustApp.asp
as regards encrition, you can use the native features provided by SQL Server
2005 it self, as indicated in
http://msdn.microsoft.com/msdnmag/is...s/default.aspx
http://msdn2.microsoft.com/en-us/library/ms189586.aspx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks very much for the articles. I have read through them quickly and see
that I may be able to embed an SQL Express db in my app, and I can encrypt
the data.
But, if a user had Admin privileges and SQL Server Management Studio,
couldn't she still open the SQL Express db and see the structure? Is there
any way to prevent anyone but me from opening the db at all, even if they
are sa?
CS
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:47q45jFgufr7U1@.individual.net...
> hi,
> catsailor wrote:
> http://msdn.microsoft.com/library/de...xpuserinst.asp
> http://msdn.microsoft.com/library/de...LExCustApp.asp
> as regards encrition, you can use the native features provided by SQL
> Server 2005 it self, as indicated in
> http://msdn.microsoft.com/msdnmag/is...s/default.aspx
> http://msdn2.microsoft.com/en-us/library/ms189586.aspx
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi,
catsailor wrote:
> Thanks very much for the articles. I have read through them quickly
> and see that I may be able to embed an SQL Express db in my app, and
> I can encrypt the data.
> But, if a user had Admin privileges and SQL Server Management Studio,
> couldn't she still open the SQL Express db and see the structure? Is
> there any way to prevent anyone but me from opening the db at all,
> even if they are sa?
the encription protection available in SQL Server 2005 is for data only...
at the schema level you can prevent, via GRANT/DENY statement permissions on
"VIEW DEFINITION" at the objects level as at the schema level it self,
http://msdn2.microsoft.com/en-us/library/ms176128(SQL.90).aspx , but a
sysadmin member can not be cut off...
you say:
>Is
> there any way to prevent anyone but me from opening the db at all,
> even if they are sa?
but ... "who are you?"... when you distribute a database to end users they
will not care about "you"... their system will care about their
acconts/logins... or better.. their principals
(http://msdn2.microsoft.com/en-us/library/ms181127(SQL.90).aspx)... and you
will not be enlisted there at all..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I think if you carry this through to it's logical conclusion you won't want
to totally block access. If you did, that would mean you would be
responsible for all backup and restore, maintenance, patching, upgrading,
etc. If the customer had a SQL Server problem, you would have to fix it
because CSS wouldn't be able to access their database to fix it. Are you
really willing to sign up for that?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"catsailor" <hullflyer at gmail.com> wrote in message
news:e27f3$441833a9$48f535c4$29530@.msgid.meganewss ervers.com...
> Thanks very much for the articles. I have read through them quickly and
> see that I may be able to embed an SQL Express db in my app, and I can
> encrypt the data.
> But, if a user had Admin privileges and SQL Server Management Studio,
> couldn't she still open the SQL Express db and see the structure? Is
> there any way to prevent anyone but me from opening the db at all, even if
> they are sa?
> CS
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:47q45jFgufr7U1@.individual.net...
>
|||yeppers, that would be part of the deal.
CS
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:OfVy9NGSGHA.4944@.TK2MSFTNGP10.phx.gbl...
>I think if you carry this through to it's logical conclusion you won't want
>to totally block access. If you did, that would mean you would be
>responsible for all backup and restore, maintenance, patching, upgrading,
>etc. If the customer had a SQL Server problem, you would have to fix it
>because CSS wouldn't be able to access their database to fix it. Are you
>really willing to sign up for that?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "catsailor" <hullflyer at gmail.com> wrote in message
> news:e27f3$441833a9$48f535c4$29530@.msgid.meganewss ervers.com...
>

emailing excel and pdf not working

I can email Web Archive reports successfully. However, I cannot send reports
in Excel or PDF.
I have Acrobat Pro 6 installed.
I DO NOT have Excel 2003 installed, but I can if necessary.
Did I missing a configuration step or something?Afte a few weeks of troubleshooting I got it to work. It was totally
unrelated to RS.
"Matt Temple" <mtemple@.dslextreme.com> wrote in message
news:10djruhppn13j04@.corp.supernews.com...
> I can email Web Archive reports successfully. However, I cannot send
reports
> in Excel or PDF.
> I have Acrobat Pro 6 installed.
> I DO NOT have Excel 2003 installed, but I can if necessary.
> Did I missing a configuration step or something?
>

Emailing a Report on the Fly

Hi,
I am rendering a report in PDF Format using web services API using a click
of a button which its doing perfectly.
As soon as this report is rendered in PDF format, Is there a way to send
him a particular user this report by Email thru C# FrontEnd.
An Email has to be sent when a report is rendered by the user automatically
using WebServices API.
plz put some sample code as well.
I am doing from C# in Winforms
Thanks For ur help
Thanks
Chandra
--
Message posted via http://www.sqlmonster.comThis is not built into RS so you would need to call the mail library
yourself. We would like to add a "send now" feature but it won't make it
into SQL 2005.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chandra Kotha via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in
message news:fb6aea0a57554e4cbbda5c3bef6d90ff@.SQLMonster.com...
> Hi,
> I am rendering a report in PDF Format using web services API using a click
> of a button which its doing perfectly.
> As soon as this report is rendered in PDF format, Is there a way to send
> him a particular user this report by Email thru C# FrontEnd.
> An Email has to be sent when a report is rendered by the user
> automatically
> using WebServices API.
> plz put some sample code as well.
> I am doing from C# in Winforms
> Thanks For ur help
> Thanks
> Chandra
> --
> Message posted via http://www.sqlmonster.com|||Thanks very much I will be using Mail API from C#.NET
--
Message posted via http://www.sqlmonster.com

Email on demand

Looking for an example of sending a 2005 RS report via a web page on demand.
I would need to fire it when a user clicked a button on the web form.
In the old days, in plain old ASP, we used to build an HTML formatted email
body and then fire it off using CDO. We could still do that with ASPX but
I'd much prefer to build a report in RS (more formatting and doc type options)
and then fire it off.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1On Oct 3, 1:07 pm, "wnichols via SQLMonster.com" <u3357@.uwe> wrote:
> Looking for an example of sending a 2005 RS report via a web page on demand.
> I would need to fire it when a user clicked a button on the web form.
> In the old days, in plain old ASP, we used to build an HTML formatted email
> body and then fire it off using CDO. We could still do that with ASPX but
> I'd much prefer to build a report in RS (more formatting and doc type options)
> and then fire it off.
> --
> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1
This link should help.
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
You will want to create a Proxy (Web Reference) to
ReportingService2005.asmx. Then attach the newly created file to an
email created via ASP.NET. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Enrique,
Thanks for the info.
EMartinez wrote:
>> Looking for an example of sending a 2005 RS report via a web page on demand.
>> I would need to fire it when a user clicked a button on the web form.
>[quoted text clipped - 6 lines]
>> --
>> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1
>This link should help.
>http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
>You will want to create a Proxy (Web Reference) to
>ReportingService2005.asmx. Then attach the newly created file to an
>email created via ASP.NET. Hope this helps.
>Regards,
>Enrique Martinez
>Sr. Software Consultant
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1|||On Oct 4, 11:04 am, "wnichols via SQLMonster.com" <u3357@.uwe> wrote:
> Enrique,
> Thanks for the info.
>
> EMartinez wrote:
> >> Looking for an example of sending a 2005 RS report via a web page on demand.
> >> I would need to fire it when a user clicked a button on the web form.
> >[quoted text clipped - 6 lines]
> >> --
> >> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1
> >This link should help.
> >http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingser...
> >You will want to create a Proxy (Web Reference) to
> >ReportingService2005.asmx. Then attach the newly created file to an
> >email created via ASP.NET. Hope this helps.
> >Regards,
> >Enrique Martinez
> >Sr. Software Consultant
> --
> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Email delivery, rendering format problem

Hi,

Im trying to set up so the report gets delivered to specified email addresses with the rendering format set to Web Archive.

The problem is, it wont deliver the background of the report. We really need the background to be yellow (company color) i have tried with both the backgroundcolor setting and backgroundimage setting with repeat =true, but it just delivers the email as transparent(white) background.

Anyone know how to solve this?

regards,
xenojust seem like it is impossible. For those with similiar problem in the future, here is the work-around that i used:
Put a rectangle on your form that stretches 100% with and height of the form and put all objects within it. Make sure it will be resizable to fit.

I dont like it at all, but hey...cant waste too much time on these things when the clock is ticking.
.xeno

Email Delivery

I'm using the web service to run reports from an application. However, I don't want to wait for a report to complete; I would like to just have the report emailed to the user when it is complete. I've only found email delivery through subscriptions. Is there another way to deliver reports via email?

If I have to use subscriptions I would like to set them to run "immediately". I've found that setting the start date to sometime in the past does not seem to run the report. Is there some way to set a schedule to run immediately. I've thought of setting the time to the near future, but I seem to have the problem of getting the proper timestamp. Can I get this through the web service some how?

Thanks,

Sam

No there is no such functionality. As you are creating a subscription, as job is created at the SQL Server Agent Service which will keep track of the execution of it, therefore setting the value to a past datetime won′t effect the execution.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

email a pdf report

I don't know if this is a bug or not. I have SP1 and used the web
service to render the report in PDF format. The report renders fine
but when I click on the email button it asks me if I want to email the
url or the report itself. I choose the latter. When it attached the
report in the email, I notice that the extension of the report is aspx
and not PDF. So, I test the email by sending it to myself. I have to
save the report as PDF extension in order to view as PDF otherwise it
me garbage. I wonder this is a bug. Thanks.I assume you are using your own ASP.NET application that calls the RS web
service then displays the result to your users. Your application needs to
set the ContentType property of the ASP.NET response object, and perhaps the
content-disposition HTTP header. Doing this will tell IE how to display the
data your page is returning.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:ADB7C080-8FC7-49DE-89FA-0104A9FF0915@.microsoft.com...
> This is happening to me too...
> "powerranger" wrote:
> > I don't know if this is a bug or not. I have SP1 and used the web
> > service to render the report in PDF format. The report renders fine
> > but when I click on the email button it asks me if I want to email the
> > url or the report itself. I choose the latter. When it attached the
> > report in the email, I notice that the extension of the report is aspx
> > and not PDF. So, I test the email by sending it to myself. I have to
> > save the report as PDF extension in order to view as PDF otherwise it
> > me garbage. I wonder this is a bug. Thanks.
> >

EM error connection forcibly closed by the remote host (ouch)

I am getting this error in Enterprise Manager:
TCP Provider: An existing connection was forcibly closed by the remote host.
But, my web app can still connect just fine to the db, so it's still inthe same place with the same login/password. And my registrationin EM was working just fine (for years) until yesterday I got thiserror. I've tried deleting the registration and re-creating itbut the same thing. What could have gone wrong to cause this tohappen?
Thanks for any pointers, I have no idea where to start looking on this one, the host says they haven't changed anything...
Well, in case this bites anybody else on the butt, here's what it was:My login didn't have permission for my DEFAULT database on theserver. Apparently EM checks my default db before checking the dbI'm actually trying to connect to! So making my db also mydefault db fixed it.

Either SQL or VB is automatically applying time offsets on my data

I have a windows app which is used in australia and uses web services to communicate with the database located in new zealand. I have a problem where dates that are returned from SQL are automatically modified to suit the timezone and i dont know how to turn it off.

For example, i insert the value '10/Jan/2006 20:00' into the database from a PC located in australia. When that data is selected back out, a 4 hour time offset is automatically applied to it and the time is returned as '10/Jan/2006 16:00'.

My current workaround is to modify my queries to say;

"Select convert(varchar, tb_date) tb_date from tablename"

Which returns the date as a string rather than a datetime which means the time offset is not applied.

This is a really poor solution and i'd be really keen to find out a better way...
Thanks

This is not problem with VB or SQL. This is because of the way DateTimes are serialized in XML when sent over Web Services. For information read this excellent article on working with DateTimes in TimeZone involved applications.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/datetimecode.asp

Effects of using Transaction in SP on Performance?

Hi All;
I have a web application which is being used at large scale and there are
upto 10,000 entries per day. Currently, there is no Begin Tran/Commit
Tran/Rollback Tran and b/c of that we found some data corruption. Now, I
changed all the transactional Stored Procedure and used Transaction into
them. Now, I am thinking about the performance of the application when I use
d
Transaction into Stored Procedures which are being used by each user very
frequently. Transaction Lock the objects which might hurt the application
performance. Please, comments on it and should I use Transaction now or not?
Thanks.
Essa, M. Mughal
Software Developer
CanadaYou should DEFINITELY use transactions. Performance penalty or not. There
is no choice here. Data integrity is, by far, the MOST IMPORTANT THING IN A
DATABASE. Sorry for the all caps, but I had to drive it home. Do not
sacrifice your data quality. Otherwise there is very little reason to even
be using a database.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Essa" <essamughal@.hotmail.com> wrote in message
news:46BFC928-7375-47ED-AA79-73FE92A45843@.microsoft.com...
> Hi All;
> I have a web application which is being used at large scale and there are
> upto 10,000 entries per day. Currently, there is no Begin Tran/Commit
> Tran/Rollback Tran and b/c of that we found some data corruption. Now, I
> changed all the transactional Stored Procedure and used Transaction into
> them. Now, I am thinking about the performance of the application when I
used
> Transaction into Stored Procedures which are being used by each user very
> frequently. Transaction Lock the objects which might hurt the application
> performance. Please, comments on it and should I use Transaction now or
not?
> Thanks.
> --
> Essa, M. Mughal
> Software Developer
> Canada|||Hi Adam;
Thanks for your strong recommendataion. I really appreciate your way of
conveying me the importance of Data. I have already changed all the
transactional stored procedure but I was just wondering so now I'll go live
with them and then see what happens. I hope nothing will happen but it will
increase data integrity.
Thanks
"Adam Machanic" wrote:

> You should DEFINITELY use transactions. Performance penalty or not. Ther
e
> is no choice here. Data integrity is, by far, the MOST IMPORTANT THING IN
A
> DATABASE. Sorry for the all caps, but I had to drive it home. Do not
> sacrifice your data quality. Otherwise there is very little reason to eve
n
> be using a database.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Essa" <essamughal@.hotmail.com> wrote in message
> news:46BFC928-7375-47ED-AA79-73FE92A45843@.microsoft.com...
> used
> not?
>
>

Effects of using Transaction in SP on Performance?

Hi All;
I have a web application which is being used at large scale and there are
upto 10,000 entries per day. Currently, there is no Begin Tran/Commit
Tran/Rollback Tran and b/c of that we found some data corruption. Now, I
changed all the transactional Stored Procedure and used Transaction into
them. Now, I am thinking about the performance of the application when I used
Transaction into Stored Procedures which are being used by each user very
frequently. Transaction Lock the objects which might hurt the application
performance. Please, comments on it and should I use Transaction now or not?
Thanks.
Essa, M. Mughal
Software Developer
Canada
You should DEFINITELY use transactions. Performance penalty or not. There
is no choice here. Data integrity is, by far, the MOST IMPORTANT THING IN A
DATABASE. Sorry for the all caps, but I had to drive it home. Do not
sacrifice your data quality. Otherwise there is very little reason to even
be using a database.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"Essa" <essamughal@.hotmail.com> wrote in message
news:46BFC928-7375-47ED-AA79-73FE92A45843@.microsoft.com...
> Hi All;
> I have a web application which is being used at large scale and there are
> upto 10,000 entries per day. Currently, there is no Begin Tran/Commit
> Tran/Rollback Tran and b/c of that we found some data corruption. Now, I
> changed all the transactional Stored Procedure and used Transaction into
> them. Now, I am thinking about the performance of the application when I
used
> Transaction into Stored Procedures which are being used by each user very
> frequently. Transaction Lock the objects which might hurt the application
> performance. Please, comments on it and should I use Transaction now or
not?
> Thanks.
> --
> Essa, M. Mughal
> Software Developer
> Canada
|||Hi Adam;
Thanks for your strong recommendataion. I really appreciate your way of
conveying me the importance of Data. I have already changed all the
transactional stored procedure but I was just wondering so now I'll go live
with them and then see what happens. I hope nothing will happen but it will
increase data integrity.
Thanks
"Adam Machanic" wrote:

> You should DEFINITELY use transactions. Performance penalty or not. There
> is no choice here. Data integrity is, by far, the MOST IMPORTANT THING IN A
> DATABASE. Sorry for the all caps, but I had to drive it home. Do not
> sacrifice your data quality. Otherwise there is very little reason to even
> be using a database.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Essa" <essamughal@.hotmail.com> wrote in message
> news:46BFC928-7375-47ED-AA79-73FE92A45843@.microsoft.com...
> used
> not?
>
>

Editing Varchar field in Enterprise Manager

I am using SQL 2000. In a table (tblTestTable) I have a field VARHCAR(4000).
the field stores text taken from a text area in a web page so contains new line characters also length is around 2000 characters.

The problem is that I am unable to edit the text in this field through Enterprise Manager. The text remains as if it is readonly. All I can do is select entire text and cut or delete. :confused:
Is there reason for this occurance? How can it beovercome?Don't use EM?

It really wasn't made for that purpose, but I'll have a look.