Make sure your server isn't using a case sensitive collation, if it is, you might want...

Sean Lange (2/24/2014)

---

patrickmcginnis59 10839 (2/24/2014)

---

Sean Lange (2/24/2014)

---

patrickmcginnis59 10839 (2/24/2014)

---

GilaMonster (2/23/2014)

---

Jim Arko (2/23/2014)

---

When using dynamic T-SQL you need to concatenate the variables.

SET @sqlstring = 'UPDATE table SET column = ' +...

dannayakrahul (2/22/2014)

---

Hello,

Thank you for your response i dont know exactly how to develop a query to that problem that is why i have kept the question with some practical data...

Sean Lange (2/24/2014)

---

patrickmcginnis59 10839 (2/24/2014)

---

GilaMonster (2/23/2014)

---

Sure, if you want...

GilaMonster (2/23/2014)

---

Sure, if you want a nice little SQL...

jay-h (2/20/2014)

---

patrickmcginnis59 10839 (2/20/2014)

---

teresalinus (2/20/2014)

---

Let me try to answer your question in a very simple way.Suppose you have an idea, for example a mobile application, which you find worthy and...

teresalinus (2/20/2014)

---

Let me try to answer your question in a very simple way.Suppose you have an idea, for example a mobile application, which you find worthy and therefore you disclosed...

Kumar Arumugam (2/17/2014)

---

Dave-148053 (8/17/2009)

---

LinkedIn was mentioned. Is it worthwhile putting your professional info on LinkedIn? Or will I be setting myself up to receive emails from Nigerian bank...

Craig-315134 (2/12/2014)

---

... out in the real world managers are often rewarded for being politically well-connected.

Sooner or later, the balance sheets catch up with them.

That's one of the more positive...

I like prepaid credit cards for this sort of thing.

Just a possibility, you might want to check to see if your SQL user accounts have a password expiration policy set.

select name, is_policy_checked

from sys.sql_logins

(shamelessly stolen from this thread: http://www.sqlservercentral.com/Forums/Topic397068-338-1.aspx)

edit:...

Something you might consider, make a directory on that share while logged in with that agent userid, then try to backup to a file within that directory.

Sometimes I like to...

As it stands, you are using the minimum price from Vend2Part for ANY partid, not just the one that you're interested in for any given row.

maybe replace

(Select Min(Price) From Vend2Part)

with

(Select...

T_Peters (2/7/2014)

---

Thanks for the replies and suggestions.

I tried changing it to UNC, but the backup still failed. The error messages are slightly different

to disk = 'Z:\backup\...' Operating system error 3(The...

GilaMonster (2/4/2014)

---

Evil Kraig F (2/4/2014)

---

The Oracle mechanism of the physical addressing is a signficant improvement because it removes all translation structures for row recovery from the non-clustered lookup upon finding...