Yes, I've used it to execute multiple SQL statements. For instance, I have a single Execute SQL Task that truncates several database tables all within the same "task."

K. Brian...

When we bring over large extract files from our mainframe systems, what we do is put a small (100 bytes or so) "tickler" file to tell us that the other...

I'm bothered by the following:

quote:

---

if update(btbclnt)

if not update(btbbcn)

set @oldclnt = (select btbclnt from deleted)

---

If we...

It's a MAPI-compliant client that you'll be needed. Basically Outlook will do (though Outlook 2000 is required for SQL Server 2000). Outlook can connect with a POP3 server,...

They shouldn't be conflicting, but one never knows. Yes, please post the code for both triggers.

K. Brian Kelley

bk@warpdrivedesign.org

There's a topic with basically the same issue:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=810&FORUM_ID=5&CAT_ID=1&Topic_Title=Installation+trouble+%2D+PLS+HELP%21%21%21&Forum_Title=Administration

Essentially, make sure you clear out all the EM files and edit out the appropriate registry keys belonging to SQL 2K....

I'm in agreement with Andy here. Basically, you have to consider that if you build the add a City into the UI, you're only running an operation in those...

Try this article from Brian Knight:

http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp

K. Brian Kelley

bk@warpdrivedesign.org

Sounds good, Chris, I like the suggestions and the script. Looks like I need to write a part II. 🙂

K. Brian Kelley

bk@warpdrivedesign.org

Connecting via NT Authentication or SQL Server logins? Sounds like you are getting to the servers via EM, so it doesn't sound like a ports issue.

K. Brian Kelley

bk@warpdrivedesign.org

You might also try the Counterpane Labs site. Counterpane Internet Security was co-founded by Bruce Schneier, author of Applied Cryptography:

http://www.counterpane.com/labs.html

It has some algorithms and links to other...

Wes is right, it's called the Ad Rotator component. Basically you create a text file (Rotator Schedule File) with the list of graphics, any links that may be associated...

From the VB side you have the option of the .AppendChunk method from ADO. I don't use it per se, but I do have several web apps running a...

A neat thing that SQL Server does is also allows you to insert any non-zero value (and non-null) and have it represented as 1. So if you're used to...

Can you post a small sample of your code? Generally there shouldn't be any reason .EOF would fail unless the connection isn't getting opened and/or the recordset isn't getting...