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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-25 : 18:30:07
|
Fernando writes "Dear SQLTeam,
I am currently running Microsoft SQL 7.0 SP1 in a Windows NT 40/SP5 on my server.
My Vendor has informed me that the compatabilty level is SQL 6.5.As
as a result, using triggers will cause some problems due to the Compatability level currently set at 6.5.
The recomendation is to setting the Compatality level to 70. Can you provide
the syntax to perform this and are there any issues with the Dbase
after the compatibility level has been set to 70.
Please advise!" |
|
|
|
|
|
SQL 70 Compatibilty level