Print directly frm PDF format

hi,
is there any ways to print the reports directly frm the web application by
rendering the reports to pdf format?
regards
AngelaThe user will have to export the report to PDF first and then print. There
is no way for Report Manager to automate this.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Angela" <Angela@.discussions.microsoft.com> wrote in message
news:36443488-ED64-4175-87E0-B01DDAD07DF6@.microsoft.com...
> hi,
> is there any ways to print the reports directly frm the web application by
> rendering the reports to pdf format?
> regards
> Angela|||hi,
in that case, there is no other way whereby i can call to print the report
directly from my application? because i have tried rendering my report to
html format and the print result is different from reporting services print.
because the page number is different.And i cant use the method
"&rs:Command=Get&rc:GetImage=8.00.1038.00RSClientPrint.html" because it will
promt the user the option to select printer whereby my user will print multi
reports at a click. so this will result the active x to prompt multi print
dialog.
regards
Angela
"Daniel Reib [MSFT]" wrote:
> The user will have to export the report to PDF first and then print. There
> is no way for Report Manager to automate this.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Angela" <Angela@.discussions.microsoft.com> wrote in message
> news:36443488-ED64-4175-87E0-B01DDAD07DF6@.microsoft.com...
> > hi,
> > is there any ways to print the reports directly frm the web application by
> > rendering the reports to pdf format?
> >
> > regards
> > Angela
>
>|||That is correct. You would need to solve this in your application. Your
app could display EMF rather then HTML and then just print the EMF and the
user would be viewing what they would print, however you would loose
interactivity.
The problem with using HTML is it does not print nicely. This is why we
created the ActiveX control to print reports. The activeX control uses EMF
to print reports. Because this is a different format (different from HTML)
the pages don't always line up. RS does not expose any mechanism for
printing the current HTML page.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Angela" <Angela@.discussions.microsoft.com> wrote in message
news:9E2C9F73-67EF-4D54-B294-61ADBA4A2FA1@.microsoft.com...
> hi,
> in that case, there is no other way whereby i can call to print the report
> directly from my application? because i have tried rendering my report to
> html format and the print result is different from reporting services
> print.
> because the page number is different.And i cant use the method
> "&rs:Command=Get&rc:GetImage=8.00.1038.00RSClientPrint.html" because it
> will
> promt the user the option to select printer whereby my user will print
> multi
> reports at a click. so this will result the active x to prompt multi print
> dialog.
> regards
> Angela
>
> "Daniel Reib [MSFT]" wrote:
>> The user will have to export the report to PDF first and then print.
>> There
>> is no way for Report Manager to automate this.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Angela" <Angela@.discussions.microsoft.com> wrote in message
>> news:36443488-ED64-4175-87E0-B01DDAD07DF6@.microsoft.com...
>> > hi,
>> > is there any ways to print the reports directly frm the web application
>> > by
>> > rendering the reports to pdf format?
>> >
>> > regards
>> > Angela
>>|||hi,
so in that case can i say i jux format my reports to EMF rather den html to
get the issue solve?
or is there an example or smaple for this calling format?
regrads
Angela
"Daniel Reib [MSFT]" wrote:
> That is correct. You would need to solve this in your application. Your
> app could display EMF rather then HTML and then just print the EMF and the
> user would be viewing what they would print, however you would loose
> interactivity.
> The problem with using HTML is it does not print nicely. This is why we
> created the ActiveX control to print reports. The activeX control uses EMF
> to print reports. Because this is a different format (different from HTML)
> the pages don't always line up. RS does not expose any mechanism for
> printing the current HTML page.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Angela" <Angela@.discussions.microsoft.com> wrote in message
> news:9E2C9F73-67EF-4D54-B294-61ADBA4A2FA1@.microsoft.com...
> > hi,
> > in that case, there is no other way whereby i can call to print the report
> > directly from my application? because i have tried rendering my report to
> > html format and the print result is different from reporting services
> > print.
> > because the page number is different.And i cant use the method
> > "&rs:Command=Get&rc:GetImage=8.00.1038.00RSClientPrint.html" because it
> > will
> > promt the user the option to select printer whereby my user will print
> > multi
> > reports at a click. so this will result the active x to prompt multi print
> > dialog.
> >
> > regards
> > Angela
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> The user will have to export the report to PDF first and then print.
> >> There
> >> is no way for Report Manager to automate this.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Angela" <Angela@.discussions.microsoft.com> wrote in message
> >> news:36443488-ED64-4175-87E0-B01DDAD07DF6@.microsoft.com...
> >> > hi,
> >> > is there any ways to print the reports directly frm the web application
> >> > by
> >> > rendering the reports to pdf format?
> >> >
> >> > regards
> >> > Angela
> >>
> >>
> >>
>
>

