Error registering a Third Party assembly

Help.

When I try to CREATE/Register a third party assembly (dtsearchNetApi2) within SQL server I am getting an error (see below). I have the source code for dtsearchNetApi2 but it is in C++ and I would like to avoid having to extend/modify it if that is avoidable. I have written a 'wrapper' class in C# but sine it references dtsearchNetApi2.dll I can't register that dll either.

CREATE ASSEMBLY DBSEARCHNETAPI

FROM 'C:\Temp\dtsearchNetApi2.dll'

WITH PERMISSION_SET = UNSAFE

Msg 6218, Level 16, State 3, Line 2

CREATE ASSEMBLY for assembly 'dtSearchNetApi2' failed because assembly 'dtSearchNetApi2' failed verification. Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database. CLR Verifier error messages if any will follow this message

dtsearchNetApi2 has references to unmanaged code. The dtSearchNetApi2.dll is a .NET 2.0 wrapper around C++ objects exported in dten600.dll. It is implemented in MSVC++ with Managed Extensions is implemented in C++/CLI 2.0.

You can't load an unmanaged assembly into Sql Server, which means you can't have a direct reference to it from your managed assembly either. To correctly access your unmanaged assembly from within Sql Clr, you need to use P/Invoke (through DllImport) instead.

Steven

|||

Thanks for the reply Steven.

Too bad the support folks in the SQL Server 2005 support group didn't know that would have saved me a few days. :)

Burke

sql

Error reading a linked Excel spreadsheet

This problem just started happening (though the process had been working
without a problem for several months):
SQL to create link:
--if the link exists drop it
IF EXISTS (SELECT srvname FROM master.dbo.sysservers srv WHERE srv.srvid !=
0 AND srv.srvname = N'Excel')
EXEC master.dbo.sp_dropserver @.server=N'Excel', @.droplogins='droplogins'
--create the link
EXEC sp_addlinkedserver 'Excel', 'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
@.FileName, NULL, 'Excel 5.0'
--add the login
EXEC sp_addlinkedsrvlogin N'Excel', false, sa, N'ADMIN', NULL
--SQL to read linked data (which throws below error):
EXEC sp_tables_ex Excel
--(this also throws same error)
select *
INTO ExcelData
from Excel...[' + @.SheetName + ']
The link to the excel spreadsheet can be made but when you try to read the
data you get:
[OLE/DB provider returned message: Could not find installable ISAM.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: ].
I have tried the following which are suggestions from searching the internet:
1. Making sure the registry entries are there.
2. Renaming Msexcl40.dll and the opening Access and running Detect and
Repair, which placed a new Msexcl40.dll in the system32 directory
3. Restarting the SQL Server Service and restarting the server
4. I tried different excel files
I have linked to the same files used above from my local SQL server and had
no problem reading the data.
I don’t know what else to do. Can someone help me with this problem?
Harolds
Hello Harolds,
From the error message, it seems jet driver has issues. You may want to
reinstall Jet SP8 to test:
829558.KB.EN-US Information About Jet 4.0 Service Pack 8
http://support.microsoft.com/default...B;EN-US;829558
239114: How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0
http://support.microsoft.com/default...b;en-us;239114
If the issue persists, please try to reinstall MDAC to see if it helps:
1. Find the file C:\windows\inf\mdac.inf (%SYSTEMROOT%\inf\mdac.inf)
(the INF folder is hidden so you will have to make in viewable:
click on Tools, Folder options..., View, click Show hidden files and
folders).
2. Right click on the file and choose install.
3. When prompted to get file, on the Locate File dialog box that results,
click Browse. You may want to direct to Win2003 SP1 setup CD or folders
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Error reading a linked Excel spreadsheet

