I'm not familar the GUI robocopy but here's a command line example for comparison.

[font="Courier New"]robocopy c:\sourcefolder \\server1\destinationshare file1.txt [/font]

A 10GB file in 1 second seems too fast, a least...

Capture all the cursor events too.

If you see many sp_cursorfetch w,x,y,z in the trace, and z is 1, then that's a clear indication the application is asking for the data...

Changing the switch, cable and NIC all sounds like a good steps, could still be some type of network configuration issue. For example, duplex mismatch.

If you haven't tried...

Hi ludvall,

First thing you might want to do is get the Secure FTP working outside of SSIS from a command prompt. And where you finally install PSFTP or PSCP...

Hey Wayne, I'm not sure I understand what the question was either.

When I read this it struck me as a "build your own adventure" for the answer.

lduvall (11/14/2008)

---

Can someone explain specifically how to create the proxy account so that the fingerprint is stored? I'm going to be running this from SQL Server Agent scheduled jobs, but...

Hi Marcelo,

Glad it helped!

Just in case you're interested, attached are a CLR based version of SIDToString, as well as a StringToSID.

Only two things would have to be modified on the above example to import the results into SQL. The logparser manual has a couple other examples as well, just...

dsquery is one in a set of commands for working with AD. Should be installed if you have Windows XP as the client. Not sure if they're available...

I might have misunderstood your question then.

Logparser queries aren't run inside Query Analyzer, they're run from a command prompt.

The text file contains the query that's used by logparser.

I don't believe logparser supports joins.

One way to get the full name -- use dsquery with the output from logparser.

-- myscript.sql

SELECT DISTINCT cs-username

USING COUNT(*) as hits

FROM C:\WINDOWS\system32\LogFiles\W3SVC1\ex0809??.log

GROUP BY cs-username

HAVING...

In the profiler trace, are you capturing all event types for the Cursor event class?

Two options that would probably solve that. One, use a stored procedure instead of sending the query from the client side application. Two, change the type of...

Just saw a reference to this very thing in SQL Server Magazine that might be of interest.

http://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx

When you created a new operator there was an option for "E-mail name", that's where the SMTP address goes -- for example, david.briggs@yourdomain.com.