Enable Error Reporting

Feb 6, 2007

Hello,
I got the error:
______________________
Reporting Services Error

* For more information about this error navigate to the report
server on the local server machine, or enable remote errors SQL Server
Reporting Services
______________________

I saw the answer:
"You could set the "EnableRemoteErrors" configuration value to True in
the ReportServer.ConfigurationInfo database table."

How can I get to the ReportServer.ConfigurationInfo database table?

I am on the reportservice server and I run "reporting services
configuration manager" and the "sql server managment". I didn't saw
that option :(

Where is this configuration?

Any help?
Thanks

View 1 Replies


ADVERTISEMENT

How To Enable SQL 2005 Reporting Services?

Oct 7, 2007

SQL was installed w/o reporting previously by the other admin. How do i enable the reporting now?

View 6 Replies View Related

How To Enable FIPS And Keep SRS (for MOM Reporting) Working?

Mar 15, 2007

Long Time Lurker, First Time Poster

Need to know how to enable FIPS and yet still keep SRS (for MOM Reporting) working? Is this even possible? SQL 2005 box sits in an OU where FIPS is enabled, serves MOM Reporting up.

Tried SSL-ing IIS and using TLS.
Tried enabling FIPS also in the local policy to ensure it was on when SQL started.
Even have SQL 2005 SP2 on there.

Everything works great if I disable FIPS and bounce it. Enable FIPS and bounce it and can't get to the SRS or MOM Reporting web pages, not locally or from a workstation.

Has anyone got this to work?

Does anyone see a reference stating that this is not supposed to work, by design, or whatever?

TIA,
KAZE33

View 3 Replies View Related

Reporting Services :: Enable And Disable Checkbox?

Sep 16, 2015

How can we create a checkbox in SSRS and how can it be enabled disabled based on the value.

View 5 Replies View Related

Reporting Services :: Enable Multi Value Parameter

Apr 2, 2010

I have an SSRS 2005 report that I want to enable for multi value. However, I always run into the issue with the way it passes multiple values. How exactly do I get a multi-value parameter setup and working on both the report AND SQL side?I used the MS example of checking the multi checkbox for the parameter and then using a WHERE Column IN (@MultiParam), but this doesn't work. When you select one item, or is it multiple I can't remember, it fails.

View 29 Replies View Related

Reporting Services :: How To Enable ADFS For SSRS 2008

Aug 3, 2009

How to enable ADFS for SSRS 2008?

View 4 Replies View Related

How To Enable Remote Errors For Reporting Services 2005

Mar 7, 2006

How do I enable remote errors for Reporting Services 2005?

View 5 Replies View Related

Reporting Services :: Cannot Enable Schedule For Power View Report

May 18, 2015

I have a couple of Power View reports that I cannot enable the data refresh schedule for. I cannot pinpoint what caused the schedule to stop working but the scheduled data refresh for these reports used to work and now they don't. Every time I try to enable a schedule the page submits and it seems like everything worked (no errors). However, when I go back to the schedule page for the report the Enable checkbox is unchecked. There are other Power View reports that are scheduled and running just fine. The only error I can track down in the SharePoint logs is this:

Failed to remove workbook tracking handle from collection for workbook

I've tried making a copy of the file and re-uploading with a different name but nothing changes. The user would really rather not recreate the report from scratch.

View 4 Replies View Related

Reporting Services :: Disable / Enable View Report Button

Sep 14, 2015

Is there a way to make the View Report disabled or enabled if certain condition exists?

View 3 Replies View Related

Reporting Services :: How To Enable HTTP For Existing SSRS Service With HTTPs

May 19, 2015

How to enable http for SSRS service in my current sharepoint 2013 environment with https.

this is needed as we have a limitation in SSAS: We cannot specify HTTPS in the Analysis Services Report Action.

View 3 Replies View Related

Reporting Services :: Enable Network Service In Report Configuration Manger?

Jun 9, 2015

My Report service account, by default "Network Service" in the config manager.

 some of my onsite people my mistakenly changed the SSRS service account to the "Local system".

when I am trying to change it back, Manager is ask to create the dialog box 2(encrypt key) given below...

When try to create the encrypt account , report server is stopped working..I had changed the properties of the reporting services also..

View 3 Replies View Related

Source Error: Details| How To Enable??

Mar 16, 2007

Server Error in '/ShoppingCart' Application.

Incorrect syntax near '.'.



Description: An
unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the
error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near '.'.

Source Error:





An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.







Stack Trace:


[SqlException (0x80131904): Incorrect syntax near '.'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) .... 

View 3 Replies View Related

Enable Caching Error During Sql Dependency Registration

Sep 11, 2006

Hey, I can't enable caching on my local computer..I use daspnet_regsql -S "localhostSQLEXPRESS" -E -d books -edand aspnet_regsql -S "AdminSQLEXPRESS" -E -d books -edto try to start but i get a login error...cannot open database "books" requested by login. The login failed. Login failed for user Computer2/Adminunable to connect to SQL database for cache dependency registrationI tested connection with vwd and sql express management and it connects so I don't know what i'm doing wrong since I followed the direction and I googled for answer but not coming up with anything that's helping me..anyone have this problem and know how to resolve so i can cache some data output on my project 

View 2 Replies View Related

Enable Package Configuration THrow Error

Nov 15, 2007



Hi please Help Me Out.

I am using Data flow object in that I take OleDb as Source and Sql Server As destination. Without enabling Package configuration everything is working fine data is moving from Source to destination.

But When i apply Package Confiiguration It throw Error And My OleDb Source object Convert in to RED Color. I cant able to track This errror

Please Help me Out .

Thanks
Sandeep

View 3 Replies View Related

Reporting Services :: JIT Debugging Error When Reporting Configuration Manager Is Opened

Sep 11, 2015

We have installed SQL Server 2005 with reporting services.When tried to open getting errors as below: how to avoid such errors See the end of this message for details on invoking  just-in-time (JIT) debugging instead of this dialog box.

ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has occurred and no additional error information is available. ---> System.Runtime.InteropServices.COMException (0x8000000A)
  at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
 
[code]...

View 4 Replies View Related

Enable Error Handling When Writing Custom Source Component /custom Error Handling Component.

Apr 21, 2006

1) We are writing a custome Source component for Oracle with OCI calls, Could some one please let me know how to Enable Error Handling for the Same,

