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...

The thing is I'm not even sure what formula it's talking about. The report itself has a store procedure as it's source... The stored procedure runs fine on SQL server. It starts out like this.... CREATE procedure spInv @de varchar(20), @bi varchar(20), @cA bit = 0 as begin...

I checked the datasource and it's correct. I also verified the dtabase and it is up to date. Error is still there.

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...

Thanks! It works! :)

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)...

Yes, thanks! That explains it. Any idea of the possible reasons why this happens? My user has been using the report on a weekly basis. The reference got lost all of a sudden.

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...

The destination size is actually 2000 quotable.

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...

Yeah, I was able to see the whole description in QA when I changed the output character to 300. So it really comes down to the DTS...

My max datalength is only 290 characters. I also tried to convert to nvarChar(4000), after all the replace, but it still truncates to the same spot... about 255 characters...

That would be about right. So Query Analyzer shows only the first 255 characters? What about in the DTS? I had the destination of my script to go to a text file. And in the text file, it's also truncated to about the same amount of characters even though I had defined the destination column...

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...

Everything is on the same server. I'm using SQL Server Agent for the scheduled job. The error says: Executed as user: TMA\sqluser. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart...