Viewing 15 posts - 61 through 75 (of 206 total)
<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(8000
October 30, 2006 at 7:28 pm
Another option for you
SELECT SPECIFIC_NAME
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE'
ORDER BY SPECIFIC_NAME
October 30, 2006 at 4:55 pm
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...
October 30, 2006 at 4:41 pm
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.
October 30, 2006 at 4:35 pm
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...
October 30, 2006 at 4:23 pm
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...
October 30, 2006 at 4:16 pm
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...
October 30, 2006 at 4:04 pm
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...
October 26, 2006 at 3:55 pm
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...
October 26, 2006 at 2:28 pm
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...
October 25, 2006 at 8:20 pm
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...
October 25, 2006 at 3:24 pm
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...
October 18, 2006 at 3:04 pm
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...
October 15, 2006 at 3:10 pm
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...
October 15, 2006 at 3:02 pm
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
October 11, 2006 at 10:58 pm
Viewing 15 posts - 61 through 75 (of 206 total)