Probably - if you're curious as to how it generates the script, run a Profiler session against your spid when you script object(s) out.

MJM

Here's a simple example that will render the result you want. Please note that this will only answer whether an A-Z character exists in the string (does not do...

Meh, I like to do it MY way though and...

Take a look at the following topics on BOL or search here at SSC in the archives:

1. Log Shipping

2. Replication

3. Database Mirroring (SQL Server Enterprise, 2005+)

I am...

I would use the following in a stored procedure:

--Use array as a stored procedure argument

DECLARE @Array VARCHAR(MAX)

SET @Array = 'val1|val2|val3|val4|val5|FOO|BAR'

SET NOCOUNT ON

DECLARE

@Delimiter CHAR(1),

@CharPos INTEGER,

@ArrayValue VARCHAR(255)

SET @Delimiter = '|'

SET @CharPos =...

In addition to these great suggestions, you can always write a brute force sqlcmd script to check...

One way of doing it (without issuing an error from the RDBMS), would be to do something like this:

IF NOT EXISTS(SELECT 'X' FROM dbo.childtable t1 WHERE t1.fk_reference = 'Value you...

Jeff Moden (10/7/2009)

---

It's easier than that. To reject things that are either blank or null in VARCHAR columns, you simply need to check for anything greater than a blank...

WHERE...

No, there is not a database-wide or server wide setting for that. That's like asking for

ALTER DATABASE mydb SET REJECT_DATA_I_THINK_IS_MEANINGLESS ON

😉

I wasn't thinking earlier when I looked at your...

Like Lutz said, here it is in code:

DECLARE

@Test2Col VARCHAR(MAX)

SET @Test2Col = NULL

IF LEN(LTRIM(RTRIM(ISNULL(@Test2Col, '')))) <= 0

BEGIN

RAISERROR('Invalid value for this column.', 16, 1)

END

ELSE

BEGIN

--Do INSERT

SELECT 'INSERTING ''' +...

toparsi (10/7/2009)

---

thanks for the replies,

I did not mean was inserting null,,, but if you see nothing in the column , is it not similar to inserting unknown value. I...

Can you try to run the following using ONLY the SQL connection? This will at least make sure you...

Can your conn string be anonymized and posted?

If not, I would recommend what Melton said above and start a Profiler trace to see the duration of the query that fails....

How are you connecting to the SQL Server then?...

Is there a Timout/Connection Timout property you can set for the Progress DB connection?