Answer Questions

• newcyan Persistent communication session inside sqlclr proc?

  I suspect this is very poor design but I've been asked to research this: can I maintain a persistent communication session inside an sqlclr proc (tcp/binary packets) The process has to maintain very high throughput - setting up and tearing down a connection on each transaction is cost prohibitive. For TCO and deployment reasons it is preferable not to have a separate windows service etc that accepts requests from inside the clr proc. Is there the luxury of an alternative integrated into the database DONT DO THIS, stored procedures are not windows services. And i believe SQL Server monitors for long running CLR threads and will auto-suspend them. There is some bits and pieces about this in BOL2005. ...Show All

• Marko Hrastovec Alternative to Reporting Services

  Hi, I need a report writer in which I can create some standard reports and also let end user create their own against an SQL Server 2005 database. The writer must have a web interface for users to create and run reports. Crystal Reports was considered too complex for end users. I've been trying with Reporting Services and MS's Report Builder, but it's been crashing on large data sets. Can anyone recommend an alternative that I could look at Thanks, Frank I understand that the concept of allowing end-users to design reports is a popular one in the industry. However, there is a problem, end-users don't know squat about designing databases, data, or reports in general. There are end-user tools that allow them to do this, but if they ...Show All

• Binco How to find a record

  How to find a record in table without key How to get specific record in table without key field and displaying on datagrid hello, you can search with the select statement, e.g. NUMBER:     SELECT * FROM STORES WHERE ZIPCODE = 21512                        SELECT * FROM STORES WHERE ZIPCODE IN (12345, 23145, 23456)                        SELECT * FROM STORES WHERE ZIPCODE BETWEEN 21431 AND 21531 TEXT:     SELECT * F ...Show All

• Dylan Smith SQL CE 3.0 (Mobile 2005) Max DB Size Question

  Hi everyone, What are the consequences for just setting the Max DB Size to 4GB and letting it go at that Is the MAX Size any arbitrary value I want or must it be close to what the actual database is expected to be Also, why did they default to 128MB Wouldn't it have been better to set it to a larger value Thanks Dorothy My tests show that when I set Max Database Size=4090 it created a 20K SDF. If it works anything like most DBMS engines, as you add data, it just adds "extents" (big blocks of data) to accommodate the new rows. I used the "Create Database in Code" example (from my EBook) to test this. hth Yup, we're publishing it ourselves--testing the ...Show All

• Yoni_Nijs Itens of the report in lines and not columns

  Hi, It would like that my report was in the following way, for example: Product A 10 Itens 00001 00002 00003 00004 00005 00006 00007 00008 00009 00010 Product B 5 Itens 00020 00021 00022 00023 00024 This is possible Thank you Sandro Borsatto Look at this blog entry. http://blogs.msdn.com/chrishays/archive/2004/07/23/HorizontalTables.aspx ...Show All

• mrotoloni Database Mail (can't connect to SMTP server)

  I'm new to Database Mail and SQL 2005. I have an existing SMTP server (not local) which I'm able to connect to and send mail using Outlook. When I try to connect to the same SMTP server in Database Mail, I get the following error in the Log: Message The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2006-09-20T17:04:21). Exception Message: Could not connect to mail server. (An established connection was aborted by the software in your host machine). ) No matter what variation I try, I can't connect to the server. I also tried setting up a local SMTP server (the one that comes with IIS). I was able to send mail out successfully from Outlook using this local SMTP server too. ...Show All

• RussP save data to disc

  Please help me I use sql express + C#, and when i execute my queries like "insert" into table, my data exist in dataset while i compile my project. How i can save my data to my data source, and how i can see my data in my table in data source Please help me, how i can save my data from dataset into disc file mdf. It was very helpful for me! thx hi, depending on your "use", you should check the InsertCommand of your object is accordingly set to your needs.. but, as you say you are using an Express edition of VS, chances are you actually save your "changes" to the datasource, but you "overwrite" the existing database physical files at each application start-up becouse of User Inst ...Show All

• AMSS Sharepoint SQL Problemas

  Hi, I had already setup a SharePoint 2007 Server with a SQL Server 2005 in the same machine. I cloned the full computer and now my SharePoint clone is pointed to use the old SQL Server. How I change my cloned SharePoint to use my cloned SQL Server The old configuration diagram OLD_COMPUTER - SharePont 2007 --> (pointed to) OLD_COMPUTER SQL Server OLD_COMPUTER - SQL Server The actual configuration diagram NEW_COMPUTER - SharePont 2007 --> (now pointed to) OLD_COMPUTER SQL Server NEW_COMPUTER - SQL Server The desired configuration diagram NEW_COMPUTER - SharePont 2007 --> (pointed to) NEW_COMPUTER SQL Server NEW_COMPUTER - SQL Server Ariel, To get the answer quickly on exactly how ...Show All

