Take a look at syscomments in the master database.

Steve

You can't actually remove it, but for presentation purposes, see "cast and convert" in Books Online.

Steve

Joseph,

I thought about that too.  In fact, I've done it more than once.  I wasn't sure that it would work in this situation though, because the procedure is part of replication. ...

I'm sure you'll get more and perhaps better ideas, but here are a couple.

To get the last sproc to output to a flat file, you can use xp_cmdshell and OSQL.

Another...

Let me start by saying that it is seriously ill-advised to modify system stored procedures.  And I'm not very familiar with replication, so I don't know what the possible impacts...

Well, I've got a loong ways to go before getting to a thousand posts, but I've been thinking about it.  It'll have to be a new picture though, the only...

HMM, mine didn't have a heater at all!  And being a convertible, it was rather drafty.  I'm also in the midwest (central Oklahoma), and yes, winter was quite cold in...

Yeah, it really didn't take too much pressure to get Frank to comply!!!

Steve

You couldn't have picked a worse time to try to travel inexpensively!!!  Sorry, can't help you there except to suggest driving a ... ahem... VW.

Mine was a "baja bug" convertible...

If you don't have a lot of users, it may be easier to just do it manually, although your database users will be orphaned and will need to be fixed using sp_change_users_login. ...

Well, I was about to post that Mr. Wynkoop's picture is on the start page of SSWUG, but I see that he has moved it to the "About SSWUG" page. ...

Hey Frank,

Which is the real you, the grinning shark or the silhouette with a question mark shaped nose???  (I'm glad I got a long ways to go

You don't need to compare old to new.  If you originally loaded variables with the values from the table, and then change those variables, all you need to do is update...

From a slightly different point of view...

If you are taking daily full backups, and hourly differentials, may I assume that your application is transactional?  You may be better off setting...

Oh, man!!! So much for my "youthful facade"! 

In 1977, at 18 years old, I was tearing up the streets in my hopped up VW, chasing wine (well, beer), women,...