No, here it returns the date as it should.

2009-03-04 20:58:41.083

Thanks, but sorry, it did not help:

SET @Query = 'Update [SQLSERVER\SQLINSTANCE].[Databasename].dbo.[Tablename]

SET [Last run] =...

Ohh... I got this error because of:

EXEC @Query

I changed it to

EXEC (@Query)

But then I got

Server: Msg 8180, Level 16, State 1, Line 1

Statement(s) could not be prepared.

Server: Msg 170,...

Thanks for the reply,

It did not work...

Server: Msg 203, Level 16, State 2, Line 23

The name 'Update [SQLSERVER\SQLINSTANCE].[Database].dbo.[UploadStatus]

SET ...

It works...

I got everything to work now... Strangely enough, it will not return values from 0-31 but it works from 1-31...

So if i change the code to:

declare @Char0 char(1),...

Could it have anything to do with the version of SQL server I am using??!

For test purposes I am using SQL Express 2005 9.0.1399...

Kind regards,

Anders

I know, but by doing that you do not get keys and indexes... 😉

It wasn't... 🙁 ....

I am still pretty sure, that for some reason, the interval @char0 - @char31 is not correctly interpreted for some reason... It will still only "look" at...

This is what the query returns, if I "print @sql" instead of executing it...

select * from dbo.Test1 where isnull([Col1], '')+isnull([Col2], '')+isnull([Col3], '') like '%-]%';

Kind regards,

Anders

Hi GSquared,

I have run the code on the Test1 table you sendt.. And i can see that it contains the char values.. But it only returns char31....

For the "fun...

Hi,

Actually I just wanted to make a copy of an entire table and its design...

Kind regards,

Anders

Hi There,

I modified your code a bit, so that I can run a single table at a time, and not every table.. Well at least that is what I think...

Hmm... After testing it again, I noticed that as far as i can see, it only returns char(31)... Not the ones below... Tested in one table...

Hi GSquared,

I have been sick for some days now, so I haven't been able to try your script until now.. And thanks very much, it works splendidly on SQL 2005...

Hi,

What I need to do is:

Find out which specific rows and columns that contains ascii values below 32, and log it either in a txt file or another db.

So, basically...