I agree..

Notice this will also give 2 points

Sorry, what about exec msdb..sp_help_jobhistory?

This s_proc is documented in BOL along with the description of the system table sysjobhistory. INformation on the table you'll find under jobs -> information stored...

Take a look at READTEXT in BOL, although I doubt this will get you much further.

There is no *text* variable in T-SQL. Your best bet is varchar(8000). I guess your...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=6&messageid=103131 offers some workarounds

Sorry Frank, didn't know you were here today

Now, that's a cheap excuse! Whereelse should I be?

Hey, finally a question I could correctly answer

Hans, one method that almost always works, is to make the changes in EM and then...

Please do not cross post. Let's use the thread here

I guess both are the same version and the same type (mdb or mde?)

Hey, what a shame for me! Too late...

For those that don't like the "quality" of the questions [and OK, the answers too] - try sending your own in

I know I did once and got hammered...

No, not me! But I know a friend who knows someone who has heard, that there might be some people...

Actually I only thought about why always reinvent the wheel when...

Discover the script section here. There are several scripts for finding duplicates.

A *virtual friend* of mine has written a nice article on arrays and lists in SQL Server. Might it is of some help for you

http://www.sommarskog.se/arrays-in-sql.html

Although I don't know of such a command line tool, I bet you'll find several scripts in the script section. So I would search the site.

Don't get too soon too...

Obsolete is quite ok with me