I have had about 60 Servers managed from a single MSX server. The jobs included database maintenance and application jobs.

As there were 2 sites (Chicago and LA) and the...

For reference:

Why should I consider using an auxiliary numbers table?

http://www.aspfaq.com/show.asp?id=2516

See the section on usage of the numbers stable to generate date ranges:

When you need to generate a...

For reference:

Why should I consider using an auxiliary numbers table?

http://www.aspfaq.com/show.asp?id=2516

See the section on usage of the numbers stable to generate date ranges:

When you need to generate a...

For reference:

Why should I consider using an auxiliary numbers table?

http://www.aspfaq.com/show.asp?id=2516

See the section on usage of the numbers stable to generate date ranges:

When you need to generate a...

exactly

If you were attempting to concatenate two variables or columns of varchar(10), you would need to make the first column varchar(20) before concatenating:

declare @v1 varchar(10)

declare @v2 varchar(10)

set @v1 = replicate('1',...

What is the meaning of "merge" ?

Possible answeres are:

For the Warehouse table, some of the columns have a source of one staging table and a different set of columns...

Did you use SQL Server Enterprise Manager or Services to change the password ?

If you used Services, then be aware that the installation of Service Pack 4 will fail.

You MUST...

select * from INFORMATION_SCHEMA.columns

select [USERNAME]

, SUM ( CASE [STATE] WHEN 'TX' then 1 else 0 end ) as TxCount

, SUM ( CASE [STATE] WHEN 'NM' then 1 else 0 end )...

Try the PowerDesigner newsgroups via Google:

http://groups.google.com/group/sybase.public.powerdesigner.general?hl=en

P.S.

CDM is Conceptual Data Model

PDM is Physical Data Model

As OSQL.exe passes the host name, use SQL Profiler to track the event "Security Audit" --> "Audit Login Failed". For the columns, be sure to include "host name".

Perhaps...

My Books Online also has the message containing {%Z} instead of %.*ls but the actual text in sysmessages does not match.

Perhaps this has something to do with internalization(languages) ?

Try running...

"the dateformat is set at the connection level"

Yes, it can be changed at the connection level, but the default dateformat of a connection is based upon the language setting of...

Looks like a SQL Server bug to me. As your version is Service Pack 3 without any patchs, recommend you try applying Service Pack 4.

You can find a list...

Please post the output from these statements:

What is the version of SQL Server ?

exec master.dbo.xp_msver 'ProductVersion'

When were statistics last updated ?

SELECT o.name as TableName

, i.name as IndexName

, STATS_DATE(i.id, i.indid) as...