This problem just started happening (though the process had been working
without a problem for several months):
SQL to create link:
--if the link exists drop it
IF EXISTS (SELECT srvname FROM master.dbo.sysservers srv WHERE srv.srvid !=
0 AND srv.srvname = N'Excel')
EXEC master.dbo.sp_dropserver @.server=N'Excel', @.droplogins='droplogins'
--create the link
EXEC sp_addlinkedserver 'Excel', 'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
@.FileName, NULL, 'Excel 5.0'
--add the login
EXEC sp_addlinkedsrvlogin N'Excel', false, sa, N'ADMIN', NULL
--SQL to read linked data (which throws below error):
EXEC sp_tables_ex Excel
--(this also throws same error)
select *
INTO ExcelData
from Excel...[' + @.SheetName + ']
The link to the excel spreadsheet can be made but when you try to read the
data you get:
[OLE/DB provider returned message: Could not find installable ISAM.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: ].
I have tried the following which are suggestions from searching the internet
:
1. Making sure the registry entries are there.
2. Renaming Msexcl40.dll and the opening Access and running Detect and
Repair, which placed a new Msexcl40.dll in the system32 directory
3. Restarting the SQL Server Service and restarting the server
4. I tried different excel files
I have linked to the same files used above from my local SQL server and had
no problem reading the data.
I don’t know what else to do. Can someone help me with this problem?
HaroldsHello Harolds,
From the error message, it seems jet driver has issues. You may want to
reinstall Jet SP8 to test:
829558.KB.EN-US Information About Jet 4.0 Service Pack 8
http://support.microsoft.com/defaul...KB;EN-US;829558
239114: How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0
http://support.microsoft.com/defaul...kb;en-us;239114
If the issue persists, please try to reinstall MDAC to see if it helps:
1. Find the file C:\windows\inf\mdac.inf (%SYSTEMROOT%\inf\mdac.inf)
(the INF folder is hidden so you will have to make in viewable:
click on Tools, Folder options..., View, click Show hidden files and
folders).
2. Right click on the file and choose install.
3. When prompted to get file, on the Locate File dialog box that results,
click Browse. You may want to direct to Win2003 SP1 setup CD or folders
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi guys !!!
I have the same problem, I'm using the same version of SQL, Excel & MDAC in
my local pc and the production server, however, the issue is only in the ser
ver.
Harolds: Please keep me posted about the way you solve this.
My Best Regards.|||I never got it fixed, I moved the process to another server where the error
does not occur.
--
Harolds
"velort" wrote:

> Hi guys !!!
> I have the same problem, I'm using the same version of SQL, Excel &
> MDAC in my local pc and the production server, however, the issue is
> only in the server.
> Harolds: Please keep me posted about the way you solve this.
> My Best Regards.
>
> --
> velort
> ---
> Posted via http://www.webservertalk.com
> ---
> View this thread: http://www.webservertalk.com/message1450885.html
>

Error Processingn Cube with time dimension

The strange thing is that- i create two cubes with same data source using the same fact table and the same dimension in both cases.

However with the first one i dont define the dimension as a time dimension and the cube processes fine.

With the second cube i do define the dimension as a time dimension and then the cube processing errors. The error say attribute key cannnot be found? But it was found in the first cube?

Anyone know what might be causing this?

Thanks,

Can you try and use copy/paste functionality in BI Dev studio to make a copy of your existing cube and try to process it then?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks for the reply unfortunatly i still get he same error when i try this.

Some more information-

The error i get is that attribute key with value 0 cannot be found. i get as many of these errors as there are nulls in the fact tables date dimension key column. There arent any 0 values.

So it might be that for some reaon the nulls are converted to zeros when a date dimension is added and this throws the referential integrity errors? Please help..

Thanks,

|||

I think you guessed it right.

You need to make sure your fact table doesnt have null's in the date dimension key column.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

But surely my date dimension field can contain nulls. It is a nullable field in the OLTP system.?

i noticed this http://mgarner.wordpress.com/tag/mdx/ see the 'null = 0' post at the bottom.

|||

This is not a good practice to have a nullable key.

Although Analysis Services allows you to map null keys to Unknown member in the dimension, it is not a good idea.

To solve this problem try define a named calculation in your DSV to map null keys to some pre-defined value on the fly.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks for you reply Edward

But.

Analysis services is not converting nulls to unknown if the column is defined as a time dimension. It is converting them to zeros and raisng referential integrity errors.

Is it the case that Analysis services cubes cannot contain nullable time dimensions?

This doesnt sound right to me as date columns often signify an event and therefore a null indicates that the event hasnt occured.

Not being able to define nullable time dimensions if true is a serious flaw in analysis services 2005.

What value could i set the calculated field to in the case of nulls. Surely unknown is the right value for a null date? I certainly wouldnt want to put in someone arbitary date and presumaably it would have to be a vlaue of datetime data type?

