Currently no service pack exist for 2008 R2. A couple of cumulative updates has been released so far.

Have a look at the build list below.

http://www.sqlservercentral.com/articles/SQL+Server+2008+R2/70092/

Currently no service pack exist for 2008 R2. A couple of cumulative updates has been released so far.

Have a look at the build list below.

http://www.sqlservercentral.com/articles/SQL+Server+2008+R2/70092/

and that is also what i was looking for. thanks so much all!

Hi Prashant

No idea why I did not think of that but it works fine. Thanks so much, I kinda feel like kicking myself for not thinking of something so simple.

Ciao

Alternatively, you would also be able to use DbaMgr2k (for MSSQL 2000, although I have successfully connected to MSSQL2005 before) http://www.asql.biz/en/Download.aspx#DbaMgr2K. A tool I have used numerous times in the...

The from subquery just need to get aliased as well.

SELECT *

FROM (SELECT ROW_NUMBER() OVER (ORDER BY [NAME]) AS 'RW', * FROM [MASTER].[DBO].[SYSOBJECTS]) S

WHERE S.[RW] = 43

its possible the user already exists in the database and is orphaned.

--*********** REPORT ON ORPHANED USERS PER DATABASE

EXEC SP_CHANGE_USERS_LOGIN REPORT

--*********** CREATE LOGIN AND CHANGE @USER TO THE SAME. THIS WILL...

depending in which OS this is running on as well, you will need to use the file path in this format:

exec xp_cmdshell 'copy C:\Docume~1\Lucky\MyDocu~1\CKM\Test.xml c:\test.xls'

that might do the trick 🙂

i had the same error trying to install SQL 2008 Express x64 on Windows 7 Enterprise. i kept on clicking on the active install window, maximizing them as well by...