Thanks, I am troubleshooting an existing service broker in our DEV env.

How do I find out what certificate was attached. I cant find it in the Object Explorer.

Is there a...

ServerA and ServerB are on same domain/Network.

ServerA is the Initiator and ServerB is the Target.

Endpoint should be set on both A and B or only Target?

Guys,

Both of these worked for me. 🙂

Thanks a lot.

1) select COUNT(*) cnt from (

select COUNT(*) cnt , USER_ID from #temp where Application_ID in (4,8) and application_id...

Yes I did the Group by Clause along with Having clause for conditions where I need to find APP Id in (4 , 8) or (8,128)..so on..

select COUNT(*) cnt, User_ID...

Thanks, That was perfect !!

How can I PIVOT this... All the columns and their count in two columns side by side.

select

sum(case when t.Application_ID = 4 then 1 else 0 end)...

but i want it PIVOT style... all the hadcoded column names you see there should be as rows with their count, ?

Thanks, I think I need the date as well.

so I will need '2011-12-09 09:50' from 2011-12-09 09:50:34.600

in SQL Server 2005.

Thanks!

Desired output in the CSV file:

DialCode jurisdiction VendorRank

519706 interstate 0.00000(VCX27),0.00390(VCX1),0.00660(VCX4)

604846 interstate ...

absolutely similar...

can I run something like select * into mysql...test1 from sqlserver.dbo.test

I have odbc connector installed (.net msi executable from web) and then created a dsn to mysql..

everything else works fine

my task is to fire sql code from sql server...

ok I ran this as per your advise..

select * from MySQL...src_customers

and got this error ...

OLE DB provider "MSDASQL" for linked server "MySQL" returned message "Unspecified error".

OLE DB provider "MSDASQL" for...

I think I found the line the error could be originating out of...

Error is at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSVariables90.get_Item(Object Index)

at ScriptComponent_13ebdf6566b5461a99d978dea2296191.ScriptMain.CreateNewOutputRows() in dts://Scripts/ScriptComponent_13ebdf6566b5461a99d978dea2296191/ScriptMain:line 26

...

Please look at this code...

Dim connMySQL As OdbcConnection

Dim sqlCmd As OdbcCommand

...