Just want to add:

What about using the Import/Export Wizard?

No problem

Btw, there is no need to excuse to asking a question, methinks. There is only a need to excuse for a bad...

Hi Andrew,

must have missed your question. Sorry

So you've decided not to store images in a db? Ok.

Actually Allen and noeld have given...

Although I agree with you, this seems like some kind of religious discussion which we won't solve here. Using the IDENTITY property is not bad per se, as long as...

As you already have found out, not all views in a RDBMS are updatable. SQL Server is not Access.

You might want to use a stored procedure for updating multiple...

I don't think so. And you don't want to use C2 auditing for this.

Well, the first one is in the upper line, while the second one is in the lower line

Looks like a copy'n'paste issue

Can you provide more information on your ADO code?

I don't think we haven't provided an answer. Unless you don't use really huge numbers, you can workaround using decimal instead of float. And I don't think there is an...

Not to be picky, but if you are not already aware of the downside of dynamic sql you might want to read this.

http://www.sommarskog.se/dynamic_sql.html

On Erland's site there is also another...

To add to noeld, I guess it's not really a wish what the developer want to use and what not. You as the DBA are responsible for your server and...

I guess that's more of a firewall issue. You should team up with your network admin. Maybe you'll find additional information here

http://www.sqlsecurity.com

What first comes to mind is, that in terms of security there is no real difference between EM and QA. With both tools can a lot of damage be done....

Oops!

...but that analyzer is not bad at all. It doesn't hurt to reference it twice

Nah, getting seriuos again. We were lacking those lighter threads here lately

Has anybody mentioned using SQL Server Best Practice Analyzer yet? It...