Thanks for having me!

Wes

I've seen this be a permissions issue in the past. You have created all the directory structures and the like yes?

Wes

I think since sql 7.0 came out the MS-DBA role has decreased. I think production dba's will move into more of performance tuneing and the like. That is the most...

if you use the client tool you can hard set the port. I assume you are talking about port 1433?

Wes

Well I script everything I can. I got lazy at my new job but I'm back on the wagon now. I submitted my backup scripts I'll do the same for...

In my previous job no dev dba touched a production box once it was in production. If there were changes to be made they were done in test/dev then scripted...

or the name of the application? Don't forget the DL 360 doesn't take xeon procs in it ether. I wouldn't expect wonders from the little 1U unit. We passed them...

yeah, our spool server is a solaris box we hold at least one days worth on that box and the rest gets pulled to tape at our leasure.

Well my new backup script looks at disk free space before it writes any backups to local disk it also verifies that the backup was moved to the ftp and...

The xp_fixeddrives lets me do what I need to do. I already have two calls to xp_cmdshell in my script and really didn't want another. I just dump the output...

Well everything went fine in test. I rolled out the production cluster installed SQL applied sp1 and blew the box up. I tried the same trick I did last time...

I could use xp_fixeddrives then do a compare against the size of the object being written to disk. I think that will work. Where did you find the sproc? I...

Well, I looked at that but every customer will not be able to talk to a master. I'll look at the sp's and get on it!

Thanks,

Wes

there was quite a talk about sql 7 being twice as slow on w2k and sql2k taking a performance hit on nt 4.0 We never did any testing but we...

whats DB2 like? I've never messed with it before.