Using SQL you'd have to poll the folder. Easy enough to run a job once a min to check, tricky part is that the file may not be complete when...

Dell pointed us to the IOmeter app I posted the link to earlier, not sure if there is a different one besides that.

Andy

I think you could pull the code into VB and then compile as a client app. That would give you the chance to customize the download location.

Andy

Thanks for the follow up!

Andy

I think its worth trying - the mechanics of replication aren't that complicated. Then again, I don't know Oracle. But I'd bet it will work.

Andy

Thanks for the follow up. I do pull data from Access occasionally, but none of the stuff I use is every passworded and just never ran into it!

Andy

I agree that achieving the MCDBA will help you attain a good set of core skills, but as Brian mentioned you will need more. Really it comes down to networking...

Wrox had one for SQL 7, not great but better than nothing.

Andy

Definite need the attach to work. Are you doing it from QA or EM? If QA could you post the syntax? Does your db have more than one log file?

Andy

Have never tried! ListAvailableServers returns the list of servers that aren't hidden, possibly you could look at the properties of the sqlserver object, maybe in the version info?

Andy

There is a util in the Resource kit that does basically what you're talking about. I've also an a small utility that just applies all the scripts in a folder,...

Even that one isn't great - try this one!

http://www.intel.com/design/servers/devtools/iometer/index.htm

Andy

Dont think there really are any as long as you replicate all data and you keep the procs in sync. It's an ongoing debate of the merits of replication vs...

Its not replication that matters, its the IP address. Probably have to add a static route to get it to use the preferred nic. Steve probably the one to ask...

Not the same way you would in SQL2K, but I don't see why you couldnt just copy the data from sysxlogins using it.

Andy