Good to know that you are preparing yourself for worst database scenarios (DBA’s nightmares :w00t:).

Best of Luck!

When you create an ODBC DSN, you provide all the information required for a connection. You can also test that connection as well.

As it’s a tested DSN (assumed to be)...

Please modify his SP with following (for debugging only)...

PRINT @SSQL -- Debugging

--EXEC (@SSQL) -- Execution

Please post back the result.

Another thought. Just provide the permissions to execute the job to a user and introduce audit/logging steps (may be a log file) in the JOB. This way jobs can be...

SQLRNNR (12/23/2011)

---

Dev (12/23/2011)

---

I just came to know about DBA in Space winner (details here) & his decision. I don’t have any opinion but I would like to share...

SQLRNNR (12/23/2011)

---

Another idea, do you still have the query window open from which you made all of the changes?

Try hitting undo a bunch of times from there until it gets...

I just came to know about DBA in Space winner (details here) & his decision. I don’t have any opinion but I would like to share a dialog snippet from...

Lamprey13 (12/22/2011)

---

Koen Verbeeck (12/22/2011)

---

<snip>

It is perfectly acceptable to have a denormalized database design in a relational database, for example in a data warehouse. SQL still works, and it is still...

Jeff Moden (12/22/2011)

---

Normally when you take on the responsibility of identifying a duplicate post, you also take on the responsibility of a little traffic control....

I am afraid you can’t tune remote queries much (subject to my limited knowledge).

Connect to second server (which you are using as Linked Server) and perform query optimization tricks. At...

Thanks Gus. I knew SQL Server Join syntax (Non ANSI). I was just trying to recollect whether Oracle Syntax was portable to SQL Server (or vice a versa).

Thanks to...

Are you querying to Linked Server tables?

Good. How will you store it, in rows / columns?

If columns? You have to...

Two probable solutions... It's not tested so be extra cautious.

http://social.msdn.microsoft.com/forums/en-US/sqlsmoanddmo/thread/3ba6d023-5899-4c5a-9270-87792840a3ba/

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/c788e276-d9af-411f-9af6-ec6a49e95273/

First of all Drawers, you started it & we enjoyed it. Thank you so much (& apology as well).

Before answering your question, I would like to ask few questions. Please...