Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 logging

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-07-27 : 02:13:13
i wrote this query,and it isnt give me any result:

SELECT message,*
FROM [dbo].[sysssislog]
WHERE message='Validation phase is beginning.'

but if i wrote this ,it give me result
SELECT message,*
FROM [dbo].[sysssislog]
WHERE message='Validation phase is beginning.
'

there is any reasone that i need to get line down(i see that lenght of message is 2048?
what i need to do ,not to get line down?

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-07-27 : 06:45:16
i think i have enter in the end, so i write select ..+char(13)+char(10)

and this still not working
Go to Top of Page
   

- Advertisement -