Once I've gone over the scripts created, I'll be speaking to the boss about how much time it saved. . . fairly sure that the time saved equals far more...

Thankyou, that's superb! :w00t:

The tool shows me the differences. . . but without creating the "alter" scripts it's not much better than my manual option. I've hit 145 differences between 2, 83 between...

Since ANSI_NULLS affects the result, and since the default means we get the desired option - only those that simply input the query are going to be annoyed. Anyone that...

Try a batch file ?

for %%f in(*.sql) do sqlcmd -s %servername -d %databasename -u %username -p %password -i "%%f"

Wow. If any of you ninjas want to spend a couple of months answering this it'd be great :hehe:

That was a very interesting read, thankyou 🙂

This is my random months table - 1,000,000...

I don't understand why the use of a case when a simple function would do the job. . .

My original suggestion fulfills the requirements: -

DECLARE @getmonth TINYINT,

...

Could you do something like this?

DECLARE @getmonth TINYINT,

@datestring VARCHAR(20),

@input ...

vimal_panchal (4/1/2010)

---

I want to add a column to a table in My SQL CE database by using the following command:

ALTER TABLE tblProducts ADD isDeleted bit

However I want to prevent the...

I once did an SSIS package to add lines to 300 database scripts. With some modification, this'd work...

Same here, sort of.

I signed up here with a silly question brought about due to me being forced to take on some DBA duties while he was on long-term sick....

Should you choose to do it as an SSIS package, this C# should get you started. It's untested and written without a compiler so I can't be certain all of...

If this was a task I'd been given, I'd be writing an SSIS package with a foreach loop and a C# script component. Our DBA would never allow SQLCLR, for...

Always nice to be given the data so we can experiement. A better way of posting the information we need to be able to help is as I've done here...