Jeff

It's easy enough to install. You don't even have to run it on the same server as you're doing the ETL on. If it's really not an option,...

Jeff

I would use SSIS (or your favourite other way of doing ETL) to bring the data from the remote servers into Access. Don't use linked servers at all -...

Have a look at the properties of the linked server, and go the the Security tab. Are there any logins listed in the box at the top? Which...

No, SQL Server waits ad infinitum for locks to be released. As Gianluca suggested, please use sp_who2 or sp_whoisactive to find out whether there is any blocking. What...

You're looking for a splitter function. Try this search for a start.

John

Edit: oops - I just realised that you were asking for an expression in SSIS to do...

I think Ola Hallengren's procedures will automatically take a full backup if one doesn't exist.

John

Blush! Thanks, guys.

John

You can do it by breaking each permission down into a sum of powers of two. Something like this should work:

SELECT UserName, ServerOperation, SUM(DISTINCT p)

FROM #Operations o

OUTER APPLY (

SELECT...

I see - you want to find out which groups a particular user is a member of, rather than which users are members of a particular group? That's a...

Or more generally, using an outer join:

CREATE TABLE MyProducts (ProdID int, ProdGrp char(7))

INSERT INTO MyProducts VALUES

(11, '*')

,(12, '*')

,(13, 'Group A')

,(14, 'Group B')

,(15, 'Group C')

CREATE TABLE MyGroups (ProdGrp char(6), ProdGrpDesc...

Try passing in your date in an unambiguous form, such as '20141001'.

John

Time for you to use your favourite search engine to investigate, then. It's a fully documented stored procedure.

John

EXEC xp_logininfo 'DomainName\GroupName', 'members'

John

Read them in as integers, do your arithmetic, then cast as a string. Something like this:

SELECT RIGHT('00' + CAST(1 AS varchar(3)),3)

John

Keep collecting the data as you are doing, and use a view to show the daily difference. You can use the ROW_NUMBER function to number each row, then join...