Viewing 15 posts - 16 through 30 (of 73 total)
Both ReportServer and ReportServerTempDB has the RSExecRole.
I modified the store procedure GetDBVersion to contain C.0.8.40 on the ReportServer and T.0.8.40 on the ReportServerTempDB, remove encryption key, upgraded the database, backup...
July 13, 2006 at 9:48 am
Use Reporting Service Configuration tool to verify Report Server has intialized.
May 30, 2006 at 9:38 am
We have been sucessful using BLAT (see http://www.blat.net) on SQL7, SQL2000 and SQL2005.
May 30, 2006 at 9:28 am
with Blat, you don't need SQL Mail (ie. outlook/exchange) it uses SMTP. But you do need permission to use xp_cmdshell
May 18, 2006 at 5:10 am
Can you ping the server either by server name or ip?
Check to see if the domain is in your dns list.
May 11, 2006 at 11:51 am
try this:
update msdb..sysdtspackages
set owner_sid = (select sid from master..sysxlogins
where name = 'sql login name')
where name = 'dts package name'
May 11, 2006 at 11:03 am
the developer has been checking their process and feels that the only updates were to a temporary table and changing their processes. hopefully it won't happen again. I'll try the...
March 31, 2006 at 11:37 am
we don't think it's doing a real rollback...reboot is very quick
March 31, 2006 at 8:36 am
this server is still running servicepack 3.
March 13, 2006 at 12:16 pm
inserts are being done through a vendor program... but here's the trigger..
-- Trigger Name: BAF_CMSARTICOLI_INSERT_UPDATE
--
--
-- Description: BAF_CMSARTICOLI_INSERT_UPDATE SQL trigger will Inserted or Updated columns in the CDS Article Master -- Table, CMSARTICOLI.
--
--
--...
March 2, 2006 at 12:07 pm
the issue is not executing the second dts from the first dts. I know I can use work flow to determine to execute the second dts or not. The issue...
March 2, 2006 at 11:32 am
MS DOS... or command prompt...
Disk Operating System (DOS)...
Operating System before Windows came along...
The batch file would be scheduled to run from task scheduler.
A batch file would contain DOS commands...
To get...
March 1, 2006 at 1:19 pm
the second dts does not unless there are records to be processed by the program that MUST run from a DOS prompt on a different server. How do you propose...
March 1, 2006 at 12:58 pm
The only constraint on the table is the primary key. And the developer is sure its not a duplicate key.
March 1, 2006 at 12:21 pm
Viewing 15 posts - 16 through 30 (of 73 total)