Like this ...

SELECT *

FROM openquery([LinkedServerName],

'

SELECT ''<[LinkedServerName>'' as Instance,

SL.name AS LoginName

,LOGINPROPERTY (SL.name, ''PasswordLastSetTime'') AS PasswordLastSetTime

,LOGINPROPERTY (SL.name, ''DaysUntilExpiration'') AS DaysUntilExpiration

,DATEADD(dd,...

Hello,

Further research has confirmed that the PasswordExpiration and the DaysUntilExpiration fields will only be returned if the linked server is called from the openquery statement.

SELECT *

Thanks Jeff!

I agree ... do it right the first time.

We always provide ample memory to SQL. If SQL ever uses 80% of what we provide then we...

Backups are on a separate server.

Thanks

Ordering the following before I go home today

* HP DL585, Quad Opteron quad core processors (16 total)

* 32-GB RAM

* 72-GB 15K 6-gb transfer rate for OS

* SAN connectivity via redundant...

Good point since I intend to use the current server as our backup server (either log shipping or replication).

Thanks

Only the data file. I understand needing some free space in the DB but 14 GB seems like a lot when it is supposed to be Views and Stored...

That did it. I looked all over for roles but never looked in the msdb database.

Thanks!

Hi,

Did you ever figure out why this was happening? I am having the same issue with GP10 and SQL 2005.

Regards,

Terry

BTW - I get the same error on two servers. One that was upgraded from SQL 2000 and the other that was a fresh install.

Both are SQL 2005 Ent

Nothing changed since the initial install.

The service account was set to Builtin\NetworkService. I just now changed it to a domain account which is the same account used for the...

OK, it's installed. Thanks

I ran the SQL Baseline Security Analyzer and it returned the following issue. Any ideas?

Issue

SSIS Roles

Result

No permissions to access database

Thanks,

Terry

I have 2 new HP DL380 G5, Dual Quad-Core Xeon 3.6GHz, 14GB RAM servers that are connected to an HP SAN with 4 TB of storage. The SAN provides...