[Edit]

Edward below is some test code which builds a test fact table and test time dim. If you define the dim as a time dim then the processing will error if you insert the null in the time dim. Note if you dont define it as a time dim it processess fine with or without the null.

Please have a look at this and let me know.

Thanks alot for all your help.

if object_id('DateDim') is not null

drop table DateDim

go

if object_id('datefact') is not null

drop table datefact

go

create table DateDim

(ID int identity, date smalldatetime)

go

insert DateDim

select getdate()

union all

select getdate()+1

union all

select getdate() +2

union all

select getdate() +3

union all

select getdate() +4

union all

select getdate() +5

create table datefact

(id int identity, datekey int , amount int)

go

insert datefact

select 1, 50

union all

select 1, 50

union all

select 3, 50

union all

select 4, 50

union all

select 5, 50

union all

select 5, 50

/*--Uncomment this so a null is insert into the time dimension reprocess the cube and it will error

union all

select null, 50

*/

sql

Error OutPut in Custom Source Component

For the Custome source Component ErrorOutput, should I go for asynchronous / synchronous Output.

If i go for synchronous output

// Create the error output.
IDTSOutput90 errorOutput = ComponentMetaData.OutputCollection.New();
errorOutput.IsErrorOut = true;
errorOutput.Name = "ErrorOutput";
errorOutput.SynchronousInputID = What Id is required here;
errorOutput.ExclusionGroup = 1;

Is it the IDTSOutput90 InPut.ID / OutPut.ID which should be assigned.

Thanks Regards

Anil

The SynchronousInputID is the ID for which the output is synchronous with, so this would be the input ID. If you write an asynchronous component then obviously you do not need to set it.|||

Hi Darren

Since I am developing a Source component I will not have any InPut.ID ?

|||

Correct, by their nature source components are asynchronous, in fact they have no inputs at all. There is no input buffer, so they must create a new output buffer which is really the definition on an asynchronous component, one that does not share the same buffer between input and output.

See Books Online "Developing a Custom Source Component "

Also take look at Books Online for the "Using Error Outputs" topic, in particular "Redirecting a Row with Asynchronous Outputs"

|||

I had a look at the Books Online "Using Error Outputs" for Asynchronous, I have add all the code thats given in there.

The Error OUT & ERROR COLUMNS ErrorColum, ErrorCode are Getting Created,

In addation to that All columns in OUTPUT should also be created Under ERROR OUT. which is not hapenning. That whould mean that I need to create error output columns, In the similar manner as we create the OutPut Columns.

Any Idea as to how to create the error output columns.

|||

Yes. In a transform or destination I would override SetUsageType to do this, add both columns at the same time., For a source you can use MapOutputColumn.

Edit - Strike, that use InsertOutputColumnAt instead.

Error OutPut in Custom Source Component

For the Custome source Component ErrorOutput, should I go for asynchronous / synchronous Output.

If i go for synchronous output

// Create the error output.
IDTSOutput90 errorOutput = ComponentMetaData.OutputCollection.New();
errorOutput.IsErrorOut = true;
errorOutput.Name = "ErrorOutput";
errorOutput.SynchronousInputID = What Id is required here;
errorOutput.ExclusionGroup = 1;

Is it the IDTSOutput90 InPut.ID / OutPut.ID which should be assigned.

Thanks Regards

Anil

The SynchronousInputID is the ID for which the output is synchronous with, so this would be the input ID. If you write an asynchronous component then obviously you do not need to set it.|||

Hi Darren

Since I am developing a Source component I will not have any InPut.ID ?

|||

Correct, by their nature source components are asynchronous, in fact they have no inputs at all. There is no input buffer, so they must create a new output buffer which is really the definition on an asynchronous component, one that does not share the same buffer between input and output.

See Books Online "Developing a Custom Source Component "

Also take look at Books Online for the "Using Error Outputs" topic, in particular "Redirecting a Row with Asynchronous Outputs"

|||

I had a look at the Books Online "Using Error Outputs" for Asynchronous, I have add all the code thats given in there.

The Error OUT & ERROR COLUMNS ErrorColum, ErrorCode are Getting Created,

