Viewing 15 posts - 36,556 through 36,570 (of 39,903 total)
Does dbo exist in all of your database user collections?
Steve Jones
April 8, 2003 at 12:56 pm
Also log in as the SQL Server account, start Outlook (or your mail client) and send mail. Do any dialogs pop up? Or is there some other "funny" thing about...
April 8, 2003 at 12:55 pm
Wow, that's quite a setup. Not sure you'll get an answer here, but good luck. We're primarily for databases, though there are a few good network people here.
Steve Jones
April 7, 2003 at 3:08 pm
I think they would still be .sql files, but saved as such and stored somewhere. You could chain them in one .sql with GOs to separate the batches or even...
April 7, 2003 at 12:00 pm
Pls post more information on the job. As well as noting if anything on the server as changed. Even if you don't think it matters, it might.
Steve Jones
April 7, 2003 at 8:43 am
Are you saying that you don't want to return rows if there are NULLs or column values?
You can use ISNULL.
Steve Jones
April 7, 2003 at 8:31 am
Shouldn't matter. This is one of the HUGE things we have over Oracle. Less DBA time spent monkeying with orders of stuff.
Or less developers writing code we have to rewrite...
April 4, 2003 at 2:36 pm
I've not seen this. Is there an affinity set? Check sp_configure for an affinity mask. In general, I've seen both CPUs run at similar levels, though I guess if one...
April 4, 2003 at 2:03 pm
Similar approach to hwat I've done in Part 1 and II. Thanks for sharing
Steve Jones
April 4, 2003 at 1:50 pm
I did find a couple things out. SP_SERVER_INFO reads from a sytem table. @@version reads from the file version of sqlsrv.exe. So I suspect somehow the table didn't get updated...
April 2, 2003 at 12:11 pm
Not sure what you mean? I'm using inserted and deleted tables.
Steve Jones
April 2, 2003 at 11:52 am
considered, but backed up with reviews. I hope to tackle it at some point.
Steve Jones
April 2, 2003 at 11:47 am
Not that I know of. How many machines?
We use SMS, works pretty good.
Steve Jones
April 1, 2003 at 11:28 am
pathing somewhere. Has to do with the different instance numbers.
Steve Jones
April 1, 2003 at 11:26 am
Viewing 15 posts - 36,556 through 36,570 (of 39,903 total)