Embedding Fonts While Exporting To PDF

Hi,
My report requires a special type of font. I have the font installed on the
report server. When I export the report as PDF and view the document on the
report server I am able to see the new font. But when I open the same
document on a machine which doesn't have the font installed, I don't get to
see the font. I understand that there is some way you can configure your pdfs
so that the fonts are embedded within the PDF so that all the clients need
not have the font installed to view the document. Is there any way we can
embed fonts in pdfs using reporting services?
Any help is greatly appreciated.
Thanks,
GeorgeYou can't embed fonts into PDF exports in this version of SRS. Maybe next
version which is due maybe middle of next year. Crystal Reports allows you
to embed fonts in version 9.
"george" wrote:
> Hi,
> My report requires a special type of font. I have the font installed on the
> report server. When I export the report as PDF and view the document on the
> report server I am able to see the new font. But when I open the same
> document on a machine which doesn't have the font installed, I don't get to
> see the font. I understand that there is some way you can configure your pdfs
> so that the fonts are embedded within the PDF so that all the clients need
> not have the font installed to view the document. Is there any way we can
> embed fonts in pdfs using reporting services?
> Any help is greatly appreciated.
> Thanks,
> Georgesql

Embedded Images

Is there any way to embed images when you want to view a report in HTML?
From what I can tell... RS makes a copy of the embedded image... and then
references this copy (hosted on the report server) in the HTML... however,
the application I use to generate the report doesn't allow direct access to
the reporting server... which complicates things a bit... has anyone else
dealt with this issue?Render report as MHTML
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"MER78" <MER78@.discussions.microsoft.com> wrote in message
news:F2682F11-DDDF-45E3-A81F-1A1193B1B3B7@.microsoft.com...
> Is there any way to embed images when you want to view a report in HTML?
> From what I can tell... RS makes a copy of the embedded image... and then
> references this copy (hosted on the report server) in the HTML... however,
> the application I use to generate the report doesn't allow direct access
> to
> the reporting server... which complicates things a bit... has anyone else
> dealt with this issue?sql

embed barcode in pdf

We export a report (pdf format) from Reporting Services that contains
barcodes. If someone tries to view the pdf on a computer that doesn't have
the barcode font loaded it doesn't show up. Is there a way to embed the
barcode image in the pdf?
Thanks,
TimPerhaps someone else will jump in but I am pretty sure there is no way to
embed the font in RS 2005.
RS 2008 will have barcode support (part of the Dundas controls that
Microsoft purchased and is including in RS 2008). This support will allow
you to get around this problem. Today your only choice is to have anyone
that needs to print barcodes to have the font on their machine.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Tim Kelley" <tkelley@.company.com> wrote in message
news:u4W0JmwpIHA.4292@.TK2MSFTNGP04.phx.gbl...
> We export a report (pdf format) from Reporting Services that contains
> barcodes. If someone tries to view the pdf on a computer that doesn't
> have the barcode font loaded it doesn't show up. Is there a way to embed
> the barcode image in the pdf?
> Thanks,
> Tim
>

Emailing Report

I need to export a view into excel and mail to my manager daily morning. Is there a way i can automate this process. I know how to convert view to excel but i need a better solution to automate this process with emailing to my mgr. Please suggest a better approach of doing this.

Thanks,

The send mail task accepts the use of file attachments.

You are using SSIS, right?|||Or you might want to consider Reporting Services for this.|||

Thats true but how; Firstly i need to convert view to excel and then send excel sheet as attachment in email. Could you pls. explain how i could do this. I am a newbie.

Thanks

|||

If you are going to use SSIS, create a new package, add a data flow task with an OLEDB source that retrieves the view. Add an Excel destination to the data flow to capture the results. Back in the control flow, add a Send Mail task to send the email.

If you want to do it in Reporting Services, post your question in the RS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1) and I'll answer it there.

EM Script Error - Permanent Fix?

