Can you connect to your machine using TCP?

Can your coworker connect to your machine trough telnet ? One can use for example putty or some other program if you...

TomThomson (10/11/2014)

---

well, the second sentence on that...

TomThomson (10/10/2014)

---

Ville-Pekka Vahteala (10/9/2014)

---

TomThomson (10/9/2014)

---

Ville-Pekka Vahteala (10/9/2014)

---

Typical setup for fw is that you have first allowed rules and then deny all

1. Allow from scope (allowed IPs) to ports 1434 and...

TomThomson (10/9/2014)

---

Ville-Pekka Vahteala (10/9/2014)

---

Typical setup for fw is that you have first allowed rules and then deny all

1. Allow from scope (allowed IPs) to ports 1434 and 1433 TCP and...

I think situation is...

Typical setup for fw is that you have first allowed rules and then deny all

1. Allow from scope (allowed IPs) to ports 1434 and 1433 TCP and UDP

2. Deny...

Here is example how to do it with select.

WITH cte AS

(

SELECT 'A1' AS id, 20141001 AS [date], 'UK-US' AS route, 20141229 AS routeDate, 'Return' AS TripType...

But why would You want to do that? Just outer join to data for select queries.

If I remember correctly those menu links should be there even when user has not enough permissions. Report will show some error on that situation.

I would look how indexes for this table are being used for a while. If it looks like this is index is used for most of the queries I would...

Do you have any groups in report yet?

If so then you just need to set group header section visible.

If you don't then just add ROW_NUMBER to your query and...

exec sp_who2 might be what you need.

Server you want to ping must have public IP and dns records.

You must have access trough firewalls.

This should be enough for ping to work.

Other option is to have VPN connection...

Would someone be able to use admin console of remote desktop and kick you out?

Could you use other computer and use pscmd, pslist and pskill?

Your query will return one record.

Are you sure that you used same query for both environments while testing Microsoft provider?

Will cast(getdate() as nvarchar(10)) return date with dots?

In query you have...