print directly

--____XFEKHDBDURGVYUDZTEEH____
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
I would like print directly from my vb.net application to default printer = in the client pc.
how can i do it.
thnkas many thanks
_______________________________
* Alberto Garc=EDa S=E1nchez
* Subdirector Inform=E1tica
* Autobar Spain, S.A.
* Email: agarcia@.autobar-spain.com
* Web: www.autobar-spain.com * Telef. +34 916787345 _______________________________
___________________________________________________________________________=
Este mensaje se dirige exclusivamente a su destinatario
y puede contener informaci=F3n privilegiada o confidencial. Si no es vd. = el destinatario
indicado, queda notificado de que la utilizaci=F3n, divulgaci=F3n y/o = copia sin
autorizaci=F3n est=E1 prohibida en virtud de la legislaci=F3n vigente. Si = ha
recibido este mensaje por error, le rogamos que nos lo comunique
inmediatamente por esta misma v=EDa y proceda a su destrucci=F3n.
This message is intended exclusively for its addressee and may contain
information that is CONFIDENTIAL and protected by professional privilege.
If you are not the intended recipient you are hereby notified that any
dissemination, copy or disclosure of this communication is strictly
prohibited by law. If this message has been received in error, please
immediately notify us via e-mail and delete it.
___________________________________________________________________________
--____XFEKHDBDURGVYUDZTEEH____
Content-Type: multipart/related; boundary="____JFEIJVQFKYROWYHWADYT____"
--____JFEIJVQFKYROWYHWADYT____
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
&
I would like print directly from my vb.net application to default = printer in the client pc.

how can i do it.

thnkas many thanks

_______________________________

* Alberto Garc=EDa S=E1nchez* Subdirector Inform=E1tica* = Autobar Spain, S.A.* Email: agarcia@.autobar-spain.com* Web: www.autobar-spain.com * Telef. +34 916787345 = _______________________________

