Answer Questions

• CBuilder Trying to access SQL SERVER 2005 with Access 2003

  I am trying to connect through ODBC connectivity, but it will not allow me to do so. I have investigated this matter. It leads me back to the server, because as I was configuring my client side database. It kept asking for the DSN(datasource name), but I was unable to choose one because there wasn't one to choose. Which is my current dilemma, How can I do this and have it available to choose from the server to satisfy the Access database I went to the domain where the software resides but I don't know what steps to take I also found an interesting piece on microsoft about Kerberos, but I can't follow along according to the instructions it has. I have Access 2003 & SQL SERVER 2005, HELP...! Basically, this is right off the ...Show All

• DaveHerrmann Full text search multiple tables

  Hi all, I want to full text search on multiple tables. Example my strSearch = example full text search engine. "SELECT TOP (100) PERCENT FT_TBL.Description AS mota, FT_TBL.test1_ID, KEY_TBL.RANK FROM dbo.test1 AS FT_TBL INNER JOIN CONTAINSTABLE(test1, *, '"+strSearch+"') AS KEY_TBL ON FT_TBL.test1_ID = KEY_TBL.[KEY] UNION ALL SELECT TOP (100) PERCENT FT_TBL1.Description1 AS mota, FT_TBL1.test2_ID, KEY_TBL1.RANK FROM dbo.test2 AS FT_TBL1 INNER JOIN CONTAINSTABLE(test2, *, '"+strSearch+"') AS KEY_TBL1 ON FT_TBL1.test2_ID = KEY_TBL1.[KEY]" I want to show results order such as GOOGLE: show top records full keyword "example full text search engine", then continune left ph ...Show All

• Adrigo Gallus Should be easy - help formatting a conditional Query.

  SQL Server 2000. Here's what I have so far. The section of the query I need help with is highlighted in blue.   CREATE PROCEDURE dbo.GetByVersion (  @targetVersion varchar(30),  @product varchar(50) ) AS  SET NOCOUNT ON; SELECT *  FROM  MyTable WHERE (product = @product) AND   CASE      WHEN @targetVersion='' THEN (targetVersion='')     ELSE (targetVersion LIKE @targetVersion + '%')   END GO   I get a syntax error in the Stored Procedure editor on an equal sign in this line:     WHEN @targetVersion='' THEN (targetVersion='') What I want is this (in psuedocode):   if @targerVersion is blank   & ...Show All

• shahidferoz Adding Data Viewer causes BI Studio to crash

  I am having this issue with BI Studio when I add Data Viewer to a relatively large data set, it causes the Visual Studio to crash. Has anyone experienced this Any help on this will be highly appreciated. Thanks, Ashish Also, I should mention here an important information. This happens only when I set the MaxBufferRows to 1000000 and BufferSize to 104857600. Thanks, Ashish Yes those are the properties. I needed to change the properties because the load was slow and I need to increase the throuhput. Changing properties should be handled by the app and crashing must be avoided at all costs. Thanks for your input though, Ashish Phil Brammer wrote: Reset your buffers to whatever you want ...Show All

• abuck DateAdd function error when used in report subscription

  I have found that when I use the dateadd function within a parameter in a report subscription, the subscription status indicates that sql mail email was sent to recipient, but no email was actually sent. I have two default parameters in the report to filter data between today's date and minus 7 days (one week ago): ToDate(=Globals!ExecutionTime) and FromDate (=DateAdd(DateInterval.day,-7, Globals!ExecutionTime) If I deploy the report to the server containing just the first default parameter, ie, today's date, the report subscription works fine and email is sent. But when I add the second default parameter containing the dateadd function, status indicates email sent but none actually is. Has anyone encountered this problem I am u ...Show All

• Gerhardo set password on report server 2000

  Hi, i want to set a username and a password on a running report server 2000 for login. how can i do this i already got it :) ...Show All

• Zadoras include column from table in SELECT in an INSERT OUTPUT clause

  Hey All – I am having problems with the OUTPUT clause in an INSERT. I have something like this: INSERT INTO dbo.Person ( PersonID ,Name ) OUTPUT p.AuditVersionGUID ,inserted.PersonID ,inserted.Name INTO dbo.PersonAudit ( AuditVersionGUID ,PersonID ,Name ) SELECT p.PersonID, p.Name FROM #Person p AuditVersionGUID is not and shouldn’t be defined on the Person table but I do have it defined in my #Person table. I get this error: Msg 4104, Level 16, State 1, Procedure spExtractPerson, Line 275 The multi-part identifier "P.AuditVersionGUID" could not be bound. I can accomplish this when I ...Show All