I know that you can make the IE script error go away by changing the view of
a database to something other than taskpad, then change it back, but this is
temporary--the error always comes back. Is there a permanent fix?
Unfortunately there is none that I know of short of SQL 2005<g>.
Andrew J. Kelly SQL MVP
"salty" <salty@.discussions.microsoft.com> wrote in message
news:9DA719CA-07DF-49C6-BF62-147D59A7CED3@.microsoft.com...
> I know that you can make the IE script error go away by changing the view
of
> a database to something other than taskpad, then change it back, but this
is
> temporary--the error always comes back. Is there a permanent fix?
>
|||That wasn't the answer I was hoping for... :^(
Thanks for the reply, though.
"Andrew J. Kelly" wrote:

> Unfortunately there is none that I know of short of SQL 2005<g>.

EM in SS2000

In EM when I right-click on a database and choose "view", "taskpad" I get a
list of tables. Under some of the tables, I see the names of indexes that I
recognize but then I also see something like hind_909246294_10A_1A or
_WA_Sys_dtCCreationDate_3631FF56. What are these?
Thanks,
--
Dan D.Those are not indexes. They are auto-creates statistics. See the auto create statistics database
option. You can drop these using DROP STATISTICS, but they were created for a reason in the first
place, so best is most often to leave them.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:A2619689-507C-4EC2-96BF-78A1461F542E@.microsoft.com...
> In EM when I right-click on a database and choose "view", "taskpad" I get a
> list of tables. Under some of the tables, I see the names of indexes that I
> recognize but then I also see something like hind_909246294_10A_1A or
> _WA_Sys_dtCCreationDate_3631FF56. What are these?
> Thanks,
> --
> Dan D.|||Thanks.
--
Dan D.
"Tibor Karaszi" wrote:
> Those are not indexes. They are auto-creates statistics. See the auto create statistics database
> option. You can drop these using DROP STATISTICS, but they were created for a reason in the first
> place, so best is most often to leave them.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:A2619689-507C-4EC2-96BF-78A1461F542E@.microsoft.com...
> > In EM when I right-click on a database and choose "view", "taskpad" I get a
> > list of tables. Under some of the tables, I see the names of indexes that I
> > recognize but then I also see something like hind_909246294_10A_1A or
> > _WA_Sys_dtCCreationDate_3631FF56. What are these?
> >
> > Thanks,
> > --
> > Dan D.
>
>

EM in SS2000

In EM when I right-click on a database and choose "view", "taskpad" I get a
list of tables. Under some of the tables, I see the names of indexes that I
recognize but then I also see something like hind_909246294_10A_1A or
_WA_Sys_dtCCreationDate_3631FF56. What are these?
Thanks,
--
Dan D.Those are not indexes. They are auto-creates statistics. See the auto create
statistics database
option. You can drop these using DROP STATISTICS, but they were created for
a reason in the first
place, so best is most often to leave them.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:A2619689-507C-4EC2-96BF-78A1461F542E@.microsoft.com...
> In EM when I right-click on a database and choose "view", "taskpad" I get
a
> list of tables. Under some of the tables, I see the names of indexes that
I
> recognize but then I also see something like hind_909246294_10A_1A or
> _WA_Sys_dtCCreationDate_3631FF56. What are these?
> Thanks,
> --
> Dan D.|||Thanks.
--
Dan D.
"Tibor Karaszi" wrote:

> Those are not indexes. They are auto-creates statistics. See the auto crea
te statistics database
> option. You can drop these using DROP STATISTICS, but they were created fo
r a reason in the first
> place, so best is most often to leave them.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:A2619689-507C-4EC2-96BF-78A1461F542E@.microsoft.com...
>
>

EM frozen when viewing tables

Hi,
When I tried to view tables of one my database (sql2000) from Enterprise
manger by clicking on Databases --> <database name> --> Tables, it got
frozen. But if I do it from Query Analyzer, I can query any table as usual.
I
close EM and tried several times, it's still the same. How can I
troubleshoot? ThanksIs this on the actual server or on another workstation using the client tool
s?
In any case, you may need to install SP4 on the client. If it happens on the
server, you need to do an impcat analisys before installing SP4. I would not
be surprised that some applications are not up to date with the current SP
from MS.
"Jen" wrote:

> Hi,
> When I tried to view tables of one my database (sql2000) from Enterprise
> manger by clicking on Databases --> <database name> --> Tables, it got
> frozen. But if I do it from Query Analyzer, I can query any table as usual
. I
> close EM and tried several times, it's still the same. How can I
> troubleshoot? Thanks|||it's on another workstation. Restart service clears it. Thanks
"Edgardo Valdez, MCSD, MCDBA" wrote:
[vbcol=seagreen]
> Is this on the actual server or on another workstation using the client to
ols?
> In any case, you may need to install SP4 on the client. If it happens on t
he
> server, you need to do an impcat analisys before installing SP4. I would n
ot
> be surprised that some applications are not up to date with the current SP
> from MS.
> "Jen" wrote:
>

EM frozen when viewing tables

Hi,
When I tried to view tables of one my database (sql2000) from Enterprise
manger by clicking on Databases --> <database name> --> Tables, it got
frozen. But if I do it from Query Analyzer, I can query any table as usual. I
close EM and tried several times, it's still the same. How can I
troubleshoot? Thanks
Is this on the actual server or on another workstation using the client tools?
In any case, you may need to install SP4 on the client. If it happens on the
server, you need to do an impcat analisys before installing SP4. I would not
be surprised that some applications are not up to date with the current SP
from MS.
"Jen" wrote:

> Hi,
> When I tried to view tables of one my database (sql2000) from Enterprise
> manger by clicking on Databases --> <database name> --> Tables, it got
> frozen. But if I do it from Query Analyzer, I can query any table as usual. I
> close EM and tried several times, it's still the same. How can I
> troubleshoot? Thanks
|||it's on another workstation. Restart service clears it. Thanks
"Edgardo Valdez, MCSD, MCDBA" wrote:
[vbcol=seagreen]
> Is this on the actual server or on another workstation using the client tools?
> In any case, you may need to install SP4 on the client. If it happens on the
> server, you need to do an impcat analisys before installing SP4. I would not
> be surprised that some applications are not up to date with the current SP
> from MS.
> "Jen" wrote:

EM frozen when viewing tables

Hi,
When I tried to view tables of one my database (sql2000) from Enterprise
manger by clicking on Databases --> <database name> --> Tables, it got
frozen. But if I do it from Query Analyzer, I can query any table as usual. I
close EM and tried several times, it's still the same. How can I
troubleshoot? ThanksIs this on the actual server or on another workstation using the client tools?
In any case, you may need to install SP4 on the client. If it happens on the
server, you need to do an impcat analisys before installing SP4. I would not
be surprised that some applications are not up to date with the current SP
from MS.
"Jen" wrote:
> Hi,
> When I tried to view tables of one my database (sql2000) from Enterprise
> manger by clicking on Databases --> <database name> --> Tables, it got
> frozen. But if I do it from Query Analyzer, I can query any table as usual. I
> close EM and tried several times, it's still the same. How can I
> troubleshoot? Thanks|||it's on another workstation. Restart service clears it. Thanks
"Edgardo Valdez, MCSD, MCDBA" wrote:
> Is this on the actual server or on another workstation using the client tools?
> In any case, you may need to install SP4 on the client. If it happens on the
> server, you need to do an impcat analisys before installing SP4. I would not
> be surprised that some applications are not up to date with the current SP
> from MS.
> "Jen" wrote:
> > Hi,
> >
> > When I tried to view tables of one my database (sql2000) from Enterprise
> > manger by clicking on Databases --> <database name> --> Tables, it got
> > frozen. But if I do it from Query Analyzer, I can query any table as usual. I
> > close EM and tried several times, it's still the same. How can I
> > troubleshoot? Thanks

EM and QA access different

