Re: Trying to set up a SQL Server Agent Account and I hit a wall....
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 20 May 2008 15:25:16 -0700
greenmtnsun (greenmtnsun@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
Our database is on SQL Server 2005, however it is set to compatibility
mode 80, its a thorn in my side, but a reality I am stuck with.
Not really. You can change compatibility level as you change shirts.
Set the compatibility level to 90 when set this thing up (of course,
you need to make sure that you have the database for yourself), and
then set it back to 80 when you are done.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Trying to set up a SQL Server Agent Account and I hit a wall....
- From: greenmtnsun
- Trying to set up a SQL Server Agent Account and I hit a wall....
- Prev by Date: Using CA issued Certificates for SQL Certificate Encryption
- Next by Date: RE: Msg 15404: Could not obtain information about user
- Previous by thread: Trying to set up a SQL Server Agent Account and I hit a wall....
- Next by thread: Application error event every minute on MSSQLSERVER : "Failure Audit: Login failed for user 'NT AUTHORITY\SYSTEM' [Client: <local machine>]
- Index(es):
Relevant Pages
|
