Very coool.

Thanks, that helps.

Data Sheet

Hi Lynn,

wow man you have explained it very good, I read about BI before but Now I can diffirenciate between Data Mart and Data Warehouse..thanks again for it.

I think now...

Hi ben,

If you create all the Data Sources in one folder, Do you create this folder on Operating System level or how you create it?

is it not like you have...

I see.............

Thanks

Hi Stefan,

Very nicely explained. I will follow the suggestion and will try to see if it works.

I would probably ask question again.

Data Sheet

I finally got it to work. it seems like if you check "Exclude if there is no data" option, then nothing showed up.

Thanks,

Data Sheet

Hi Grant,

I will check the filter. Is there anyway we can see the actual command i.e CREATE LOGIN in the event capturing?

Data Sheet

sys.indexes has object_id column, my stored procedure is accepting TableName as parameter.

How can I get the Primary Key column when I have TableName in parameter but in the column I...

Well, I have found it of my own. I was using "single tick" but it is "double tick".

like:

=Parameters!TableName.Value & "Column List"

Data Sheet

Thanks lucky,

I tried but now I got this error:

DECLARE

@SnapshotDBNamePart VARCHAR

(10),

@SnapshotDBNameString VARCHAR

(20),

@SnapshotDBNameExtention