You could use the FileSystemObject, it will return disk space info. Or maybe cmdshell Dir *.* > diskinfo.txt, then parse out the bytes? Hackaroo! I think you can also get...

Kiran,

Could you explain a bit about why you want to do this? You're not going to see much different in performance doing this in a proc vs just executing dynamic...

Using SQL2K. I think it was the annotation one. You cant save directly to VB using 7.0, but there is a utility (on the CD I think) that will do...

Bill, Im not sure where the "cutoff" point is - if you're doing tran log backups you're in good shape. If you REALLY want to be sure, you could kick...

Im currently keeping 3 days worth. Got burned once only keeping one day, tape backup job failed, next night it deleted the file, a day later I needed the backup...

Bill, I've got an article on here that might help you:

http://www.sqlservercentral.com/columnists/awarren/20010425205439_1.asp

The short story is the simplest way I've found is to do the install on the "new" server,...

The answer is - it depends! I normally advocate zipping files before copying in general, usually winds up being faster overall. Two things to consider, which is faster, and which...

Leon and I were just discussing a project where we need to do something similar. Batch file is certainly one option. Other than that, if you know VB you could...

Gee, an upgrade will fix it? Who woulda thought??

Thanks for the follow up!

Andy

Only way to get that value is to write it out to a table, either a permanent one or a global temp (use the ## prefix). One of the many...

Steve, Im curious - you said LMHOSTS and not HOSTS? Also, I am currently using the Client Utility configured with an alias to an IP to access a SQL server...

Hey Mike,

I've never done bi-directional, kinda had it on the "to-do" list since hearing a discussion about it at SQL Connections in Orlando earlier this year. Im still not sure...

Not sure how/why the datetimes would be different. Could you post some sample data or the error message, or both?

Andy

Hey Mike,

What if I want to use a domain account for sql and/or the agent? This is kinda nice to have in my opinion. Do you think using SQL login/password...

Just fully qualify the names, like this:

select a.id, b.id from db1.dbo.test a inner join db2.dbo.test b on a.id=b.id

If you set up a linked server, you can even do this across...