2) Is it possible to write Custome Error Handeling Component for SSIS? if yes could you please help me on how to write it.

Thanks in advance.

View 1 Replies View Related

Error Opening Reporting Services Site --- Server Error In '/Reports' Application

May 9, 2008

I recently installed SQL Server 2005 Enterprise on a machine running Server 2003. I have successfully configured Reporting Services (see below for summary of settings)
- Used the defaults for the Repor tServer and Report Manager Virtual Directories
- Windows Service Identity set to domain user. The domain user is part of the administrator group on the machine and has sysadmin rights to the database
- Web Service Identity set to NT AuthorityNetworkService

When I open http://localhost/reports/, I get the following error:

I have check a bunch of forums, but have no success. Any advise would be greatly appreciated!!




Server Error in '/Reports' Application.


Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll' -- 'The directory name is invalid. '

Source Error:







[No relevant source lines]
Source File: Line: 0



Show Detailed Compiler Output:





c:windowssystem32inetsrv> "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727csc.exe" /t:library /utf8output /R:"C:WINDOWSassemblyGAC_32System.Web2.0.0.0__b03f5f7f11d50a3aSystem.Web.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3a890e9c0068591f_f54cc701ReportingServicesFileShareDeliveryProvider.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Web.Mobile2.0.0.0__b03f5f7f11d50a3aSystem.Web.Mobile.dll" /R:"C:WINDOWSassemblyGAC_32System.Data2.0.0.0__b77a5c561934e089System.Data.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Web.Services2.0.0.0__b03f5f7f11d50a3aSystem.Web.Services.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Configuration2.0.0.0__b03f5f7f11d50a3aSystem.Configuration.dll" /R:"C:WINDOWSassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.IdentityModel3.0.0.0__b77a5c561934e089System.IdentityModel.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.ServiceModel3.0.0.0__b77a5c561934e089System.ServiceModel.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem2.0.0.0__b77a5c561934e089System.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl34a099978068591f_f54cc701ReportingServicesEmailDeliveryProvider.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727mscorlib.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3de5a23320958a20_f54cc701ReportingServicesWebUserInterface.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Xml2.0.0.0__b77a5c561934e089System.Xml.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3498aee86042473c_93d0c501ReportingServicesCDOInterop.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Runtime.Serialization3.0.0.0__b77a5c561934e089System.Runtime.Serialization.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Drawing2.0.0.0__b03f5f7f11d50a3aSystem.Drawing.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3cd47089b0f2a80e_f54cc701Microsoft.ReportingServices.Interfaces.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3f180608d0083daf_b16dc701Microsoft.ReportingServices.Diagnostics.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl323449648068591f_f54cc701ReportingServicesNativeClient.DLL" /out:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll" /debug- /optimize+ /w:4 /nowarn:1659;1699;1701 "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.0.cs" "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.1.cs"


Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.1433
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.

error CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll' -- 'The directory name is invalid. '








Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

View 5 Replies View Related

I Am Getting An Error Message When I Try To Print Using Reporting Services: An Error Occurred During Printing (0x80004005)

May 22, 2007

I am getting an error message when I try to print using reporting services: "an error occurred during printing (0x80004005)"

View 4 Replies View Related

SQL Reporting - An Internal Error Occurred On The Report Server. See The Error Log For More Details. (rsInternalError)

Feb 6, 2006

I have created an RDL file programatically. When I execute the code I get the error as mentioned below:

Error: Sub report cannot be shown.
An internal error occurred on the report server. See the error log for more details. (rsInternalError)

When I copy and paste the code of RDL file into new RDL file and try to preview the output I get correct result.
Note: The new RDL file does not give any error if the output is seen using preview tab but it gives the error only when executed from report viewer or from internet explorer.

Any Suggestion/feedback is highly appreciated.
Thank You.


The code of the sample RDL is shown below:

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="DataSource1">
<DataSourceReference>DataSource1</DataSourceReference>
<rd:DataSourceID>fe4806ee-0358-4a87-b764-ac5de049545e</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>0.25in</BottomMargin>
<RightMargin>0.25in</RightMargin>
<PageWidth>11in</PageWidth>
<ReportParameters>
<ReportParameter Name="machine_id">
<DataType>String</DataType>
<Prompt>machine_id</Prompt>
</ReportParameter>
<ReportParameter Name="from_date">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>From Date</Prompt>
</ReportParameter>
<ReportParameter Name="to_date">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>To Date</Prompt>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ReportItems>
<Table Name="table1">
<DataSetName>Main_Report</DataSetName>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<rd:DefaultName>textbox2</rd:DefaultName>
<ZIndex>1</ZIndex>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!syscode.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<Grouping Name="table1_Group1">
<PageBreakAtEnd>true</PageBreakAtEnd>
<GroupExpressions>
<GroupExpression>=Fields!syscode.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
</TableGroups>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Subreport Name="subreport1">
<Parameters>
<Parameter Name="machine_id">
<Value>=Fields!machine_ip.Value</Value>
</Parameter>
<Parameter Name="syscode">
<Value>=Fields!syscode.Value</Value>
</Parameter>
<Parameter Name="from_date">
<Value>=Parameters!from_date.Value</Value>
</Parameter>
<Parameter Name="to_date">
<Value>=Parameters!to_date.Value</Value>
</Parameter>
</Parameters>
<ReportName>Holding_Summary_Multi_Period</ReportName>
</Subreport>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
</Details>
<TableColumns>
<TableColumn>
<Width>10.5in</Width>
</TableColumn>
</TableColumns>
<Height>0.5in</Height>
</Table>
</ReportItems>
<Height>0.75in</Height>
</Body>
<rd:ReportID>d0a1293a-e98c-4f75-9597-03426d2e7218</rd:ReportID>
<LeftMargin>0.25in</LeftMargin>
<DataSets>
<DataSet Name="Main_Report">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>select account_syscode as syscode , 'display Name' as display_name , * from mars_customer_list
where machine_ip = @machine_id</CommandText>
<QueryParameters>
<QueryParameter Name="@machine_id">
<Value>=Parameters!machine_id.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>DataSource1</DataSourceName>
</Query>
<Fields>
<Field Name="syscode">
<rd:TypeName>System.Int64</rd:TypeName>
<DataField>syscode</DataField>
</Field>
<Field Name="display_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>display_name</DataField>
</Field>
<Field Name="customer_syscode">
<rd:TypeName>System.Int64</rd:TypeName>
<DataField>customer_syscode</DataField>
</Field>
<Field Name="account_syscode">
<rd:TypeName>System.Int64</rd:TypeName>
<DataField>account_syscode</DataField>
</Field>
<Field Name="machine_ip">
<rd:TypeName>System.String</rd:TypeName>
<DataField>machine_ip</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Code>Shared offset As Integer

