Using LIKE in this manner is going to require putting ever possible character other than 0-9 in the pattern. Fortunately, there's an easier way. Specify a range of 0-9 and...

Then you didn't do an in place upgrade. If you are upgrading the default instance, tell the setup program to make the install the default instance, and it will upgrade...

Just to make sure that I understand correctly, the distribution database is on the same server as the subscriber, not the publisher?

Are you planning to do an upgrade in place...

A couple of ideas for that:

1. Insert the results into a table variable and then select where the level = the max level in the table.

2. Make the whole query...

What do the contents of the log file say for the last execute by the bat file?

How are you executing the bat file? Do you see the command window and are you interacting with it as it runs? I ask because there is another pause command...

No, but there are cases where it wouldn't work without a semi-colon. For example, I have a stored procedure that performs a maintenance task with many steps. The procedure basically calls...

Hmmm, sounds kind of like you deleted something iportant when you deleted the other instance.

DTS doesn't have a looping mechanism, not directly. So, how are you doing the loop? Please explain how you doing that, and I will be able to help you a...

You do realize that your last command in the bat file is PAUSE, don't you? The last thing in the file is saying to wait, so it is waiting. Take...

Nope, not a bug. It's also not SQL Server's fault. It is the behavior, by design, of the ISAM used to connect to Excel and standard delimited text files. In...

I would put a bat file on the server, schedule the bat file via Windows Scheduled Tasks to check for existence of new files. If new files are detected, fire...

The problem is that the other version has a different name. So you have to use the -S flag to tell it the name of the instance it should connect...

Is your default instance up and running? What is the exact error output that sqlcmd gives you?

In the last section, you didn't alias ParentInfo as P like you did in the earlier section.

INNER JOIN ParentInfo <insert alias here>