Raise Error WITH LOG Option Problem.
Feb 28, 2008
Hello,
We are migrating the SP from 2000 -> 2005, in my previous verriosn they are using WITH LOG option to store the error messges in to the Applicatin log and System log.When migrated to 2005 and I tried to run that i got error messgae like "Only System Administrator can specify WITH LOG option for RAISERROR command.".
Is there any possbility that without granting admin access to the developers that we can run this stored proceedure.
My DBAs dont want to provide the admin access to all developers to execute this SPs is there any work around for this problem.
please help me out.
suggest me if there any other ways to handle this situation.
I hope i will be answered by some one.
Thanks
Thanks
-----------------
Ram MCP
View 1 Replies
ADVERTISEMENT
Jan 30, 2007
Will raiserror within a procedure make a auto rollback
I have a SP like
Create procedure test
as
begin tran
insert into test values (1,'one')
raiseerror('%s',16,1,'Value Inserted')
commit tran
will the above SP make the insertion or not?.if not,pls tell me how to make the value insert into the table still
raiserror is needed.
Thanks in advance
View 2 Replies
View Related
May 23, 2006
HI, I have a lookup that find a specific row. If that row does not exist, I need to create a new one. If it exists, I need to raise an error and trap it with the "on_error" event of the dataflow in order to log it. Is there a way to raise an error and specify the error message from the dataflow? I was thinking using the conditional split and verify if the value returned from the lookup (by set the error config to ignore the error) is not or not. But how can I raise an error when the value is not null?
Thank you,
Ccote
View 1 Replies
View Related
Nov 10, 2006
I can't believe I can't find this in books online...
I have a transformation script component and I have a case where I want the object to completely fail if it is encountered. How do I code that? All my searching BOL could find is how to redirect rows to an error output which is not what I need in this case.... I'd think it would be something simple like Me.RaiseError("Something really bad happened") but I haven't found it ...
View 13 Replies
View Related
Feb 18, 1999
I was asked if you can do "raise error" from the server side. I can do it from the client side but never had to do it server side. Is it possible at all, I can't find any documents on it. I'm using 6.5, and 7.0....
View 1 Replies
View Related
Aug 16, 2006
Hi friends
i've a stored proc (sql 2005) that'll raiseerror statement when something violated.
but my C# application that calls this stored proc does not any throw exception when this happens !!
i remember visual basic used to through an exception for this type of things.
is it different in C# and how do we handle this scenario ?
Thanks for ur ideas.
View 10 Replies
View Related
Sep 12, 2006
cos RAISERROR isnt callable, but I really want to indicate a non-fatal warning to be passed back to the client (C++ code)
View 2 Replies
View Related
Mar 24, 2006
Hey guys,
I created a script task in my package that checks for filenames of files that are to be processed by the package.
for example, File.txt contains a header row of "File.txt|03252006"
what my script should do is to check whether or not the actual filename matches the header record inside..
If File.txt has a header record of "readme.txt|03252006" then the script should raise an alert or notification but not fail the package..
I am lost here.. I have no idea how to access the SSIS package's events/alerts from within my script task..
my code looks something like this:
'Get Filename from File Connection String
Dim strFile_Name As String = strFile_Conn.Substring(strFile_Conn.LastIndexOf("") + 1, strFile_Conn.Length - (strFile_Conn.LastIndexOf("") + 1))
'Get Filename from header
Dim ReadHeader As StreamReader = New StreamReader(strHeader)
Dim HeaderFileName As String = ReadHeader.ReadLine()
ReadHeader.Close()
HeaderFileName = HeaderFileName.Substring(0, HeaderFileName.IndexOf("|"))
If strFile_Name <> HeaderFileName Then
<I don't know what to put here I should raise an alert or notification that the file identification failed.>
End If
Thanks in advance guys, I hope someone would be able to help me
Kervy
View 4 Replies
View Related
Apr 27, 2008
Hi everyone In my SqlServer Management Studio Express, on start up it shows the server type option, but greyed.So that value is fixed to database engine. ( I'm trying to work on an SqlServer Compact Edition database through the SSMStudiothat's why I'm trying to get this to change.)Besides, after I connect i go to the Object Explorer, expand the server node, and go to Replication.When i expand replication, i get the "Local Subscription" option, but nothng for Publication.( I want to work on Merge Replication, that's why I desparately need Publication to work)Am i missing something here? I did not install SqlServer separately, I only have what comes bundled with the Visual Studio 2005 Setup.
View 2 Replies
View Related
Jul 20, 2005
I?m getting an error when I execute a stored procedure which is try to insert a row to a table.The error is:Server: Msg 1934, Level 16, State 1, Procedure SRV_SP_IS_EMRI_SATIRI_EKLE, Line 32INSERT failed because the following SET options have incorrect settings: 'ANSI_NULLS.'.In my sp, I insert an row to a table. But also I created a view which is select some fields from this table.(Note: Some fields are calculated fields in this view. To see if calculated fields cause this error , I didnt selec calculated fields in the view, but I?m still getting this insert error.One more note: My indexed field is an identity field also.) I think, index causes this error. But I cant find my error.Thank you for your help...To do this view, I execute this code:drop view SRV_V_GARANTILI_IS_EMRI_SATIRLARI_TgoCREATE VIEW dbo.ViewTwith SCHEMABINDING ASSELECTS.FieldA,....S. FieldHFROMdbo.TABLE SWHERE(S.FieldA = 1) AND (S. FieldB IS NULL) AND (S.FieldH IN (0,1))goSET NUMERIC_ROUNDABORT OFFGOSET ANSI_PADDING,ANSI_WARNINGS,CONCAT_NULL_YIELDS_NULL ,ARITHABORT,QUOTED_IDENTIFIER,ANSI_NULLS ONGOcreate unique clustered index ViewT_IX_FieldA on ViewT (FieldA)go****************************************** This message was posted via http://www.sqlmonster.com** Report spam or abuse by clicking the following URL:* http://www.sqlmonster.com/Uwe/Abuse...d4cddba67ade8b6*****************************************
View 7 Replies
View Related
Mar 17, 2008
Hi,
I have set the option as required oon the sequence container and the tasks in it as supposrted ..it fails saying cannot acquire connection ..In all forums they are saying need to check system properties..but i sont have the right to do so
Is there any other alternative to provide a rol;lback on failure or handle this connection error without changing systme setting..
Please Help!!!!
View 4 Replies
View Related
Jun 10, 2005
I select the option execution from a report (it's in properties option) and then raise an error which says An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.
View 29 Replies
View Related
Jan 21, 2004
I'm using a software called epi suite which is used to print id badges. The system is currently running on an access database and everything works according.
I am trying to migrate it off access to SQL 2k and have run into a problem when trying to insert data back into the system.
I can pull back data w/o any problems (to view and even print badges) but the minute I try to Save anything [New Image or change the card to unprinted], it comes back with the error:
Failed to save the card record.
Database error: Invalid attribute/option identifier
Error HY092[Microsoft][ODBC SQL Server Driver]
Has anybody ran into this type of situation before? The problem is, the company will only support access and says that SQL is a use at your own risk type of deal.
I'm new to using MS SQL so I am unsure what the best solution would be to try and find the problem. Is it possible that the software is just sending some sort of malformed query over to the database? Anything I have found on that error [HY092] seems to point in that general direction.
Thanks for your help.
View 4 Replies
View Related
Jan 28, 2014
A customer use SCSM 2012 RTM and recently they changed the password of the account that connects with the datasources that use Service Manager to generate reports. There are several datasources namely DWStagingAndConfig, ConfigurationManager, DWDataMart and other ones.The process to change the password of the account, done via web in the SSRS URL instance of Service Manager, requires to enter in the Manage option of each DataSource and replace the password with the right one in the Properties section; is a really simple step. However, after the change, the only Datasource that not allows to access again to the Manage option is DWStagingAndConfig (appears a message that points out to a report server internal error);I append a extract of the SSRS log related to the problem with this Datasource.
library!ReportServer_0-109!3024!01/22/2014-14:54:14:: Call to GetPermissionsAction(/SystemCenter/ServiceManager/DWStagingAndConfig).
library!ReportServer_0-109!8820!01/22/2014-14:54:14:: Call to GetSystemPermissionsAction().
library!ReportServer_0-109!8820!01/22/2014-14:54:14:: Call to GetSystemPropertiesAction().
library!ReportServer_0-109!8ab8!01/22/2014-14:54:15:: Call to GetDataSourceContentsAction(/SystemCenter/ServiceManager/DWStagingAndConfig).
library!ReportServer_0-109!8ab8!01/22/2014-14:54:15:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
[code]...
View 11 Replies
View Related
Feb 10, 2015
So I started a new job recently and have noticed a few strange configurations. Typically I would never mess with min memory per query option and index create memory option configuration because i just haven't seen any need to. My typical thought is that if it isn't broke... They have been modified on every single server in my environment.
From Books Online:
• This option is an advanced option and should be changed only by an experienced database administrator or certified SQL Server technician.
• The index create memory option is self-configuring and usually works without requiring adjustment. However, if you experience difficulties creating indexes, consider increasing the value of this option from its run value.
View 3 Replies
View Related
Apr 28, 2008
I have a table name “StringResources� which contains resources for different cultures. Right now, whenever admin adds any new resource, it immediately available to end user. Now the new requirement came up. We want admin to add resource first and when he is ready with all the resources for particular culture then only the resources should be available to end user.
Important: StringResource table has SQLCacheDependecy set. So any change for particular culture will invalidate the cache. This how the select statement looks.SELECT dbo.StringResources.resourceType, dbo.StringResources.cultureCode, dbo.StringResources.resourceKey, dbo.StringResources.resourceValue FROM dbo.StringResources
WHERE dbo.StringResources.cultureCode=@cultureCode
Which would be the best option below:
1> Add new Boolean column “Published� and show only resources which are published to end user.
Advantage: No need of extra table.
Disadvantage: This will invalidate the cache every time resource is added even if it’s not published.
Other option
2> Add new temporary table with same structure. When admin add new resource, add it to this temp table and when publish move resources to String Resources table.
Advantage: Admin will have separate working space. It will invalidate cache only when resources are published.
Disadvantage: Need extra table.
View 4 Replies
View Related
Sep 9, 2006
How can I get an All option into the cascading prompt?
I want to view data for all states in USA. I find I can't proceed to load report unless I have filled in a value for all prompts. Any help?
Thanks
View 1 Replies
View Related
May 19, 2008
I have a small doubt.
If we enable AWE option we can have advantage of available physical memory.we can have more memory by using max server memory property.
then why this AWE option comes in to picture.
I read bol but iam not able to understand what exactly happens.
Could any one tell me why this AWE option if we have max server memory property.
View 5 Replies
View Related
Oct 25, 2007
Hi,
What is equivalent to OPTION (RECOMPILE) in SQl Server 2000.
Create table #Employee
(
EmpId int IDENTITY,EmpName varchar(30)
)
insert into #Employee(EmpName )
select EmpName from AllEmployees
OPTION (RECOMPILE)
View 1 Replies
View Related
Feb 27, 2006
I have a vacation request app I'm designing, and it has a VacationData Table with TotalVac, UsedVac, VacLeft, VacationCarriedOver, and VacCompleted.
I need to take the VacLeft and divide by 2 and place that data in the following two spots, one in the VCO and add it to the TotalVac, which is pulled from another table w/hire date and other info.
I only need to run this on Jan 1 of every year, any suggestions?
View 2 Replies
View Related
Jul 12, 2001
I was running a query and it didn't execute stating you have run out of locks
How could I set the locks
thanks
Sejal
View 2 Replies
View Related
Oct 14, 1999
I am trying to alter a table that has an identity field to make the column have the not for replication option. I just can't seem to get the syntax down for the alter table command. PLEASE HELP. I know it can't be that hard!!!
View 2 Replies
View Related
Jan 23, 2003
Is there a Stored Procedure or something else that will tell me if a DB is set to Full or Simple recovery?
Thanks,
Ken Nicholson
View 5 Replies
View Related
Apr 27, 2001
Im trying to transfer data from SQL tbl to .xls file through a DTS package.
My problem is that DTS transfers all the data from the source tbl to .xls
file.
But i would like to have the selective data transfer based on some query like ;
select * from tbl where field ='val'
instead of complete data transfer.
Thanks in advance.
Regards
Siva
View 2 Replies
View Related
Oct 15, 2005
70-229 certification exam measures your ability to design and implement database solutions by using Microsoft SQL Server 2000 Enterprise Edition. Candidates for this exam work in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition. Candidates have at least one year of experience implementing relational databases. I don't have experience on database. Haven't experience on SQL server administration. Suggest me good one resources in low price. What are best option available in market?
View 2 Replies
View Related
Jun 6, 2006
First off, I apologize for not knowing what I'm talking about and being long winded. I'm trying to determine if SQL Server Express is an option for a client of mine. Their needs are beginning to go beyond what I'm comfortable with in Access, so I'm looking into the option of upgrading to a SQL Server Express back-end with a VB front-end.
Access doesn't require any setup beyond "File, new", so I know nothing about the background work required to get a database running on a platform like SQL Server.
My first concern is what kind of network admin rights do I need to install & use SSE..
It's unlikely that her IT group will just hand us the keys to any of their servers, so all we really have available is what we can put on her network drives. Am I right in assuming that using a SQL Server database would involve more network privileges than just dropping a file on the network and pointing my front end app at it?
With that said, I think I remember seeing something on one of the MSDN pages about setting up a database to run off of a CD-Rom. Could I somehow use this capability to get what I need?
View 6 Replies
View Related
Dec 12, 2007
Hello all
I would like to add a couple more fields that the users can query by, more options how would I add in the same stored proecedure, First Name, Date, and IR#?? so they can have the ability to run it by one field or two fields or all the above?? how would I incorporate those in the stored procedure??
CREATE PROCEDURE [SearchByDateExcls]
(@StartDate datetime,
@EndDate datetime)
AS SELECT [IR Number], Date, Inspector, Violation, [Violation Type], Loss, [Loss Type]
FROM dbo.Revised_MainTable
GROUP BY [IR Number], Date, Inspector, Violation, [Violation Type], Loss, [Loss Type]
HAVING (Date BETWEEN @StartDate AND @EndDate)
is this correct
CREATE PROCEDURE [SearchByDateExcls]
(@StartDateServed datetime,
@EndDateServed datetime, @Enter_LastName nvarchar(25), @Enter_Duration nvarchar(10))
AS SELECT IR#, [Date Served], [Reason For Exclusion], Duration, [First Name], [Last Name]
FROM [dbo].[Extended Exclusions]
GROUP BY IR#, [Date Served], [Reason For Exclusion] , Duration, [First Name], [Last Name]
HAVING (Date BETWEEN @StartDateServed AND @EndDateServed, Enter_LastName, @Enter_Duration)
View 3 Replies
View Related
May 12, 2008
Hi,
I was sreading about NOLOCK that it could prevent deadlocks but could return data which is not committed yet.
1) Should we use NOLOCK with select statements
2) If the transaction isolation level is set appropriately (e.g. Serializable)in the component (for e.g COM+ component) but NOLOCK is specified in the select then would it return uncommitted data. I mean if the transaction is controlled at hihger level then what will be the Pros and Cons of using NOLOCK.
Thanks
View 3 Replies
View Related
Aug 29, 2006
Hi there,
I am selecting few records from a particular table and however I need to run the same query using UNION.But its taking long to execute the query.If I run the query as 2 parts then it works fine but if I put in UNION to both queries then I have problem.Can anyone help?
eg:
Select '' as name,'' as userid,'' as firstname from table1 where user like 'A%'(works fine)
Select name,userid,firstname from table1 where user like 'A%'(also works fine)
but if I user
Select '' as name,'' as userid,'' as firstname from table1 where user like 'A%'
UNION
Select name,userid,firstname from table1 where user like 'A%'
its taking too long
Somebody please help me
View 10 Replies
View Related
Mar 31, 2008
Hello,
Do I need to restart service after I set recovery option
"ALTER DATABASE SET RECOVERY XXXX"
can i specify RECOVERY OPTION in CREATE DATABASE?
Thanks
View 4 Replies
View Related
Jul 20, 2005
Hi Everyone,I tried to bcp in the data file to a table in sqlserver 2000.The data file has got few blanks in certain columns.My requirement is all those blanks has to be converted null while bcpin the data.1. I have tried giving the option -k - Didn't work2. I have tried creating a format file with prefix length 2 i.e as thecolumn is character.3. Initially it was giving string data truncation error due to theservice pack3. Then I updated the service pack 3 also.Pls someone help me out as this is very critical.Thanks,Ganesh
View 1 Replies
View Related
Jul 20, 2005
I need to check if any user in the database is assigned any permissionWITH GRANT OPTION. Please let me know how do I check this. Also let meknow if assigning rights WITH GRANT OPTION is possible from enterprisemanager.Thanks in advanceKamal
View 1 Replies
View Related
Feb 21, 2007
Hello there,
I am not a company programmer but I do like to write programs for myself. I am currently looking at writing a Database program to track my DVD's, CD's Tapes and the likes (as well as quite a bit of other data). While discussing this with others it was suggested that I use MSDE (since it's free) and that way I could learn more about SQL databases at the same time.
When I connected to the MS website to download MSDE I found that it will not be supported with Vista. Since I am planning on getting a new PC which will most likley come with Vista I am now wondering what would be the best way to develop my database.
1. Should I use Access (Since it will only be accessed across my home network)?
2. Is there a version of SQL (that does not require a License fee) for Home use?
Please tell me what options I have now!.
View 1 Replies
View Related