__________________________________________________________________= _________Este mensaje se dirige exclusivamente a su destinatarioy = puede contener informaci=F3n privilegiada o confidencial. Si no es vd. el = destinatarioindicado, queda notificado de que la utilizaci=F3n, = divulgaci=F3n y/o copia sinautorizaci=F3n est=E1 prohibida en virtud = de la legislaci=F3n vigente. Si harecibido este mensaje por error, le = rogamos que nos lo comuniqueinmediatamente por esta misma v=EDa y = proceda a su destrucci=F3n. This message is intended = exclusively for its addressee and may containinformation that is = CONFIDENTIAL and protected by professional privilege.If you are not = the intended recipient you are hereby notified that anydissemination, = copy or disclosure of this communication is strictlyprohibited by law. = If this message has been received in error, pleaseimmediately notify = us via e-mail and delete it.___________________________________________= ________________________________
--____JFEIJVQFKYROWYHWADYT____--
--____XFEKHDBDURGVYUDZTEEH____--This is a multi-part message in MIME format.
--=_NextPart_000_0985_01C5420A.07D28330
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
There is a printer extension example delivered within the samples of the =Reporting Service SDK, perhaps yo may have a look in here.
HTH, Jens S=FC=DFmeyer
--
http://www.sqlserver2005.de
--
<alf> schrieb im Newsbeitrag =news:ulGhNifQFHA.3888@.TK2MSFTNGP10.phx.gbl...
I would like print directly from my vb.net application to default =printer in the client pc.
how can i do it.
thnkas many thanks
_______________________________
* Alberto Garc=EDa S=E1nchez
* Subdirector Inform=E1tica
* Autobar Spain, S.A.
* Email: agarcia@.autobar-spain.com
* Web: www.autobar-spain.com * Telef. +34 916787345 _______________________________
=_________________________________________________________________________=__
Este mensaje se dirige exclusivamente a su destinatario
y puede contener informaci=F3n privilegiada o confidencial. Si no es =vd. el destinatario
indicado, queda notificado de que la utilizaci=F3n, divulgaci=F3n y/o =copia sin
autorizaci=F3n est=E1 prohibida en virtud de la legislaci=F3n vigente. =Si ha
recibido este mensaje por error, le rogamos que nos lo comunique
inmediatamente por esta misma v=EDa y proceda a su destrucci=F3n.
This message is intended exclusively for its addressee and may contain
information that is CONFIDENTIAL and protected by professional =privilege.
If you are not the intended recipient you are hereby notified that any
dissemination, copy or disclosure of this communication is strictly
prohibited by law. If this message has been received in error, please
immediately notify us via e-mail and delete it.
=_________________________________________________________________________=__
--=_NextPart_000_0985_01C5420A.07D28330
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

There is a printer extension example delivered =within the samples of the Reporting Service SDK, perhaps yo may have a look in here.
HTH, Jens S=FC=DFmeyer
http://www.sqlserver2005.de
--
schrieb im Newsbeitrag news:ulGhNifQFHA.3888=@.TK2MSFTNGP10.phx.gbl...
I would like print directly from my vb.net application to default =printer in the client pc.

how can i do it.

thnkas many thanks

_______________________________

* Alberto Garc=EDa S=E1nchez* Subdirector Inform=E1tica* =Autobar Spain, S.A.* Email: agarcia@.autobar-spain.com* Web: http://www.autobar-spain.com">www.autobar-spain.com * Telef. +34 916787345 _______________________________

=________________________________________________________________=___________Este mensaje se dirige exclusivamente a su destinatarioy puede contener = informaci=F3n privilegiada o confidencial. Si no es vd. el destinatarioindicado, queda notificado de que la utilizaci=F3n, =divulgaci=F3n y/o copia sinautorizaci=F3n est=E1 prohibida en virtud de la =legislaci=F3n vigente. Si harecibido este mensaje por error, le rogamos que nos =lo comuniqueinmediatamente por esta misma v=EDa y proceda a su destrucci=F3n. This message is intended exclusively for =its addressee and may containinformation that is CONFIDENTIAL and =protected by professional privilege.If you are not the intended recipient you =are hereby notified that anydissemination, copy or disclosure of this communication is strictlyprohibited by law. If this message has =been received in error, pleaseimmediately notify us via e-mail and =delete =it.__________________________________________________________________=_________

---

--=_NextPart_000_0985_01C5420A.07D28330--|||This is a multi-part message in MIME format.
--=_NextPart_000_0121_01C541D4.7DE6D840
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
If you are using URL integration then the new client side printing with =the next service pack (hopefully imminent) might do the trick for you.
-- Bruce Loehle-Conger MVP SQL Server Reporting Services
<alf> wrote in message news:ulGhNifQFHA.3888@.TK2MSFTNGP10.phx.gbl...
I would like print directly from my vb.net application to default =printer in the client pc.
how can i do it.
thnkas many thanks
_______________________________
* Alberto Garc=EDa S=E1nchez
* Subdirector Inform=E1tica
* Autobar Spain, S.A.
* Email: agarcia@.autobar-spain.com
* Web: www.autobar-spain.com * Telef. +34 916787345 _______________________________
=_________________________________________________________________________=__
Este mensaje se dirige exclusivamente a su destinatario
y puede contener informaci=F3n privilegiada o confidencial. Si no es =vd. el destinatario
indicado, queda notificado de que la utilizaci=F3n, divulgaci=F3n y/o =copia sin
autorizaci=F3n est=E1 prohibida en virtud de la legislaci=F3n vigente. =Si ha
recibido este mensaje por error, le rogamos que nos lo comunique
inmediatamente por esta misma v=EDa y proceda a su destrucci=F3n.
This message is intended exclusively for its addressee and may contain
information that is CONFIDENTIAL and protected by professional =privilege.
If you are not the intended recipient you are hereby notified that any
dissemination, copy or disclosure of this communication is strictly
prohibited by law. If this message has been received in error, please
immediately notify us via e-mail and delete it.
=_________________________________________________________________________=__
--=_NextPart_000_0121_01C541D4.7DE6D840
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

