something like VS Studio Team Edition? from what i know the devs use the ancient Visual Source Safe or something like that

now i'm getting. even detached and reattached the database

Msg 33009, Level 16, State 2, Procedure trig_alter_sp, Line 0

The database owner SID recorded in the master database differs from the database...

nice article

only thing i'm looking for now is if there is a way to audit SSRS. Us DBA's are responsible for watching it, but our BI dev's have access to...

last year we did this

we had a SQL 2000 server with database services and RS on it. management wanted high availability. we took this server along with a SQL 2005...

nice article

motivated me to start coding some reports based on a month or so of performance data i started collecting. only thing i cant figure out is to how to...

on a few databases i've seen the recovery process take 2 hours if we restarted SQL during the rollback of a big transaction

thx

I guess it's vmware to the rescue then

this is great and would be a great replacement for Full Text Indexing for smaller text columns. my biggest gripe about FTI is the blocking caused by inserting large amounts...

you just go to the website, click get key and it takes 2 seconds

the data isn't used very much after the archive so it doesn't have to be exact. just worried about storage.

nice, thank you

ran this and it dropped over 1000 indexes in a few seconds. we have a process to copy some tables to an archive db every month and i...

have a similar situation

i'm in the process of reorganizing tables in a database that stores event log data. currently i have a few tables per server and i'm going to...

i think you only need ReportServer. The temp one is like tempdb that is used to hold data for when reports are executing

what about creating a subscription and sending it out to users a few times a day?

another way is to connect to Reporting Services instead of the database engine and you...

what is the proprietary database? i didn't think anymore existed. almost all vendors seem to use mysql, postgres or sybase