if you are a local admin on the server, there is a technique using powershell to impersonate the service account running SQL, and add logins, and then add that login...

MessageBox can only display strings, and RecordCount is an integer,so simply convert the value you want to display.

MessageBox.Show(RecordCount.ToString)

Public Sub Main()

'

' Add your code here

...

bzoom100 (12/28/2016)

---

I am using Microsoft SQL Server Report Builder 3.0.

I have a table called "tblDataPermit"

My DataSet1 includes the column "Type"

The Type column has numeric values 1-54.

In my report if...

not efficiently, because you would have to manipulate each column value.

what are we doing? stripping out just two specific values? stripping all non numeric characters? what about alpha characters?

with a...

no functions are allowed in a filtered index definition, so the ISNULL is not compliant with teh syntax.

also, OR statements are not valid either; the filter has to be...

I'm with Sue;

either an invalid email is being used(ie someone@gmailcom, missing the period) or a null a missing semicolon between multipel addresses, or something for one of your new report...

Welsh Corgi (12/23/2016)

---

Lowell (12/23/2016)

---

Welsh Corgi (12/23/2016)

---

Lowell (12/21/2016)

---

Dts.Events.FireError is what you want.

is your account used by a team of users, and not an individual?

Trivially adapted from part of an answer ...

Welsh Corgi (12/23/2016)

---

Lowell (12/21/2016)

---

Dts.Events.FireError is what you want.

is your account used by a team of users, and not an individual?

Trivially adapted from part of an answer I posted for...

djj (12/22/2016)

---

Has anyone had their gallbladder removed? What was the recovery like? Can you go back to work in three days.

If you haven't guessed I need mine out.

I...

look to see what database mail has to say about the specific message; it could be that a firewall issue prevents connections, or you misspelled a password or something:

SELECT top...

Dts.Events.FireError is what you want.

is your account used by a team of users, and not an individual?

Trivially adapted from part of an answer I posted for you yesterday @4:40pm(less...

thakur.bhagat24 (12/20/2016)

---

In previous example is very useful

But I have one new requirement of order by color what we get using below case.

CASE WHEN (ROW_NUMBER() OVER (ORDER BY [SpecialOfferID]))%2...

here's a C# code example, change directory to file, and

try

{

string FileName = (string)Dts.Variables["BHCS_InPatient_File"].Value;

...

what is the issue? you've been around long enough to know exact errors and a description of the...