If you are using URL integration then the new =client side printing with the next service pack (hopefully imminent) might do the =trick for you.
-- Bruce Loehle-Conger MVP SQL =Server Reporting Services
wrote in message news:ulGhNifQFHA.3888=@.TK2MSFTNGP10.phx.gbl...
I would like print directly from my vb.net application to default =printer in the client pc.

how can i do it.

thnkas many thanks

_______________________________

* Alberto Garc=EDa S=E1nchez* Subdirector Inform=E1tica* =Autobar Spain, S.A.* Email: agarcia@.autobar-spain.com* Web: http://www.autobar-spain.com">www.autobar-spain.com * Telef. +34 916787345 _______________________________

=________________________________________________________________=___________Este mensaje se dirige exclusivamente a su destinatarioy puede contener = informaci=F3n privilegiada o confidencial. Si no es vd. el destinatarioindicado, queda notificado de que la utilizaci=F3n, =divulgaci=F3n y/o copia sinautorizaci=F3n est=E1 prohibida en virtud de la =legislaci=F3n vigente. Si harecibido este mensaje por error, le rogamos que nos =lo comuniqueinmediatamente por esta misma v=EDa y proceda a su destrucci=F3n. This message is intended exclusively for =its addressee and may containinformation that is CONFIDENTIAL and =protected by professional privilege.If you are not the intended recipient you =are hereby notified that anydissemination, copy or disclosure of this communication is strictlyprohibited by law. If this message has =been received in error, pleaseimmediately notify us via e-mail and =delete =it.__________________________________________________________________=_________

---

--=_NextPart_000_0121_01C541D4.7DE6D840--|||This is a multi-part message in MIME format.
--=_NextPart_000_000D_01C541C4.983E43A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
http://blogs.msdn.com/bryanke/articles/71491.aspx
<alf> wrote in message news:ulGhNifQFHA.3888@.TK2MSFTNGP10.phx.gbl...
I would like print directly from my vb.net application to default =printer in the client pc.
how can i do it.
thnkas many thanks
_______________________________
* Alberto Garc=EDa S=E1nchez
* Subdirector Inform=E1tica
* Autobar Spain, S.A.
* Email: agarcia@.autobar-spain.com
* Web: www.autobar-spain.com * Telef. +34 916787345 _______________________________
=_________________________________________________________________________=__
Este mensaje se dirige exclusivamente a su destinatario
y puede contener informaci=F3n privilegiada o confidencial. Si no es =vd. el destinatario
indicado, queda notificado de que la utilizaci=F3n, divulgaci=F3n y/o =copia sin
autorizaci=F3n est=E1 prohibida en virtud de la legislaci=F3n vigente. =Si ha
recibido este mensaje por error, le rogamos que nos lo comunique
inmediatamente por esta misma v=EDa y proceda a su destrucci=F3n.
This message is intended exclusively for its addressee and may contain
information that is CONFIDENTIAL and protected by professional =privilege.
If you are not the intended recipient you are hereby notified that any
dissemination, copy or disclosure of this communication is strictly
prohibited by law. If this message has been received in error, please
immediately notify us via e-mail and delete it.
=_________________________________________________________________________=__
--=_NextPart_000_000D_01C541C4.983E43A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

