Since you state that the problem began after changing the sa password:

In EM choose SQL Server Agent, right-click and choose Properties, Connection tab

Is the SQL Server connection using sa? If...

Sounds like the SQL Box's MSSQLSERVER Service account does not have enough permissions to the \\server-ip\folder\Accessdatabase.mdb.

Are you using the Local System account? If so grant permissions on the the folder/share...

You could play with the Services.msc settings for Recovery to attempt to start the service, however this will not account for the DC being offline for a long time as...

Unless you are running as Local Administrator, you do not have permission to write to the C:\Documents and Settings folder, try changing this to a folder that you can write...

Try this:

if object_id('tempdb.dbo.#t') is not null drop table #t

create table #t (ID int identity not null, Childid int, Siblingid int)

insert #t (Childid, Siblingid)

          select 2221, 3331

union all select 2221, 3332

union...

You say Small Business Server, what edition?

SBS 2003 Premium Edition comes with SQL Server 2000, and is licensed per seat, usually bundled with 5 User CALs, and the SBS...

How many Terminal Server sessions?

You have alocated 1/2 the server memory to SQL Server, and left the rest to be shared by the OS and Terminal Server clients, so...

Try using:

NTAUTHORITY\Authenticated Users

Instead of

Authenticated Users

Andy

Try:

SELECT UPPER(ISNULL(LEFT(f_name,1),'-')

     +ISNULL(LEFT(m_name,1),'-')

     +ISNULL(LEFT(l_name,1),'-')) AS Initials

FROM MyTable

ORDER BY Initials

<edited>

Andy

Try:

IF DB_NAME() = 'Master'

 GOTO Exit

-- REST of your script

GOTO Quit

Exit:

'**************************************************************************************'

PRINT '************** Master db is selected. Please select correct database *****************'

PRINT '**************************************************************************************'

Quit:

Andy

Add multiple HDs and you can also rotate backups offsite.

We find that for a multi-server backup solution, that a Firewire external HD provides better throughput than USB.

I use the native...

If you are stating that the use of CONVERT(varchar,ISNULL(Acct_Nbr,'')) without specifying the varchar(<length&gt is bad, I agree, however given no DDL for the table...

Try moving the addition and many of the other WHERE clause items to the JOIN ON clause. Was:

...AND TXUYUV00.UBNR=TXUYUF01.VBNR...

changed:

...AND TXUYUV00.UBNR=TXUYUF01.VBNR AND TXUYUV00.UBNR='001'...

This should help buy eliminating records early on in...

The reason for the error is the fact that you have multiple sysprocesses records added via the "join" with context_info, which you control. You are effectively asking for all sysprocess...

Place your Windows CD in the drive, choose the <cd drive>:\VALUEADD\MSFT\NET\NETBEUI folder, right-click NETNBF.INF and choose install. You will be limited in connecting to SQL Server using the named pipes...