Thanks a lot Ian! That's exactly what I needed 🙂

A couple of questions:

- where is the database located? on the sql2000 server? if so, is the sql2005 allowed to connect to the sql2000 server?

- does the 'sa' principal exist...

Nice one. To be honest: what I expected wasn't the right answer 😉 But after testing it I knew what was 🙂

Thanks for the lesson in wildcard characters!

Have you tried encapsulating your IF statements between "BEGIN...END"?

For example:

SELECT * FROM employee

BEGIN

IF @employee = 'Some value' THEN 'some condition'

END

BEGIN

IF @employee = 'some other value' THEN 'some other condition'

END

Yes, this can be done. Try using order by [column_name] asc.

You are referring to a table D (D.Debit) but you don't declare this table. Perhaps you mean I.Debit?

Hi there,

Thanks for this script...I was looking for a script like this. I tried both the SQL2005 and the SQL2000 script. No problem with the first script but the second...

Are you sure the sixth field is filled in for every row in your original file?

If you want 'server A' to be replaced by 'server B' the very instant 'server A' crashes you should consider using replication.

If replication is out of the question you should...

Jan Van der Eecken (7/16/2008)

---

The answer doesn't seem to be 100 percent accurate. If you look up BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/016fb05e-a702-484b-bd2a-a6eabd0d76fd.htm under SNAPSHOT ISOLATION it reads:

Except when a database is being recovered,...

Hi!

Have you clicked on the link I provided about computed columns?

When using computed columns you don't need to use a query to accumulate the columns. The accumulation is done by...

If you create a backup of your database you're sure you can attach it to another server.

So you want a per row accumulation of Col1 and Col2 and put the answer in Total? (I'm having a bit of a problem with some smilies in your tables...

Hi,

You can:

1) rightclick on a database

2) click tasks

3) click import or click export

Then it's possible to import / export the full database or you can just select the table(s) you'd...

Well then you can use your tab delimited file to import the data by using BCP.