http://blogs.msdn.com/bryanke/articles/71491.aspx">http://blogs.m=sdn.com/bryanke/articles/71491.aspx
wrote in message news:ulGhNifQFHA.3888=@.TK2MSFTNGP10.phx.gbl...
I would like print directly from my vb.net application to default =printer in the client pc.

how can i do it.

thnkas many thanks

_______________________________

* Alberto Garc=EDa S=E1nchez* Subdirector Inform=E1tica* =Autobar Spain, S.A.* Email: agarcia@.autobar-spain.com* Web: http://www.autobar-spain.com">www.autobar-spain.com * Telef. +34 916787345 _______________________________

=________________________________________________________________=___________Este mensaje se dirige exclusivamente a su destinatarioy puede contener = informaci=F3n privilegiada o confidencial. Si no es vd. el destinatarioindicado, queda notificado de que la utilizaci=F3n, =divulgaci=F3n y/o copia sinautorizaci=F3n est=E1 prohibida en virtud de la =legislaci=F3n vigente. Si harecibido este mensaje por error, le rogamos que nos =lo comuniqueinmediatamente por esta misma v=EDa y proceda a su destrucci=F3n. This message is intended exclusively for =its addressee and may containinformation that is CONFIDENTIAL and =protected by professional privilege.If you are not the intended recipient you =are hereby notified that anydissemination, copy or disclosure of this communication is strictlyprohibited by law. If this message has =been received in error, pleaseimmediately notify us via e-mail and =delete =it.__________________________________________________________________=_________

---

--=_NextPart_000_000D_01C541C4.983E43A0--

Print Control

Hi guys
The Print control - printing directly from the Report Manager - have a
default setting. Is there a way to change this default setting'
Our problem is that the default is 5*8 letter format whereas here we use A4
format. Preferable it would pickup the report format in regards to portrait
or landscape.
Thanks.
Regards
JonasIt should pick this up. Check and see what your page layout size is.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jonas Larsen" <JonasLarsen@.discussions.microsoft.com> wrote in message
news:CB2C2B3D-CAD3-4565-AB2F-8E134D8D0243@.microsoft.com...
> Hi guys
> The Print control - printing directly from the Report Manager - have a
> default setting. Is there a way to change this default setting'
> Our problem is that the default is 5*8 letter format whereas here we use
> A4
> format. Preferable it would pickup the report format in regards to
> portrait
> or landscape.
> Thanks.
> Regards
> Jonas|||I have a report that have this:
<PageHeight>29.7cm</PageHeight>
<PageWidth>42cm</PageWidth>
Which matches A3 landscape but ends up as 8,5 by 11". This report does have
page header and footer does that matter?
I must admit that it does pickup A3 & A4 formats on some other reports.
Thanks.
Regards
Jonas
"Bruce L-C [MVP]" wrote:
> It should pick this up. Check and see what your page layout size is.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jonas Larsen" <JonasLarsen@.discussions.microsoft.com> wrote in message
> news:CB2C2B3D-CAD3-4565-AB2F-8E134D8D0243@.microsoft.com...
> > Hi guys
> >
> > The Print control - printing directly from the Report Manager - have a
> > default setting. Is there a way to change this default setting'
> >
> > Our problem is that the default is 5*8 letter format whereas here we use
> > A4
> > format. Preferable it would pickup the report format in regards to
> > portrait
> > or landscape.
> >
> > Thanks.
> >
> > Regards
> > Jonas
>
>|||Weird, it picks it up for some but not all. All I can suggest is to see if
there is anything different between the reports that work and those that
doesn't.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jonas Larsen" <JonasLarsen@.discussions.microsoft.com> wrote in message
news:33FEE50C-2C84-41D9-A23E-998C30BCDB10@.microsoft.com...
>I have a report that have this:
> <PageHeight>29.7cm</PageHeight>
> <PageWidth>42cm</PageWidth>
> Which matches A3 landscape but ends up as 8,5 by 11". This report does
> have
> page header and footer does that matter?
> I must admit that it does pickup A3 & A4 formats on some other reports.
> Thanks.
> Regards
> Jonas
> "Bruce L-C [MVP]" wrote:
>> It should pick this up. Check and see what your page layout size is.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Jonas Larsen" <JonasLarsen@.discussions.microsoft.com> wrote in message
>> news:CB2C2B3D-CAD3-4565-AB2F-8E134D8D0243@.microsoft.com...
>> > Hi guys
>> >
>> > The Print control - printing directly from the Report Manager - have a
>> > default setting. Is there a way to change this default setting'
>> >
>> > Our problem is that the default is 5*8 letter format whereas here we
>> > use
>> > A4
>> > format. Preferable it would pickup the report format in regards to
>> > portrait
>> > or landscape.
>> >
>> > Thanks.
>> >
>> > Regards
>> > Jonas
>>

