Home Forums SQL Server 2005 Administering 'DBCC' is not recognized as an internal or external command RE: 'DBCC' is not recognized as an internal or external command

  • Yes, the server should be set to allow remote connections. The -E will work if the id of the login you are running is set up as a windows authenticated login inside the server. You need the -U and -P if the id you are using to run the .bat file is set up as a SQL authenticated id inside the server. If neither is true, you need to have your DBA set up the id as one or the other before you can actually make the connection.


    And then again, I might be wrong ...
    David Webb