Does your system has a SQL Express default instance as well as another instance named KBMSS installed???

yes using the same profile on both the nodes

yes have set the outlook separately on both the nodes independent of each other.

Outlook is installed on both the nodes. I'm getting this error.What does this means

"[265] Unable to resolve email recipient name 'USNATMBSQLAdmin' (reason: The MAPI Call failed)

well this approach is really not good. The DTS packages were done directly on the production. You should have got the drivers and all...

well either u can create a cursor and delete all the duplicate records. Somthing like this

Declare @id int,

        @name varchar (50),

        @cnt int,

        @salary numeric

Declare getallrecords cursor local...

If this is a production box then autogrow feature takes a toll and hampers the performance during the production time evrytime the database gows. So I would suggesst you to to...

I have a server where the owner of Model database is not SA but some other user. I don't know how it happened because I noticed it recently.

So I need...

Well never use the EM to alter a table which is huge because the EM creates a new table,copies the entire data there and then deletes the old table. So...

This is INFORMATIONAL message added in Service Pack 4.

There might be some operation going on (which caused file to grow) which was cancelled.

If you have profiler for same...

yes it worked when I specified the owner name.

But in this case I just had one object by this name and the owner was XYZ. then also why was it...

It gives the same error as above.

Well the developers have saved the data like this.Now they just need to extract the text out of this.

Thanks a Lot.hat made things really clear

Hi

Thanks a lot..Have written the query properly now.

SELECT TBLA.Loginname,TBLA.updatecount,TBLA.refreshercount,TBLB.testcount 

from

(select E.LoginName,

sum(case when type='Update' then 1 else 0 end) as UpdateCount,

Sum(Case When type='Refresher' then 1 else 0 end) as RefresherCount

from...

Hi

Thanks a lot it worked.But just one more thing.

You have written that " JOIN syntax also allows you to avoid conditions like "NOT IN (select ....)", because this can...