Error on Creating publication

Hi all, when I create publication with New Publication Wizard. I get the following errors. Did someone meet this before? Can you help me? Thanks!

===================================

SQL Server could not create publication 'JK'. (New Publication Wizard)

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Program Location:

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand)
at Microsoft.SqlServer.Replication.ReplicationObject.ExecCommand(String commandIn)
at Microsoft.SqlServer.Replication.ReplicationObject.CommonCreate()
at Microsoft.SqlServer.Replication.Publication.Create()
at Microsoft.SqlServer.Management.UI.CreatePublicationWizard.CreatePublicationThreadMethod()

===================================

Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction.
Changed database context to 'Test'. (.Net SqlClient Data Provider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=3933&LinkId=20476

Server Name: nxstudio-david\sql2k5_dc
Error Number: 3933
Severity: 16
State: 1
Procedure: sp_addmergepublication
Line Number: 1034

Program Location:

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

Try setting remote proc trans to 0. i.e.

exec sp_configure 'remote proc trans', 0

go

However you may have custom apps that depend on this being enabled, if so, be careful when flipping this switch.

|||

Greg, Thanks!

I try to follow your instruction, but I get the following message.

"Configuration option 'remote proc trans' changed from 0 to 0. Run the RECONFIGURE statement to install."

It seems the original value is 0 too.

Error on creating new Integration Services project in VS2005

I am creating my first Integration Services project and am getting an
error immediately after creating the project. The error is in the
designer and it displays a red X, saying "Microsoft Visual Studio is
unable to load this document: Object reference not set to an instance
of an object". Clicking on the error in the error window just opens up
the xml file which contains the following:
<?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
DTS:Name="VersionComments"></DTS:Property><DTS:Property
DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
DTS:Property><DTS:Property DTS:Name="PackageType">5</
DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
DTS:Property><DTS:Property
DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
DTS:Property><DTS:Property DTS:Name="Disabled">0</
DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
DTS:Property><DTS:Property DTS:Name="FilterKind">1</
DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
DTS:Property></DTS:LoggingOptions><DTS:Property
DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
DTS:Property><DTS:Property DTS:Name="Description"></
DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
DTS:Property></DTS:Executable>
I have VS2005 SP1, running WindowsXP SP2. Inegration services is
running on the Sql Server on my machine, but this shouldn't matter
anyway as the error is happening before I have even indicated and data
source to use.
Any ideas?
Thanks,
Marcus
I just uninstalled/reinstalled VS2005 and SP1 and STILL have the same
problem! If this project is moved to another machine, it produces no
errors. Is there something wrong with the manner in which xml is
parsed in my version of VS? I tried re-registering Msxml3.dll, but
still no go. What could be going on here?!?!
Thanks for any feedback.
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> I am creating my first Integration Services project and am getting an
> error immediately after creating the project. The error is in the
> designer and it displays a red X, saying "Microsoft Visual Studio is
> unable to load this document: Object reference not set to an instance
> of an object". Clicking on the error in the error window just opens up
> the xml file which contains the following:
> <?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Integration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus
|||The version of SQL Server 2005 I am running on my machine is SP2
(version 9.00.3054.00 from Mar 23 2007).
[vbcol=seagreen]
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> I am creating my first Integration Services project and am getting an
> error immediately after creating the project. The error is in the
> designer and it displays a red X, saying "Microsoft Visual Studio is
> unable to load this document: Object reference not set to an instance
> of an object". Clicking on the error in the error window just opens up
> the xml file which contains the following:
> <?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus
|||The version of SQL Server 2005 I am running on my machine is SP2
(version 9.00.3054.00 from Mar 23 2007).
[vbcol=seagreen]
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> I am creating my first Integration Services project and am getting an
> error immediately after creating the project. The error is in the
> designer and it displays a red X, saying "Microsoft Visual Studio is
> unable to load this document: Object reference not set to an instance
> of an object". Clicking on the error in the error window just opens up
> the xml file which contains the following:
> <?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus
|||Anybody? I hope I am not all alone on this one. Yikes!
M.
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> I am creating my first Integration Services project and am getting an
> error immediately after creating the project. The error is in the
> designer and it displays a red X, saying "Microsoft Visual Studio is
> unable to load this document: Object reference not set to an instance
> of an object". Clicking on the error in the error window just opens up
> the xml file which contains the following:
> <?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus

Error on creating new Integration Services project in VS2005

I am creating my first Integration Services project and am getting an
error immediately after creating the project. The error is in the
designer and it displays a red X, saying "Microsoft Visual Studio is
unable to load this document: Object reference not set to an instance
of an object". Clicking on the error in the error window just opens up
the xml file which contains the following:
<?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
DTS:Name="VersionComments"></DTS:Property><DTS:Property
DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
DTS:Property><DTS:Property DTS:Name="PackageType">5</
DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
DTS:Property><DTS:Property
DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
DTS:Property><DTS:Property DTS:Name="Disabled">0</
DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
DTS:Property><DTS:Property DTS:Name="FilterKind">1</
DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
DTS:Property></DTS:LoggingOptions><DTS:Property
DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
DTS:Property><DTS:Property DTS:Name="Description"></
DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
DTS:Property></DTS:Executable>
I have VS2005 SP1, running WindowsXP SP2. Inegration services is
running on the Sql Server on my machine, but this shouldn't matter
anyway as the error is happening before I have even indicated and data
source to use.
Any ideas?
Thanks,
MarcusI just uninstalled/reinstalled VS2005 and SP1 and STILL have the same
problem! If this project is moved to another machine, it produces no
errors. Is there something wrong with the manner in which xml is
parsed in my version of VS? I tried re-registering Msxml3.dll, but
still no go. What could be going on here?!?!
Thanks for any feedback.
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> I am creating my first Integration Services project and am getting an
> error immediately after creating the project. The error is in the
> designer and it displays a red X, saying "Microsoft Visual Studio is
> unable to load this document: Object reference not set to an instance
> of an object". Clicking on the error in the error window just opens up
> the xml file which contains the following:
> <?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Integration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||The version of SQL Server 2005 I am running on my machine is SP2
(version 9.00.3054.00 from Mar 23 2007).
>>sigh<<
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> I am creating my first Integration Services project and am getting an
> error immediately after creating the project. The error is in the
> designer and it displays a red X, saying "Microsoft Visual Studio is
> unable to load this document: Object reference not set to an instance
> of an object". Clicking on the error in the error window just opens up
> the xml file which contains the following:
> <?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||The version of SQL Server 2005 I am running on my machine is SP2
(version 9.00.3054.00 from Mar 23 2007).
>>sigh<<
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> I am creating my first Integration Services project and am getting an
> error immediately after creating the project. The error is in the
> designer and it displays a red X, saying "Microsoft Visual Studio is
> unable to load this document: Object reference not set to an instance
> of an object". Clicking on the error in the error window just opens up
> the xml file which contains the following:
> <?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||Anybody? I hope I am not all alone on this one. Yikes!
M.
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> I am creating my first Integration Services project and am getting an
> error immediately after creating the project. The error is in the
> designer and it displays a red X, saying "Microsoft Visual Studio is
> unable to load this document: Object reference not set to an instance
> of an object". Clicking on the error in the error window just opens up
> the xml file which contains the following:
> <?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||I just reinstalled SQL Server and applied the most recent service
pack. Still no go. Anyone?
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> I am creating my first Integration Services project and am getting an
> error immediately after creating the project. The error is in the
> designer and it displays a red X, saying "Microsoft Visual Studio is
> unable to load this document: Object reference not set to an instance
> of an object". Clicking on the error in the error window just opens up
> the xml file which contains the following:
> <?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||On Mon, 20 Aug 2007 22:13:29 -0000, Marcus <holysmokes99@.hotmail.com>
wrote:
>I just reinstalled SQL Server and applied the most recent service
>pack. Still no go. Anyone?
>Marcus
I suggest asking in microsoft.public.sqlserver.integrationsvcs, rather
than in the .server group.
Roy Harvey
Beacon Falls, CT

Error on creating new Integration Services project in VS2005

I am creating my first Integration Services project and am getting an
error immediately after creating the project. The error is in the
designer and it displays a red X, saying "Microsoft Visual Studio is
unable to load this document: Object reference not set to an instance
of an object". Clicking on the error in the error window just opens up
the xml file which contains the following:
<?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
DTS:Name="VersionComments"></DTS:Property><DTS:Property
DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
DTS:Property><DTS:Property DTS:Name="PackageType">5</
DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
DTS:Property><DTS:Property
DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
DTS:Property><DTS:Property DTS:Name="Disabled">0</
DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
DTS:Property><DTS:Property DTS:Name="FilterKind">1</
DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
DTS:Property></DTS:LoggingOptions><DTS:Property
DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
DTS:Property><DTS:Property DTS:Name="Description"></
DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
DTS:Property></DTS:Executable>
I have VS2005 SP1, running WindowsXP SP2. Inegration services is
running on the Sql Server on my machine, but this shouldn't matter
anyway as the error is happening before I have even indicated and data
source to use.
Any ideas?
Thanks,
MarcusI just uninstalled/reinstalled VS2005 and SP1 and STILL have the same
problem! If this project is moved to another machine, it produces no
errors. Is there something wrong with the manner in which xml is
parsed in my version of VS? I tried re-registering Msxml3.dll, but
still no go. What could be going on here?!?!
Thanks for any feedback.
Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> I am creating my first Integration Services project and am getting an
> error immediately after creating the project. The error is in the
> designer and it displays a red X, saying "Microsoft Visual Studio is
> unable to load this document: Object reference not set to an instance
> of an object". Clicking on the error in the error window just opens up
> the xml file which contains the following:
> <?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Integration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||The version of SQL Server 2005 I am running on my machine is SP2
(version 9.00.3054.00 from Mar 23 2007).

Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:[vbcol=seagreen]
> I am creating my first Integration Services project and am getting an
> error immediately after creating the project. The error is in the
> designer and it displays a red X, saying "Microsoft Visual Studio is
> unable to load this document: Object reference not set to an instance
> of an object". Clicking on the error in the error window just opens up
> the xml file which contains the following:
> <?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||The version of SQL Server 2005 I am running on my machine is SP2
(version 9.00.3054.00 from Mar 23 2007).

Marcus
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:[vbcol=seagreen]
> I am creating my first Integration Services project and am getting an
> error immediately after creating the project. The error is in the
> designer and it displays a red X, saying "Microsoft Visual Studio is
> unable to load this document: Object reference not set to an instance
> of an object". Clicking on the error in the error window just opens up
> the xml file which contains the following:
> <?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus|||Anybody? I hope I am not all alone on this one. Yikes!
M.
On Aug 14, 12:28 pm, Marcus <holysmoke...@.hotmail.com> wrote:
> I am creating my first Integration Services project and am getting an
> error immediately after creating the project. The error is in the
> designer and it displays a red X, saying "Microsoft Visual Studio is
> unable to load this document: Object reference not set to an instance
> of an object". Clicking on the error in the error window just opens up
> the xml file which contains the following:
> <?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/
> SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property
> DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property
> DTS:Name="VersionComments"></DTS:Property><DTS:Property
> DTS:Name="CreatorName">BNHO1\mbell</DTS:Property><DTS:Property
> DTS:Name="CreatorComputerName">BT4WKS1361</DTS:Property><DTS:Property
> DTS:Name="CreationDate" DTS:DataType="7">8/14/2007 12:22:35 PM</
> DTS:Property><DTS:Property DTS:Name="PackageType">5</
> DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</
> DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</
> DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</
> DTS:Property><DTS:Property DTS:Name="VersionMajor">1</
> DTS:Property><DTS:Property DTS:Name="VersionMinor">0</
> DTS:Property><DTS:Property DTS:Name="VersionBuild">0</
> DTS:Property><DTS:Property
> DTS:Name="VersionGUID">{834A3ADF-377D-4F01-88DC-1E0B5424B918}</
> DTS:Property><DTS:Property DTS:Name="EnableConfig">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></
> DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</
> DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</
> DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</
> DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</
> DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</
> DTS:Property><DTS:Property DTS:Name="Disabled">0</
> DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</
> DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</
> DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</
> DTS:Property><DTS:Property DTS:Name="LocaleID">4105</
> DTS:Property><DTS:Property DTS:Name="TransactionOption">1</
> DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
> <DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</
> DTS:Property><DTS:Property DTS:Name="FilterKind">1</
> DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></
> DTS:Property></DTS:LoggingOptions><DTS:Property
> DTS:Name="ObjectName">Package</DTS:Property><DTS:Property
> DTS:Name="DTSID">{433D7504-1A63-4960-86EB-8501C7A77A37}</
> DTS:Property><DTS:Property DTS:Name="Description"></
> DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</
> DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</
> DTS:Property></DTS:Executable>
> I have VS2005 SP1, running WindowsXP SP2. Inegration services is
> running on the Sql Server on my machine, but this shouldn't matter
> anyway as the error is happening before I have even indicated and data
> source to use.
> Any ideas?
> Thanks,
> Marcus

Error on creating cube file from Excel 2003, AS 2005

Hi,

I tried to create a cube file in Excel 2003. Data source is SSAS 2005.

On the last step of wizard I get the following error:
Microsoft OLE DB Provider for Analysis Services 2005:
Query (3,2) Parser: The syntax for 'DIMENSION' is incorrect.

Seems like a bug. Is there any fix?
Tried to search google, found nothing...

SQL Server 2005 Developer SP2
Excell 2003 SP2

Thx for any tip...

certainly sounds like a bug. Can you provide a repro' that the product team can look at?

thanks,

Bala.

Error on creating cube file from Excel 2003, AS 2005

Hi,

I tried to create a cube file in Excel 2003. Data source is SSAS 2005.

On the last step of wizard I get the following error:
Microsoft OLE DB Provider for Analysis Services 2005:
Query (3,2) Parser: The syntax for 'DIMENSION' is incorrect.

Seems like a bug. Is there any fix?
Tried to search google, found nothing...

SQL Server 2005 Developer SP2
Excell 2003 SP2

Thx for any tip...

certainly sounds like a bug. Can you provide a repro' that the product team can look at?

thanks,

Bala.

Error Msg 8120

Hello all,

I am using SQL Server 2005 Express on my local machine and am having a hard time figuring out why this problem is occuring. I am creating a stored procedure just fyi. 8120 = Column 's.Spread' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. And also...Column 's.Pay End Dt' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Both of these fields are being used in an expression not actually pulled into the query. I have bolded the line that the error refers to...Here is the sql:

USE ForecastSQLDBA
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE GetHistoricalData
@.AccountName varchar(50),
@.MaxDate smalldatetime
AS
BEGIN

SELECTDivision,
SUM(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN Spread ELSE 0 END) AS [05Spread],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN Spread ELSE 0 END) AS [06Spread],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN [Bill] ELSE 0 END)/SUM(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN [Cost] ELSE 0 END) AS [05MarkUp],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN [Bill] ELSE 0 END)/SUM(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN [Cost] ELSE 0 END) AS [06MarkUp],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN [Bill] ELSE 0 END)/SUM(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN [Cost] ELSE 0 END) AS [07MarkUp],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN Spread ELSE 0 END)/SUM(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN [Emp] ELSE 0 END) AS [05SPC],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN Spread ELSE 0 END)/SUM(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN [Emp] ELSE 0 END) AS [06SPC],
SUM(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN Spread ELSE 0 END)/SUM(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN [Emp] ELSE 0 END) AS [07SPC],
SUM(CASE WHEN [Pay End Dt] = @.maxdate THEN [Bill] ELSE 0 END)/SUM(CASE [Pay End Dt] WHEN @.maxdate THEN [Cost] ELSE 0 END) AS [07CurMarkUp],
AVG(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN [Emp] ELSE 0 END) AS [05AvgEmp],
AVG(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN [Emp] ELSE 0 END) AS [06AvgEmp],
AVG(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN [Emp] ELSE 0 END) AS [07AvgEmp],
MAX(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN [Spread] ELSE 0 END) AS [05High],
MAX(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN Spread ELSE 0 END) AS [06High],
MAX(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN Spread ELSE 0 END) AS [07High],
CASE Spread WHEN MAX(CASE WHEN [Pay End Dt] BETWEEN '2005-01-01' AND '2005-12-31' THEN Spread ELSE 0 END) THEN [Pay End Dt] ELSE '' END AS [05MaxWeek],
CASE Spread WHEN MAX(CASE WHEN [Pay End Dt] BETWEEN '2006-01-01' AND '2006-12-31' THEN Spread ELSE 0 END) THEN [Pay End Dt] ELSE '' END AS [06MaxWeek],
CASE Spread WHEN MAX(CASE WHEN [Pay End Dt] BETWEEN '2007-01-01' AND @.maxdate THEN Spread ELSE 0 END) THEN [Pay End Dt] ELSE '' END AS [05MaxWeek]

