(newbie) copying rows between tables via notepad

Hi
newbie question I'm sure
I have 2 databases on 2 different machines, there is no
connection between the 2. What I need is a way of
extracting particular rows from particular tables and adding them
to another database. The only viable way of doing this is via
email for unimportant reasons.
Via query analyser I can do a select and get the results in
text then manually adjust these back into an insert statement.
There must be a better way but I'm too new to this to know how
Any ideas?

Thanks
Fhttp://vyaskn.tripod.com/code.htm#inserts

--
David Portas
SQL Server MVP
--|||You can use bcp.exe or DTS to export the data to file, then the same
mechanism to import them at the destination - see Books Online for the
details. Or if you want to use INSERTs, then check this out:

http://vyaskn.tripod.com/code.htm#inserts

Simon|||Simon Hayes wrote:
> You can use bcp.exe or DTS to export the data to file, then the same
> mechanism to import them at the destination - see Books Online for
the
> details. Or if you want to use INSERTs, then check this out:
> http://vyaskn.tripod.com/code.htm#inserts
> Simon

Thanks for the reply, this looked like it would have been ideal but
this is the output I get, it gets cut off (column names changed to
protect
the innocent :-))

INSERT INTO [XXXXXXXXXXXXXX]
([XXXXXXXXXXXXX],[XXXXXXXXXXXX],[XXXXXXXXXXXXXXX],[XXXXXXXXXXXXXXXXXXX],[XXXXXXXXXXXXXXXXX],[XXXXXXXXXXXXXX],[XXXXXXXXXXX],[XXXXXXXXXXXXXXXXX],[XXXXXXXXXXXXXXX],[XXXXXXXXXXXXXXXXXXX],[XXXXXXXXXXXXXXXXXX])VALUES('7CC60B79-1B27-4|||(foldface@.yahoo.co.uk) writes:
> Thanks for the reply, this looked like it would have been ideal but
> this is the output I get, it gets cut off (column names changed to
> protect

Sounds like you should go into to Tools->Options->Results and adjust
"Maximum characters per column".

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks for the reply, yes, that was it, it was in the faq for that SP
as well but I assumed it was the SP that wasn't working because I
briefly saw this comment, huge is a relative thing!
Works fine now, very handy

NOTE:This procedure may not work with tables with too many columns.
Results can be unpredictable with huge text columns

(Cluster) Memory settings

Hello, I am purchasing a HP DL-380 (Cluster)
I am planing to install Windows 2003 and SQL 2000
Both machines has two processors and 4 GB o Physical Memory (RAM), but I
want to put 6 GB in the
Active Machine and 2 GB in the Passive Machine.
So, That is possible?
1) Is possible to have differentes memory configuration in a cluster?
2) SQL 2000 and Windows 2003 supports 6GB of Physical Memory?
Thanks a lot!!
AA
I forgot to mention that both machine are with 32 bits processors
Thanks again
AA
"AA" <aa@.personal.net.py> wrote in message
news:%23K0V94MIEHA.2376@.TK2MSFTNGP12.phx.gbl...
> Hello, I am purchasing a HP DL-380 (Cluster)
> I am planing to install Windows 2003 and SQL 2000
> Both machines has two processors and 4 GB o Physical Memory (RAM), but I
> want to put 6 GB in the
> Active Machine and 2 GB in the Passive Machine.
> So, That is possible?
> 1) Is possible to have differentes memory configuration in a cluster?
> 2) SQL 2000 and Windows 2003 supports 6GB of Physical Memory?
>
> Thanks a lot!!
>
> AA
>

(Cluster) Memory settings

Hello, I am purchasing a HP DL-380 (Cluster)
I am planing to install Windows 2003 and SQL 2000
Both machines has two processors and 4 GB o Physical Memory (RAM), but I
want to put 6 GB in the
Active Machine and 2 GB in the Passive Machine.
So, That is possible?
1) Is possible to have differentes memory configuration in a cluster?
2) SQL 2000 and Windows 2003 supports 6GB of Physical Memory?
Thanks a lot!!
AA
Do not do this. Just remember that some day resources from node one with 6GB of memory failover to node 2 with 2GB of memory. What will you do then
rgds
Sinisa Perovic
|||What you will do then is exactly what everyone has to do who is running a
configuration with dissimilar processing capacity. You plan for the case
where both are running on the node with the least power. You estimate the
degradation in performance for the applications based on various load and
time scenarios. You then make a business decision as to whether that
degradation in performance during that specific downtime scenario is
acceptable or not. If it is acceptable, you configure it and off you go.
If it isn't acceptable, you come up with alternatives. Saying to not ever
do this is a very simplistic answer that simply is not correct.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

