That would indicate that you used the name of the batch file with the -i parameter rather than the name of the file that had the 2 DBCC commands in...

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...

No, the .bat file should only have the SQLCMD line in it. The actual DBCC commands should be in another file indicated by the -i filename on the SQLCMD...

SQL Server is a service that runs like any other service under the OS. In order to issue commands or SQL statements to the server, you have to connect...

Look up SQLCMD, a utility that can run as a DOS command and read your script as input, connect to the SQL Server and execute your script.

Here's a link:

http://msdn.microsoft.com/en-us/library/ms162773.aspx

How are you executing this? DBCC is a command that SQL Server recognizes but the OS does not. You need to execute the DBCCs like you would execute...

OK, that's a puzzler. I'm assuming that the log backup is in a script or a maintenance plan. What else is this process tring to do and in...

I have a suspicion that the log backup isn't the process that's causing the log to be full. Can you check the server error log to see if that...

What is the exact error message you are getting?

Why are you shrinking the logs with every backup?

Yes, you should use convert to display the data. Data is held in a date column in an internal format that supports the ability to display the data in...

Get the execution plans (actual) for the 2 procs. The plans should be different and will probably give a clue as to how the server is deciding to attack...

You have to remember that your "column headings" aren't really headings, they're data values in columns in the unioned result. Columns can only have one data type, so you...

I would second Craig's concerns. We haven't really gotten a clear picture from the OP as to how any duplicates in the child tables relate to the duplicates in...

It would help if you posted the DDL for the main table and at least one of the tables linked to it. The generic solution would be to find...

If you haven't explicitly limited SQL Server's memory allocation, it will take all it can getand keep it until it is forced to release it. Databases are supposed to...