Hi All,

I am preparing for MCTS SQL 2008.

Please inform me, how can I take beta exam of 70-432 MCTS SQL 2008.

or

Is there any online practise test available for this paper...

I want to pass value for mutiple recipients without mentioning the mailid of the recipient as follows,

EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Test',

@recipients = @empemailid, @manageremailid, @body = @body,

@subject =...

Hi All,

Thanks for your technical information..

Cheers,

Experts,

I am having requirement to send mail(notify) to list of email id stored as 2 columns in a SQL table. I am having a plan of writting cursor to retreive...

I solved the error by mentioning appropriate values in ''suggest type" as per the article

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125290

and it worked..

BR,

Parthi

Hi Ed,

Thanks alot for the table script.

Even though the table was created with all columns of width 4000, I was faced with the below error continuously

Error 0xc020902a: Data...

Hi Ed,

Thanks alot for that and the text qualifier " was missed by me. I tried most of the option except this because I didnt understand the usage of the...

Hi Ed,

I have not configured SSIS package but was using import wizard in which I was facing the problem.

I pasted the adcollection.csv file and table definition script because in...

Yes...I changed the 'Text Qualifier' as 'Double Quote {"}' which I refered from SQL 2000 import method.

Still it was working..

Hi Elisabeth,

Thanks for your information..

I was trying to use 400 Bulk Insert commands in query analyser without BEGIN TRANSACTION....ROLLBACK\COMMIT...

I was getting error if the source text file didnt have complete...

sorry to mention, the import is successfully creating new table with all the columns but no data was being imported..

Hi All,

Thanks for your valuable information.

let me write down my understanding to get clarified again

* using DTS package we can automate the task of storing DHCP logs on SQL...

Steve/Brian,

Thanks for your information..

Yes..I am planning to import Windows DHCP log text file in SQL database. I am very concerned about parsing the log file so that data can...

Hi,

You are great and Thanks alot..Now the query is generating the result set.

Please brief me why the sub select query was causing the problem?

Hi Jackson,

Thank you...

From your reply I believe the windows updates wont have much impact on cluster setup at the registry level.

BR,

Parthipan.S