you might run into some permissions issues, you might need a domain admin level permission;

i can query servers i...

with powershell, you can check the services that exist on multiple machines, as long as they are on the LAN/you can connect.

You don't want to handcuff yourself into a...

you can do the same thing effectively with a dedicated admin connection from the server,

again only if you are a local admin user on the server, and also only if...

i was wondering if you could do the same as a set based operation, without the loop

does this produce your expected results?

SELECT

SUM(CASE WHEN (ISNULL(otherprocedurecode1,'') <> '' AND ISNULL(otherprocedurecode1date,'') = ''...

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...