AFAIK, if you assign these to the same value, you can only store decimals. The scale (2nd param) is allowing for that many decimal points to the right, which means...

Not in SQL Server, but I have used these in DB2 and they were very handy for processing things like end of month loads. We had a host hypervisor that...

So the hint is being submitted in the T-SQL?

I'm not sure you can override this without removing the hint from the code. I believe the hints in the query are...

How to: Debug T-SQL Using the SQL Server Management Studio - http://msdn.microsoft.com/en-us/library/ms241871%28v=VS.80%29.aspx

I know this is late, but you could pass the location to the client program, but it's strictly the client program that would have to find that point in the...

SQLJocky (8/9/2011)

---

Steve Jones - SSC Editor (8/9/2011)

---

There is a default mapping, which makes the linked server a public object, but if you say that Joe in SQL Server is mapped...

@SQLFRNDZ (8/9/2011)

---

Might be I'm understanding wrong but

You can have the Oracle Login on local...

Haven't seen/heard of this. Can you create a new plan?

We do not have one this year. We could not work out an acceptable deal with PASS.

Most chapters (user groups) have a code that can be used for a $100...

You can't put an Oracle login on the local side because that isn't authenticated or recognized in SQL Server. You should be able to specify that certain logins to SQL...

Revenant (8/9/2011)

---

Ross McMicken (8/9/2011)

---

Security has to become an integral part of the corporate culture. A good way to jump start that is to implement policies around applications and security that...

weldredge (8/9/2011)

---

Hi Steve, we met briefly at SQL Saturday, and I am really glad to hear that someone as successful as yourself does nto define thier job as thier passion....

It is in dependent of location and you bring up good points, majorbloodnock. However using foreign firms v domestic ones can make a difference. Ultimately if there is a domestic...

What does "decommission" mean? there is no feature in SQL Server to do this, so if you perhaps just removed or set the databases to offline, then you might be...

No, the changing of the location during attach or restore shouldn't affect that.