i took the data from the query into a temp table and then did the

select @sql=@sql+mytext from #res

print @sql

works fine

if you take out the assertion and just return a recordset it works fine - i can't see why the top clause if affecting you when concatenating into a string

initially...

nguyenhoang 18993 (5/17/2012)

---

how are you determining that the trigger did not fire ? - have you run a profiler trace to determine the data that was inserted?

No! if I action...

there seems to be some syntax issues in your code

Msg 156, Level 15, State 1, Line 28

Incorrect syntax near the keyword 'DESC'.

i think it's a cut and paste issue

why would it matter if the column is empty ?

your trigger will fire in the following way

if records are instered or update where isNull(ChungTuKho.TenForm,'')<>'DieuChuyenKho') then perform block of code 1

else perform block of code 2

if it's not firing...

do you have service broker enabled ? if so have a look at the queues and see what is in there .

Ramana P (5/17/2012)

---

Hi All,

I have table like this,

while I am altering the column, datetime to Int , it is throwing error.

I doesn't have any data in table '

GO

CREATE TABLE tblConvert(ID...

also have a look at the performance condition alerts - such as lock wait time, deadlocks per second etc

you need to do the following

1) ensure database mail is configured

2) go into sql server agent and set up an operator with your email address

3)in sql agent set up an...

can you post the error log that it created in the backup directory

can you clarify what you mean by file lock please?

have a look at this article recently posted

http://www.simple-talk.com/sql/t-sql-programming/the-tsql-of-csv-comma-delimited-of-errors/

i...

you should read the MS documentation

http://msdn.microsoft.com/en-us/library/ms189852.aspx

look at the article and take note of the configurations involving witnesses

also look at high safety mode and high performance mode - i think you...

krypto69 (5/16/2012)

---

Yes, our users would be re-directed to the server in the other state when there is a chance of a hurricane (florida).

Do I still want to look at Db...