That should be correct.

Grant is correct, you aren't giving enough information. Is there monitoring on the new server for backups? If so, how does that work? Perhaps they are the same.

It doesn't have...

Set the min low, maybe 1024MB (1GB) and then go from there. The max is usually more important.

If this is x86, 32 bit (and I think it is), then you...

Excellent question, Ron. I've used this type of demo in presentations before.

It looks like you have 8GB of RAM in the server and have the min for SQL Server set to 7GB?

I wouldn't set the minimum at all. Leave it...

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...