Puja Shah (5/18/2011)

---

Can you please tell me what permissions are required for an sa user to execute xp_cmdshell ?

One more thing, below query executes successfully:

set @sql = ' exec master.dbo.xp_cmdshell...

Chrissy321 (5/18/2011)

---

EXEC master..xp_cmdshell 'osql -d master -E -Q "EXEC sp_help_revlogin" -w 300 -o \\MyFolder\Users.sql'

What are my other options for outputting this to a file if xp_cmdshell is not...

More indexes will will slow...

gary.morey (5/18/2011)

---

I am trying to run the following update query:

UPDATE WebSessionsPerCall

SET WebSessionsPerCall.CALL_ID = NumberOfWebSessionsBeforeCall.CALL_ID

FROM NumberOfWebSessionsBeforeCall

WHERE NumberOfWebSessionsBeforeCall.USERID = WebSessionsPerCall.USERID

AND NumberOfWebSessionsBeforeCall.OPEN_TIME = WebSessionsPerCall.OPEN_TIME

GO

The WebSessionsPerCall table has about 89 million rows in it....

Puja Shah (5/18/2011)

---

Error: 2011-05-18 18:42:40.59

Code: 0xC0011002

Source: {0E519291-8D78-43A0-ADB0-5D8001AB8215}

Description: Failed to open package file "C:\Users\pujashah\Documents\New Package.dtsx" due to error 0x80070005 "Access is...

Listed are some articles concerning this utility. There are not for the operating system that you are using.

http://www.technologyquestions.com/technology/windows-xp/27345-defrag-exe-dfrgntfs-exe-always-running.html

http://www.processlibrary.com/directory/files/dfrgntfs/19281/

http://forums.techguy.org/windows-xp/214561-dfrgntfs-exe-cant-kill.html

The process for this defrag utility will continue to run unless you stop which you should not do if a defrag in progress.

Is it consuming a lot of resources?

It would help if you provided schema and data but I do not understand your GROUP BY Clause?

You need a subquery to derive the results needed.

Just though you are not...

bijarcity (5/17/2011)[hr I really would be happy if you help me ,this is the project of my DB in university ,and i like to design that because i think Distributed...

Thanks for all of the feedback.

Do I need to change...

I'm no longer a kid (Goat).:hehe:

Welsh Corgi (5/17/2011)

---

Welsh Corgi(5/17/2011)

---

How are you authenticating to Windows from a...

How are you authenticating to Windows from a Linux Client?

davidshephard (5/17/2011)

---

Date,Source,Severity,Message

05/17/2011 11:54:28,Logon,Unknown,Login failed for user 'uftmasterad\trackitdev'. [CLIENT: 10.52.208.160]

05/17/2011 11:54:28,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 6.

05/17/2011 11:41:44,Logon,Unknown,Login failed for user 'uftmasterad\trackitdev'. [CLIENT: 10.52.208.160]

05/17/2011 11:41:44,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 6.

05/17/2011 11:40:37,Logon,Unknown,Login failed...