Search results for query: *

We are in the process of deploying our sharepoint portal server. One of the request is to load some 2000+ documents with their meta-data into the document libraries in the portal site. Currently, we have a SQL database storing the meta data and the pointer of the docs location. What I need to...

I was trying to add stock quotes functionality in my sharepoint site, and I was trying to create a DataView web part in front page connecting to XML web service (http://office.microsoft.com/Research/Providers/MoneyCentral.asmx?WSDL). I added a new data source for this but when I drop this data...

Hi, I have three fields in the my table: Client Fees Costs In my report, I am presenting the sum(fees), sum(costs) and sum(fees) + sum(costs) for each "Client". So, when create the report, I group by "Client". If I want to present this data sorted by sum(fees) + sum(costs)...

No, this is not necessary. master..xp_cmdshell is working. The problem was resolved. It was the windows startup service account issue. That account must be a domain account with the neccessary permission.

Sorry, the command corresponding to the error message should be: exec master..xp_cmdshell 'bcp &quot;SELECT * FROM pubs..authors&quot; queryout \\<myservername>\<myfoldername>\authors.txt -U sa -P -c'

I am having problem creating/copying txt file in a remote computer using the xp_cmdshell cmd from Query Analyzer: Got the following errror message when execute: exec master..xp_cmdshell 'copy D:\result.txt \\<myservername>\<myfoldername>\result.txt' (where I have permission to write on...

rdroske: Yes, I can manually run bcp from command prompt in any directories, but getting error just when running inside xp_cmdshell in Query Analyzer. gzm219: Not sure if the following is what you are looking for: BULK INSERT Northwind.dbo.[Order Details] FROM 'f:\orders\lineitem.tbl'...

Thanks. I have verified already that all the paths are accesible from the second machine.

Hi, I have trying to execute the following command in my Query Analyzer: EXEC master..xp_cmdshell 'bcp &quot;SELECT * FROM pubs..authors&quot; queryout \\Ny2_alextest5\ConnectionPolinska\authors.txt -U sa -P -c' This is working in my first machine. But when I run it in the second machine, I...

Hi, My report has the following columns: BillDate, Invoice, Client, Matter, Fees, Costs, Age My report is grouped by the &quot;Age&quot; field in my database. For each group, I need to get the sum(Fees) where invoice < 0 and the sum(Fees) where invoice > 0. Any ideas on how can I do it? Thanks...

Thanks for your ideas, synapsevampire. I am just the native connection already. It looks like the problem is with @dtDateWanted Parameter which is a &quot;DateTime&quot; type. After I convert the @dtDateWanted Parameter to a varchar(10), the report is working. Wondering if there is any...

I have a report with the data source from a SQL Server 2000 stored procedure. When I execute this stored produre from Query Analyzer, I got more than 10000 records returned, but got no records back for the report from Crystal Report 8 and error message &quot;Failed to open rowset&quot; from...