Heh... or, you could just shoot yourself in the head now and save on the anticipation 😀

Heh... no problem there... most people don't even know it exists! 😛

Thanks for the feedback, Bruce.

Heh... also notice that the != gets converted to a <> in the query plan output 😉

Matt is correct... even if you're using SSIS, 2000 rows should be processed in the proverbial blink of an eye... even faster if you use Bulk Insert, instead 😉 ...

Heh......

Susan S (11/8/2007)

---

I mean the above script will produce.

Name of database

Logical file name of .MDF

.Mdf File location drive

Size of the file in MB

Physical file location(full path of .mdf file)

Maxsize

Growth

and...

Correct... for more info, lookup "table hints, locking hints" in Books Online.

Ummm... rather than struggling with syntax, do you know what Books Online is? Comes free with SQL Server and, although it sometimes takes a bit to find what you're...

Do you have control over what the custom app does? For example, could you modify the custom app to write to a table in the server?

Otherwise, using BULK INSERT...

I don't know what is wrong, but I can neither open or save the attachement.

However, my recommendation was to look at "Expanding Hierarchies" in Books Online... that recommendation still stands......

I guess that means they're on the same server... so...

1) where can i have a predefined table with DBName,EMail as fields in it. either in each 5 DB's or just...

That would be my suggestion, as well.

There's a thousand different reasons for things like this...

Do the tables have the same number of rows?

Do the tables have the same indexes?

Are the indexes up to date?

Are the statistics...

Both...

The DBA's need to verify that the SQL Server instance is logged in either as a Super User that can see everything or must be logged in as a user...

Vincent Chute (11/9/2007)

---

The exact opposite for me.

I learnt != in maths so seeing <> has always been a wtf moment for me.

Just different notation dialects.

"!" being a shorthand for the...