Hi David,

Don't know if you knew but SQL Server has it's own (A little limited) Encryption routines 'built in'. Have a look at this in QA.

pwdencrypt encrypts your password....

Hi Nancy,

There is always the 'cursorless loop' in your situation:-

Declare @WorkingVariable, @EndVariable

SET @EndVariable = SELECT MAX(distinct traceid)from ::fn_trace_getinfo(default)

SET @WorkingVariable= SELECT MIN(distinct traceid)from ::fn_trace_getinfo(default)

WHILE @WorkingVariable <= @EndVariable

BEGIN

--DO THE WORK

--INCREMENT BEFORE TESTING

SET...

Hi Sergio, Giovin,

Of course it can be done directly.

This should be a little easier to understand:-

DECLARE @SQL nvarchar(4000),

 @A_Variable varchar(100)

SET @A_Variable = 10

PRINT '1 - ' + CAST(@A_Variable as varchar(50))

BEGIN TRAN

 SET...

Hi Farrel,

Do you not do the word shortening thing where you are from? 

Bully - Bulldozer? 

Ah well, just get the avatar set and have done with it 😉

I do...

Can you give us a sample couple of lines of the data you are trying to import and a table definition for the table it is going into.

Have fun

Hi Michael,

Have a quick look through BOL - Check under keywords "character data format" and subtopic "Unicode Character Format".

Have fun

Hi Ramesh,

This sounds like a timing issue - I seem to remember having the same problem once.

Sometimes it works sometimes it doesn't - dependant on wether the entry in sysindexes...

Hi Guys n Gals,

Just to throw things out a little further.....

MSSQL 2000:-

--The middle " is a double quote - not two singles

if '"' = '"      '

 select 'equal'

else

 select 'not equal'

-- returns...

Hi Noel,

How goes it?

Go on then - for what reason would it not stand mutiple records? 

Speak to you soon

Hi CCB,

Just got to the same spot - using IS NOT NULL........

From what I can see it should work fine with multiple inspections.

Under update - If you check the next...

Hi CCB,

When you say 'it doesn't work' - are you getting anything at all? Error msg's etc?

I take it you realised the above trigger only handles Insert?

Personally - I would fire...

AFAIK? New one on me Arthur.....

As far as I am aware, the use of GoTo is to be frowned upon in 99% of circumstances except for error handling.

Normally it can be...

Cheers Frank