you are right this is a pain. in the end i just gave up on the printing and use qp on the sceen.

this is surely for ms to fix, i...

your best bet could be in the transaction log.

query analyser is not that forgiving

no i don't think that is the problem.

check your timeout limit.

i would suggest you use oledb provider for sql, which ms touts as being optimised for sql server, instead of...

Instead of email why not just put the [enter problem] page on the website, since you said it is online. and have that page insert into the database.

it seems like...

do you want to use the result in a front end application. your request is not clear on that end.

or just go onto enterprise manager.right click on the actual database you want to move, goto all tasks -> Detach Database

when you have moved it, right click on the databases...

most likely a time out issue

i believe ms has not given us that capability for the moment.

quick solution is to create a front end page in aspx and then dynamically create the rs url for...

i tried the following

select CAST(CAST(notes AS varbinary(8000)) AS VARCHAR(8000)) from timage

first convert to varbinary and then to varchar, probably it will truncate some of the notes[VERIFY].

for the solution...

i tried recreating your problem but did not get the error.[maybe if your post the exact steps you are taking and especially the variables you are inputing i can see...

just create a stored proc that does the job and include it in your dts package.

create proc cp_transferData

as

insert into database1..table10

select a.email,a.address

from database1..table1 a inner join

database2..table3 b on a.id = b.id

you...

i don't know of any but try googling

I have never had problems with this website since i joined. i had blogged it as a good site, but obviously due to my questionable writing and orating skills i...

maybe the files are corrupt. but since you were using disk mirroring you should be able to get your data from the mirror.

i think if you remove the network library it should work.