I was looking for the info on what DB a job is running. For Example if I am running a stored procedure in the job and if that stored procedure...

Can anyone help me to have the below query with not having the clause 'LaggedData'. I am not able to use this on SQL server 2000 instance.

Thanks.

The reason why I wanted to do this is.. I wanted to minimize the usage of the view 'EmplyeeCodes'.
 Each time i used 'exists' this object is queried once......

Sure. I will do in the future.

Thanks for the help. It worked really well.

I need to run this query also on sql 2008 database and getting the following error on 2008.

The Parallel Data Warehouse (PDW) features are not enabled.

How can I rewrite the...

I tried it .. but its taking more time.. since I am working with 200k records.. I am wondering if there is a way that I can elimante nulls with...

Thanks for your help.It works fine. But I need to by pass the null values.

Say like if addr2 has a null values it should not be added in the result...

@input1 uniqueidentifier

when the input paramter is not set to null, we should definitley send the value for it,right?

@input1 uniqueidentifier=null

then we dont need to send the value to this parameter,right?

Thanks.

Any suggestions?

can we insert the error or error number into the database with an insert statement?

After I started MSDTC do I need to restart the server?

Thanks.

its stored in sql server. I was able to open the package in BIDS.

But if I modify the package on my local copy(visual studio) , how can I update these...

Thanks Guys.

I am still looking for some help on this. If anyone can answer this I would be very greatful.

Thanks.

database is sql 2008 with .net 4