Primary key and identity fields information got lost by "Import Da

Hi all!
I want to import data from Sql Server 2000 into Sql Server 2005.
When i select "Import Data" in 2005 and import tables directly from the 2000
Data Source, the primary keys and the identity fields information is lost in
2005.
Who knows why?
Best regards
Ulrich Schumacher
urlich
How about BACKUP /RESTORE commands
Or you can create a linked server to SQL Server 2000 and run SELECT * INTO
Schema.Mytable FROM SQL2K.Database.DBO.Table it ON SQL Server 2005
"ulrich schumacher" <ulrichschumacher@.discussions.microsoft.com> wrote in
message news:D20F7B7B-5C85-441B-AFE5-14191B3DF6CA@.microsoft.com...
> Hi all!
> I want to import data from Sql Server 2000 into Sql Server 2005.
> When i select "Import Data" in 2005 and import tables directly from the
> 2000
> Data Source, the primary keys and the identity fields information is lost
> in
> 2005.
> Who knows why?
> Best regards
> Ulrich Schumacher
>

Primary key and identity fields information got lost by "Import Da

Hi all!
I want to import data from Sql Server 2000 into Sql Server 2005.
When i select "Import Data" in 2005 and import tables directly from the 2000
Data Source, the primary keys and the identity fields information is lost in
2005.
Who knows why?
Best regards
Ulrich Schumacherurlich
How about BACKUP /RESTORE commands
Or you can create a linked server to SQL Server 2000 and run SELECT * INTO
Schema.Mytable FROM SQL2K.Database.DBO.Table it ON SQL Server 2005
"ulrich schumacher" <ulrichschumacher@.discussions.microsoft.com> wrote in
message news:D20F7B7B-5C85-441B-AFE5-14191B3DF6CA@.microsoft.com...
> Hi all!
> I want to import data from Sql Server 2000 into Sql Server 2005.
> When i select "Import Data" in 2005 and import tables directly from the
> 2000
> Data Source, the primary keys and the identity fields information is lost
> in
> 2005.
> Who knows why?
> Best regards
> Ulrich Schumacher
>

Primary key and identity fields information got lost by "Import Da

Hi all!
I want to import data from Sql Server 2000 into Sql Server 2005.
When i select "Import Data" in 2005 and import tables directly from the 2000
Data Source, the primary keys and the identity fields information is lost in
2005.
Who knows why?
Best regards
Ulrich Schumacherurlich
How about BACKUP /RESTORE commands
Or you can create a linked server to SQL Server 2000 and run SELECT * INTO
Schema.Mytable FROM SQL2K.Database.DBO.Table it ON SQL Server 2005
"ulrich schumacher" <ulrichschumacher@.discussions.microsoft.com> wrote in
message news:D20F7B7B-5C85-441B-AFE5-14191B3DF6CA@.microsoft.com...
> Hi all!
> I want to import data from Sql Server 2000 into Sql Server 2005.
> When i select "Import Data" in 2005 and import tables directly from the
> 2000
> Data Source, the primary keys and the identity fields information is lost
> in
> 2005.
> Who knows why?
> Best regards
> Ulrich Schumacher
>