Forum Replies Created

Viewing 15 posts - 31 through 45 (of 67 total)

  • RE: The case for Remote Access

    Steve,

    Currently, I am working within my limits.  However, the need to perform basic tasks like restoring backups on other machines is taking way to long (determine which backup to restore,...

  • RE: Initializing replication

    Perhaps a move from the general to the specific......

    I have a merge replication setup between two servers.....For reasons that I cannot explain (as in, huh...what happend?!?) the merge agent no longer...

  • RE: Using xp_cmdshell

    that's not it.  The problem seems to be that although SQL Server is running under my ID, it doesn't have quite the same credentials that I have running in the...

  • RE: How do you spell S-Q-L?

    I have a similar list of basic questions I ask DBA candidates and am often surprised at the discrepancy between stated experience level and the answers given.  Even worse is...

  • RE: Dynamic Parameters for Stored Procedures

    Thought I had an example at hand, but can't put my finger on it at the moment.  However, the basic technique is as follows:

    If I need to send in a...

  • RE: having SQLH2 report problems

    The error results from not having Admin access to the specified server.  The SQLH2.exe will attemp to read the registry of all specified servers.  If the ID of the SQLH2.exe...

  • RE: Customizing Look and Feel of reporting manager

    This site has a brief tutorial on creating a basic customized report manager

    http://odetocode.com/Articles/95.aspx

  • RE: Windows Authentication problem

    I found the source of the problem.  The Report Manager pages were accessing other directories that the users did not have rights to.  Giving the users rights to there directories...

  • RE: Dynamic Parameters for Stored Procedures

    Another possibility would be to have a single parameter that is a large varchar field.  You could then send in parameters as a string composed of name/value pairs ( or...

  • RE: Schema Changes - Merge Replication

    Govind,

    I have encountered this issue many times and unfortunately, there is no easy solution.  The options availabe are limited:

    1.  Use sp_repladdcolumn and sp_repldropcolumn going through the tedious drop/add trick.  An...

  • RE: Accessing Novell Servers

    Running the dir command from a Window's command shell using either the UNC pathname to the Novell box or the map drive letter works fine on my current XP box.  Running...

  • RE: Accessing Novell Servers

    Running the dir command from a Window's command shell using either the UNC pathname to the Novell box or the map drive letter works fine on my current XP box.  Running...

  • RE: Accessing Novell Servers

    Running the dir command from a Window's command shell using either the UNC pathname to the Novell box or the map drive letter works fine on my current XP box.  Running...

  • RE: Accessing Novell Servers

    Running the dir command from a Window's command shell using either the UNC pathname to the Novell box or the map drive letter works fine on my current XP box.  Running...

  • RE: Accessing Novell Servers

    Running the dir command from a Window's command shell using either the UNC pathname to the Novell box or the map drive letter works fine on my current XP box.  Running...

Viewing 15 posts - 31 through 45 (of 67 total)