• mharoun_ca Loops and building comma delimited strings

  The problem: I have 2 tables, with a one to many relationship - lets say customers, and order items. Each order record has a field that is meant to be a comma delimited list (they are reference numbers) that is driven by the quantity field. So, say in the order record, an item has a quantity of 3. The reference number will look like this: 1, 2, 3 And if the next order item for that customer has a quantity of 4, the reference number value is 4, 5, 6, 7 And the final item with quantity of 2: 8, 9 Reference numbers can either be auto assigned (and are in my web application) or manually set. If manually set they will NOT be numeric. In my web application, it is possible for users to return to a customer's order and ...Show All

• Osiris43 Lookup Task Datatype issue

  Hello: I'm attempting to use the lookup task and i'm running into an issue about incompatible datatypes. The table that i'm referencing in the lookup has a field named DateCreated, and it's DataType is DateTime. But when I hook it up to the Lookup Task, the lookup task thinks it's a DB_Timestamp, so i get an incompatible data type error. What can i do i'm not sure if this would resolve your issue, but have you tried using the data conversion component SamuelEe , maybe i misunderstood you. however, the lookup transformation is a data flow component. SamuelEe wrote: Duane: Thanks for your reply. My problem is not with the dataflow, but with the Lookup Task misinterpreting the Data Type of ...Show All

• Ademaure Connection provider for DBF file

  Hi, I want to upload some DBF files to SQL server using Integration Service. I already check every provider, but not found provider for DBF file. Anyone can help me You're right. Thanks a lot. Hi! While the Jet OLE DB data provider will work for older Dbase IV formatted DBFs it will not work for Visual FoxPro tables. The FoxPro and Visual FoxPro OLE DB data provider works with all versions of FoxPro DBFs. As I said in my other post, it can be downloaded from msdn.microsoft.com/vfopxor/downloads/updates. Hi! You can download the FoxPro and Visual FoxPro OLE DB data provider from msdn.microsoft.com/vfoxpro/downloads/updates. It works for all versions of Fox ...Show All

• Roman Hnatiuk Full Text Search Weighted Question

  Hello, I have the following query: USE test SELECT new.[key], new.rank, test_Class.Manufacturer, test_Class.Model, test_Class.Title, test_Class.Description FROM test_Class INNER JOIN FREETEXTTABLE(test_Class, (Manufacturer, Model, Title, Description), 'Logan') AS new --CONTAINSTABLE(test_Class, (Manufacturer, Title, Description), 'Logan Magnolia') AS new --FREETEXTTABLE(test_Class, (Manufacturer, Title, Description), 'Logan') AS new on test_Classs.Class_ID = new.[key] ORDER by rank desc I want to have the search work so that if the word logan is in the Manufacturer Column it has a higher rank than if it apeared twice in the description. Basically I want to weight the colomn instead of specific words in the search, which I know how to do. A ...Show All

• IamHuM Calendar Control issues

  Hi all, When I click on a calendar control for date parameters the page will freeze or throw a java script error. This does not happen all the time, and is not isolated to one PC. It happens randomly on several PCs. Is there any known issue with this control regards, Bill No it is not by design. :) I am surprised that it does take so long to load. Is this happening the first time you view the report or when navigating through calendar months If it is the first time, the calendar is one of the last things loaded on the page, if the entire page is still loading (IE will render objects and allow interaction even though the page hasn't finished loading) the calander may not be loaded until the page ...Show All

• GrandpaB Error on using VB in calculated members AFTER stepping up to Enterprise version ??

  I have "succesfully upgraded" ( ) our SQL2005 from standard to Enterprise version. Before, following set worked like a charm: CREATE SET CURRENTCUBE.[Now CY] AS strtomember("[00 - Time].[00 - H - Calendar].[Day Name].&[" + format(now(),"yyyyMMdd") + "]"); But when I process the cube now, I get this error: Error 1 MdxScript(Sales) (58, 74) The '[now]' function does not exist. 0 0 It seems like the reference to Visual Basic has been lost somehow Curiously following calculated member works, even it also uses now() CREATE MEMBER CURRENTCUBE.[MEASURES].[Now] AS now(), FORMAT_STRING = "yyyyMMdd", VISIBLE = 1; Any suggestions please ;-) / geert larsen denmark ...Show All

• laboremus Connecting to Oracle Datasource for import

  Now this is the first time i have tried this with SQL 05 I am trying to Import data from an Oracle DB. I have the connection info: Xtx20xxx = (DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST =urlpart1.part2.part3.com)(PORT = 1521)))(CONNECT_DATA =(SID = Xtx20xxx )) ) I used the Microsoft OLEDB provider for oracle from the dropdown, The username and password I have also. I tried to enter in the Xtx20xxx as the server name, clicked "Properties" put in the username and password I can given and clicked "Test Connection". No matter what I get the infamous ORA-12154 : TNS :could not resolve service name error message. I am sure I am missing something obvious here but I have absolutely no clue and ...Show All