Answer Questions

• qrli Reporting Services Configuration - Database Setup

  I have trouble to configure the Report Server. The error message I got when trying to setup database : Verifying Dabase Version The Current Connection string is not valid and cann't be used to connect to SQL Server and it also failed to assign Reporting Services Right to user Any idea Thanks Can you tell us the detailed error message There should be a link in the status pane that says "tell me more ...". yes I did. Louis! Did you managed to solve this issue We have the same problem. Best Regards, Zoltan Have you tried using the report server configuration ...Show All

• Raj Deep How to list all filegroups for a specific database?

  Hi, all here, Would please any expert here give me any guidance for how to list all filegroups for a specific database within SQL Server 2005 Thanks a lot in advance for that. With best regards, Yours sincerely, Hi, Jens and Joeydj, thanks a lot for your guidance. With best regards, Yours sincerely, Within the database use the following command: SELECT * FROM sys.filegroups HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- use northwind select * from sysfiles select * from sysfilegroups ...Show All

• Vitaliy Kochubiy Problem with Transaction Logs

  Hi, I have a big problem with transaction log. I need to reduce the transaction log file becouse, the have 25 GB, but when i run the statement for BACKUP LOG with TUNCATE_ONLY, dont work, becouse i have database mirroring installed. Please is very urgent. what forum may that be I ran the shrinkfile command in simple recovery mode the log went from 561 to 5 MB -wade Oh I also got this big problem, and I amazing that no MS SQL supporter answer this question clear. Perhaps this has been explained scattered in Ms SQL help. There is 2 way: 1. Take the SQL server model to: simple and schedule 1 daily database backup 2. If the model is: full recovery: must schedul ...Show All

• gafferuk Passing array to stored procedure

  Can some one tell me the way to pass Table or Array or list of values to stored procedure [Note: I already know some ways which are not useful in my case: - By passing a list of values separting each with a delimeter like comma(,) - Using XML ] Any other way Please, its urgent Thanks in advance Hi All thnx for ur comments really its all Usefull i Just Have small Problem . after i Created the global temporary table in SQL Server , and Inserted the Data i wanna use in the Stored Procedure i Pass the temporary table Name to the Stored Procedure But i couldnt use it with aCursor or even Normal Select Statement. coz i have to concatinate it in the select Statemant Sea ...Show All

• Dhaval Heruwala SSIS CAL licensing

  Hello, How does licensing of SSIS work on a CAL basis As far as I'm concerned there are no users of it per se cos its a back-end process. Therefore, do you only need one CAL Thanks Jamie   I guess I was right (if not late with my answer). The real question is how does MS view users. Based on their licensing doc, MS views each physical person as a user and not necessarily the number of user accounts.  Since running your packages doesn't require a physical user connected to the DB, I would assume you don't need any CALs.  I've run into these type of questions with licensing before and you may get different answers depending on who you ask.  I'm almost certain you need either 1 or 0 CALs ...Show All

• tongkusat Page Braking

  We are using sql server 2005 reporing services. In one of reports we have table containg data. In that table we have 2 groups. At asset class level and second is Sector level and then we have detail section. In same report we are showing Report Title and Logo of company at top. Suppose now report is of 5 pages, in our case what is happening is till 4 pages report is coming correctyly but on last page sometimd total is coming at top crossing Company Logo which is at Report Header Level So why is it happenig so can anyone help me out --sandyee ...Show All

• Montana47 ?'s about Access .mdb's <-> 64-bit SQL 2005

  Here's what I need to make happen: Our web app users need to be able to import/export data from our 64-bit SQL 2005 box to an Access .mdb exclusive to them. Legacy apps dictate we stick with .mdb files. When the [export] package is complete, the site should present the finished exported .mdb for download. This process must be able to run in parallel, since multiple users can execute at the same time. Finally, since we can't afford to buy SQL licenses just to run SSIS packages on the web servers, we have to find a way to accomodate that limitation. I have an SSIS package that handles all the file and data movement, and a web site on a separate server that calls the package. I've gotten as far as checking if the file exists through web ...Show All

• LouisPeter About @@ERROR in SQL 2005 online book

  Here http://msdn2.microsoft.com/en-us/library/ms190193.aspx it is explained that @@ERROR will be cleared and reset. But here: http://msdn2.microsoft.com/en-us/library/ms190248.aspx http://msdn2.microsoft.com/en-us/library/ms187009.aspx we still see: IF (@@ERROR <> 0) SET @ErrorSave = @@ERROR Chester Hi Chester, The second example is indeed incorrect as @@error will be reset to 0 by the IF statement. The local @ErrorSave should be set after each statement and them compared: declare @a int, @ErrorSave int; set @a = (1 / 0); -- divide by zero set @ErrorSave = @@ERROR; if (@ErrorSave <> 0) begin select @ErrorSave AS [ErrorNumber] end Cheers, Rob ...Show All