(BUG?)Some JPEGs not showing correctly in PDF-Export

Hi,

we've some pictures from broken machines, they are taken with a digital camera and should be showed within a report.
But some Pictures don't display correctly:
I want to add this image.
In PreviewMode or if exporting to Tif-Images everything looks fine, but if I export to PDF the Image looks like this (resized, but it also looks so if I don't resize it).

If I open the file in Paint.net and save it again everything is okay.. But its strange for the users that this picture shows up correctly everywhere except the PDF-Export. So they say its a problem of PDF export and not of the image..

Does anybody have a similar issue and a solution for this problem?
It doesn't matter if I retrieve the jpeg from a database or from disk, this problem always occurs.
I tried this with and without SP1-> same problem..

Any help would be appreciated
I found the problem by hex-editing the PDF..
Some picutures ( like the one in the link above) get marked as grayscale though they are RGB!!
If you manually change
/XObject /Subtype /Image /ColorSpace /DeviceGray /BitsPerComponent 8 ....
to
/XObject /Subtype /Image /ColorSpace /DeviceRGB /BitsPerComponent 8 ....
and open the PDF the images are okay!

So, thats the bug, but who can give me a solution?
(Editing the PDF afterwards is no solution ;))
|||I analysed the files, the problem seems to occur if the Huffman table marker (FFC4) Header shows up prior the Start of frame marker (FFC0)!
I don't know if the jpegs aren't "well formed" if huffman table marker comes first but other programs process them correctly..

If I manually move the start of frame marker to some position prior the Huffman table marker the pictures show up correctly (the pdf says /DeviceRGB)..
|||We also have noticed this problem, though I don't know my way around Jpeg files well enough to verify the frame sequencing problem you identified above.

I do not believe that we saw this problem until I applied SQL Server 2005 Service Pack 1 last week.

Do you have the service pack applied?
|||

We are also having the same problem and we do have SP1 installed on SQL 2005. Is there still no fix for this issue ? Please help.

|||I've reported that as Bug, take a look at:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=152109

MS Comment:
This is a duplicate of https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=152109. It has been fixed for the upcoming Service Pack 2.

It's a duplicate of itself;) But they seem to fix it..

(BUG?)Some JPEGs not showing correctly in PDF-Export

Hi,

we've some pictures from broken machines, they are taken with a digital camera and should be showed within a report.
But some Pictures don't display correctly:
I want to add this image.
In PreviewMode or if exporting to Tif-Images everything looks fine, but if I export to PDF the Image looks like this (resized, but it also looks so if I don't resize it).

If I open the file in Paint.net and save it again everything is okay.. But its strange for the users that this picture shows up correctly everywhere except the PDF-Export. So they say its a problem of PDF export and not of the image..

Does anybody have a similar issue and a solution for this problem?
It doesn't matter if I retrieve the jpeg from a database or from disk, this problem always occurs.
I tried this with and without SP1-> same problem..

Any help would be appreciatedI found the problem by hex-editing the PDF..
Some picutures ( like the one in the link above) get marked as grayscale though they are RGB!!
If you manually change
/XObject /Subtype /Image /ColorSpace /DeviceGray /BitsPerComponent 8 ....
to
/XObject /Subtype /Image /ColorSpace /DeviceRGB /BitsPerComponent 8 ....
and open the PDF the images are okay!

So, thats the bug, but who can give me a solution?
(Editing the PDF afterwards is no solution ;))|||I analysed the files, the problem seems to occur if the Huffman table marker (FFC4) Header shows up prior the Start of frame marker (FFC0)!
I don't know if the jpegs aren't "well formed" if huffman table marker comes first but other programs process them correctly..

If I manually move the start of frame marker to some position prior the Huffman table marker the pictures show up correctly (the pdf says /DeviceRGB)..|||We also have noticed this problem, though I don't know my way around Jpeg files well enough to verify the frame sequencing problem you identified above.

I do not believe that we saw this problem until I applied SQL Server 2005 Service Pack 1 last week.

Do you have the service pack applied?|||

We are also having the same problem and we do have SP1 installed on SQL 2005. Is there still no fix for this issue ? Please help.

|||I've reported that as Bug, take a look at:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=152109

MS Comment:
This is a duplicate of

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=152109.

It has been fixed for the upcoming Service Pack 2.

It's a duplicate of itself;) But they seem to fix it..

(BUG?)Some JPEGs not showing correctly in PDF-Export

Hi,

