Doubt In SP & Raise Error

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


ADVERTISEMENT

Raise An Error In The Dataflow

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

How To Raise Error In Script

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

Raise Error On Server Side.

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

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

Raiseerror Does Not Raise Exception

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

Is There Anyway To Raise A Warning From A UDF (in Sql2000 And/or In SQL2005)

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

How To Raise Notifications In SSIS Script Tasks?

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

Sp-doubt

May 3, 2008

 frenz:
i have the following procedure:while running


EMP_SP_EmpDetails_Display 'FirstName', 'ASC'

i got the error like this: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '.'.

plz can any one solve this problem.




My procedure:


set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:
-- Create date:
-- Description:
-- =============================================
ALTER procedure [dbo].[EMP_SP_EmpDetails_Display]
-- Add the parameters for the stored procedure here
(@colum as varchar(50),@order as varchar(50))
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

declare @sqlexec varchar(1500)


-- Insert statements for procedure here
set @sqlexec=''
set @sqlexec=@sqlexec + 'SELECT EL.UserName,EL.Password, E.EmpID, E.FirstName, E.LastName, E.DesignationID, E.DepartmentID, E.Sex '
set @sqlexec=@sqlexec + 'E.DOB, E.Age, E.Address, E.Email, H.Hobby,'
set @sqlexec=@sqlexec + 'ContactNo=Case When E.phone is not null Then E.phone '
set @sqlexec=@sqlexec + 'When E.phone is null Then E.Mobile End, '
set @sqlexec=@sqlexec + 'E.DateOfjoining, D.Designation, DE.Department '
set @sqlexec=@sqlexec + 'From dbo.EMP_Tbl_Employee E '
set @sqlexec=@sqlexec + 'Inner Join dbo.EMP_Tbl_Designation D On E.DesignationID=D.DesignationID '
set @sqlexec=@sqlexec + 'Inner Join dbo.EMP_Tbl_Department DE On E.DepartmentID=DE.DepartmentID '
set @sqlexec=@sqlexec + 'Inner Join dbo.EMP_Tbl_EmployeeHobbies EH On E.EmpID=EH.EmpID '
set @sqlexec=@sqlexec + 'Inner Join dbo.EMP_Tbl_Hobby H On E.Sno=H.Sno '
set @sqlexec=@sqlexec + 'Inner Join dbo.EMP_Tbl_EmployeeLogin EL On E.Sno=EL.Sno order by '+@colum+' '+@order+''

exec(@sqlexec)

END

View 1 Replies View Related

So Doubt

Nov 4, 2003

i have some doubt that if we want to put some data in the database, is two paragraph words, so is it i need to type this two paragraph word in the database?

how i can made a paragraph in database? is it possible?

View 5 Replies View Related

Doubt

Mar 2, 2005

Hi there

I have a question here. I need to import the excel template into sql server data base tables. I did worked on the regular importing of excel spread sheets to import into the appropriate data base columns. I am not getting idea with the eacel template. My main goal is to import the excel template to sql tables and then reproduce the same template for the user in the browser. If any body can help i would really appreciate.....

View 6 Replies View Related

A Doubt

May 19, 2008

hi all

I have heard that neither SQL Server 2000 nor SQL Server 7.0 supports adding the IDENTITY property to an existing column by using a single T-SQL command .Is it true?

ok
tanx in advance

View 2 Replies View Related

Sql Doubt

Dec 12, 2005

ramesh writes "i was using oracle database in last 2 years.
presently my concern using sqlserver 2000.
so i have some doubt in sqlserver 2000.
pls answer me.

1.Give some tips T-SQL with Examples.
2.how to call .sql files in query analyser."

View 4 Replies View Related

Doubt With LSN

Jan 25, 2007

Hello,

When hourly transcation log backups are taken , is any log sequence number(LSN) generated .

I want to know if this is right or wrong.I
do the T-log backups until 10.00 pm and I do the complete DB backup at 12.00 AM. So the complete DB backup contains the DB and the T-log from 10.00 pm till 11.59 pm.

So, is my understanding right.

Thanks

View 2 Replies View Related

Doubt

Jun 5, 2007

