Just remove the second "w:\dir\" from your command.

A good search term would be "ren command syntax".

John

I use the script below for setting up Database Mail. It's useful if you regularly build new servers or set up Database Mail on existing ones. You should...

m.rajesh.uk (4/25/2013)

---

Hi all.

I found there was fragmentation in my server and i rebuild the indexes to remove fragmentation. But even after rebuilding the...

What happens when you run the SELECT statement from Management Studio?

John

DevDB (4/24/2013)

---

Its running fine for me. It returned 29877 when I added CONVERT(numeric(14,2),Value) > 0 in where Clause.

My machine is

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)...

Here we have an object lesson in why EAV tables are not a good thing. If you can't change the database structure, this should work for you:

SELECT DataId, PathId,...

I suspect this is because it's attempting to do the conversion in the WHERE clause for all values, not just those with PathID 30 and 31.

Try something like this:

WITH MyValues...

Does the same thing happen if you put your hex values in quotes in the first query?

John

The original backup.

John

OK, you should be in business. Back up your transaction log. Restore your full backup (preferably not overwriting the existing database) with no recovery. Restore the log...

You're setting the value of @strFind to a single character, yet you're then testing to see whether that value is in a list that includes strings of more than one...

In the old style syntax, a cross join was denoted by separating the tables to...

I'm sure it is. You'll either have to give db_owner access or speak to the vendor.

John

Thanks for posting back with the solution.

Please do not use the NOLOCK hint unless you completely understand the potential consequences. If in doubt, leave it out.

John

It's probably the application checking that you're a member of the db_owner role before you make the changes. If it allows you to proceed despite the fact you're not...