Have a look at the below article.  Specifically where it talks about the drop table command instead of delete.

-Luke.

http://www.sqlservercentral.com/columnists/jsack/capturingtheerrordescriptioninastoredprocedure.asp

I've never done that specifically but I've taken data from Pervasinve and populated a SQL table with it.  You just need to have the Pervasive ODBC driver installed and create...

When you create your DTS job, use an Execute SQL Task.  Choose the proper Connection (the one to your informix dsn) and call your sp the same way you would if you...

Yes, I understand that a simple order by in the SQL statement would be a simple fix for this.  What I was really trying to find was how many rows...

David that worked perfectly.

Thanks so much!

Did you already try to reinstall the Client tools?  This will probably fix your problem with EM.

For me it'd be telecommuting as well.  The only thing is that I'd need a nice bonus as well to help me afford the sailboat I'd be telecommuting from

Yeah patches... I knew I should have spent more time with Mavis Beacon...

As far as hardening a server or SQL installation, first things first, make sure the atches are up to date.  Then check various security resources white papers etc from MS,...

Once upon a time I used to work as a network admin for a temp and permanent placement company.  Yes this does happen, also think of it this way,...

take a look at this discussion and see if it helps you...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=168902

Check out Item number 4.1 in the SP4 readme.  Either from your distro or here.

http://download.microsoft.com/download/1/b/d/1bdf5b78-584e-4de0-b36f-c44e06b0d2a3/ReadmeSql2k32sp4.htm#_unattended_installations

Have a look at the following and see if it helps you...

http://support.microsoft.com/default.aspx?scid=kb;en-us;811889&Product=sql2k

When I was about 7-8 I remember my dad bringing home a Trash 80 to do some work for a computer class he was taking at the time.  This led to...

Not sure if this will answer your question, but here goes.

When you are adding a new user and you choose windows authentication, the domain drop down box will list all domains that...