A stored procedure is nothing more than saving the code you write in a query analyzer window so that you can run it again.

If in QA you write

select top 5 *...

Two complete different things!

DTS was designed specifically to import or export data in and out of SQL Server.

Jobs will run packages of DTS, or stored procedures, or code, on a...

Why so many connections? Probably because the VB code was not properly written! VB developers sometimes forget to close connections that they open.

Rather than constantly fight with developers (OK. You...

Thanks.

It would have been so much easier if such a database setting existed. Too bad.

Sara

Hi Eric,

I am not a fan of dynamic sql either, but sometimes it is the best solution.

Have a great weekend!

you might want to try this

insert..... 'Cote D' + char(39) + 'Ivoire'

I find that easier than keeping track of how many single quotes I need to type.

Sara

What is the -11, -22? how are those numbers generated?

Have you tried setting up parameterized queries in EXCEL? From what you write, this seems to be the best solution.

1. Create a stored procedure with parameters.

2. grant permissions on the...

It gets set only for the individual setting.

Let's see what Noel has to say. He does seem to know it all!

Thanks Sushila!

BUT - that works only for the individual session.

I'm looking to change it for the entire database, so that anyone who opens a session, whether in QA or through...

Aiwa's way will work, and possibly is the best way to do it.

But there is another way as well. Use dynamic SQL. dynamic sql takes everything as text, so you...

No. They are encrypted.

What you can do, if necessary, is change them or delete them, if you have the rights to do so.

Despite the occasional existence of a "natural key", I still prefer to alway use a generated key ID. All too often the natural key is changed by powers outside of...

Thanks for the tip. I downloaded XML Spy from altova and it is a help.

But - I still have a problem outputting XML....

Noel is absolutely right - as usual. I was too quick on the draw.

OK.

First, in QA tools - options - results, turn off...