Viewing 15 posts - 16 through 30 (of 36 total)
Based on what this posting is telling me http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=103859 , I think might be flogging a dead horse. Damn...almost there but no cigar.
Is the only way to grant users...
August 29, 2004 at 9:25 pm
Hi Phil
The method for creating hasnt changed. The application front end offers the user the type of delimiter they want, then a bcp call is made.
set @strCommandText = 'bcp "select...
August 18, 2004 at 9:39 pm
Another piece to the puzzle....the import works fine in Access 2000. Doh!
August 18, 2004 at 8:11 pm
Im not getting anywhere, I'd better start from the other end.....We are opening a text file in Excel which was exported from an SQL database using predefined widths for each...
August 18, 2004 at 7:36 pm
Yes this does return the record.....but Im curious as to why the problem has surfaced in the last month and only for new records. This process has been going on...
August 15, 2004 at 11:33 pm
Very enlightening Jonathan. Thank you. Just a comment that I have; 'is it neccessary to truncate the log if you are using the simple recovery mode?'
I'm not exactly sure at...
August 12, 2004 at 5:40 pm
Hi,
Sorry if the following question seem a bit dumb...Im still trying to work out all the bits to a warehouse/olap environment. My questions are:
1. How do you create an OLAP...
August 11, 2004 at 10:19 pm
To extend this further....The DTS contains three 'Execute Process Tasks'. The first one performs the task 'net use j: /d'(to ensure that the J drive is not currently mapped). This...
July 20, 2004 at 9:22 pm
Ouch...not want I wanted to hear! The example I posted was simplified, the statment I was running has a SUM() function in it and consequently the summed figures are doubling...
July 15, 2004 at 4:03 am
Hi Rajesh,
I am having exactly the same problem you describe. I have designed a stored procedure with a dynamic where clause. When I create a report using Visual Studio.net, which...
July 2, 2004 at 12:01 am
I think if you change the permissions on the Folder then all items beneath that folder do not automatically inherit the changes. You have to go to each report item...
July 1, 2004 at 12:42 am
OK...Got it...had to run the Report services install on my local machine as well. Now Im just having problems submitting a report to the report server because of the following...
June 24, 2004 at 2:48 am
Found useful information in the MSSQL help files on Microsoft Search Service, which makes use of Full text indexes. Used for fuzzy searching. I'm still interested in a step by...
June 2, 2004 at 10:31 pm
Have you recently applied the security patches for SASSER? I am having a similar problem since the application of the patch this morning.
May 5, 2004 at 6:30 pm
Viewing 15 posts - 16 through 30 (of 36 total)