I had increased query cost to 1200, there was no difference... Now, even the sql's (using except) are not running in backend.

So i have changed query governor setting to...

No, I dont think anyone has changed the query cost time...

Even after increasing query cost to 1200, there was no difference...

Now, even the sql's (using except) are not...

Thank you... I shall check again for more back files specified on that data...

But to my knowledge i would have specified one location in the destination list.

Anyway thanks all....

But I think I had taken the backup in a single destination only.

Is it possible to get the error in the above case?

Am using 'IN' since its a self join

Yes teh indexes are used in the where clause, a glimpse of the query. Highlighted are the indexes used:

Createddatetime uses clustered index and sid uses non clustered

SELECT * FROM Ex...

Thanks a lot for the replies!!!

Am looking for the metdata repository information (the various transformations;count of records in source; transformation....) of the packages.

There is no third party tool in informatica for achieving teh same

Thanks..

It looks like there are very few tables in msdb database which provides the metadata... its not as extensive as Informatica ETL tool?

Please correct me if am wrong....

Yes they are using windows authentication only.

Steps which I followed to restrict a group (windows authentication) accessing a database:

1.Created a group for Windows authentication (Administrative tools-> computer management-> add groups (searched in the local network and...

Thanks all for the responses.

Currently,have added the email recipiemts in the operator using a ; and it seems to be working fine.

Hi thatseve,

My requirement is only in the end of n number of steps (package), i ll be sending teh mail..

And even if one of the step in the middle...

Where is it that we can specify the database mail in the sql server agent (for sending multiple recipients)

I was thinking the database mail is setup for the purpose of...

Thanks for the reply.

I would also like clarification for the below:

1.What is the max character size for the email in the operator( 'To'

address)?

2.In the sql server agent, under...