In addation to that All columns in OUTPUT should also be created Under ERROR OUT. which is not hapenning. That whould mean that I need to create error output columns, In the similar manner as we create the OutPut Columns.

Any Idea as to how to create the error output columns.

|||

Yes. In a transform or destination I would override SetUsageType to do this, add both columns at the same time., For a source you can use MapOutputColumn.

Edit - Strike, that use InsertOutputColumnAt instead.

Error opening table in Windows 2003

I'm running SQL Server 2000 SP3 on Windows 2003 Server.
I can create tables, indexes, etc. in SQL Enterprise
Manager. But I'm unable to open a table to view the data
in SQL Enterprise Manager. It give me the following
error message: Provider cannot be found. It may not be
properly installed.
I've uninstalled SQL Server 2000 and re-installed it with
SP3 but still running into the same problem.
Anyone know what's going on or have any idea to correct
this error?
ThanksDid you try using Query Analyzer? How are you connecting to SQL Server
service (windows auth, sql auth)?
<tchen@.ceira.com> wrote in message
news:03a901c399be$c3fb7b20$a601280a@.phx.gbl...
> I'm running SQL Server 2000 SP3 on Windows 2003 Server.
> I can create tables, indexes, etc. in SQL Enterprise
> Manager. But I'm unable to open a table to view the data
> in SQL Enterprise Manager. It give me the following
> error message: Provider cannot be found. It may not be
> properly installed.
> I've uninstalled SQL Server 2000 and re-installed it with
> SP3 but still running into the same problem.
> Anyone know what's going on or have any idea to correct
> this error?
> Thanks

Error open/accessing a MSSQL Linked Server

Hi!

Im having the fallowing error when I try to open/access a linked server
Error:
Error 7302: Could not create an instance of OLE DB provider 'MSOLAP.2'.
OLE DB error trace [Non-interface error: CoCreate of DSO for MSOLAP.2 returned 0x80004005].

I have already tried to create the server using SEM and also with SQL syntax in ISQLW.
Code:
EXEC sp_addlinkedserver
@.server='LINKED_OLAP',
@.srvproduct='',
@.provider='MSOLAP.2',
@.datasrc='MyServerName.MyDomain,
@.catalog='MyDataBase'

Im allowed to create the linked server but I cant use it.

Information:
OS: Windows 2003EE
SQL: MSSQL 2000 + SP3a
MDAC: MDAC2.8 rtm

Thanks,
Paulowhen referring to objects defined in a linked server, you should use the convention:
servername.databasename.userid.object|||That it's not the problem for sure.|||I'd see if any of Microsoft's (http://search.microsoft.com/search/results.aspx?view=msdn&st=b&na=82&qu=0x80004005+OLAP&s=1) ideas help.

-PatP|||Thanks, but none of the links apply to.

Paulo

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 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 on Create Trigger

I have the following

CREATE TRIGGER dbo.tgrCacheCustomers
ON dbo.Customers
FOR INSERT, UPDATE, DELETE
AS
EXEC sp_makewebtask 'C:\DependencyFile.txt','SELECT top 1 CustomerId FROM customers'

and I get the following error that I dont understand:

Error 21037: [SQL-DMO] The name specified in the Text property's 'CREATE ...' statement must match the Name property, and must be followed by valid TSQL statements.

Any ideas someone?Before anyone can help, please kindly explain what you want to accomplish in:
EXEC sp_makewebtask 'C:\DependencyFile.txt','SELECT top 1 CustomerId FROM customers'

Thanks.|||

This error occurs sometimes when you renmae the trigger manually by using F2 Function key & rename. if the name doesent matches with the name specified in the trigger.

Regards
Salman Zafar

Error Msg 141 on Bulk Insert

I've got the following SP to automatically insert all files in a directory into the database:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE Imp_Header_PO_sp

@.FilePath varchar(1000) = 'D:\EBT\Outbound\',

@.WIPPath varchar(1000) = 'D:\EBT\Outbound\WIP',

@.ArchivePath varchar(1000) = 'D:\EBT\Outbound\Archive',

@.FileNameMask varchar(1000) = '*Header.txt'

AS

BEGIN

SET NOCOUNT ON;

declare @.Filename varchar(1000),

@.File varchar(1000)

declare @.cmd varchar(2000)

create table #Dir (s varchar(8000))

-- Move Header files to WIP

