some groups cannot be enumerated , I've seen that on my AD, where we have two forests of AD accounts with two way trusts.

I've found we've got a groups with...

if you are local admin, you probably want to do a takeover of the server,

then i believe you can at least add yourself via a dedicated admin connection...

Tac11 (5/3/2016)

---

Hi Lowell,

in the result header there are 2 columns 'date' and 'Start_time' what are these can you put specific column name? plus if I want to filter by date...

since you don't have the error yet, i'm leaning towards checking things that are different in the other environment, like ANSI_NULLS and QUOTED_IDENTIFIER.

maybe the procedure was compiled or is running...

i would add dates and whodunnit information to the history table as well. From what you have show so far, you cannot tell when it occurred, which could be important,...

j-1064772 (4/29/2016)

---

Sioban Krzywicki (4/28/2016)

---

I keep trying to convince people that the most secure database would be one where they can't use alphanumeric table and column names. I created one that's...

SQL!$@w$0ME (4/29/2016)

---

Hello guys,

I can't connect to a named instance(TCP/IP) through VPN connection. But I can connect to the default instance(TCP/IP) [highlight="#ffff11"]on the same server[/highlight] through VPN.

The named instance is...

it's not a one line fix; performance and query tuning and analysis, a have entire books written on the subject.

in general, my knee jerk reaction would be to update statistics...

just the drops scripts are pretty easy, you can just build the statements from sysjobs;

select

'IF EXISTS (SELECT job_id FROM msdb.dbo.sysjobs_view WHERE name = N''' + name + ''')

EXEC...

Sioban Krzywicki (4/28/2016)

---

I keep trying to convince people that the most secure database would be one where they can't use alphanumeric table and column names. I created one that's all...

Sioban I'm with you here!

I try like crazy to make everyone replace reserved words, as well as fixing misspelled columns i inherited.

I have a column ProvdierType that makes me crazy,...

CTE's would work, as well as subqueries(same thing,really , just different format.

here's my version of your post as CTE's:

DECLARE @personID INT = 123999;

WITH ELDASummary

AS (SELECT...

there's no upgrade path for Express to non express versions; instead you need to backup all the databases, script out your logins, as well as anything server related...certificates, linked servers,...

a trigger has a COLUMNS_UPDATED integer value which represents a bitmask for the columns that were mentioned in the update, but it does not tell you if the value changed...

is this on a cluster, where it might be failing over or toggling to the other node?

is it possible someone is downing the server for maintenance?

did you check the...