we've some pictures from broken machines, they are taken with a digital camera and should be showed within a report.
But some Pictures don't display correctly:
I want to add this image.
In PreviewMode or if exporting to Tif-Images everything looks fine, but if I export to PDF the Image looks like this (resized, but it also looks so if I don't resize it).

If I open the file in Paint.net and save it again everything is okay.. But its strange for the users that this picture shows up correctly everywhere except the PDF-Export. So they say its a problem of PDF export and not of the image..

Does anybody have a similar issue and a solution for this problem?
It doesn't matter if I retrieve the jpeg from a database or from disk, this problem always occurs.
I tried this with and without SP1-> same problem..

Any help would be appreciatedI found the problem by hex-editing the PDF..
Some picutures ( like the one in the link above) get marked as grayscale though they are RGB!!
If you manually change
/XObject /Subtype /Image /ColorSpace /DeviceGray /BitsPerComponent 8 ....
to
/XObject /Subtype /Image /ColorSpace /DeviceRGB /BitsPerComponent 8 ....
and open the PDF the images are okay!

So, thats the bug, but who can give me a solution?
(Editing the PDF afterwards is no solution ;))|||I analysed the files, the problem seems to occur if the Huffman table marker (FFC4) Header shows up prior the Start of frame marker (FFC0)!
I don't know if the jpegs aren't "well formed" if huffman table marker comes first but other programs process them correctly..

If I manually move the start of frame marker to some position prior the Huffman table marker the pictures show up correctly (the pdf says /DeviceRGB)..|||We also have noticed this problem, though I don't know my way around Jpeg files well enough to verify the frame sequencing problem you identified above.

I do not believe that we saw this problem until I applied SQL Server 2005 Service Pack 1 last week.

Do you have the service pack applied?|||

We are also having the same problem and we do have SP1 installed on SQL 2005. Is there still no fix for this issue ? Please help.

|||I've reported that as Bug, take a look at:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=152109

MS Comment:
This is a duplicate of

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=152109.

It has been fixed for the upcoming Service Pack 2.

It's a duplicate of itself;) But they seem to fix it..sql

(AKU) Running on 64-bit machines

Hi,
We have HP4640 64-bit Itanium machines. Can we run SQL Server Standard
Edition (32-bit) on them? Is that via IA32EL? Is there a performance
degradation with IA32EL?
I believe our only option is to go for 64-bit Enterprise Edition.
Regards
Hi
For SQL Server 2000, 64 on 64. 32 on 64 is not supported.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Yusuf" <Yusuf@.discussions.microsoft.com> wrote in message
news:DDB2DF76-81EB-4A5B-BFC4-051CC274E46A@.microsoft.com...
> Hi,
> We have HP4640 64-bit Itanium machines. Can we run SQL Server Standard
> Edition (32-bit) on them? Is that via IA32EL? Is there a performance
> degradation with IA32EL?
> I believe our only option is to go for 64-bit Enterprise Edition.
> Regards

(AKU) Running on 64-bit machines

Hi,
We have HP4640 64-bit Itanium machines. Can we run SQL Server Standard
Edition (32-bit) on them? Is that via IA32EL? Is there a performance
degradation with IA32EL?
I believe our only option is to go for 64-bit Enterprise Edition.
RegardsHi
For SQL Server 2000, 64 on 64. 32 on 64 is not supported.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Yusuf" <Yusuf@.discussions.microsoft.com> wrote in message
news:DDB2DF76-81EB-4A5B-BFC4-051CC274E46A@.microsoft.com...
> Hi,
> We have HP4640 64-bit Itanium machines. Can we run SQL Server Standard
> Edition (32-bit) on them? Is that via IA32EL? Is there a performance
> degradation with IA32EL?
> I believe our only option is to go for 64-bit Enterprise Edition.
> Regards

(AKU) Running on 64-bit machines

Hi,
We have HP4640 64-bit Itanium machines. Can we run SQL Server Standard
Edition (32-bit) on them? Is that via IA32EL? Is there a performance
degradation with IA32EL?
I believe our only option is to go for 64-bit Enterprise Edition.
RegardsHi
For SQL Server 2000, 64 on 64. 32 on 64 is not supported.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Yusuf" <Yusuf@.discussions.microsoft.com> wrote in message
news:DDB2DF76-81EB-4A5B-BFC4-051CC274E46A@.microsoft.com...
> Hi,
> We have HP4640 64-bit Itanium machines. Can we run SQL Server Standard
> Edition (32-bit) on them? Is that via IA32EL? Is there a performance
> degradation with IA32EL?
> I believe our only option is to go for 64-bit Enterprise Edition.
> Regards