FROM (SELECT Division, [Pay End Dt], Sum(isnull([SumOfNum of Emp],0)) AS Emp, SUM(isnull([SumOfNet Spread],0)) AS Spread, SUM(isnull([SumOfTotal Bill],0)) AS Bill, SUM(isnull([SumOfCost],0)) AS Cost FROM dbo.tbl_NAHistory WHERE [Generic Customer] = @.AccountName GROUP BY Division, [Pay End Dt]) AS s

GROUP BY [Division];
END

Thanks in advance,
-BOK, I was wrong...the last three CASE expressions need to go in the GROUP BY but they can't because they have aggregates. Any ideas?

error message while creating table in the database

Hi

I created database using SQL server and runs under Cassini. The creation of database is ok but I have a problem when I am creating the table in database. Whenever I execute the code to create the tables, it shows the error message like 'Server not found' or just hang there. Does anybody know why it hang while I am creating the table? Is it because of the code or it's the time out error. Pls help as I am very new to this area.

MZAre you tying to create tables in SQL Server (Query Analyzer or Enterprise Manager), or in Web Matrix, or in your web application code, or...? If you can clarify where you are experiencing problems we should be able to help.

Terri

Error message when creating replication with generated SQL scripts

Hi all SQL Replication experts :)

I have created my production server as a distributor and a publication on that server. On my backup server I have created a pull subscription. After that I have generated SQL scripts on my backup server so I can create the pull subscription anytime.

