I second your thoughts. Correct way is to get permissions and I have already asked for that.

MysteryJimbo (10/1/2012)

---

You could create a SQL Account with sysadmin permissions and use this to...

Exactly what I did, but the copy permission was not there 🙂

SpringTownDBA (10/1/2012)

---

Sql server should have permissions to copy the file, so xp_cmdshell.

My approach for moving databases:

1. Alter DB set...

Well one reason is tha tI don't want users to enter any data in this database while I am moving it. I know there are other ways to achive it...

we just want to shift files from one drive to another with larger space. So attach/ detach looks simpler...

Jason-299789 (9/28/2012)

---

I would speak to the network admin about obtaining rights as...

Thats a nice explanation. I got your point Gail. Thank you...

GilaMonster (9/24/2012)

---

Add OR nm IS NULL

Null never matches any value, so you cannot have null returned from a in or...

May be it's difference of perception but to me it looks illogical. I am asking just remove those records which are there in NOT IN, and i didn't mention NULL,...

This was a good point Paul.

thanks Chris,I'll look into it myself.

But the results of this and previous query doesn't match. Seems ordering on different column changed the results.

Thanks so much for your thoughts. I'll give it a try.

Just an addition that i will have to remove top, left joins etc to make an indexed view here.

Thanks for guidance Gail.

So I I direct output to a file, will it write complete message? Ok, let me try it.

opc.three (6/26/2012)

---

The messages logged by SQL Agent are limited, and formatting is removed...

This actually gives the same text as you get thru GUI and again it won't be complete

440692 I am just a number (6/26/2012)

---

You may be able to get some additional...

Sorry, I missed to see that you used CTE inside the query to make it nested.

Thanks

SQLKnowItAll (6/19/2012)

---

Here is the proc:

USE test

GO

CREATE TABLE tab1 (id int,oldId int, InsertedOn datetime)

insert into tab1...