• Divermarv how to extract username and password from ftp connection manager?

  Hi, I would like to know how to programmatically extract username and password from an ftp connection manager. Thanks. I got this code but I want to get the values of every available property in a connection manager. Please help. Thanks! For Each connMgr In myConns Dim connProperties As DtsProperties = connMgr.Properties Dim connProp As DtsProperty For Each connProp In connProperties MsgBox(connProp.Name) Next Next this is where i got the code. I do not know how to extract the value from the properties. there is no ".value" from intellisense. is there a way not to make write-only Hi, ...Show All

• sesnir Grouping Data

  Hi Exports I have a simple question, but I can't seem to get around it. Please help. I have a table like this: [select * from Enrollment] Course ID PersonID Role BCC110 123 Student BCC110 321 Student BCC110 456 teacher BCC123 457 Student and I want to have a report like Course ID Total Students Total Teachers BCC110 2 1 BCC123 1 0 How do I achieve this Sam Feel free to post more info and someone can definitely help. Although because it's a sql question, it might be better to put it in that type of forum. Include a link here that would link us to the new post. ...Show All

• John Fly How do I Install SQL Server Compact Edition from a storage card on a device

  Hi all experts, in case of a cold boot on a device, I insert the the flash SD disk in a device and install the NETCF 2.0 by clicking on the NETCFv2.wm.armv4i.cab which iI previously copied, that's fine it works OK, but is there a cab file for Sql server CE that i can install from the flash disk as well, I'm trying the Sqlce30setupen.msi, SQLServerCE31-EN.msi, an I get a device message "There is no application associated....." TIA Jack You need the cab files located at: C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\armv4i For Mobile 5, Pocket PC, base: sqlce30.ppc.wce5.armv4i.CAB (required) For Mobile 5, Pocket PC, Replic ...Show All

• cdun2 sorting detail items in a report group

  How do you perform an interactive sort of detail within a group I want to put a sort on the loan number header to sort the detail lines withing each group. I DON'T want to re-sort the groups. THANKS Report looks like this: Loan number - Header A - Group break 1234 - loan number detail 4321 - loan number detail B - Group break 2345 - loan number detail 5434 - loan number detail Jim- Were you able to resolve this I'm having a similar problem. Thanks, Geoff ...Show All

• XycsoscyX Security Update for Microsoft Data Access Components (KB832483)

  I recently reformatted my computer and am using Windows 2000 Professional. I enabled Automatic Update. This morning I noticed that the "Security Update for MS Data Access Components (KB832483)" kept showing up. My records indicate that it successfully installed (several times), but the same update keeps showing up to be installed. I finally disabled the Automatic Update function in order to keep it from constantly reappearing. Any ideas Hi Jens, It fixed my problem. Thanks, SiuBo Hi Jens, You old Suessmeyer you! I was about to reply congratulating you on getting rid of that verdammt update which the MDAC installation sorted. However, rat ...Show All

• Nick Karasev How to restore a Sql Server 2005 database backup to Sql Server 2000

  Hi All This is a very urgent requirement of my client having 200 stores and one Head office. the HO has just installed SQL-Server 2005, The HO sends small backups of the data related to stock transfer which needs to be restored at stores. It was working find when both the HO and stores were SQL-Server 2000. but the process has come to a dead halt as the HO has SQL-Server 2005. It is not possible to convert the stores immediately. please help me out. Thanks Raoshan I have learned this the hard way - you cannot restore a SQL Server 2005 backup to SQL Server 2000 due to some changes in the metadata. Even an attach/detach from SQL Server 2005 to SQL Server 2000 won't work. Try out Jens K. Suessmeyer advice, script out the ...Show All

• sheiderpbsj buffer is full

  All, My weekly loading is failed and here is the error message I got. Could someone kindly point me what is the problem and how to detail with it Thanks Error: 0xC0047012 at Fact_ResidentService, DTS.Pipeline: A buffer failed while allocating 63936 bytes. Error: 0xC0047011 at Fact_ResidentService, DTS.Pipeline: The system reports 43 percent memory load. There are 4227104768 bytes of physical memory with 2378113024 bytes free. There are 8796092891136 bytes of virtual memory with 8787211939840 bytes free. The paging file has 10300792832 bytes with 14786560 bytes free. Error: 0xC0047022 at Fact_ResidentService, DTS.Pipeline: The ProcessInput method on component "Union All 1" (3629) failed with error co ...Show All