Did you install Outlook with the Custom installation CDO option?

Did you create the profile while logged in as the service account?

Outlook profiles are stored in the user's profile (C:\Documents and Settings\<user...

Looks like you are attempting to use SQL 2005 syntax (ALTER LOGIN) on SQL 2000, use sp_password, from BOL:

Examples

A. Change the password of a login without a former password

This example...

You could add:

CREATE UNIQUE index Codes_AK ON #codes (code, email)

ALTER TABLE #codes ADD CONSTRAINT Codes_UC UNIQUE (code, email)

However both of your insert statements will fail:

-- This should pass because it's...

Here is an example of the n number of columns from rows, maybe it will ignite some sparks?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=237882#bm238057

You also might check out these examples:

How to dynamically number rows in...

From Books Online (BOL):

How to set the default language (Enterprise Manager)

To set the default language

1. Expand a server group.
2. Right-click a server, and then click Properties.
3. Click the Server Settings...

Use notepad to type, then paste to this forum, benefit is that you will still have the text to try again when the "post" in this forum fails and looses the 15...

Make sure you have MSDTC service started on all 3 servers, and that each LinkedServer has the desired permissions for the "other" servers.

Make sure that the SQL Server service accounts...

Please do not cross post, see my reply here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=131&messageid=242493#bm242763

Andy

I suggest that you look at using ADODB.Stream:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdobjstream.asp

Andy

You could use LinkedServers or OPENQUERY to reference MDB data, this is copied from the Books Online (BOL) for Distributed Query Architecture:

Ad hoc connector names

For infrequent references to...

update users set Password=left(NEWID(),8)

Andy

This script handles this:

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=764

Andy

1> msdb see the log_shipping_* tables

2a> the size of the log file

2b> the time to backup the log, copy the backup file, and restore the log backup

3> EM - ServerName...

Could RECYCLER folder cause the 2.5 TB to be actually be less?

Turn it off for that drive. I am sure that there is some scratch space required on a...

Try:

IF OBJECT_ID('dbo.udf_IsShiftValid') IS NOT NULL

        DROP FUNCTION dbo.udf_IsShiftValid

GO

CREATE FUNCTION dbo.udf_IsShiftValid

        (@StartTime datetime

        , @EndTime datetime

        , @DayTime datetime)

RETURNS int

AS

BEGIN

        DECLARE @RtValue AS int

        SET @RtValue=0 --...