-- Start T-SQL

USE msdb

EXEC sp_send_dbmail

@profile_name = 'dbmail',

@recipients = 'XYZ@abc.com',

...

The step is not coming. While clicking the setup.exe, I am getting the below message

"SQL Server setup media does not support the language of the OS or does not have...

Can you post the full error message?

SQL server agent is not client tool. SQLCMD, SSMS, BIDS, Visual studio are the tools.

I am getting the error message when clicking setup.exe(first step). Can we check it from ini files or other files where language is mentioned?

Is there any way to find out the edition and language from the SQL server media/installation files(2008R2)?

Yes, I passed the exam.

Hi,

I used the second book(Microsoft self paced training kit) and it was useful. I have not used the other one.

Yes, SP1 is applicable for Enterprise Evaluation edition as well.

Keep MAXDOP as its default value unless there is system specific requirement for this.

create table Test1 (Text nvarchar(max))

Go

insert into Test1 SELECT NCHAR(8486)

Go

select * from Test1

Use SQL server migrant assistant to deal with that.

select CStid, MIN(Price) from Tablename group by CStid

http://support.microsoft.com/kb/918992/

No easy was to take table backup as we take full backup of a database. Use BCP utility to take table backup.

There’s another way to back up a table, and...