Public Function GetPN(reset As Boolean, pagenumber As Integer) As Integer
If reset
offset = pagenumber - 1
End If
Return pagenumber - offset
End Function

</Code>
<Width>10.5in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>en-US</Language>
<PageFooter>
<ReportItems>
<Image Name="image1">
<Sizing>Fit</Sizing>
<Left>8.875in</Left>
<MIMEType />
<Width>1.5in</Width>
<Source>External</Source>
<Style />
<Value>bottom_right_logo.gif</Value>
</Image>
</ReportItems>
<Height>0.5in</Height>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
</PageFooter>
<TopMargin>0.5in</TopMargin>
<PageHeight>8.5in</PageHeight>
</Report>

View 8 Replies View Related

Can't Enable SQLCacheDependency

Feb 1, 2007

I have a SQL 2005 database and am running the 2.0 framework. I cannot seem to enable SQL caching on the db. I'm using the command line tool as follows:
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727>aspnet_regsql -S 99.99.999.999 -Uwebteam -P sa -t tblname -d dbname -et
Enabling the table for SQL cache dependency.
.An error has happened.  Details of the exception:The database 'dbname' is not enabled for SQL cache notification.
To enable a database for SQL cache notification, please use the System.Web.Caching.SqlCacheDependencyAdmin.EnableNotifications method, or the command line toolaspnet_regsql. To use the tool, please run 'aspnet_regsql.exe -?' for more information.
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727>
 
I've replaced the ip address, dbname and tblname with ficticious names for obvious reasons here in the post.
What command can I enter to enable the database for caching?  

View 4 Replies View Related

Its Urgent Is There Anything Like To Enable...

Feb 28, 2005

Hi evryone

I have two databases. one is bayan and other is clearance. clearance was already there. i created new bayan. both database having same things. such table ,views.
both contains arabic and english records.

when i try to fetch records from clearance table as arabic it is working
the query is like:
select * from customers where cust_name_araibc='here arabic text'

it is working fine

but same query i try with bayan databses it runs but it doesnt display any records.

So is there anything like to enable languages in sql server databses.

Please reply soon

Its very urgent.

thanx in advance

View 4 Replies View Related

Enable Transaction Log

May 14, 2008

hi
i have backup of transaction log of database but tracnscation log check box is desable ho i can enable this

View 3 Replies View Related

Dts - Enable Logs

Oct 24, 2007

how do i enable logs on a DTS on sql server2005?

Thanks
Peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

View 1 Replies View Related

Index Enable

Mar 3, 2008

I have to disable index using
alter index empind on emp diable;


but how to enable
alter index empind on emp enable;/its not working

View 1 Replies View Related

Enable Logging

Mar 8, 2008

All, I am using SSIS in sqlserver. I wanted to enable logging in SSIS. I just want to log all the activities in the log file. How can i enable logging in SSIS? I would appreicate if any one could answer for this. thanks in Advance.

View 1 Replies View Related

Enable A Trigger

Jul 23, 2005

Hi!I know that you can enable/disable a trigger through the altertable command. Once a trigger is disabled, is there a wayto determine whether it is disabled or enabled? I see there is astatus column in sysobjects ...is that what I should be using?thanks in advance for any helpKaren

View 1 Replies View Related

Enable AWE Under SQL2005 EE -

Nov 30, 2006

Hello,

