Mohammed,

Was wondering if you managed to find a solution to this.

Grant,

I had the same issue on my shiny new extended events deadlock capture automation I have been working on ...

I...

Weekend

weak - end

weakened

emblem

You will need to provide the table schema and provide insert scripts with sample data for anybody to help you with the script.

Completely agree with Jeff, the best way is to standardize the table names and write t-sql code and schedule as a weekly or monthly job.

Try downloading and installing Microsoft® SQL Server 2008 R2 Evaluation

No a member of database owner role will not need read and write permissions.

I would vote for using SSIS to process the data , in conjuction with SSRS for letting users subscribe to the reports.

Makes perfect sense to me !

Hey i missed out mentioning my training on youtube; There are pretty great training videos available freely on youtube; check this SSAS video by Amit Bansal http://www.youtube.com/watch?v=aglwqC8irMA

There are pretty great training videos available freely on youtube; check this out by Amit Bansal http://www.youtube.com/watch?v=aglwqC8irMA

This video gave me enough confidence with my basics.

Hi vand.erik,

I passed my exam in first attempt reading the self prep book and practicing the exercises in the book.

Additionally I am a big fan of nugget sessions. I use...

The answer is B. SQL Server Destination

the data flow task itself will transfer data from source to destination; you just need to provide the destination connection

Hope you realize this is a SQL Server 2008 - General section and the entire forum is mainly about SQL Server and not MySQL

You will need to configure the master...

Hi Deep_kkumar,

we will need to analyze the results of DBCC MEMORYSTATUS before suggesting anything. Please paste the output of DBCC MEMORYSTATUS