Sure you can change the isolation level in a trigger. The new isolation level takes effect from that point until it's set to something else. Isolation level specified by SET...

Leave out the hints, just set the isolation level before you start the transaction. There's no good reason to use hints over the explicit isolation level.

The thing is, 0 can't be cast to a date.

DECLARE @SomeDate CHAR(8) = '0'

SELECT ISDATE(@SomeDate), CAST(@SomeDate AS DATE)

Msg 241, Level 16, State 1, Line 3

Conversion failed when converting date and/or...

LEFT/RIGHT OUTER JOIN is the newer join method, the older *= has been deprecated since 2005.

Most likely what happened here is you had corruption in the 2000 database, checkDB wasn't as good on 2000 and so missed it, after upgrade it was picked up.

Got a...

Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

That exact query returns over 13000 rows that fail the isDate check?

"It...

What does this return?

SELECT CONVERT(CHAR(8), EZACDT)

FROM SYM_SPT_SNI_01.dbo.DBA_MVX_CINACC00

WHERE EZCONO = 2

AND EZDIVI = '001'

AND ISDATE(CONVERT(CHAR(8), EZACDT)) = 0;

clintonG (3/19/2013)

---

I'm deleting Guest and I wasn't planning on giving anybody the sa. I'll also change the sa password to a GUID. I'm installing SQLExpress and if they want an...

All the details on the certs and exams: http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx

For prices and booking, you want the Prometric website.

That's not a database setting, get the developer to check the app again. SQL won't automatically close connections (I've left connections open for days or weeks)

Only way it can be...

anoop.mig29 (3/19/2013)

---

hi i know that shrinking data base increase fragmentation , so logically shrinking data files would two result in fragmentation but does shrinking log file increases fragmentation. i hope...

Typically the order of keys in teh index should be where clause first, joins second. If you have them that way round, it's going to be useful no matter whether...

A database goes offline when someone runs ALTER DATABASE <database name> SET OFFLINE or right clicks the database Tasks -> Set offline. That's a user operation. If you have a...