Thank You.

SQl server 2003 64bit, SP2

16 GB RAM

720+ GB Hard Disk

Intel[R] Xeon [TM] MP CPU

Dedicated fot this particular database.

Not virtualised.

Thanks. again

I too doubt it... Checking all those as well. Thank you somuch.

Thanks Santhosh.

Wel, I got the ID from sys.traces and manualy executed it.

Now am able to delete those unwanted file.

Just one more thing, what's the script to "ENABLE FILE ROLLOVER" ?

Yesterday I...

Thanks for quick response. I created a new trace file after adding the commands to close it. Even that file I am not able to delete. Getting the same error....

Hi,

I missed to add those additional lines you mentioned. Hence whatever .trc file created is still there in the folder. Actualy I want to remove those files now. When I...

Thank you somuch. Will try that way.

What do you suggest to pull data from DB's in other servers then.?

Yes, I am able to ping that server.

Thanks.

Thanks !

My current query is as below.

selectC.[SV], AG.[AN], AG.[PV], C.[gid]

fromComp C

joinAgnt AG on AG.gid = C.gid

joinIdnt ID on ID.gid = C.gid

Where1 = 1

andAG.[PV] = '4.6' or AG.[AN]...

Thank you.

Anybody has got any other explanation.?

Thanks.

Craig Farrell (3/18/2011)

---

San, this doesn't make sense from this side. If you're selecting email_1, email_2 ... that sounds like different columns, yet you state it's one column.

can you right-click,...

Thank you very much experts.

So ultimately whats I assumed was right I believe.

Thanks a ton once again.

SQLCHILD (2/11/2011)

---

what are the main purposes for which temporary tables are used?

I want to know the uses of temporary tables in practical and commercial applications i.e. practically in...

So what's happening after updating the statistics..?