When you create a backup, you can give it any extension you want .... which is what they did. It's not because it is an older version.

Has your Windows account been granted access to the server and database?

Personally, for running SQL from an external file, I prefer to create a VBScript file instead of DOS.

If you...

You're not using CDO, you're using CDONTS. They're not the same thing. CDONTS requires CDONTS.dll and no longer comes standard in Windows. I suggest rewriting your procedure to use CDO;...

Another problem with using Select Into is that the column definitions are based on the result set and not the underlying structure. So for example, if you have a varchar(500)...

>> I generally use the deleted table for updates/deletes, and inserted for new rows.

For updates, deciding which table you should use depends on which set of data you want. The...

I think what he is looking for is:

insert into mytable(f1,f2,f3)

values(@var1,

         getdate(),

        Case When @Var3 Is Not Null Then @Var4 Else Null End)

You actually could leave off the "Else Null" part because...

Also make sure your date field is indexed. For a real performance boost, store the date as an integer (20060704 = July 4, 2006, e.g.) as this will create a...

You are taking the term "non-logged" too literally. When you truncate a table, it is logged. It logs a single record basically saying that it the table was truncated as...

If it's just a heaser line and 1 data line, I would just use an ActiveX script (in a DTS package) to read in the two lines, split each line...

The article is here: http://www.sqlservercentral.com/columnists/sjones/2744.asp

I think you're having a Null math problem of your own. You had 11 items in the article. Or did you intend for "Forgetting about...

Actually, no. I specifically demonstrated using column names instead of * to demonstrate that the key fields don't have to be the same. Only the fields in the queries have...

Actually, you can do that without dynamic SQL or having 10,000 sp's. All you need is a view that performs a Union All of the various views and include a...

Like I said before, post your code!!!

That won't do you any good as Exec() will only read the first 4000 characters of a variable.

One option is to use NText and sp_executesql.

I'm out of ideas.