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


ADVERTISEMENT

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

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

Failed To Enable Constraints

Jul 31, 2006

I have to admit I'm pretty new to ASP.net.
I'm trying to insert a row of data into my SQLExpress database table "Prets"
I'm getting the user_ID from the table "Membres"
Here's the code I have:
Imports System.Web.UI.PageImports System.Security.PrincipalImports WiseNetTableAdaptersPartial Class membre_sec_Pret_demande_pret    Inherits System.Web.UI.Page    Protected Sub submit_btn_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles submit_btn.Click        Dim User As String = My.User.Name        Dim pretAdapter As New PretsTableAdapter        Dim membreAdapter As New MembresTableAdapter        pretAdapter.AjouterPret(Convert.ToInt32(membreAdapter.GetUserIDbyName(User)), Convert.ToDecimal(montant_txt.Text), Convert.ToString(raison_txt.Text))    End SubEnd Class
And here's the error I get at runtime:
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. 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.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.Source Error:



Line 1610: }
Line 1611: WiseNet.MembresDataTable dataTable = new WiseNet.MembresDataTable();
Line 1612: this.Adapter.Fill(dataTable);
Line 1613: return dataTable;
Line 1614: }Source File: c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Fileswisenetindustriesafc388c716067f12App_Code.tyietv41.0.cs    Line: 1612 Stack Trace:



[ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.]
System.Data.DataTable.EnableConstraints() +1820725
System.Data.DataTable.set_EnforceConstraints(Boolean value) +39
System.Data.DataTable.EndLoadData() +138
System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +218
System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +318
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +221
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +162
System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +107
WiseNetTableAdapters.MembresTableAdapter.GetUserIDbyName(String nom) in c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Fileswisenetindustriesafc388c716067f12App_Code.tyietv41.0.cs:1612
membre_sec_Pret_demande_pret.submit_btn_Click(Object sender, EventArgs e) in c:inetpubwwwrootWiseNetIndustriesmembre_secPretdemande_pret.aspx.vb:12
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
   

View 1 Replies View Related

Failed To Enable Constraints

Apr 15, 2007

Hello there, I have a table under SQL2005 express with 8 fields with a primaryKey defined.In my BLL in the table adapter there is one "SELECT DISTINCT prodCAT from prods" The prodCAT is a nvarchar(50) and it is not part of an index or primaryKey.When I preview the data from my BLL I get the correct data.I defined a new web form (aspx) and put a ddl (dropDownList) with an objectdataSource that relates to the above sql function/command and I get a"Failed to enable constraints. One or more rows contain values violating
non-null, unique, or foreign-key constraints." BTW when I defined the above SQL in the BLL I got a "The new command text makes the function return data with schema different from the schema of the main query" Any suggestions???  

View 8 Replies View Related

How To Enable Ah Hoc Query In SQL 2000

May 10, 2007

Hi guys
 I have a program which imports data into sql server from csv files. This program uses the something like this
 
CREATE PROCEDURE MyImport
(
@FileName AS VARCHAR(200)
)
AS
SET NOCOUNT ON
DECLARE @SQL VARCHAR(4000)
SET @SQL = ' SELECT *
FROM OpenRowset(''MSDASQL'', ''Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:;'', ''SELECT * FROM ' + QUOTENAME(@FileName) + '' + ''') as t
'
EXEC (@SQL)
 
when i excute this i get a permission error saying the account i specified in the web config doesn't have rights to run these type of scripts. I tried using the sa account which works. But its not recommended to setup applications to access the database using the sa account.
i did some research and i found out that yon can actually enable that by change a registry key. But i cant find the MSDASQL datasource under ms sql server providers in the registry.
Any other ways i can enable this?
 

View 3 Replies View Related

Sp_configure/enable CLRI

May 23, 2007

Hi.
I  right click the (root) Solution Explorer to add an SQL object (something.mdf) but I get an error message
that "Generating user instances in SQL Server is disabled. Use sp_configure 'user_instances enabled' "
WHERE DO I WRITE THE SP_CONFIGURE CODE IN VISUAL WEB DEVELOPER ?
(I don't see anything like new query  of server and the one in the SQL SERVER management studio is already done).
10x

View 7 Replies View Related

Enable SQL Remote Access

Jan 21, 2008

Hi.,please help.,i get this error.,i made my web and deploy it in a different system which is winserver03, we have in the same network.how will i enable SQL remote access: 
Server Error in '/' Application.


An error has occurred while establishing a connection to the server.
 When connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance
Specified) 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: An error has occurred while establishing
a connection to the server.  When connecting to SQL Server 2005, this failure
may be caused by the fact that under the default settings SQL Server does not
allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error
Locating Server/Instance Specified)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): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186 System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +737554 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +114 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +421 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +133 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.GridView.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69 System.Web.UI.Control.EnsureChildControls() +87 System.Web.UI.Control.PreRenderRecursiveInternal() +50 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2041

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

View 1 Replies View Related

Failed To Enable Constraints

Aug 25, 2003

does anyone had any idea on the following codes that i'm facing?i have no ideas what is constraints and i hardly can view my page. In addition to that, i also faced the same problems when i'm trying to change my user password. it eventually managed to change the password but then the changes leads to the failed to enable constraints too. however, the following codes is not related to the change password but the purchase item. Hope someone can help me up! thanks!

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
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.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Source Error:


Line 223: SqlDataAdapter2.SelectCommand.ExecuteNonQuery()
Line 224: SqlConnection1.Close()
Line 225: SqlDataAdapter2.Fill(BuyData2)
Line 226: i = BuyData2.BuyView.Count
Line 227: For n = 0 To i - 1


Source File: C:InetpubwwwrootegBuy.aspx.vb Line: 225

Stack Trace:


[ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.]
System.Data.DataSet.FailedEnableConstraints() +19
System.Data.DataSet.EnableConstraints() +519
System.Data.DataSet.set_EnforceConstraints(Boolean value) +31
System.Data.DataTable.EndLoadData() +300
System.Data.Common.DbDataAdapter.FillFromReader(Object data, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +260
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +129
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
eg.Buy.Page_Load(Object sender, EventArgs e) in C:InetpubwwwrootegBuy.aspx.vb:225
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

View 4 Replies View Related

How To Enable And Disable The Identity

Nov 17, 2006

Hello there :-)

Kindly help me find the answer on how to enable and disable the identity of a field on a table via SQL Script?

Thanks :-)

View 1 Replies View Related

How To Enable Remote Connections?

Jul 11, 2006

Hello guys,

I would like to know how to enable remote connections to my SQLExpress installation? Thank you very much for any help!

Regards,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !

View 4 Replies View Related

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 View Related

How To Enable TCP/IP Connectons To SqlServer

Jul 23, 2005

How to enable remote connections on TCP/IP?I have just installed for first time SqlServer 2000,and cannot connect from other host via ODBC.I give hostname or address but it does not connect.I checked on my firewall that there is no listenning socketon port 1433 nor 1440 on sqlserver host.I can only connect using "(local)" server in ODBC on sqlserver host.Regards,Mark

View 2 Replies View Related

How To Enable The SQL To Update All Fields?

Nov 9, 2006

How to enable the SQL to update all fields?

"UPDATE addresses SET "

+ "strCompany='" + strCompany + "',"

+ "Name='" + strName + "',"

+ "strAddress='" + strAddress + "',"

+ " strPhone='" + fields.phone.getText() +
"',"

+ " strHp='" + fields.hp.getText() + "',"

+ " strFax='" + fields.fax.getText() +
"',"

+ " strEmail='" + strEmail + "',"

+ " strStart='" +
fields.start.getText().trim() +
"',"

+ " intDay= '" + Integer.valueOf(dd) +
"',"

+ " intMonth='" + Integer.valueOf(mm) +
"',"

+ " intYear='" + Integer.valueOf(yy) +
"',"

+ " strMrc='" + fields.mrc.getText() +
"',"

+ " strIsp='" + fields.isp.getText() +
"',"

+ " strDes='" + fields.des.getText() +
"',"

+ " strSale='" + fields.sale.getText() +
"',"

+ " strContract='" +
fields.contract.getText() +
"',"

+ " strMark='" + fields.mark.getText() +
"'"

+ " WHERE strCompany='" + strCompany

+ "'"
+ "AND strName='" + strName + "'";

View 1 Replies View Related

How To Enable SSL For HTTP Endpoint?

May 31, 2007

Hi,

I'd like to know how can I setup the SSL so I can secure my HTTP Endpoint.

I saw in the documentation that some settings such as SSL_PORT and PORTS should be set to SSL port number and SSL but I did not find out anywhere where they explain how to enable SSL.



Do we enable SSL the same way we enable it or SQL Server 2005 or does that have to be done through the MMC - Certificates.

I don't have any IIS server running on this server, so I was wondering if IIS is a requirement to generate and import the certificate.



I appreciate your help and comments.

Bruce.

View 3 Replies View Related

Enable The CLR At Database Level Only

Jul 26, 2007

Hi,

Is there a way to allow specific databases access to the CLR. Currently, my understanding is that when this setting is enabled, it applies to all databases within the instance.

Kind regards,

Jan.

View 1 Replies View Related

Enable Ad Hoc Queries In SQL 2000

Dec 18, 2007



I am trying to enable AD HOC queries in SQL Server 2000. I have tried running the following code:




Code Block
sp_configure 'show advanced options',1
reconfigure with override
go
sp_configure 'Ad Hoc Distributed Queries',1
reconfigure with override
go





but I get the following error message:

'DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
Server: Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78
The configuration option 'Ad Hoc Distributed Queries' does not exist, or it may be an advanced option.

Valid configuration options are:'





I am logged in as administrator.

How do I enable AD HOC on this machine?

Thanks

View 1 Replies View Related

Bug With 'enable Identity Insert On'

Mar 29, 2007

I'm using sp1, tryng to copy from 2005 db to 2005 db, selecting many tables at once, delete target rows on, identity insert ON.



choosing not to optimize for many tables:

Error: 0xC0202009 at Data Flow Task, Destination - table1 [22]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK_table1'. Cannot insert duplicate key in object 'dbo.table1.".

Error: 0xC0202009 at Data Flow Task, Destination 3 - table2 [226]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

Etc., for each table



Optimizing for many tables:

Error: 0xC0202009 at {AB2253E6-28B4-4D5A-B843-236F8E53E075}, OLE DB Destination [2]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK_table1'. Cannot insert duplicate key in object 'dbo.table1.".

Information: 0x402090E0 at {AB2253E6-28B4-4D5A-B843-236F8E53E075}, OLE DB Destination [2]: The final commit for the data insertion has ended.

When I drop and recreate the tables manually and set 'identity insert on' it doesn't bring the identity field over AT ALL.

I like that MS has tried to make it easier to move many tables at once by allowing us to set 'enable identity insert' to everything at once, but it doesn't appear to work. ( I've been puzzling over how it could work, anyway...)



Before sp 1, I had to go into each table by clicking the 'edit' button, and it would bring the correct identity value over, but the tables would no longer have the identity property on that field.



I have also tried 'run as a transaction' to no avail...

View 5 Replies View Related

How To Enable Mirroring Feature?

Mar 14, 2006

Hi

When I try to mirror a database, I get an error about disability of Mirroring . I m asked to set Trace Flag to 1400 at startup.

I dont know what r startup options and cant get help on it too.

Will someone let me know how can I enable mirroring in SQL server 2005

Regards

View 1 Replies View Related

How To Enable A User Account

Sep 20, 2007



I found the the status of guest account in model database is abnormal,but i don't know how to make it active.

any suggestions?

thanks

View 3 Replies View Related

Enable User SQL Instances

Mar 8, 2007

I couldn't reply the another thread so I'm continuing here.

Was about "Enable user SQL instances" and the Report Service didn€™t started too.
How do I enable this remote connections?
And in the instalation, Should I Add a user to the SQL Server Administration Role?

And also in the step "ready to install" of the SQL Server SP2 shows the following:

The following components will be installed:

· SQL Server Database Services (Upgrade)
(Database Services, Replication, Full-Text Search)
· Reporting Services
(Reporting Services, Report Manager)
· Client Components (Upgrade)
(Connectivity Components, Management Studio Express)

Warning: Setup found that the following components that already exist are at a different service pack level than the components being installed.

Components: Microsoft SQL Server 2005 Tools Express Edition, Microsoft SQL Server 2005 Express Edition (SQLEXPRESS)

After completing setup, you must download and apply the latest SQL Server 2005 service pack to all the components.

View 1 Replies View Related

Enable And Disable Websync.log

Jan 9, 2007

Hi, is there a way how to enable / disable logging on web merge synchronization into the file websync.log? The file exists in the ISAPI folder, on some machines there are some messages, on others there is nothing. There are Timeout messages on the client during synchronization and we need to find where is the problem, if it is on the server side or if it is a network error or something else.
Thanks, Pavel

View 8 Replies View Related







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