I understand that SQL2005x64 bits ignore AWE enable in SQL because it can address all the memory without having to use AWE. How about 32 bits SQL2005, does it support AWE enabled??

View 1 Replies View Related

Can't Enable Queue

Sep 28, 2006

Hi Folks,

I was testing my error handling and purposefully failed some messages. Automatic posion message detection kicked in and disabled my queue. I tried the following, one at a time to enable it again but it doesn't work:

ALTER QUEUE MigrationQueue WITH STATUS = ON;

ALTER QUEUE MigrationQueue WITH STATUS = ON, ACTIVATION (STATUS = ON);

I would have thought the first line would've worked but I get the following when trying to receive...

The service queue "MigrationQueue" is currently disabled.

Help.

View 6 Replies View Related

HOW TO: Enable Drill Down

May 28, 2007

I have a problem on creating a report using Microsoft SQL Server Business Intelligence Development Studio. I am new to this environment, anybody here can help me on how to enable the "DrillDown" on the table?



When I am using the wizard, the option to enable the drill down will appear, but when I am using "Report Server Project", I really don't know how to enable it, and theres was no table properties on how to enabled it.



Could you help me please



Thanks

View 4 Replies View Related

Not Able To Enable Xp_cmdshell Using DMO

Aug 10, 2007

Hi,
I am using DMO + VBScript to enable the xp_cmdshell feature in SQL Server 2005 Express.
But I get error "Item cannot be found in the collection corrosponding to the requested name or ordinal".
Here is the script which I am using:

Dim excmd: Set excmd = CreateObject("ADODB.Command")
Set excmd.ActiveConnection = connx ' This was created earlier using sa login and connected to master database

excmd.CommandType = 4
excmd.CommandText = "sys.sp_configure"
excmd.Parameters.Refresh
excmd.Parameters(1).Value = "show advanced options"
excmd.Parameters(2).Value = 1
excmd.Parameters(3).Value = Null
excmd.Execute () ' This line failes
If (Err.Number <> 0) Then
LogText "Unable to execute stored procedure. " & Err.Number & " " & Err.Description
Exit Sub
End If

excmd.CommandText = "RECONFIGURE WITH OVERRIDE"
excmd.Parameters.Refresh
excmd.Execute ()
If (Err.Number <> 0) Then
LogText "Unable to Refresh. " & Err.Number & " " & Err.Description
Exit Sub
End If

excmd.CommandText = "sys.sp_configure"
excmd.Parameters.Refresh
excmd.Parameters(1).Value = "xp_cmdshell"
excmd.Parameters(2).Value = 1
excmd.Parameters(3).Value = Null
excmd.Execute ()

If (Err.Number <> 0) Then
LogText "Unable to execute sp xp_cmdshell. " & Err.Number & " " & Err.Description
Exit Sub
End If

excmd.CommandText = "RECONFIGURE"
excmd.Parameters.Refresh
excmd.Execute ()
If (Err.Number <> 0) Then
LogText "Unable to Refresh after running sp. " & Err.Number & " " & Err.Description
Exit Sub
End If

Can some body provide a clue to me !!!

Thanks in advance
Amit

View 1 Replies View Related

Can You Enable SSIS To Use AWE

Dec 11, 2007



Hi - can anyone advise if it is possible to enable SQL 2005 SSIS to use AWE? If it is possible - how is this enabled?

Thanks
BravehearT1326

View 3 Replies View Related

Can Not Enable Parameter

Feb 13, 2008



I have a date parameter that users can not choose because it is grayed out. The Prompt User property is checked in Report Manager. What else do I need to do to enable this functionality. I'm using SSRS 2005

Thanks
Dean

View 5 Replies View Related

How To Enable Optimistic Concurrency

Jul 25, 2006

I have a number of SqlDataSource objects in my application, which don't have Optimistic Concurrency option enabled. The SDS objects use custom Sql statements so I can no longer select the Advance button to enable Concurrent Concurrency.
How can I enable this option? Is there a designt ime property, and even a run time property that can be set?
The only method we have so far is to create a new SDS, with Optimistic Concurrency switched on, then copy and paste my custom Sql into it and rebind my components..
Any help on this matter is appreciated.
Regards,
Steven
 
 

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved