Grasping now...

Are you using Kerberos or NTLM? I am thinking cached tickets.

Have you tried bouncing the SQL service? The server?

Jack Corbett (7/10/2012)

---

I agree with Grant.

The only issue with Extended Events on 2008 is that there are some key events that aren't available in Extended Events...

Officially MS only supports 2 previous versions in terms of the compat level, i.e. database compat mode 80 is no longer available as of SQL 2012. I would not be...

Right, transactional replication is not possible from 2012 to 2000. I have seen people add a shim (not official technical term) database in between to facilitate replication between incompatible platforms,...

2000 is three versions away from 2012.

What I would really like to see is a before and after CSV file.

The before file being what you receive from your external data supplier.

The after file being...

On the problem instance can you do this?

EXECUTE AS LOGIN = 'NewLoginName';

GO

REVERT;

GO

EXECUTE AS LOGIN = 'OldLoginName';

GO

REVERT;

GO

What does this yield on the working instance? How about the non-working instance?

EXEC sys.xp_logininfo

@acctname = N'GROUPNAME',

@option = 'members';

How are things going?

Thanks. The persistent use of memory while the cursor is open is not necessarily the same as a memory leak. Of course if your system must support a large volume...

I think Hadrian was answering the initial post, not sjimmo, in which case the response makes sense. Look at the time...

kprmcl (7/11/2012)

---

Thanks for the quick replies 😎

Is this the way to do it, or should I use a stored procedure?

ALTER DATABASE...

See if something like this is interesting to you. I get something like this, which should be easily parseable by PS:

C:\>dsquery group domainroot -limit 2 | dsget group -members |...

mtillman-921105 (7/10/2012)

---

I believe that most of the time, you can use a WHILE loop rather than a cursor. I'm not saying that a WHILE loop is a lot better,...

BULK INSERT supports the use of a format file. See the FORMATFILE option: BULK INSERT

Depending on what you meant:

Using a Format File to Skip a Data Field

or

Using a Format File...