Result: SP3

Am I OK?

Ok, I was finally able to run the upgrade. I was going from SP2 (cu#9) to SP3.

Now my version is:

Microsoft SQL Server 2005 - 9.00.4035.00 (X64) ...

How I can determine which CU# we are currently running?

With SQL2005, how come when I try to execute

SELECT * FROM OPENQUERY(ADSI,'SELECT name

FROM ''LDAP://server''

WHERE objectCategory = ''Person'' AND objectClass = ''user''

I am getting

Msg 7399, Level 16, State 1,...

Thanks, I am on CU#9

I am curious to see how long it take to run the SP3 upgrade process (on average to see the expecting downtime)?

Thanks

How do we know what CU is currently running on a SQL 2005 server?

Hi,

I am trying to figure out where to download SP3 for SQL2005 64bits Standard Edition. The only one I found is for 32 bits. Can someone shoot the link...

Hi,

I am struggling trying using Transfer SQL Objects Task Editor to transfer table between 2 databases.

I just want to copies somes tables (with indexes) own by DBO. ...

As everyone, I am surprise that we are still having this issue. Meanwhile, as anyone as found a workaround?

I have and old apps that with lots of users in...

Yeah, was a pain. Hopefully I will be able to get ride of the silly script I wrote to assign role every 2 min.;)

I might have found my problem. Someone added a copy object task in a SSIS project. The default parameters were still there as for as copy role, user and...

I think I didn't explain my problem in the right way. I have some users in a database that are losing their right in the database (db_datareader). This...

Hey Greg,

You are right, I thought my colleague were trying to add the package to their project, but is was not the case.

Did you tried to use "EncryptSensitiveWithPassword"...

Hi Greg

When I set the protection level to ""EcryptAllWithPassword", my colleagues can open the packages in BIDS, but the can't run the debug mode (the green play arrow in not...

Thanks Greg for your help.

I will work on it today, and let you know. Did you tried to use "EncryptSensitiveWithPassword" instead?