To test my script I used sp_removedbreplication 'dbname' to remove replication on the backup server. I then used the generated SQL script to create the pull subscription again. I got this error message

Job 'ProdServName_DBName-BackServName-DBName401A48AE-D8DC-4F29-A610-13916370CD0B' started successfully.
Server: Msg 208, Level 16, State 1, Procedure sp_addsubscription, Line 135
Invalid object name 'syspublications'.

What does this Error message mean and what can I do about it?

Grateful for all answers
Best,
/M

It looks like the database you are trying to add the subscription to is not the publication database. Can you confirm that the add subscription job has all the correct parameters on it?

Error message creating database

hi all,
While creating a database in SQL 2005 i get an error message like:
Create failed for Database 'Student_Course'.
(Microsoft.SqlServer.Express.Smo)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Create+Database&LinkId=20476[/url]
Program Location:
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Cr eateImpl()
at Microsoft.SqlServer.Management.Smo.Database.Create ()
at
Microsoft.SqlServer.Management.SqlManagerUI.Create DatabaseData.DatabasePrototype.ApplyChanges(Contro l marshallingControl)
at
Microsoft.SqlServer.Management.SqlManagerUI.Create Database.DoPreProcessExecution(RunType runType, ExecutionMode& executionResult)
at
Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTree ViewControl.DoPreProcessExecutionAndRunViews(RunTy pe runType)
at
Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTree ViewControl.ExecuteForSql(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)
at
Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTree ViewControl.Microsoft.SqlServer.Management.SqlMgmt .IExecutionAwareSqlControlCollection.PreProcessExe cution(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)
at
Microsoft.SqlServer.Management.SqlMgmt.ViewSwitche rControlsManager.RunNow(RunType runType, Object sender)
===================================
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
Program Location:
at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String
sqlCommand, ExecutionTypes executionType)
at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
at
Microsoft.SqlServer.Management.Smo.ExecutionManage r.ExecuteNonQuery(StringCollection queries)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.Ex ecuteNonQuery(StringCollection queries, Boolean includeDbContext)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.Cr eateImplFinish(StringCollection createQuery, ScriptingOptions so)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Cr eateImpl()
===================================
CREATE DATABASE permission denied in database 'master'. (.Net SqlClient Data
Provider)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .1399&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476[/url]
Server Name: PREM-PC\SQLEXPRESS
Error Number: 262
Severity: 14
State: 1
Line Number: 1
Program Location:
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String
methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String
sqlCommand, ExecutionTypes executionType)
Pls help me in resolving the issue.
Mail me at "prem_karuna@.hotmail.com"
thanks & rgds,
prem.
Prem,
The message that matters is: CREATE DATABASE permission denied in database
'master'.
Therefore you will need to have Create Database permissions granted to you
before you can create a database. Talk to the administrator of the SQL
Server or, if you are the administrator, grant yourself that permission.
RLF
"Prem" <Prem@.discussions.microsoft.com> wrote in message
news:3CE44971-6BB7-4350-807E-B01A35C40429@.microsoft.com...
> hi all,
> While creating a database in SQL 2005 i get an error message like:
> Create failed for Database 'Student_Course'.
> (Microsoft.SqlServer.Express.Smo)
> --
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Create+Database&LinkId=20476[/url]
> --
> Program Location:
> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Cr eateImpl()
> at Microsoft.SqlServer.Management.Smo.Database.Create ()
> at
> Microsoft.SqlServer.Management.SqlManagerUI.Create DatabaseData.DatabasePrototype.ApplyChanges(Contro l
> marshallingControl)
> at
> Microsoft.SqlServer.Management.SqlManagerUI.Create Database.DoPreProcessExecution(RunType
> runType, ExecutionMode& executionResult)
> at
> Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTree ViewControl.DoPreProcessExecutionAndRunViews(RunTy pe
> runType)
> at
> Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTree ViewControl.ExecuteForSql(PreProcessExecutionInfo
> executionInfo, ExecutionMode& executionResult)
> at
> Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTree ViewControl.Microsoft.SqlServer.Management.SqlMgmt .IExecutionAwareSqlControlCollection.PreProcessExe cution(PreProcessExecutionInfo
> executionInfo, ExecutionMode& executionResult)
> at
> Microsoft.SqlServer.Management.SqlMgmt.ViewSwitche rControlsManager.RunNow(RunType
> runType, Object sender)
> ===================================
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.Express.ConnectionInfo)
> --
> Program Location:
> at
> Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String
> sqlCommand, ExecutionTypes executionType)
> at
> Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(StringCollection
> sqlCommands, ExecutionTypes executionType)
> at
> Microsoft.SqlServer.Management.Smo.ExecutionManage r.ExecuteNonQuery(StringCollection
> queries)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.Ex ecuteNonQuery(StringCollection
> queries, Boolean includeDbContext)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.Cr eateImplFinish(StringCollection
> createQuery, ScriptingOptions so)
> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Cr eateImpl()
> ===================================
> CREATE DATABASE permission denied in database 'master'. (.Net SqlClient
> Data
> Provider)
> --
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .1399&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476[/url]
> --
> Server Name: PREM-PC\SQLEXPRESS
> Error Number: 262
> Severity: 14
> State: 1
> Line Number: 1
>
> --
> Program Location:
> at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
> Boolean breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
> exception, Boolean breakConnection)
> at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
> stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String
> methodName, Boolean async)
> at
> System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult
> result, String methodName, Boolean sendToPipe)
> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> at
> Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String
> sqlCommand, ExecutionTypes executionType)
> Pls help me in resolving the issue.
> Mail me at "prem_karuna@.hotmail.com"
> thanks & rgds,
> prem.
|||Re: "granting yourself", sorry but my sentence looks very unclear.
If you are the sysadmin on the server you will have create database rights.
However, if you are running your create database task using an alternate
login that has fewer rights, then that login will need to have additional
rights granted.
RLF
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:uRxVAjNbIHA.4344@.TK2MSFTNGP02.phx.gbl...
> Prem,
> The message that matters is: CREATE DATABASE permission denied in database
> 'master'.
> Therefore you will need to have Create Database permissions granted to you
> before you can create a database. Talk to the administrator of the SQL
> Server or, if you are the administrator, grant yourself that permission.
> RLF
> "Prem" <Prem@.discussions.microsoft.com> wrote in message
> news:3CE44971-6BB7-4350-807E-B01A35C40429@.microsoft.com...
>

Error message creating database

hi all,
While creating a database in SQL 2005 i get an error message like:
Create failed for Database 'Student_Course'.
(Microsoft.SqlServer.Express.Smo)
--
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476
--
Program Location:
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
at Microsoft.SqlServer.Management.Smo.Database.Create()
at
Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype.ApplyChanges(Control marshallingControl)
at
Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabase.DoPreProcessExecution(RunType runType, ExecutionMode& executionResult)
at
Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.DoPreProcessExecutionAndRunViews(RunType runType)
at
Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.ExecuteForSql(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)
at
Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.Microsoft.SqlServer.Management.SqlMgmt.IExecutionAwareSqlControlCollection.PreProcessExecution(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)
at
Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType runType, Object sender)
===================================
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
--
Program Location:
at
Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
sqlCommand, ExecutionTypes executionType)
at
Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
at
Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection createQuery, ScriptingOptions so)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
===================================
CREATE DATABASE permission denied in database 'master'. (.Net SqlClient Data
Provider)
--
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476
--
Server Name: PREM-PC\SQLEXPRESS
Error Number: 262
Severity: 14
State: 1
Line Number: 1
--
Program Location:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
sqlCommand, ExecutionTypes executionType)
Pls help me in resolving the issue.
Mail me at "prem_karuna@.hotmail.com"
thanks & rgds,
prem.Prem,
The message that matters is: CREATE DATABASE permission denied in database
'master'.
Therefore you will need to have Create Database permissions granted to you
before you can create a database. Talk to the administrator of the SQL
Server or, if you are the administrator, grant yourself that permission.
RLF
"Prem" <Prem@.discussions.microsoft.com> wrote in message
news:3CE44971-6BB7-4350-807E-B01A35C40429@.microsoft.com...
> hi all,
> While creating a database in SQL 2005 i get an error message like:
> Create failed for Database 'Student_Course'.
> (Microsoft.SqlServer.Express.Smo)
> --
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476
> --
> Program Location:
> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
> at Microsoft.SqlServer.Management.Smo.Database.Create()
> at
> Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype.ApplyChanges(Control
> marshallingControl)
> at
> Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabase.DoPreProcessExecution(RunType
> runType, ExecutionMode& executionResult)
> at
> Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.DoPreProcessExecutionAndRunViews(RunType
> runType)
> at
> Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.ExecuteForSql(PreProcessExecutionInfo
> executionInfo, ExecutionMode& executionResult)
> at
> Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.Microsoft.SqlServer.Management.SqlMgmt.IExecutionAwareSqlControlCollection.PreProcessExecution(PreProcessExecutionInfo
> executionInfo, ExecutionMode& executionResult)
> at
> Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType
> runType, Object sender)
> ===================================> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.Express.ConnectionInfo)
> --
> Program Location:
> at
> Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
> sqlCommand, ExecutionTypes executionType)
> at
> Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection
> sqlCommands, ExecutionTypes executionType)
> at
> Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection
> queries)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection
> queries, Boolean includeDbContext)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection
> createQuery, ScriptingOptions so)
> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
> ===================================> CREATE DATABASE permission denied in database 'master'. (.Net SqlClient
> Data
> Provider)
> --
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476
> --
> Server Name: PREM-PC\SQLEXPRESS
> Error Number: 262
> Severity: 14
> State: 1
> Line Number: 1
>
> --
> Program Location:
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection)
> at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
> methodName, Boolean async)
> at
> System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
> result, String methodName, Boolean sendToPipe)
> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> at
> Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
> sqlCommand, ExecutionTypes executionType)
> Pls help me in resolving the issue.
> Mail me at "prem_karuna@.hotmail.com"
> thanks & rgds,
> prem.|||Re: "granting yourself", sorry but my sentence looks very unclear.
If you are the sysadmin on the server you will have create database rights.
However, if you are running your create database task using an alternate
login that has fewer rights, then that login will need to have additional
rights granted.
RLF
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:uRxVAjNbIHA.4344@.TK2MSFTNGP02.phx.gbl...
> Prem,
> The message that matters is: CREATE DATABASE permission denied in database
> 'master'.
> Therefore you will need to have Create Database permissions granted to you
> before you can create a database. Talk to the administrator of the SQL
> Server or, if you are the administrator, grant yourself that permission.
> RLF
> "Prem" <Prem@.discussions.microsoft.com> wrote in message
> news:3CE44971-6BB7-4350-807E-B01A35C40429@.microsoft.com...
>> hi all,
>> While creating a database in SQL 2005 i get an error message like:
>> Create failed for Database 'Student_Course'.
>> (Microsoft.SqlServer.Express.Smo)
>> --
>> For help, click:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476
>> --
>> Program Location:
>> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
>> at Microsoft.SqlServer.Management.Smo.Database.Create()
>> at
>> Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype.ApplyChanges(Control
>> marshallingControl)
>> at
>> Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabase.DoPreProcessExecution(RunType
>> runType, ExecutionMode& executionResult)
>> at
>> Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.DoPreProcessExecutionAndRunViews(RunType
>> runType)
>> at
>> Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.ExecuteForSql(PreProcessExecutionInfo
>> executionInfo, ExecutionMode& executionResult)
>> at
>> Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.Microsoft.SqlServer.Management.SqlMgmt.IExecutionAwareSqlControlCollection.PreProcessExecution(PreProcessExecutionInfo
>> executionInfo, ExecutionMode& executionResult)
>> at
>> Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType
>> runType, Object sender)
>> ===================================>> An exception occurred while executing a Transact-SQL statement or batch.
>> (Microsoft.SqlServer.Express.ConnectionInfo)
>> --
>> Program Location:
>> at
>> Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
>> sqlCommand, ExecutionTypes executionType)
>> at
>> Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection
>> sqlCommands, ExecutionTypes executionType)
>> at
>> Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection
>> queries)
>> at
>> Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection
>> queries, Boolean includeDbContext)
>> at
>> Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection
>> createQuery, ScriptingOptions so)
>> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
>> ===================================>> CREATE DATABASE permission denied in database 'master'. (.Net SqlClient
>> Data
>> Provider)
>> --
>> For help, click:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476
>> --
>> Server Name: PREM-PC\SQLEXPRESS
>> Error Number: 262
>> Severity: 14
>> State: 1
>> Line Number: 1
>>
>> --
>> Program Location:
>> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
>> Boolean breakConnection)
>> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
>> exception, Boolean breakConnection)
>> at
>> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
>> stateObj)
>> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
>> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
>> bulkCopyHandler, TdsParserStateObject stateObj)
>> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
>> methodName, Boolean async)
>> at
>> System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
>> result, String methodName, Boolean sendToPipe)
>> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
>> at
>> Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
>> sqlCommand, ExecutionTypes executionType)
>> Pls help me in resolving the issue.
>> Mail me at "prem_karuna@.hotmail.com"
>> thanks & rgds,
>> prem.
>