Users (other than sysadmin) can query tables in QA just fine, but when they
try to view the same table in EM, they get an error that says they "might no
t
have permission to perform this operation, or the object XXX might no longer
exist in the database."
Any ideas?RP
How do you query the table? by stored procedure or by querying underlying
table?
"RP" <RP@.discussions.microsoft.com> wrote in message
news:19B8A84F-3E22-455D-9792-BD4AB4F5E7AF@.microsoft.com...
> Users (other than sysadmin) can query tables in QA just fine, but when
they
> try to view the same table in EM, they get an error that says they "might
not
> have permission to perform this operation, or the object XXX might no
longer
> exist in the database."
> Any ideas?|||just a regular query of the table
"Uri Dimant" wrote:

> RP
> How do you query the table? by stored procedure or by querying underlying
> table?
>
> "RP" <RP@.discussions.microsoft.com> wrote in message
> news:19B8A84F-3E22-455D-9792-BD4AB4F5E7AF@.microsoft.com...
> they
> not
> longer
>
>

Editing views in 2005 Management Studio

It was always the custom in Enterprise Manager, when creating a view, to
create a dummy view, e.g.:
SELECT 1
save it, then go back and edit the view. This way, you could edit the view
definition without Enterprise Manager destroying your formatting, and you
can add comments.
Now using "Microsoft SQL Server Management Studio", there is no longer a
"Properties" option if i right-click a view name.
So where is the option to edit a vew in MS?
(Is "MS" what we're abbreviating "Management Studio" these days?)Right click the view name in Management Studio and select Modify from
the context sensitive pop-up menu. Personally I always write creation &
alter scripts for every DDL object I create - that way you don't have
some GUI changing all your formatting etc. (also it's good for getting
the DDL syntax in your head).
I think Management Studio is commonly abbreviated SSMS (SQL Server
Management Studio). It seems to be the way Microsoft have marketed the
SQL 2005 products:
SSMS - SQL Server Management Studio
SSAS - SQL Server Analysis Service
SSIS - SQL Server Integration Services
SSRS - SQL Server Reporting Services (although I've often seen this as
just RS)
etc.
Although now that I think about it I've never seen Service Broker
abbreviated and I've seen Reporting & Notification Services abbreviated
as RS & NS (in fact I can't remember ever seeing Notification Services
abbreviated SSNS). Hmmm...
*mike hodgson*
http://sqlnerd.blogspot.com
Ian Boyd wrote:

>It was always the custom in Enterprise Manager, when creating a view, to
>create a dummy view, e.g.:
> SELECT 1
>save it, then go back and edit the view. This way, you could edit the view
>definition without Enterprise Manager destroying your formatting, and you
>can add comments.
>Now using "Microsoft SQL Server Management Studio", there is no longer a
>"Properties" option if i right-click a view name.
>
>So where is the option to edit a vew in MS?
>(Is "MS" what we're abbreviating "Management Studio" these days?)
>
>|||Do you mean using the query building tool? If you just want to edit in
text, click on Script View, Create As, To New Query Window and edit it
there. I tend to do that with all objects in SSMS
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
news:OWljNm4KGHA.3984@.TK2MSFTNGP14.phx.gbl...
> It was always the custom in Enterprise Manager, when creating a view, to
> create a dummy view, e.g.:
> SELECT 1
> save it, then go back and edit the view. This way, you could edit the view
> definition without Enterprise Manager destroying your formatting, and you
> can add comments.
> Now using "Microsoft SQL Server Management Studio", there is no longer a
> "Properties" option if i right-click a view name.
>
> So where is the option to edit a vew in MS?
> (Is "MS" what we're abbreviating "Management Studio" these days?)
>|||Not completely. BIDS is Business Intelligence Studio (though it could be
SSBIDS :)
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message
news:%23f$o554KGHA.1312@.TK2MSFTNGP09.phx.gbl...
Right click the view name in Management Studio and select Modify from the
context sensitive pop-up menu. Personally I always write creation & alter
scripts for every DDL object I create - that way you don't have some GUI
changing all your formatting etc. (also it's good for getting the DDL syntax
in your head).
I think Management Studio is commonly abbreviated SSMS (SQL Server
Management Studio). It seems to be the way Microsoft have marketed the SQL
2005 products:
SSMS - SQL Server Management Studio
SSAS - SQL Server Analysis Service
SSIS - SQL Server Integration Services
SSRS - SQL Server Reporting Services (although I've often seen this as just
RS)
etc.
Although now that I think about it I've never seen Service Broker
abbreviated and I've seen Reporting & Notification Services abbreviated as
RS & NS (in fact I can't remember ever seeing Notification Services
abbreviated SSNS). Hmmm...
mike hodgson
http://sqlnerd.blogspot.com
Ian Boyd wrote:
It was always the custom in Enterprise Manager, when creating a view, to
create a dummy view, e.g.:
SELECT 1
save it, then go back and edit the view. This way, you could edit the view
definition without Enterprise Manager destroying your formatting, and you
can add comments.
Now using "Microsoft SQL Server Management Studio", there is no longer a
"Properties" option if i right-click a view name.
So where is the option to edit a vew in MS?
(Is "MS" what we're abbreviating "Management Studio" these days?)|||"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message
news:%23f$o554KGHA.1312@.TK2MSFTNGP09.phx.gbl...
> Right click the view name in Management Studio and select Modify from
> the context sensitive pop-up menu. Personally I always write creation &
> alter scripts for every DDL object I create - that way you don't have
> some GUI changing all your formatting etc. (also it's good for getting
> the DDL syntax in your head).
That doesn't work. It shows me the SQL of the view, but not the view
defintion itself. And if i modify the SQL formatting, or add comments, the
formatting is destroyed and comments are removed.
Any other suggestions?|||> Do you mean using the query building tool? If you just want to edit in
> text, click on Script View, Create As, To New Query Window and edit it
> there. I tend to do that with all objects in SSMS
i want the equivalent of Enterprise Manager's
Right-Click->Properties
i don't want to have to script the view, and then run a drop-create.
Everyone, it's okay to admit that it cannot be done in SSMS.|||> Everyone, it's okay to admit that it cannot be done in SSMS.
Sorry, just trying to figure out what you want and fit an answer to your
request.
If you are asking is the paradigm of SSMS the same as EM. No, not at all.
(And I don't like query editors at all, so I would never have used it in EM
either.) SSMS uses an editing paradigm of files, and you start one by
scripting objects to the file.
Instead of scripting it as CREATE, script is as ALTER and you can save
changes by just executing the batch.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Ian Boyd" <ian.msnews010@.avatopia.com> wrote in message
news:eWlEZi$KGHA.1236@.TK2MSFTNGP10.phx.gbl...
> i want the equivalent of Enterprise Manager's
> Right-Click->Properties
> i don't want to have to script the view, and then run a drop-create.
> Everyone, it's okay to admit that it cannot be done in SSMS.
>|||"Louis Davidson" <dr_dontspamme_sql@.hotmail.com> wrote in message
news:ellSfRALGHA.2780@.tk2msftngp13.phx.gbl...
> If you are asking is the paradigm of SSMS the same as EM. No, not at all.
> (And I don't like query editors at all, so I would never have used it in
> EM either.)
i also don't like query editors, and always created and edited view DDL
directly

> Sorry, just trying to figure out what you want and fit an answer to your
> request.
...which was different from Right-Click->Design View|||Yeah, OK. Looks like the Modify menu option is about as close as SSMS
gets to the old SQLEM view properties. But you're right - it reformats
stuff (don't you hate it when tools do that!).
The easiest thing for you to do (doesn't require hand-crafting scripts)
is to just right click the view name and select Script View As | ALTER
To | New Query Editor Window. That will automatically generate the
ALTER VIEW script for you from the actual view schema (ie. it'll keep
whatever comments & whitespace were in the code). All you have to do is
change the bits you want changed and then execute the ALTER VIEW
statement. You don't even have to save the script if you don't want
(although, personally, I would always keep a record of what I changed in
the DDL). And since it's an ALTER statement it'll keep dependencies,
permissions & all those other things that tend to disappear and get
forgotten when you DROP VIEW... CREATE VIEW...
That's about as close as I can suggest to simulate the old View
Properties dialog box in SQLEM.
*mike hodgson*
http://sqlnerd.blogspot.com
Ian Boyd wrote:

>"Louis Davidson" <dr_dontspamme_sql@.hotmail.com> wrote in message
>news:ellSfRALGHA.2780@.tk2msftngp13.phx.gbl...
>
>i also don't like query editors, and always created and edited view DDL
>directly
>
>
>
>
>...which was different from Right-Click->Design View
>
>|||use Script as Alter.
EM scripts the view to the properties window using a CREATE, so it ran a
drop-create under the hood, and restored permissions.
The only thing the properties window gave you that scripting doesn't is
the permissions button.
But if you script as alter instead, you don't have to worry about losing
permissions, so that's moot.
The advantages of having the script (you can search, it's not a modal
window, it's far easier to read, you can save to a file directly from
it, etc.) far outweight the EM properties window. [i rap knuckles around
here when i see people using EM props window :)]
Ian Boyd wrote:
>
> i want the equivalent of Enterprise Manager's
> Right-Click->Properties
> i don't want to have to script the view, and then run a drop-create.
> Everyone, it's okay to admit that it cannot be done in SSMS.
>

Editing table data in Query Analyzer

Hi All !
I open a table in Query Analyzer by right clicking on it and
selecting 'Open' and when the data is displayed in the view pane I
would like to be able to edit it. It seems however that tables marked
as read only (as shown on the top bar e.g. SQL Query Analyzer - [Open
Table ServerName.DBName.dbo.TableName(read-only)] ) can not be edited
whereas the one that do not have that attribute infront of the name I
can edit. Is there a way I can change the read only attribute of a
table so that I can edit data directly in the view pane?
Please let me know if there is !
Thanks a heap ! :)

Harkirat"harry" <i1073@.tamu.edu> wrote in message
news:1105726082.290783.48450@.f14g2000cwb.googlegro ups.com...
> Hi All !
> I open a table in Query Analyzer by right clicking on it and
> selecting 'Open' and when the data is displayed in the view pane I
> would like to be able to edit it. It seems however that tables marked
> as read only (as shown on the top bar e.g. SQL Query Analyzer - [Open
> Table ServerName.DBName.dbo.TableName(read-only)] ) can not be edited
> whereas the one that do not have that attribute infront of the name I
> can edit. Is there a way I can change the read only attribute of a
> table so that I can edit data directly in the view pane?
> Please let me know if there is !
> Thanks a heap ! :)
> Harkirat

I suspect your table has no primary key (which it normally should have) or
unique index. If there's no way to identify each row in the table then you
can't edit it because there's no way to know which row you're changing. You
can still use an UPDATE statement to modify the table data of course.

Simon|||Yesssssssssss !!! That was it !! Sure wouldn't have guessed that
one...:p
Thanks a heap Simon ! :-)

Harkirat

Simon Hayes wrote:
> "harry" <i1073@.tamu.edu> wrote in message
> news:1105726082.290783.48450@.f14g2000cwb.googlegro ups.com...
> > Hi All !
> > I open a table in Query Analyzer by right clicking on it and
> > selecting 'Open' and when the data is displayed in the view pane I
> > would like to be able to edit it. It seems however that tables
marked
> > as read only (as shown on the top bar e.g. SQL Query Analyzer -
[Open
> > Table ServerName.DBName.dbo.TableName(read-only)] ) can not be
edited
> > whereas the one that do not have that attribute infront of the name
I
> > can edit. Is there a way I can change the read only attribute of a
> > table so that I can edit data directly in the view pane?
> > Please let me know if there is !
> > Thanks a heap ! :)
> > Harkirat
> I suspect your table has no primary key (which it normally should
have) or
> unique index. If there's no way to identify each row in the table
then you
> can't edit it because there's no way to know which row you're
changing. You
> can still use an UPDATE statement to modify the table data of course.
> Simon