Hi Dormer,

Good idea. I initially started to  set this up, but it was becoming cumbersome, so I thought I would ask around for other suggestions. If you get it going,...

Thanks spongemagnet ... great suggestion ... but how would you accomodate for the updated chart data range? Each time you append data, how would the data series change to capture...

Hi DMcClain,

Can Excel do that? I thought I would have to "get external data" and re-map the data source to the chart re: when a new month of data stats...

sa24,

Many thanks for the tip. I'm testing it now and it looks like it will fit our dev/prod deployment model as well.

Hi,

Thanks for all the inputs. A little FYI ...

From testing, I discovered that using sp_changeobjectowner in QA DOES NOT work with db_ddladmin. It requires db_ddladmin AND db_securityadmin permissions. BOL also...

Red Green?? Another fellow Canadian !!!

Can't really reply to JEFF W ... it's a proprietary app ... from reviewing the existing View definitions, I believe it is directly updating the...

Hi, thanks for the responses. Doe the &.0 database within the 8.0 environment still use the 8.0 query optimizer?

Hi,

to further elaborate my environment ... we allow developers DDL/DML rights (db_ddladmin; db_datareader; db_datawrite) in development and in the production environment, they have only db_datareader rights. I believe that the develper should...

Thanks Brian. Makes sense.

Hi,

I don't see the user through Enterprise Manager, but I see an entry in the model sysusers table ... but I thought Microsoft frowns on updates to the system tables...

EM tool: MSSQL 2000 w/SP3

Thanks all for the advice/suggestions.

I tried everything, but eventually got it resolved using a similar method as Rita's reply. Using Enterprise Manager (EM), I stopped and re-started SQL Mail. Everything...

Hi, sorry about that. i assumed that everyone would be able to see the print screen. Here is the text from the error box:

Line: 307

Char: 2

Error: Unexpected error

Code: 0

URL: res//C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\1033\sqlmmc.rll/Tabs.htm

Do...

Great tip. I'll try it with the backup process within EM ... 

HI, not sure what you mean by profiler? Also, I'm using MSSQL 2000 SP3/SP3a?