Does the stored procedure run just as slow in the query window if you have the same SET options as your applications connection?

You should be able to get the applications...

Yes. Always a good idea...

If you've already tried format files with the bulk insert then using the Script Component will work too.

An example of what the process would look like:

[Flat File Source] ---> [Script...

I'm guessing the "" is just formatting, but if not, remove that. Also, check if the account you're running the script under has permission to the [font="Courier New"]C:\Output[/font] folder.

Fso.CopyFile CopyFromSpec,...

Going under the assumption you're using Reporting Services with SQL 2005.

1) Create a Dataset based on your query

2) Add a Chart control to the Layout

3) From the Dataset, drag the...

Two things to check. That Windows Firewall is allowing traffic to port 1433 and that remote connections for your SQL instance are enabled.

The reason for putting them on different drives basically serves two purposes. One, to improve performance by preventing contention for disk resources between the transaction log and data file. Two,...

Using the Foreach Loop container is part of it. In the Foreach container add a Data Flow task. In the Data Flow task modify your connection manager to use...

The performance issue may just be that your log started out at an initial size of 1MB-2MB, then grew from there. That can be expensive because each time it autogrows...

It might be that you have multiple SMTP servers and need to point to the one that will route to external addresses. For example, the configuration below would use the...

Since anonymous access was enabled that sounds like an NTFS permission issue on the website folder.

For example, you might have to remove the I_USR_ user and the Users...

NuJoizey (7/17/2008)

---

Todd,

hey, thanks so much for your response, this got me a step closer - Disabling anonymous does indeed solve the immediate problem of my app not seeming to...

I believe you'll find that in RC0 but not the CTP's. And if you have RC0, Activity Monitor can be found as an icon on the toolbar in SSMS or...

NuJoizey (7/16/2008)

---

Todd Engen (7/16/2008)

---

... my app has code in it to recognize who is logged into the current session, and makes certain display choices based on that. If my...

... my app has code in it to recognize who is logged into the current session, and makes certain display choices based on that. If my app doesn't recognize...