I agree with Antares. A packet sniffer will help. You could also open a QA or ISQL session from the server and see if it stays open for an hour,...

is the value being changed? I wouldn't be surprised if v6.5 didn't flag update() with no actual data changes.

Steve Jones

steve@dkranch.net

I have connections that run from my machine sometimes overnight and they do not break. I suspect you have some network issue here.

The short answer is the DBA sets...

If you have a multi CPU box, then the server will "parallelize" the queries, which will run multiple threads or fibers (not the same). On a single proc box, there...

A few thoughts.

1. Upgrade to SQL 2000 and W2K. I know it costs money, but it also will give nice performance improvements in how the server runs. You can run...

It was intended to allow multiple applicaitons to setup their own SQL Server without worrying about issues with a database inside a server, etc. Like Access, multiple .mdb files can...

You will have to use an ActiveX task to do this. Basically you will have to set a variable reference to the package, then get the table name you need...

select top 1

from ( select top 6

salary

from salarytable

...

restore from backup

Steve Jones

steve@dkranch.net

I believe the query for xp_sendmail must be a statement(s) that returns a single result set. You are attempting to output messages witht the print statement, whcih is not the...

You just pass it in as a varchar.

create procedure MyPRoc

@MyParam varchar(100)

as

select @MyParam

return

go

declare @c varchar( 100)

select @c = '1,2,3,4,5'

exec MyPRoc @c

Steve Jones

steve@dkranch.net

You have the wrong password for the service. Login failed means the service tried to login and could not. Check this in Control Panel | Admin Tools | Services |...

Not sure what you mean. Do you mean that you need to know what you need to know? Or what you need to hire someone (temp or perm) to do?

You...

I do not believe this is stored. The current session is as long as you are connected with isql. When you "quit" of disconnect, the password is not stored any...

I'd drop them to the local drive and then ship them. SQL Zip will work, also you can use my PushFTP process. Been using it for months and had to...