Answer Questions

• korihelvete Shrink log transaction file

  Good day, I have a database at the moment in SQL Server 2000 which is about 700meg, but the transaction log is just short of 50gig. How can I shrink this safely. Is setting the recovery model to simple and then truncating the log wise. Currently the recovery model is full. Please advise and help. I am trying to help my dad who manages a small office, with a SQL database, and I don't know much ...Show All

• timay Using HTTP Post to secure parameter values?

  It is mentioned in "MS SQL Server 20005 Reporting Services" (good book by the way) that you can get around URL access limitations by employing the HTTP Post method. I have employed the HTTP Post example from the book and parameter values are still exposed in the URL. Am I missing something I have searched the internet trying to get a definitive answer to this issue and came across this blog ( http://blogs.msdn.com/tudortr/ ) entry w ...Show All

• J-Man3568 get unspecified error when browsing data of CUBE

  Please give me solution, I am getting this message when I am browsing data of cude "Unable to browse data of <cude name>    unspecified error" please tell me the solution of this. What service pack have you installed If you look at the Microsoft knowledgebase you will see that there are several problems which caused this. Typically it is fixed once you install SP4. _-_-_ Dave I have SQL Server 2000 installe ...Show All

• tomk_vsts_user Flags on a table

  Hi all Been thrown a bit in the deep end and need some advice..... new to db design. I have been emailed the lay out of the table which is not a problem, they then go on to talk about flags on columns if data is inserted , updated... ect. How do i set them up The data is going to be imported in via DTS from a excel spread sheet Thanks in advance Rich Could it be that they are talking about ...Show All

• Tena SQLServer2005_SSMSEE.msi & SqlServer2K5_BOL.msi

  After I installed SqlServer2K5_BOL.msi, Microsoft SQL Server Management Studio Express CTP does not launch any more. How can I use both SSMSEE and BOL Hi I am skeptical, but will soldier on. I just downloaded this yesterday. I will see if I get a new rev on the new download. Here is my environment: Microsoft SQL Server Management Studio Express      9.00.1399.00 Microsoft Dat ...Show All

• cnuk Deploying SMO

  Hello, I am writing a commercial client application for SQL server 2000/2005 and probably I am going to use SMO dll's. I would like to know if there is any restriction in order to deploy SMO objects with my software. Are they free and moreover is possible to deploy only those dll's that i actually need, without installing the whole redist package. thank you in advance! Zoran Maksimovic See http://b ...Show All

• linley The value could not be converted because of a potential loss of data in SSIS package

  With my SSIS package, I want to import data from a flat file (TXT- delimited with ) to a table in my database in sql server 2005. The problem is that I have a column of type datetime in my table. But as you know, the data in txt is string. First I created my package through importing data and using import/export wizard in management studio to my database and selecting flat file connection. There, I selected my txt file and column delimiter as ...Show All

• TyroneH SQL 7 [DBNETLIB] 2147467259(80004005) [Connection write(send()),] General Network Error

  HI all I am facing a problem on sql server 7 Desktop Engine with front end VB6 and ADO 2.8 my OS is windows 2000 Professional. ie. I am doing appendchunk to add image files on SQL Table it works fine for Approximately 130 MB, But i am trying to add 249 MB size file it will be showing these error Message. [DBNETLIB] 2147467259(80004005) [Connection write(send()),] General Network Error check your network documentation. I do so ma ...Show All

• idjones Data Source Views

  I'm looking for examples of using Data Source Views as data source within a Data Flow. I have looked through the code examples supplied with the CTP but no joy. Thanks Al You do not have to write code to use DSVs with Data Flows in SSIS. You need to create a new Data Source and then a new DSV based on that Data Source. Now add a new connection based on the Data Source to the Data Flow. Add a OLEDB Source compo ...Show All

• Marshie creating a database, tables, records, and fields in a Sql server 2005 express

  I am at my wits end as to how to do this. I have downloaded Sql server management Studio and tried to create a database but I can't figure it out. There is an almost nonexistant help file so I am lost as to how to start. I have succeeded in looking at some system databases but that is about the extent of it. Can someone show me the proper procedure Am I using the wrong tool Thanks, Paul Hi Paul, there is no ne ...Show All

• M. Leary Problem Passing Report Parameters in URL

  I'm currently trying to create a report that will take three parameters in the URL to generate a report: year, month, and day. The report is using an analysis services data source in RS 2005. Now, my problem is that the parameters being passed in the URL are not being selected in the drop down boxes for the parameters. The report does not throw any exceptions, and after the user selects values for the year, month, and day everything generates su ...Show All

• Rick Pariera Configure Report Server - Web Service Identity

  Windows 2000 Server / IIS 5 / SQL Server 2005 Developers Edition / .Net 2.0 and .Net 1.1 When I attempt to configure the Report Server, I cannot configure the Web Service Identity, the ASP.NET service account shows blank. I have attempted to edit the rsreportserver.config file, as follows: <WebServiceAccount>.\ASPNET</WebServiceAccount> This (stop / start of course). But this only causes the Report Server to not start. If ...Show All

• BlueMikey Can not change filter on model report - UPDATED 7th June

    I have a very simple report based on a test model. The report is filtered via a date field and runs ok. If I try to change the filter I get the following error message: Operation Failed Short time pattern does not include hours and minutes Does anyone know how I can correct this Regards John  UPDATE This only happens if I try to filter between two dates, a single date works correctly! ...Show All

• dtorg1955 Counting no. of records

  Hi I need the ability to calculate the no. of records based on the no. of times a value in the sql report is given. For example based on a table shown below: Ref No. First Name Surname 18 test test 18 test test 18 test test 19 test test 19 test test I need to calulate the records returned on the ref no. I have managed to set page breaks based on a new ref no. with grouping and therefore the count will be disp ...Show All

• LLam How to Fetch the Recrods from MS Access and using it in Script Task Using Control Flow Tools(Execute SQL Task)

  Hi I have an application like fetching records from the DataBase(MS Access 2000) and results i have to use in Script Task. At present i have used the record fetching query,connection string in Script itself. I would like to use in Independently. Is there any Tools like (Control Flow Tools like Execute SQL Task) are there to fetch the result set from Acccess and can use the fetching results in Script Task.... Thanks & Regards Deepu ...Show All