Randy,

Your suggestion returns too much. It returns the count (SELECT COUNT(*)) which isn't what the poster requested.

-SQLBill

Frank et al...

I can see I was a bit misunderstood...I think the original poster should be able to mark the post that was helpful/expert in solving their issue. I didn't...

Frank,

You posted this:

As for letting the original poster rate the answer:

I don't want to sound offending, but how should someone with lesser experience judge whether an answer is superior or...

Personal experience.

I have had problems (suspect databases) when SQL Server services were stopped and files moved and then the services restarted.

I have NEVER had problems with detaching the database(s), moving...

I think the points for posts ought to go away.

Look at it this way....everybody posts.

Almost everybody answers the QOD.

Very few people submit FAQs, Scripts, Articles.....

I'm on another site that allows...

I agree it's a serious matter. But think about it....the SQLServerCentral gurus are working extra hard to fix the problems with this site and make it the best possible. Coming...

I can't help with your question, but there's currently another thread concerning Tivoli software and doing backups. I posted a link to your thread on the other one and asked...

The link I posted below is another person having problem with doing backups with Tivoli software. I don't use Tivoli to do backups, but since other posters to this thread...

Francisco,

I'm curious, just what ARE you trying to do?

First you tell us that you don't have room on the server to do a full backup to the hard drives.

Then you...

Plus it got you another 2 points!!!!!!

BTW- I agree with you Frank. The point system can cause an increase in 'worthless' posts. Maybe...

What is TSM?

The only GOOD ways to backup the .mdf and .ldf is to stop the services or detach the database.

The BEST way to backup a database is to use...

How did I keep the nice format? I cheated!!!!!!!!!!!!!!!!!!

I copied the code into Notepad, fixed the format and then copied that into the reply...

For those missing apostrophe's try this:

WHERE pps_cust_po_master.fkey_customer =' + CONVERT(VARCHAR(100),@pkeycustomer)''

-SQLBill

I'm posting your code in hopfully a more readable format....

SET @query1 = ' SELECT pps_products.pkey_product AS [pkey_item],

pps_cust_po_dtl.quantity AS [quantity],

pps_products.product_id AS [product_code],

pps_cust_po_master.pkey_cust_po_master AS [fkey_order],'

SET @query2=' CASE LEN(LEFT(pps_products.comments,1)) WHEN 1 THEN mytemptb.stringval +...

And then there's ones like me who rarely use Enterprise Manager. I do just about everything in Query Analyzer. I'm now trying to make it even more difficult on myself....I'm...