Search results for query: *

Only had 12 KB free space so I deleted an old backup file that's 18 GB big. 12 hours later there's only 100MB free space. A couple more hours later, only 4 MB free space is left. Please advice.

I turned on self-service site management option so I can create another Top Site. But I didn't get a new announcement that includes the link for creating a top site as the books said I would. Is there another way that I could create a top level site? Please help! Thanks!

I'm trying to uninstall .net framework from the server but I do not see it in the "add or remove programs" list. I also tried add/remove components but it's not there either. Please help! Thanks!

Hi! I have a form with a combo box and 3 tabs associated with the values in the combo box. Depending on the data selected for the combo box, I need to hide or show the appropriate tab to show sub categories. It works on Single Form view, but I need to use it for a Continuous Form view. So...

I have a Crystal Report that runs fine in production, but gives me the following error when I run it against the test server: Error in formula <Object_Visibility>. ' ' This field name is not known. The test server is an exact copy of the production, I've had it restored from...

Hello! I'm trying to create a link to a "read-only word document" from my website. <A HREF="C:\User Guide.doc" target="_new">User Guide</A> When I try to use this link, the word document opens but if I click on the table of contents, the document gives me a prompt saying the document has been...

Hello! I'm trying to create a link to a "read-only word document" from my website. <A HREF="C:\User Guide.doc" target="_new">User Guide</A> When I try to use this link, the word document opens but if I click on the table of contents, the document gives me a prompt saying the document has been...

Hi! I have a view based on 3 tables. Now, out of the result, I need to randomly pick 5 ID's. I'm trying to use RAND but don't really know how to use it on the ID's or if it's even possible. Is there a way to randomly select an ID or a row from a view (or a temp table, whichever will work)...

Hello! I have this access report that I wrote a while back and it was working until today. Now it's giving me the error message "User-defined type not defined". I have the following variables in my code: Dim rsReport As ADODB.Recordset Dim GroupCounter As Integer Dim intColumnCount As...

Hello! I have a DTS package that runs a SQL script and exports the results into a .txt file. But my resulting text file gives me a truncated description. If I run the script in QA or in Query view of the table in SQL Server Enterprise Manager, I get the description fine. My SQL looks...

Hello! I have a SQL select script to get the ID and description (along with a few more fields). If I run the script in Query view of the table in SQL Server Enterprise Manager, I get the description fine. But if I run the same script in SQL Query Analyzer, the description field gets...

Hello! I have a DTS package that runs perfectly if ran manually. But if I run the scheduled job for it, the job fails. I tried it on a different server but I got the same result. Please help. Thanks!

Hi! I need to create a DTS that pulls data from a text file and send them to a table. The name of the text file would depend on the date and time of the day (this process would have to be run hourly). I wrote the script to pick up the correct date and time. But I'm not sure what's the next...

Hi! Does SQL Server have an equivalent of the inStr function in Access? Basically, I need to evaluate a field if it has a specific string. For example, I need to know if there is "DDD" in the string "ERTGDDDE". Please help. Thanks!

Hello! I have a report with about 15 rows of data from a crosstab query. The preview looks fine but when I print, I get only the last line of the data printed 15 times (in 15 rows). If I export the report into Excel or RTF, I get the same result as the printout. But if I do a direct print...

Hi! I wrote the following code to upload a text file to an ftp server. The code works fine, except that if a file with the same name already exists in the folder, i get a message asking if i want to overwrite it. I could ignore the message and it'll overwrite the file anyway after 30 seconds...

I have a script that downloads some text files from a site. I have it scheduled to run automatically every hour. The problem is sometimes it succeeds, sometimes it fails, but there is no pattern of when it fails. The failure happens at the line MySite.connect. Following is the code (I tried...

Hi! I created a script to download files from an FTP site using CuteFTP. Set MySite = CreateObject("CuteFTPPro.TEConnection") But I'm getting the following runtime error: ActiveX component can't create object: 'CuteFTPPro.TEConnection' I do have cuteFTP installed on my server so I'm...