• Jive Dadson SSIS DTC Transaction's HOT questions

  I am using SSIS with Transaction, and I met a lot of questions as below: 1.IF DTC doesn't support ADO.NET Connection Please check the ADO.net Connection's property, it has a property named like: DTCTrancactionSupport. But it's always set to False and unable to edit. IF the answer is NO, HOW could I bound all my Tasks into one Transaction You know, I have some Tasks with SQL connection, and I have also some Script Tasks, witch need the ADO.net connection. 2.IF DTC required to run in both the Destination Server and the Source Server I have a Dataflow Task, and take some data from a table in a Source Server to a Destination Server. The DTC doesn't run on the Source Server. I found the Dataflow Task hangs when I use the SSIS ...Show All

• Criminet Help about running SQL CE on Win CE 4.2

  Hi everybody, I developed mobile programs for WM5.0 with C#.NET using SQL Mobile. (Visual Studio 2005, SQL Server 2005 Mobile, Mobile SDK) But I couldn't run SQL CE on WinCE 4.2 (Visual Studio 2003, SQL Server 2000 CE). For example on emulator, an Insert command is running successfully. But on device (Intermec CK 31) we are getting error. Here is my code : using System; using System.Data; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data.SqlServerCe; namespace UmurBS.Forms.BasimSayimForms { public class bsEkleForm : System.Windows.Forms.Form { private System.Windows.Forms.DataGrid dg; private Syste ...Show All

• Damian Otway Assistance in connecting a SQL Server Client to SQL Server sitting in a shared environment

  Hi, I need to connect to a SQL server thats running in say abc.trident.com and also sits in a shared environment.. I have couple of questions 1) That SQL server is accessible from my network, yet when I swtich on my enterprise manager I am unable to view that in the list of running SQL servers in the populated list. Is it because its sitting in a shared environment I am unable to view that 2) What is the connection striing I should use to connect to the server..When I try to configure a SQL server registrations it normally asks for SQL Server name along with the user authentication Should I mention fill the Server: field as  abc.trident.com or // abc.trident.com/abc.trident.com to connect to the clus ...Show All

• kcchesnut SQL Buffer Cache empty -- SQL 2005 Dev Edition

  Can anyone tell me how and why my buffer cache would contain 0 items in it Same query similar database different hardware but same scheme as SQL 2000 equivalent is peforming 10X faster than index optimized version on SQL 2005 and using database snapshot. Is this possibly a configuration problem on my end Did you look at the execution plans   Are they different   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     < HVJ@discussions.microsoft.com > wrote in message news:1633729f-ce3b-448e-96be-373f2878847f@discussions.microsoft.com ... I did not completely review the undocumented DBCC CACHESTATUS comma ...Show All

• Jason N Report SnapShot Creation Programmatically through Java

  Hi, I am facing some issues while creating report snapshots programmatically using axis (Java platform for creating and deploying web services applications). To create a report snapshot what should be the methods called I tried using UpdateReportExecutionSnapshot() but didn't find any parameters to set the schedule information which would say when the execute the report snapshot. Can you please guide me for this Also I had one more doubt regarding report snapshots. If a parameterized report is configured as snapshot then we would require to set default parameters for the report. Is there a way to create snapshots of the same report with different parameters eg : The employee information report displays the information base ...Show All

• Saptagiri Tangudu SetDefaultInitFields fails for a Column using ExtendedProperties

  Hi, Using SetDefaultInitFields fails for a Column when specifying "ExtendedProperties" as a field. note: SetDefaultInitFields seems to be ok with "DataType" as a field. The exception is "unknown property ExtendedProperties". Thoughts on what might be the issue with loading the ExtendedProperties Thanks, Andy B Following is a snapshot of the test code: System.Data.SqlClient. SqlConnection dbConnection1 = new System.Data.SqlClient. SqlConnection (); dbConnection1.ConnectionString = "Data Source=.\\SQLExpress;Integrated Security=SSPI" ; dbConnection1.Open(); Microsoft.SqlServer.Management.Common. ServerConnection serverConnection1 = new Microsoft.SqlServer. ...Show All

• jiao accessing report

  Hi, I have created a sample report called Report1 in SSRS 2005. This currently is running locally on my workstation. I can even browse to it using the http address i.e. http://localhost/Reports The question is: How can someone else access this report on my machine. They can not browse to my machine by typing http://12.32.2.344/Reports Do I need to do any configuration in my local IIS Thanks ...Show All

• Olyx Analysis service does not remain started

  I have installed SQL Server 2005 Standard Edition for our Team Foundation Server install. I have verified the installation and all seems well, except that the Analysis Services service does not remain started. I get a message like "Some services stop if there is nothing to do." The Analysis service needs to be running in order for the TFS install to succeed. How can I get the Analysis Services service to remain started Thanks in Advance I didn't use those parameters - I followed the "How To: Install SQL Server 2005 for Team Foundation Server" doc. I installed it all interactively. Since the default is to not start these services, this shou ...Show All