Yes, depending on what the procs are doing. If they are joining data across servers, then all bets are off. Even if they are processing data on...

cphite (5/9/2012)

---

Putts (5/9/2012)

---

SQLKnowItAll (5/9/2012)

---

I think the "real" problem here, that you are avoiding, is that the database schema keeps changing. If it was designed properly to begin with, you...

Putts (5/9/2012)

---

That's basically what we're doing. But if we can't rely on all SPs returning all necessary columns then we can't write a singular method that's able to translate...

Putts (5/9/2012)

---

Allow me to rephrase my question to get off the particulars.

We want to create a virtualization within our database to reflect the makeup of a class in code ......

Going to jump in here:

From an architects point of view, I would always create my classes based on the logical design, not views which are abstract. What the OP...

anthony.green (5/8/2012)

---

Not to worry, glad you spotted the mistake.

Just out of noticing your joining syntax, what type of join are you after here as the syntax from table1, table2 denotes...

G-Squared is right. I would NEVER recommend a trigger in this situation for a more insidious reason than mentioned above. Since triggers can be fired simultaneously from multiple...

I have never tried the comma, always seen and used the colon seperator.

mtassin (12/10/2008)

---

From BOL

The Database Engine does not automatically generate values for the column. To insert a globally unique value, create a DEFAULT definition on the column that uses the NEWID...

I selected True and was told I got it wrong. However, if I choose to make a column a GUID column, choose identity and select it to be RowGuidCol,...

Peter Rijs (12/9/2008)

---

Gosta,

I assumed that by installing the Office PIA, you are not installing full-blown excel, but still can use the excel object model and automation.

As the comment about "not...

I have a SQL Server with several MySQL instances as linked servers and I can do all the standard CRUD operations on them without a problem. I would hazard...

ricol (12/5/2008)

---

Sorry, you think all of us are fouls. Might be that some consultants use their small brains. I understand your need of telling what could happen if a technolgy...

For the love of god.. stop showing people crap like this. Someday I will take a consulting job where some vbscripter DBA .NET wannabee has seen and applied this...

When hiring my DBA's, I typically look for those that know where to get the answers, rather than those that think they know the answer.