You can use the RAISERROR Statment with the NO WAIT option to achieve the behaviour you want.

ikonrao (6/6/2013)

---

We have a table in which we want to know whether any of the columns has unique constraint defined.

Or if we can get create table statement for that table,...

bgraham 64271 (6/5/2013)

---

SQLSACT (6/5/2013)

---

Have a look at...

gurjer48 (6/5/2013)

---

hi thank you for you time and reply

first we have to get knowledge.

I got that ,

I am not clarified about whether my current position in small company which...

This question is lacking...

PearlJammer1 (5/28/2013)

---

The situation has happened because whenever we need to do a datacleanse the Dev's take a backup of the table and then give it the new name, so i...

kishorefeb28 (5/29/2013)

---

Hi Experts,

i have a text file with 1 -3 lakh records and 5 columns or so.... each column is seperated by tab delimiter.

i need to import this...

I would think you're asking this in the wrong Forum. I believe there is a Forum specific to PowerPivot here.

jralston88 (5/24/2013)

---

Hello,

We're running SQL Server 2008 upgrade advisor against a SQL Server 2000 instance. When asked to identify which components to analyze, I enter the server name and click...

todd.ayers (5/28/2013)

---

I have a split database that has one Back end and 3 front ends. Is it still possible to migrate over to SQL Server even though I have...

Glad you got it sorted.

phc (5/18/2013)

---

I have gotten a bit further on by nesting a query, but I am not sure I have the distinct right

SELECT C.first_name"Provider", Count(C.provider_no) "Diabetics with over 1 BP in...

That sounds extreme and will almost certainly not solve this issue.

Not to doubt you but have you actually confirmed that you do have Foreign...

subhajeetsur (5/16/2013)

---

SQL: a language for talking to the database. It lets you select data, mutable and create database objects (like tables, views, etc.), change database settings.

T-SQL: (procedural) extensions for SQL...

I'm sorry but it looks to me like that does nothing more than assign a string to a variable.

Have you looked into the previous suggestions made?