Hi,
I have a table in my database. Now I will import the data into table from excel. Now I have Firstname,Lastname,email,phone from excel.There is a chance some email,phone can be null. Now I have to identify and update the null values with values from tables from another database which has a master table containing all values.

How to write a script?

View 4 Replies View Related

Doubt Is SQL

Mar 28, 2008

Hi guys I am new to SQL Pls help me on this...

In sql server 2005 we have ROW_NUMBER() as inbuilt function...
But i am using sql server 2000... instead of ROW_NUMBER () what is the functionality in SQL SERVER 2000. can anyone help me out in this pls...

Thnaks in advance!!!!

Thanks and Regards,
Samuel P

View 2 Replies View Related

Doubt

Jul 20, 2005

hi,How to search a word in the sqltable?.ie suppose the field name has data type nvarchar(200). From there i enter the persional address of that persion. now i want to know the information whoes are coming from particular city?. The city value can enter in the address field. how we can make search?...with regards,ks.kumar****************************************** This message was posted via http://www.sqlmonster.com** Report spam or abuse by clicking the following URL:* http://www.sqlmonster.com/Uwe/Abuse...753175428d29c27*****************************************

View 1 Replies View Related

Doubt

Jul 28, 2007

Hi,

How to retrive the health insurance claim cms form in fastest way using sql server 2005

View 1 Replies View Related

SQL Query Doubt

Jun 26, 2007

Hello:
I had a Sql query doubt. I have two tables. One is table with profile data but in this table instead of actually values it stores codes. The value of each code is stored in another table. Something like this
Profile Table
ProfileID    Title  First Name  Last Name       State
1             122          xxx          yyy                 333
So as you can see title and state both are code which are further stored in another table which is something like this
Code_ID         Code_Value
122                   Director
124                   International
333                  AZ
Now I want to replace all these codes with values. Something like this
ProfileID    Title               First Name  Last Name       State
1             Director           xxx              yyy                 AZ
I tried Case statement but it fails. I am not sure how to do this. I have hundred thousands of records to doing programmaticall slows the process. I would appreciate your help or ideas.

View 2 Replies View Related

Doubt On Recovery

Aug 9, 1999

When I try to restore a database on one server from another server, by choosing the ‘From device’ option, I am not able to see any mapped drives. So I always have to copy the backup file to my local drive before performing the restore. Is there any other way to do it?
For example, Server1 contains a database db1. A full backup, differential backup and log backups of db1 are stored in ,
D:mssql7ackupfulldb1_full.bak
D:mssql7ackupdiffdb1_diff.bak
D:mssql7ackuplogdb1_log.bak
The backup devices have been created using sp_addumpdevice.
Server2 contains a database db1.
If I need to restore a copy of db1 on server1 onto db1 of server2, I first copy
D:mssql7ackupfulldb1_full.bak
D:mssql7ackupdiffdb1_diff.bak
D:mssql7ackuplogdb1_log.bak
to a local drive on server2.
I then restore using the ‘from device’ option.
SQL Server uses NT Domain account with admin. Privileges, log on as a service rt. Etc.

Thankyou.
Praveena

View 1 Replies View Related

Doubt On Recovery

Aug 10, 1999

When I try to restore a database on one server from another server, by choosing the ‘From device’ option, I am not able to see any mapped drives. So I always have to copy the backup file to my local drive before performing the restore. Is there any other way to do it using Enterprise Manager?
For example, Server1 contains a database db1. A full backup, differential backup and log backups of db1 are stored in ,
D:mssql7ackupfulldb1_full.bak
D:mssql7ackupdiffdb1_diff.bak
D:mssql7ackuplogdb1_log.bak
The backup devices have been created using sp_addumpdevice.
Server2 contains a database db1.
If I need to restore a copy of db1 on server1 onto db1 of server2, I first copy
D:mssql7ackupfulldb1_full.bak
D:mssql7ackupdiffdb1_diff.bak
D:mssql7ackuplogdb1_log.bak
to a local drive on server2.
I then restore using the ‘from device’ option.
SQL Server uses NT Domain account with admin. Privileges, log on as a service rt. Etc.

Thankyou.
Praveena