select @.cmd = 'move ' + @.FilePath + @.FileNameMask + ' ' + @.WIPPath

select @.cmd = 'dir /B ' + @.WIPPath + @.FileNameMask

delete #Dir

insert #Dir exec master..xp_cmdshell @.cmd

delete #Dir where s is null or s like '%not found%'

-- Import file

while exists (select * from #Dir)

begin

select @.FileName = min(s) from #Dir

select @.File = @.WIPPath + @.FileName

select @.cmd = 'bulk insert'

select @.cmd = @.cmd + ' POWebOutHeader'

select @.cmd = @.cmd + ' from'

select @.cmd = @.cmd + ' ''' + replace(@.File,'"','') + ''''

select @.cmd = @.cmd + ' with (Fieldterminator = ',')'

-- Import the data

exec (@.cmd)

-- remove filename just imported

delete #Dir where s = @.FileName

-- Archive the file

select @.cmd = 'move ' + @.WIPPath + @.FileName + ' ' + @.ArchivePath + @.FileName

exec master..xp_cmdshell @.cmd

end

drop table #Dir

END

GO

When I try to execute the code, I get the following error, on this line: select @.cmd = @.cmd + ' with (Fieldterminator = ',')'

Msg 141, Level 15, State 1, Procedure Imp_Header_PO_sp, Line 46

A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.

I've tried to find a fix for this error, but it seams to only relate to a select statement and not a Bulk Insert. Can someone please help me figure out how to fix this error?

Thanks,

Laura

Causes:

This error occurs when you are assigning the column values from a SELECT statement into local variables but not all columns are assigned to a corresponding local variable.

|||

The error occurs because you need to double your quotes

select @.cmd = @.cmd + ' with (Fieldterminator = '','')'

instead of

select @.cmd = @.cmd + ' with (Fieldterminator = ',')'

Run these 2 example to see the error

declare @.cmd varchar(50)
select @.cmd =''
select @.cmd = @.cmd + ' with (Fieldterminator = ',')'
print @.cmd

declare @.cmd varchar(50)
select @.cmd =''
select @.cmd = @.cmd + ' with (Fieldterminator = '','')'
print @.cmd

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||You are awesome! Thanks!

Error Msg

On Feb 8, 4:19 pm, "Michael" <michae...@.gmail.com> wrote:
> Hi,
> If I use SQL Server Agent-Jobs to create a job agent to run a stored
> procedure. Where the error message from the stored procedure will go
> to? Say, I set the job from today to tomorrow, running every hour.
> Thanks!
> Mike
What I mean here Error Msg is the text I use RAISEERROR to put in the
output window. Where the text message will go if I use job agent?
Thanks,
Mike
Michael,
If you view job history and click "Show step details", you will see the
errors and messages in the text box at the bottom of the window. There is a
limit to what you can see here if there are a lot of messages or errors. You
can also:
select message from the msdb..sysjobhistory table
(watch the date and time columns, they are funky and will have to be
converted).
If you want to store it all for later review, send the text out to a file.
Edit a job step and open the Advanced tab and you'll see a place for file
name and a check box to determine if you should append to the file or not.
-- Bill
"Michael" <michaelnx@.gmail.com> wrote in message
news:1170970322.522398.278850@.q2g2000cwa.googlegro ups.com...
> On Feb 8, 4:19 pm, "Michael" <michae...@.gmail.com> wrote:
> What I mean here Error Msg is the text I use RAISEERROR to put in the
> output window. Where the text message will go if I use job agent?
> Thanks,
> Mike
>

Error Msg

Hi,
If I use SQL Server Agent-Jobs to create a job agent to run a stored
procedure. Where the error message from the stored procedure will go
to? Say, I set the job from today to tomorrow, running every hour.
Thanks!
MikeOn Feb 8, 4:19 pm, "Michael" <michae...@.gmail.com> wrote:
> Hi,
> If I use SQL Server Agent-Jobs to create a job agent to run a stored
> procedure. Where the error message from the stored procedure will go
> to? Say, I set the job from today to tomorrow, running every hour.
> Thanks!
> Mike
What I mean here Error Msg is the text I use RAISEERROR to put in the
output window. Where the text message will go if I use job agent?
Thanks,
Mike|||Michael,
If you view job history and click "Show step details", you will see the
errors and messages in the text box at the bottom of the window. There is a
limit to what you can see here if there are a lot of messages or errors. You
can also:
select message from the msdb..sysjobhistory table
(watch the date and time columns, they are funky and will have to be
converted).
If you want to store it all for later review, send the text out to a file.
Edit a job step and open the Advanced tab and you'll see a place for file
name and a check box to determine if you should append to the file or not.
-- Bill
"Michael" <michaelnx@.gmail.com> wrote in message
news:1170970322.522398.278850@.q2g2000cwa.googlegroups.com...
> On Feb 8, 4:19 pm, "Michael" <michae...@.gmail.com> wrote:
> What I mean here Error Msg is the text I use RAISEERROR to put in the
> output window. Where the text message will go if I use job agent?
> Thanks,
> Mike
>

Error Msg

Hi,
If I use SQL Server Agent-Jobs to create a job agent to run a stored
procedure. Where the error message from the stored procedure will go
to? Say, I set the job from today to tomorrow, running every hour.
Thanks!
MikeOn Feb 8, 4:19 pm, "Michael" <michae...@.gmail.com> wrote:
> Hi,
> If I use SQL Server Agent-Jobs to create a job agent to run a stored
> procedure. Where the error message from the stored procedure will go
> to? Say, I set the job from today to tomorrow, running every hour.
> Thanks!
> Mike
What I mean here Error Msg is the text I use RAISEERROR to put in the
output window. Where the text message will go if I use job agent?
Thanks,
Mike|||Michael,
If you view job history and click "Show step details", you will see the
errors and messages in the text box at the bottom of the window. There is a
limit to what you can see here if there are a lot of messages or errors. You
can also:
select message from the msdb..sysjobhistory table
(watch the date and time columns, they are funky and will have to be
converted).
If you want to store it all for later review, send the text out to a file.
Edit a job step and open the Advanced tab and you'll see a place for file
name and a check box to determine if you should append to the file or not.
-- Bill
"Michael" <michaelnx@.gmail.com> wrote in message
news:1170970322.522398.278850@.q2g2000cwa.googlegroups.com...
> On Feb 8, 4:19 pm, "Michael" <michae...@.gmail.com> wrote:
>> Hi,
>> If I use SQL Server Agent-Jobs to create a job agent to run a stored
>> procedure. Where the error message from the stored procedure will go
>> to? Say, I set the job from today to tomorrow, running every hour.
>> Thanks!
>> Mike
> What I mean here Error Msg is the text I use RAISEERROR to put in the
> output window. Where the text message will go if I use job agent?
> Thanks,
> Mike
>

Error messages 1910; cannot create more than 250 indexes in one table

Hi all,
I am having problems to rebuild or create a new index at SQL server 6.5. It
is always give me error message:1910 " cannot create more than 250 indexes i
n one table. While I am only having 5 indexes in this table. I really don't
know what's went wrong sinc
e it was alright for all this years.
I really need help to deal with this problem since the table is the main tra
nsaction in our application system.
Thanks in advance run sp_help tablename
and put the output here so that myself or even our fellow newsgroup friends
can get more idea about the error
also check this link
http://msdn.microsoft.com/library/d...serr_1_733k.asp
Regards,
MD
"Femmy" <anonymous@.discussions.microsoft.com> wrote in message
news:9BC246D8-38BF-40DE-AF28-341F23C8DB2E@.microsoft.com...
> Hi all,
> I am having problems to rebuild or create a new index at SQL server 6.5.
It is always give me error message:1910 " cannot create more than 250
indexes in one table. While I am only having 5 indexes in this table. I
really don't know what's went wrong since it was alright for all this years.
> I really need help to deal with this problem since the table is the main
transaction in our application system.
> Thanks in advance |||Here is the output of sp_help tablename
Name Owner Type
When_created
-- -- --
--- --
--
mc_admission dbo user table
3 Sep 1998 7:06PM
Data_located_on_segment
--
default
Column_name Type Length Prec S
cale Nullable TrimTrailingBlanks
FixedLenNullInSource
-- -- -- -- -
-- -- --
--
ac_no char 10
no yes
no
ur_no char 10
no yes
no
bill_no char 10
no yes
no
bill_date datetime 8
no (n/a)
(n/a)
appr_no char 10
yes yes
yes
adm_type char 2
no yes
no
co_code char 5
no yes
no
mem_code char 5
no yes
no
mem_name varchar 40
yes yes
no
cl_code char 5
no yes
no
adm_doc char 6
no yes
no
ref_fr_doc_code char 6
yes yes
yes
ref_to_doc_code char 6
yes yes
yes
adm_date datetime 8
no (n/a)
(n/a)
dischg_date datetime 8
yes (n/a)
(n/a)
room_no char 5
no yes
no
bill_amt float 8 53 (
null)no (n/a)
(n/a)
bill_gst float 8 53 (
null)no (n/a)
(n/a)
pay_amt float 8 53 (
null)no (n/a)
(n/a)
pay_gst float 8 53 (
null)no (n/a)
(n/a)
oc_code1 char 5
no yes
no
oc_code2 char 5
yes yes
yes
oc_code3 char 5
yes yes
yes
anc_type char 2
yes yes
yes
ipa_stat char 2
yes yes
yes
Identity Seed In
crement
-- --- --
---
No identity column defined. (null) (n
ull)
index_name index_description
index_keys
-- ----
- ----
----
--
----
--
i_admission0 nonclustered located on default
ur_no
i_admission3 nonclustered located on default
adm_date
i_admission2 nonclustered located on default
adm_type
(1 row(s) affected)
No constraints have been defined for this object.
No foreign keys reference this table.|||I'd run consistency checks against the database:
DBCC CHECKDB
DBCC CHECCATALOG
DBCC NEWALLOC
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Femmy" <anonymous@.discussions.microsoft.com> wrote in message
news:9BC246D8-38BF-40DE-AF28-341F23C8DB2E@.microsoft.com...
> Hi all,
> I am having problems to rebuild or create a new index at SQL server 6.5.
It is always give me error message:1910 " cannot create more than 250
indexes in one table. While I am only having 5 indexes in this table. I
really don't know what's went wrong since it was alright for all this years.
> I really need help to deal with this problem since the table is the main
transaction in our application system.
> Thanks in advance

Error messages 1910; cannot create more than 250 indexes in one table

Hi all
I am having problems to rebuild or create a new index at SQL server 6.5. It is always give me error message:1910 " cannot create more than 250 indexes in one table. While I am only having 5 indexes in this table. I really don't know what's went wrong since it was alright for all this years.
I really need help to deal with this problem since the table is the main transaction in our application system
Thanks in advance :)run sp_help tablename
and put the output here so that myself or even our fellow newsgroup friends
can get more idea about the error
also check this link
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_733k.asp
Regards,
MD
"Femmy" <anonymous@.discussions.microsoft.com> wrote in message
news:9BC246D8-38BF-40DE-AF28-341F23C8DB2E@.microsoft.com...
> Hi all,
> I am having problems to rebuild or create a new index at SQL server 6.5.
It is always give me error message:1910 " cannot create more than 250
indexes in one table. While I am only having 5 indexes in this table. I
really don't know what's went wrong since it was alright for all this years.
> I really need help to deal with this problem since the table is the main
transaction in our application system.
> Thanks in advance :)|||Here is the output of sp_help tablenam
Name Owner Type When_created
-- -- --- --
mc_admission dbo user table 3 Sep 1998 7:06PM
Data_located_on_segment
--
default
Column_name Type Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource
-- -- -- -- -- -- -- --
ac_no char 10 no yes no
ur_no char 10 no yes no
bill_no char 10 no yes no
bill_date datetime 8 no (n/a) (n/a)
appr_no char 10 yes yes yes
adm_type char 2 no yes no
co_code char 5 no yes no
mem_code char 5 no yes no
mem_name varchar 40 yes yes no
cl_code char 5 no yes no
adm_doc char 6 no yes no
ref_fr_doc_code char 6 yes yes yes
ref_to_doc_code char 6 yes yes yes
adm_date datetime 8 no (n/a) (n/a)
dischg_date datetime 8 yes (n/a) (n/a)
room_no char 5 no yes no
bill_amt float 8 53 (null)no (n/a) (n/a)
bill_gst float 8 53 (null)no (n/a) (n/a)
pay_amt float 8 53 (null)no (n/a) (n/a)
pay_gst float 8 53 (null)no (n/a) (n/a)
oc_code1 char 5 no yes no
oc_code2 char 5 yes yes yes
oc_code3 char 5 yes yes yes
anc_type char 2 yes yes yes
ipa_stat char 2 yes yes yes
Identity Seed Increment
-- --- ---
No identity column defined. (null) (null)
index_name index_description index_keys
-- --- -----------
i_admission0 nonclustered located on default ur_no
i_admission3 nonclustered located on default adm_date
i_admission2 nonclustered located on default adm_type
(1 row(s) affected)
No constraints have been defined for this object.
No foreign keys reference this table.|||I'd run consistency checks against the database:
DBCC CHECKDB
DBCC CHECCATALOG
DBCC NEWALLOC
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Femmy" <anonymous@.discussions.microsoft.com> wrote in message
news:9BC246D8-38BF-40DE-AF28-341F23C8DB2E@.microsoft.com...
> Hi all,
> I am having problems to rebuild or create a new index at SQL server 6.5.
It is always give me error message:1910 " cannot create more than 250
indexes in one table. While I am only having 5 indexes in this table. I
really don't know what's went wrong since it was alright for all this years.
> I really need help to deal with this problem since the table is the main
transaction in our application system.
> Thanks in advance :)

Error Message. Please help

I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named <name> already exists"
Thank You
Try refreshing enterprise manger.
Regards
Amish Shah
|||I used the right mouse button and clicked REFRESH.
and nothing happened.
Anything else I can try?
Thanks
"amish" <shahamishm@.gmail.com> wrote in message
news:1143649651.420463.246200@.v46g2000cwv.googlegr oups.com...
> Try refreshing enterprise manger.
>
> Regards
> Amish Shah
>
|||I have found disconnecting from the server and/or shutting down EM helps.
Joseph R.P. Maloney, CSP,CCP,CDP
"Shayaan Siddiqui" wrote:

> I used the right mouse button and clicked REFRESH.
> and nothing happened.
> Anything else I can try?
> Thanks
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1143649651.420463.246200@.v46g2000cwv.googlegr oups.com...
>
>
|||How do you do this?
Do you click the "X" or is there another process?
Shayaan
"jrpm" <jrpm@.discussions.microsoft.com> wrote in message
news:9576EDFF-5EF4-4944-8B59-EF4422D1A05F@.microsoft.com...[vbcol=seagreen]
>I have found disconnecting from the server and/or shutting down EM helps.
> --
> Joseph R.P. Maloney, CSP,CCP,CDP
>
> "Shayaan Siddiqui" wrote:
|||Any suggestions?
Thanks
"Shayaan Siddiqui" <givethis@.mac.com> wrote in message news:e2hL$h0UGHA.5884@.TK2MSFTNGP14.phx.gbl...
I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named <name> already exists"
Thank You

Error Message. Please help

I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to cre
ate the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Ther
e is already an object named <name> already exists"
Thank YouTry refreshing enterprise manger.
Regards
Amish Shah|||I used the right mouse button and clicked REFRESH.
and nothing happened.
Anything else I can try?
Thanks
"amish" <shahamishm@.gmail.com> wrote in message
news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
> Try refreshing enterprise manger.
>
> Regards
> Amish Shah
>|||I have found disconnecting from the server and/or shutting down EM helps.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Shayaan Siddiqui" wrote:

> I used the right mouse button and clicked REFRESH.
> and nothing happened.
> Anything else I can try?
> Thanks
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
>
>|||How do you do this?
Do you click the "X" or is there another process?
Shayaan
"jrpm" <jrpm@.discussions.microsoft.com> wrote in message
news:9576EDFF-5EF4-4944-8B59-EF4422D1A05F@.microsoft.com...[vbcol=seagreen]
>I have found disconnecting from the server and/or shutting down EM helps.
> --
> Joseph R.P. Maloney, CSP,CCP,CDP
>
> "Shayaan Siddiqui" wrote:
>|||Any suggestions?
Thanks
"Shayaan Siddiqui" <givethis@.mac.com> wrote in message news:e2hL$h0UGHA.5884
@.TK2MSFTNGP14.phx.gbl...
I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to cre
ate the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Ther
e is already an object named <name> already exists"
Thank You