Not only that, but if the DBA actually DOES learn the system well, is he then not allowed to be DBA anymore? 

That sort of thinking is screwed, and not standard...

As an aside, this is a good reason why your applicate shouldn't access tables directly.  In this case, you would only have to change the procs (which you would still...

Kevin,

The code you posted compiled and executed just fine for me.  If I try to run the estimated execution plan I get the "Invalid object name '#output'." error.

In this case,...

Man, this article does not go into any depth.  Your example proc has capitals in it, which Microsoft specifically says not to do.  The script for a system proc should...

Yeah, you should use DTS, that's going to be the fastest.  Simply set up your SQL db as one data source and your access db as the other.  Use a...

Oops!  wrong forum post.  I was on the same track you guys were, though...so that's good

if you look at sp_job_help, it's a wrapper proc for "sp_get_composite_job_info".  If you are not using any parameters there is no danger in executing sp_get_composite_job_info directly.  Much faster, too.

Also, if...

A variation on above sysindex posts:

Select  so.name, sc.rowcnt as RowsInTable

From sysobjects so (nolock)

JOIN sysindexes sc (nolock) on so.id = sc.id

WHERE  sc.indid < 2

order by RowsInTable desc

I have found this to be...

Here's a simpler example:

if object_ID('tempdb..#Test') is not null drop table #Test

Create Table #Test

 ([id] [char] (22) ,

  [ques_name] [varchar] (50) ,

  [ques_val] [varchar] (100) )

Insert #Test Values ('1','date','10/14/2004')

Insert #Test Values ('1','country','usa')

Insert #Test...

Or, if you want the columns to be dynamic based on distinct values in ques_name:

----------------------------------------------------------------

if object_ID('tempdb..#Test') is not null drop table #Test

Create Table #Test

 ([id] [char] (22) ,

  [ques_name] [varchar] (50)...

Very thorough data...the first one one this site that I would say is almost too thorough.  Very very nice...

Abstracting it out, the key is:

Create a temp table (#Event in the...

Something like below:

From T1 (nolock)

JOIN T2 (nolock) on cast(T1.ID as char(10)) = cast(T2.ID as char(10))

I can't really help you more without the actual data types and some sample data.

Commonly, the way to do this is to put the connection string in a separate dbConnection class.  If the connection string changes then only this class must be re-compiled, not...

Steve,

Very cool!  Thumbs up for obscure but useful ASCII knowledge.

cl

Ducati,

That's what we're saying...that parsing the xls formulas is extremely hard, for exactly the questions you are asking, namely nesting and text delimiters.  There has got to be a better...