Search results for query: *

Whoops please disregard this post, the reason was that the order by criteria, was the same value for 74% of the items. sorry wasn't thinking.

SELECT TOP 5 PERCENT dbo_FormReportSS.UPC, dbo_FormReportSS.ItemDesc, dbo_FormReportSS.WhseNum, dbo_FormReportSS.PriceOnly, dbo_FormReportSS.CaseCost, dbo_FormReportSS.UnitsCase, dbo_FormReportSS.UnitCost, dbo_FormReportSS.[GM%], Sum(dbo_FormReportSS.LstWght) AS SumOfLstWght...

Success!!! I am going to begin using veritas to backup onto tape after my backup on the hard drive (it only takes 1.5 hours. I still have no idea why SQL server takes so long.

Alright!!! went on lunch and came back and it is finished. Took less than an hour, now too backup that up on my tape... thanks a lot guys, Joe

OK i cancelled my tape drive backup and am backing up on the Hard drive. I will keep you posted. Joe

Wow thanks for all the quick responce. I am backing up strait to the Local backup tape drive through SQL server. The server is fairly new (a little over a year)it is a dell 4600 with duel 2.4Ghz/512k Xeon processors. Im not sure what model the backup drive is, i will look into this further...

Hi I am Running SQL Server 2000 on Windows 2000. Backup started at 6:00PM and is still going at 10:00AM. My old backup was part of a "Database Maintenence plan" so i expected it to take some time. The new database maintenence plan is only a a complete backup to the tape drive...

check this post out, it sounds similar to a problem i was having. thread183-600595

Ken, Thanks for the quick reply, it gave me the message sub or function not defined. I may not have been clear enough in my original post. The Stored procedure is on SQL enterprise manager and the access database is on a client PC. Joe

Hi, I am trying to execute a stored procedure in the onclick event of a command button. I already have the stored procedure working, i just need to be able to execute it. Here is what i have so far.. RunDTS is the name of my stored procedure. Private Sub ImportNewItems_Click()...

OK nevermind, I guess that the Microsoft DTSPackage Object Library is only availible on computers that have SQL server installed.

I am trying to do the same thing (run a DTS package from VBA) It looks like the code above will work and I also found some similar code on the Microsoft website. However I can not find the "Microsoft DTSPackage Object Library" to reference. I tried going to tools then References, but...

Is there a way to program a command button to print a report with. 1. 4 pages per sheet 2. A select amount of pages (user defined through a input box or textbox) I have tried to set the print settings on the report and it seems that if i use a button they get reset. Thanks in advance, JF

If you are talking about a text box then... me.text1 = ""

Whoops sorry I messed up that link here is the right one: thread702-563930

Check this posting out http://www.tek-tips.com/viewthread.cfmSQID=563930&SPID=702&newpid=702&page=1 I got some great ideas based on JFGambits link to his search Database.

AL Almeida, You were right!!!! In ODBC Administration, I configured the driver I was using and for some reason the Large Objects Threshold was set to 64KB. Thank you for pointing out the problem to me. JF

AL Almeida, Thank you for your quick responce I will look into limitations for the Driver. I am using a OLEDB connection using the Iseries access for windows driver(Client Access ODBC Driver 32-bit). The AS400 is servering a Text DB, I am Querying a "physical file" is what our...

Hello, I have a query that i thought should be pretty straitforward: SELECT * FROM SEASIA.RUMBA400.FMSV3DB05.ARCUST CustomerList 33 records (it is querying from a linked AS400 server) The wierd think is there are 1500+ rows in the table on the AS400 and the query only returns 35 of...

Hi, I have a SQL server that I was trying to link to another SQL server. When I Removed the link I can no longer view any tables or views! I get a message that there are files missing or not registered. Has this ever happened to anyone else before? The data files and transaction logs are...