simone,

You should be able to set a variable to the script name before each osql call. Then use the variable to insert the script name into your logging table. I'm...

While you can use the MODIFY FILE it would be easier to do the restore while moving the database at the same time. IEFrom...

For inner joins I don't think it really matters as noted by the optimizer doing the same thing. However if you go to an outer join many times it HAS...

Thanks Chuck! You beat me to it

If you are using QA you can have it default to right align numerics by going to the Tools/Options menu. Then clicking on the Results tab and checking the Right...

I'm with Rob on this one. Use the replace function in the join. BTW: Rob is missing the closing parenthesis.

SELECT *

FROM table1 as a JOIN table2 as b on REPLACE(b.str_value,...

The only ways I can think of would be to use actual global variables in a DTS Package and the other would be to create an SP to call all the...

Jonathan,

Create a "Reporting" database on these machines to write out the job errors to. Then you can simply have the job insert a record into the logging table in the...

I've never had a problem with this either. Even when moving from one machine to another. Did they perhaps change their settings in QA and not realize it?

Does the instance have a case sensitive default collation even though your database doesn't? I run Latin1_General_Bin as my default collation and the above query needs to be changed to...

Just out of curiosity are there any triggers that change the NOCOUNT behavior? I've had problems with this in the past where a trigger has played havoc with NOCOUNT settings.

If this is a very large table you could look into using the SET ROWCOUNT syntax and then loop through until you no longer delete records. Then in the loop...

I started using Visual Studio for SQL Dev work about 6 years ago and now I don't use anything else. My reasoning is that no matter what job I had...

If your main question is how to shrink the log file you could run the Backup Log ... With Truncate_only and then immediately run Backup Database. Once you have done...

I agree with Bill. It sounds like you used the RECOVERY switch and need to run the script Bill gave to get you out of the "Loading" state.

I'm sure...