Dropping the BUILTIN\Administrators will also affect the SYSTEM account, and Full text indexing.

KB for info for removal of the BUILTIN\Administrators SQL Server login:

http://support.microsoft.com/kb/317746

Andy

Change use of @@IDENTITY to SCOPE_IDENTITY() for the @MyID assignment. See BOL for the diggerences.

Andy

I would have gone for the 850 because it has the new Dual Core Pentium D Processor!

Andy

1st the syntax is BEGIN DISTRIBUTED TRAN [SACTION] not BEGIN TRAN [SACTION]

I suggest that you move this just before your loop:

DECLARE @Err int

DECLARE curMembers CURSOR FOR

  SELECT  [ID], Name,.....etc

   FROM...

Try:

SELECT A.Name, A.Email, A.Accountlevel, I.PhoneNumber

FROM Account AS A

 LEFT JOIN AdminInfo AS I ON A.<your linking field> = I.<your linking field>

  AND A.AccountLevel = 10

Andy

Look in the SQL Server Login for BUILTIN\Administrators, does it have the sysadmin role? If it is not there at all then what SQL Server login/roles are your AD accounts...

If you have removed sysadmin from BUILTIN\Administrators or removed this SQL Server login, then SYSTEM has no way to login to the SQL Server 2000 databases, see KB 317746.

I hope that this late reply can help someone:

SQL Server Migration Assistant for Oracle V2.0 Beta

http://go.microsoft.com/?linkid=3978512

Download this Oracle to SQL Server 2005/2000 Migration Toolkit (9/6/2005).

Andy

I think the problem is here:

pSalary = ((100*EE)/@EERate)

Change to:

pSalary = ((CAST(100 AS money)*EE)/@EERate),

SQL Server takes the left most value in an expression as the resulting data type, and since your...

Change Domain accounts to Local accounts for the SQL services before the DC upgrade.

You will have to change the SQL Server from a NT domain member server to a Workgroup member before...

I use Visio for Enterprise Architects that comes with Visual Studio for Enterprise Architects (2002 or 2003). This allows you to "Reverse Engineer" the MDB, then by changing the database...

Look in the Office Resource Kit for the Outlook Security template if you are using Exchange email, this allows for customizing the Security settings for MAPI (Outlook and external programs)....

EM will only show local drives, you can type in UNC paths and have it use them, just be sure that the service accounts for SQL Server / SQL Agent...

My experience is don't use USB, use Firewire instead.

I have a seperate server using Firewire to connect to the external HD, created a share on that server, then use the...

Do you have Excel installed on the server that is running the DTS and ActiveX script? From your error is seems not.

Also Close the XLS between the ActiveX and DTS,...