pamozer (5/7/2012)

---

So I'm thinking I wasn't completely clear in my issue. The dbmail works fine. I am trying to do a try catch in case somebody goes in...

well, it depends on the results you want, right?

you had said at first you just wanted check how many rows are existed as like as above scenario...

so displaying the stuff...

try this page, and change the drop down menu to 2008 instead of 2012;

there's far too many...

Great job posting the DDL, that makes it SO easy to help!

by using the INTERSEC operator, i seem to get the results you might be looking for;

you could do somethign...

i guess it depends on what you mean by failed. do you mean:

1. zero rows got deleted, but you expected it to delete something,

2. or do you mean...

a couple of basic examples:

--connect via trusted connection using your domain credentials

SELECT *

FROM OPENROWSET('SQLOLEDB','Server=yourservernamehere;Trusted_Connection=Yes;Database=Master',

...

if adding a CLR is an option, take a look at this project i slapped together over at codeplex, and this thread that discusses other options, as well as tightening...

it happens a lot:

there is a MicroSoft knowledge base article on the specific registry entries and files that will help tremendously:

How to manually uninstall an instance of SQL Server 2005

sp_senddb_mail Is a service broker; it's already asyncronous

more likely is the person calling the procedure doesn't have permissions to send dbmail, which requires being a user in the DatabasemailUserRole in...

An excellent point on security Jeff, I'm still mulling it over.

I was thinking that a CLR added a layer of flexibility in there. You don't have to give the end...

i think Craig is right...errors are being supressed in the .net app, and stesting...

well i took opc.three's advice and slapped together a project on CodePlex.

There is no doubt in my mind this will help the SQL Community.

If any of you guys have...

is adding CLR assemblies an option?

I made a suite of CLR export functions as a proof of concept, and i can export to any text data type or HTMl as...

how are you looking at the results?

you know that SSMS, in gridview mode, converts CrLf to spaces so that it can present all the data, right? even thought the...

hmsanghavi (5/3/2012)

---

SqlCommand cmd = new SqlCommand();

cmd.CommandText = "UPDATE DimRequestMasterTestHS SET [RunningBoard] = ?,[DutyBoard] =? ,[DriverId] =? ,[PublicServiceCode] = ?,[ServiceCode] = ?,[DepotCode] = ?,[Direction] = ?,[EOJMethod] = ?, JourneyNo=? WHERE [RequestID]=?...