View 1 Replies View Related

Sql Server Doubt

Aug 13, 2004

Hi all
I am using osql utility in sql server 2000 to convert data in database to excel sheet. My datas contain both english and chinese . While converting to excel sheet english datas are comming but the datas in chinese is comming like (?) this. Does any body has any idea to solve this problem. is there any way to set font in osql utility.
Note: I tried giving chinese font in excel still it is not working.
Its really urgent pls reply
thanks

View 2 Replies View Related

Installation Doubt

Apr 3, 2008

can we install a named instance first with out default instance?

The default recovery model in sql server is full or simple?

View 1 Replies View Related

Replication Doubt

Apr 13, 2008

Hello Could any one clear my doubts

1. Why it is necessary to have a primary key for a table in order to publish.
2. After setting up transactional replication can we add another table at the publisher side.If it is possible how to replicate that table.

View 2 Replies View Related

Foreign Key Doubt

Apr 15, 2008

hi al,
We normally use foreign key in a table, as a reference to a primary key in another table.
But by definition foreign key can assume null value.so my question is when we are using foreign key as null in a table.Clarification with an example would be great..
thanks in advance..

View 1 Replies View Related

Small Doubt

May 29, 2008

in command promt how to come out c drive to d drive

View 2 Replies View Related

Doubt In GROUP BY...

Jun 12, 2008

Hi All,

select MatchID, ClubID, Max(Distance) as 'MaxDist'
From dbo.TrendHALF_SECOND_POSITIONS
Where MatchID in (8,12)
Group By MatchID, ClubID

How to get the PlayerID who has max(distance),
If i do Group By MatchID, ClubID,PlayerID i can get the playerID,
But I need PlayerID, but PlayerID should not include in Group By clause

How can i achieve it..

Thanks
Ganesh

Solutions are easy. Understanding the problem, now, that's the hard part

View 5 Replies View Related

Query Doubt!!

Jun 13, 2008

Hi,

I just execute the following statement

Delete top 1 from <table name>
it is giving the error "incorrect syntax near 1"


But this statement is working fine .

Delete top (1) from <table name>

What is the differance between these statements..?

Can any can explian me..


Thanks
Lakshmi.S

View 3 Replies View Related

Query Doubt

May 28, 2007

hi folks,

i want the difference of 15 mints i.e 24.15000 but it is giving 24.45000

select (datediff(mi,'2007-04-28 14:30:14.347','2007-04-29 14:45:14.347')/60.0)

Vinod
Even you learn 1%, Learn it with 100% confidence.

View 8 Replies View Related

Doubt On Trigger

Jun 8, 2007

This is my table structure

EMPId EMpName PhoneNO
------------------------


and in my application i may change the " PhoneNo" Column for a empid.

I want to audit the PhoneNo change.

I have one more audit table say, EmpAudit where i have phoneno as a column

If there is any phoneNumber change for a particulare EMPID, i want to put a new phone no to the audit table.

How to implement this with out using INSTEADOF trigger???

View 5 Replies View Related

CREATE DB --- Doubt

Jun 21, 2007

I want to create a database,before that i want to check whether i have the permission to create a DB.(Im not creating this DB from Master)

if db_id('TEST_DB') is null
CREATE DATABASE TEST_DB.

What code i have to add before the above piece of code.So that my query shouldnt make any error like 'Permission denied..'

Thanks in Advance

View 2 Replies View Related

CREATE DB - Doubt

Jun 21, 2007

I want to create a database,before that i want to check whether i have the permission to create a DB.(Im not creating this DB from Master)

if db_id('TEST_DB') is null
CREATE DATABASE TEST_DB.

What code i have to add before the above piece of code.So that my query shouldnt make any error like 'Permission denied..'

Thanks in Advance

View 1 Replies View Related

Replication Doubt

Sep 6, 2007

Dear Experts,
i'm practicing replication with this link,
id dont know why my database engine option in server type was not enabled.
please guide me in this regard

http://blog.csdn.net/longrujun/archive/2006/06/09/783357.aspx

thank you very much

Vinod
Even you learn 1%, Learn it with 100% confidence.

View 2 Replies View Related







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