Answer Questions

• videsh Replication for Full-Text Index

  I have built a Full-Text Index on a indexed view. I'd like to replicate this indexed view from a control database to a live database. What values should I specify for @type and @schema_option for the sp_addarticle sproc to ensure the Full-Text Index is still functional after it's replicated For now, I have set @type="indexed view logbased" and @schema_option=0x90000F3. Are these values correct Could anyone give me some advice on ...Show All

• Prince Kwadwo Kuragu How do I integrate with SourceSafe or TFS-VC?

  Where can I find information about how to integrate a SQL 2005 database with either SourceSafe or Team Foundation Server Version Control I would like to have database changes for tables, views, stored procs, etc. under source control. Is this even possible You do not integrate the database itself with source control. What gets integrated is your development environment. (i.e. Management Studio and BID Stud ...Show All

• Borook Updating data source schemas for cubes

  I have built a data source view and a cube. The datawarehouse is in the design phase and the management is not yet sure about the desired facts. So that I have and I have to do a (small) redesign of the database from time to time add/delete columns for the underlying tables. Since now, I'm always recreating the cube, which is a little time consuming. Is it somehow possible to update the data source view and the cube in VS to the current table s ...Show All

• Michel4CE Fixed

  I fixed the problem, what I was doing was working.  I was doing something stupid.  I was not refreshing the user properties in the GUI. Great to hear. Thanks for reporting back. ...Show All

• Nancy Sullivan Why is this query not right for SQL Server?

  hi, I have this query, #ReturnItems is a temp table have ProductID, CreditCode, NonCreditCode and Amount, all are int. select ProductID,  sum(TotalCredits), sum(TotalNonCredits) from   (   select   ProductID,  sum(ReturnAmount) as TotalCredits, 0 as TotalNonCredits     from #ReturnItems where CreditCode > 0 group by ProductID   union   select ProductID,  0 ...Show All

• 105 Cross Row Referential Integrity

  In SS05 XML typed columns, is it possible to have cross row constraints and referential integrity Say I have a column with two schemas: Author and Book. Each has an ID. Each row in the table has only one author or book. Can I enforce that all Author ID are unique across all rows and that there is an author for every book Is it possible now If yes, how If no, is there a plan to add this feature in the future Is there any work around now ...Show All

• Daniel Leom Insert with condition

  Hi, what i am trying to do is, reading from an array which has the column name and value and then insert that value to the column which is fetched from that array.And on the other hand i should use select to get the data's which have the same ID. more detail: what i have >> (VARID,columnName,Value) what i want>> insert to table (columnName) values (Value) while ID =VARID any idea how i should do that tnx ...Show All

• optyler sp_helplogins

  I tryning to program (in VB.net) sp_helplogins, assuming this is the correct sp to use to determine who is currently logged onto the database. Ive already programmed, in VB.net, the execution of sp_helpuser and get correct results, but don't seem to be able to program sp_helplogins. Any help would be appreciated. Thanks, /jerry Thanks Louis, I'll give sp_who2 a try... I ran it from MSDE Mana ...Show All

• timothy leung dynamic change of graphs type

  We have a requirement where we show a particular simple graph in type columns. we wanted to give the user a parameter like Type: which has some or different charts in it. i would like to give a user a feature of dynamically changing the chart type. hope you understand me. let me know which is the property i need to assign the parametere value and where i should write that OK, just figured out a work ar ...Show All

• ivanotto Release database lock

  Actually I'd like to know how I got the lock and then you can tell me how to release it. Here's the problem (this is sql server 2000 with visual studio 2005) I have a windows service that wakes up every 5 minutes and does some database work (reads rows from a table, process them, inserts them into another table). When the inserts are complete, the process should (I would think) release the database lock, but it doesn't. The database is access ...Show All

• Hans Bothe Distributed Transaction completed error

  Hello, I am running a package that has an Execute SQL Task, a Data Flow Task, and then an Execute SQL Task. My Data Flow Task in set to run in a transaction (ReadCommitted).  The first Execute SQL Task and the Data Flow Task run successfully.  When the last Execute SQL Task runs, I get the error message: "[Execute SQL Task] Error: Executing the query "select start_time from TRD_JOB_HISTORY where job_history_id = " failed with the follo ...Show All

• Siza ActiveX Script Task] Error:

  Hi,  I'm trying to reset the below  Global varialbe in SSIS - Activex script. Function Main() DTSGlobalVariables("GxvFilename").value =null Main = DTSTaskExecResult_Success End Function Getting the below  Error when executing the package. [ActiveX Script Task] Error: Retrieving the file name for a component failed with error code 0x060339E4 Please provide me solution for this. Thanks,     ...Show All

• duy99 Backup CERTIFICATE Fails

  I've problems with backing up the certificate (on the Witness Server). On principal and mirror, it works fine (Win 2003 Server, US English), but on my local PC (XP Prof, German) what i use as witness Server following backup command raises an error: USE master ; CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'something$Strong123' ; CREATE CERTIFICATE HOST_W_cert WITH SUBJECT = 'HOST_W certificate for database mirroring' ...Show All

• cevans Missing ODBC Driver

  I have a Windows 2000 development server with multiple instance of SQL Server 2000 Dev Edition installed. Recently, i encounter an error on Enterpise Manager. "A connection could not be established to SERVERNAME\INSTANCENAME . Reason : Data source name not found and no default driver specified. Please verify SQL Server is running and check your SQL Server registration properties(by right-clicking on the SERVERNAME\INSTANCENAME ...Show All

• eric8910 help importing large flat file into relational tables

  I am trying to find the best (fastest) way to import large text files into sql server 2000 relational tables. The database has simple recovery model. The total size of data to be load is about 1gb (each file) source: Multiple source files with different layout. Destination: 3 sql server tables; a parent table with a ID (IDENTITY) primary key and a 3 column unique index (alternate key) and a detail table that has a DETAIL_ID (IDENTITY) pr ...Show All