Viewing 15 posts - 1 through 15 (of 95 total)
Hi SQLRNNR,
Here are the steps to setup testing environment. Let me know if anything else required.
Thanks again.
* SQL2008r2/SE/SP1; client tool: SQL Server Management Studio (SSMS)
* partner1/principal database: P1 (dev box);...
September 10, 2014 at 1:02 pm
Hello,
thanks for the responses.
BOL states database owner (dbo) should work from either partner. This only worked from the Principal partner for me. The acct had to be sysadmin when breaking...
September 10, 2014 at 10:46 am
thanks.
is there a way to migrate on a report by report basis?
February 18, 2010 at 1:12 pm
Hi Michael,
do you have a referernce/link to that documentation? I would love to pass along to our vendor.
thanks. jeff
March 27, 2009 at 1:02 pm
Hello Jerry,
to my knowledge, this issue has not been resolved by Microsoft ... albeit, i haven't tried it with mssql2005's SP3 ... ?
my workaround:
a. i built a seperate Maint Plan/Job...
March 27, 2009 at 12:01 pm
yes - if you have a DBA account (mssql or NT auth.) which is mapped to sysadmin server role ...
January 22, 2009 at 7:33 am
Hi - the users can do quite a bit via the SSRS web front end ie: add/delete users ... abeit, they can't run an existing report ... just see all...
September 19, 2008 at 12:07 pm
Hi,
Many thanks for replies.
Jeffrey - Sql Server Configuration Manager (SSCM) is what I was looking for. Perfect! It displays all the instances and their names. Also, SQL Server...
May 26, 2008 at 11:32 am
hi, excellent ! i think this is exactly what i'm looking for ... there are new db roles for DTS vs giving the developer the sysadmin server role.
many thanks again.
February 25, 2008 at 11:36 am
Hi,
initially, the pkg will need to created & run by the developer for testing ... then i suspect we will be automating the process (importing xml data nightly) via sql...
February 25, 2008 at 5:58 am
Thanks Steve. Much appreciated.
I did an extensive search over google, MS forums/MS bug fixes/etc ... and I only found 1 reference/posting to similar case on another forum … but the...
October 10, 2007 at 11:40 am
Hi Ramprasad.G,
unfortunately for my case, it didn't work as it requires min Oracle 8i ... it didn't recognize/connect to 7.3.4 instance ... but from initial install and wizard, it looks...
July 12, 2007 at 9:51 am
Hi,
there are approx 300 tables with primary keys, unique keys and a couple of check constraints. No RI. No special indexes. Otherwise pretty simple ....
July 11, 2007 at 8:38 am
Hello,
We use DTS packages (which can be schedulked as a job) and/or stor procs (which can also be called by a job). We (DBA & Developers) have found this methodology...
March 27, 2007 at 8:00 am
Viewing 15 posts - 1 through 15 (of 95 total)