What little you had left?? :hehe::hehe::hehe::hehe::hehe::hehe:

For me, a real scary dba is one who insists on not learning anything new, and continuing to do the same thing day in and day out.

Eirikur Eiriksson (9/8/2014)

---

itsanjayg (9/8/2014)

---

Hello Mr. Steve,

thanks for question.

I tried in SQL2012 and it works fine without any error.

like this....

CREATE SYNONYM Emp FOR Appconfig

SELECT * FROM emp

it will successfully show...

Good stuff from the big 3 already. Here is an article to chew on that elaborates a bit more on the TVF perf problems

http://blog.waynesheffield.com/wayne/archive/2012/02/comparing-inline-and-multistatement-table-valued-functions/

Grant Fritchey (9/4/2014)

---

polkadot (9/4/2014)

---

Thanks Grant.

By extensible I mean, current practices that will allow maximum future flexibility to rearranging server and network infrastructure. For example, in the near future we...

WayneS (9/4/2014)

---

SQLRNNR (9/4/2014)

---

Roy Ernest (9/4/2014)

---

So ANSI Joe is still at it? It has been a very long time since I have been to the forums.

Do we have any new...

The lower privilege user will need permissions to alter the database (mirror and principal). Or they will need to be a member of sysadmin.

+1

Another one is HammerDB

http://hammerora.sourceforge.net/

DrKiller (9/4/2014)

---

I think the explanation need some work.

CTEs doesn't ALWAYS need a semi-colon in front.

This for example works fine:

DECLARE @tmpVariable INT

WITH cte

AS

(

SELECT 1/0 as 'Result'

)

SELECT *

FROM...

Roy Ernest (9/4/2014)

---

So ANSI Joe is still at it? It has been a very long time since I have been to the forums.

Do we have any new ANSI Joe...

silver

Since you already ran reconfigure, you shouldn't need to worry about that message. Think of it as a reminder that is displayed every time you change a config.

Just be...

Eirikur Eiriksson (9/3/2014)

---

Alvin Ramard (9/3/2014)

---

Koen Verbeeck (9/3/2014)

---

xsevensinzx (9/3/2014)

---

I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just...

Or was it wee wee wee all the way home?

You antagonist;-)