I'd take a similar approach. They're going to provide you with a list of users somehow, so try to use that to generate the SQL you need to get...

Minnu:

Does this code work?

DECLARE @bat varchar(200)

SET @bat = 'E:\Test_batch\Test.bat UPDATE DELETE';

EXECUTE master..xp_cmdshell @bat

If so, then you've got some unwanted characters in your @bat variable that's causing it to be interpreted...

Also make sure the login has permission to access the format file in its location on the server.

I've actually used this tactic in conducting interviews. I felt that some people were trying to bluff their way through the technical portion of the interview so I threw...

Maybe it was a trick question.

No problem. Glad I could help you for a change.

WOW! That's an intense nested CTE.

It ran fine until the year 2808, so I figured you must be bumping up against a converted numeric somewhere that was "really up...

There will certainly be an impact on the server. While you're creating your duplicate table, the server will be processing lots of disk I/O, which will impact reads in...

Kingston hit the nail on the head here. This is a huge topic and you...

That's quite a job to be assigned. I don't know of any automated tool that would do the whole job. I would probably opt to do it table-by-table,...

This will give you the jobs owned by sa:

select j.name, l.loginname

from msdb.dbo.sysjobs j

inner join syslogins l on j.owner_sid = l.sid

where l.loginname =...

I liked the question. I admit I haven't worked with grouping sets and it made me examine them. So, I learned something today, which makes it a good...

Having the sysadmin server role means you can do anything on the SQL Server, so I would treat it as being the same as the 'sa' account. You'll also...

When I refresh test from production, I take approach it by first notifying everyone that I'm going to do so, then I drop the test database, then restore the test...

I think this is what you're looking for.

SELECT l.LeaderID, l.leader, m.memberid, m.member, ROW_NUMBER() OVER (PARTITION BY l.leader ORDER BY l.leader)

FROM #tblLeaders l

INNER JOIN #tblMembers...