Very cool, Lowell. Certainly easier than scripts to start with.

No, but Sybase uses T-SQL, so there will be some familiarity with the language and syntax. Thats' about it.

What do you mean "open a URL"? When you put a URL in your browser, it gets a stream of HTML that it renders. What do you propose the server...

Litespeed doesn't change the fact the server is doing the backup.

You are going to be copying data from a location the server can see to the client's disk. That can...

The default trace keeps a certain amount of data. It's not based on time, but does it matter? Try it and see if the data is there.

The only other alternative,...

Jeff was a little short after your reply, but how is this rude?

Nice try on the posted data... for future posts and better/quicker answers, plsea see the article at the...

You can try the default trace, and see if it's still in there. http://www.sqlservercentral.com/articles/64547/

otherwise, no. You need to be looking for this activity with a trace to catch it.

I thought SSMS would be great when I first saw it, but it's too fragmented for me.

The thing I've found is that I don't often keep jumping to different tasks....

Typically to find the latest, I've used a correlated subquery.

select a.SalesDate as 'MostRecentDate'

from Sales a

where a.SalesDate = (select max( SalesDate)

...

I agree with Henry. The log in simple mode grows to accomodate the largest transaction that is open. Then once the transaction commits, that space gets re-used. If the log...

It's definitely hard to do in the real world. However like Dave mentioned, you take notes, you document things, and you review the issues.

In terms of your VM issue across...

I'd agree on Express. CE doesn't have stored procs, which is an issue.

Good luck with the replication. It can be tricky, and the more you can limit what data can...

Changed it to a DMV from a table. We generically seem to use "table" for system tables, views, and DMVs, which isn't correct.

The question has been edited to say "batch"...

Buck wants to go back to the MMC, things like the right-click-MyComputer-Manage.

There were plug ins for managing SQL 2K.

I liked Enterprise Manager. Personally I'd like to replace SSMS with a...

Thanks, but even I've had periods where I haven't posted much. Course, I have to keep this baby going, so I don't get too much of a break.

I doubt I'll...