Duplicate post. Please reply here

For data integrity issues it is much better to explicitly define the column(s) and foreign key(s).

In the scenario you mention you would have enforce RI using triggers which is much...

1. Yes, to the best of my knowledge you would need to develop a CLR function in C# or VB.

2. Yes, although you would want a function not...

katesl (2/5/2009)

---

Now, can you explain those windows? What is wrong with them? Does the author of an article know the code is going to display inside a...

Nah, only 24 hours between posts. We just haven't hit another question to go off on. Although there was one today where the OP finally posted DDL and...

I'm going to jump in here and say "Thanks for writing the article". It takes some guts to put your code out there on a site like this because...

Yeah, I actually know just about that much ORACLE which is...

Lynn Pettis (2/4/2009)

---

Jack Corbett (2/4/2009)

---

Try again. The DDL you posted is not for SQL Server as it uses the VARCHAR2 data type which does not exist in SQL Server....

Try again. The DDL you posted is not for SQL Server as it uses the VARCHAR2 data type which does not exist in SQL Server. I believe the...

Lynn Pettis (2/4/2009)

---

Based on your last comment, local temporary tables may not work. They are only good for the current session, and if the table name is being passed...

Great, glad I could help.

I kind of held back on this question, but I have to ask since your developers are doing it.

Why are they using...

Yes Synonyms are probably the best option. A Synonym is basically just an alias for or a pointer to another object.

Think about it like a nickname. A person may...

I think the SYNONYM is really the way to go. The number of the rows in the table won't affect the usefulness of the SYNONYM.

I would not...

Something like this would work, but there may be a better solution:

;WITH cteAgents AS

(

SELECT

ROW_NUMBER() OVER (PARTITION BY agentid ORDER BY agentid) AS row_id,

agentid,

AcctNo

FROM

dbo.calls

)

SELECT

*

FROM

cteAgents

WHERE

row_id <= 5

MY guess is the operator for the Job does not have rights to the folder or folders being accessed. Sounds like you may need to lookup PROXY Accounts in...