<P>It may not be the most elegant, but it will work and you can extend your columns as well</P><PRE>

declare

@sql VARCHAR(

Another option for you

SELECT SPECIFIC_NAME 

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_TYPE = 'PROCEDURE'

ORDER BY SPECIFIC_NAME

Apparently, this will disappear if you restart the SQL Agent (not MSSQLSERVER!). The fact that the publication does not exist suggests that you shouldn't see it, but apparently the refresh...

Based on the "play" data you've supplied, can you give an example of expected output? Unfortunately I am unable to grasp what you want from the description alone.

I take it then that you are running this remotely from the server where sqlcmd would be installed by default - presuming that you are running SQL Server 2005.

Not...

One option you have open to you is to create a user defined function and add that as part of a check contraint. Here's an example from BOL that may...

BOL recommends you use SQLCMD instead of OSQL.

I guess it depends what kind of formatting you are after. Looks like SQLCMD has some options available.

Any chance you can output...

Not sure if this is helpful, but, I believe you can only have 2005 as a publisher in this scenario - assuming that you are using 2000 as a publisher...

You probably only needed to add repl_distribution as a login to the SQL Server instance.

Using SSMS (yes, SQL Server Management Studio), just use the object explorer to drill down to...

Sam,

I think what Chris was hinting at was why are you building a dynamic SQL statement and running it, instead of just running the statement "SELECT FullName AS UserFullName FROM...

Have you checked that you can connect to the other server via SSMS? This may give you an indication of where to start looking for the actual problem.

Is there some...

Great article. Having just spent some time working through a posted question with some other SSC members, I could see the guys was struggling with some of the answers and...

Thanks for the pointers David. Yes I did mean "NOT" a hardware issue. But obviously even with a good set of hardware, you still need to ensure your configuration is...

Review the comments I put in after Rudy added his list, then go to BOL (books on line) and look up anything that is not clear to you. Then if...

Does the procedure you are trying to drop already exist?

What does the actual error say?

These things could be helpful indetermining what is actually going wrong