You never showed us the code. Question, in the code, are you using table variables??

Unfortunately, I can't see what you see. I know that when I run Activity Monitor on my desktop system against one of my servers that Activity Monitor is displayed...

Does the account under which SQL Server Agent run have appropriate permissions to the source and destination directories/shares?

First, the only way you will learn is to do. If you have problems, ask specific questions.

Second, if you really want help, then please read and follow the instructions...

CirquedeSQLeil (12/15/2009)

---

The Dixie Flatline (12/15/2009)

---

The Thread ebbs and flows, Bru. 🙂

Barry (aka MISTER 10K) made an heroic effort to participate in the final sprint down the stretch and...

I'm wondering if properly indexed temp tables in place of the table variables might not be a solution without converting the cursors? I'd move the creation of the temp...

Also seeing the use of table variables. Do you know on average how many rows of data may be inserted into each of these tables? As the number...

We had a performance issue with our PeopleSoft Finance application when we upgraded from SQL Server 2000 to SQL Server 2005. Long story short, there was a table used...

Ack!! I just looked at the code you posted. Cursors! Have you looked at rewriting the cursor-based code as set-based?

And, no, I haven't starting looking at the code...

Personally, I'd need more specifics regarding your requirements. You indicate that each day the filename changes, but when you say file1 one day then file2 the next, is the...

Are you copying or moving the files. If you are moving the files, they are removed from the source location, so if you run it once in VS (BIDS),...

Or: select * sys.tables

Have you even bothered to read ANYTHING in Books Online? Do you even know what it is? Many of your questions could easily be answered...

Magy (12/15/2009)

---

Well if I do this query:

SELECT machineID, machineType FROM machinema A

LEFT JOIN modelma B ON B.startmachine = A.machineID

WHERE A.modelID = @modelID

ORDER BY startmachine DESC

it is in the order I...

What is the table definition for XMLmodelMap and what indexes are defined?

Also, the only way to ensure order in a query is to include an ORDER BY clause in the...

Another option, you can make your nonclustered indexes covering indexes by including the columns from the table used frequently in the index using the INCLUDE clause of CREATE INDEX.

In this...