Answer Questions

• TGerd Sql Server 2005 (32 Bit)

  Pls provide the link to download the evaluation version Sql Server 2005 32-BIT. Will SS2005 support 32-BIT You'd think this is pretty obvious :) goto www.microsoft.com and search for sql server 2005. ...Show All

• BigGamer Getting intermittent error with SQLDMO objects

  In an application that uses SQLDMO object to BCP data into a empty table in a database I get the following error only occassionally on one or two machines out of hundreds. I would like to understand why and resolve the issue. From the application log file.  Bulk Copying data [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 84) was deadlocked on lock resources with another process and has been chosen as the deadlo ...Show All

• DGKol dynamic sql query syntax

  Hi friends I need ur help with syntax of following dynamic sql.actually it is simple version of what am doing but i know for sure this line actually causing the error. DECLARE @p_taskentrydtfilter nvarchar(50),@taskentrydttag nvarchar(100) declare @p_taskentrydt DATETIME set @p_taskentrydtfilter= '>=' set @p_taskentrydt = '20050609' select @taskentrydttag=case when (@p_taskentrydt='' OR @p_taskentrydt is null) then '' else ' and task.entrydt ...Show All

• SPC Posson Triggers

  I am working in a database which tracks arrival and departure times for all employees. I am trying to create a trigger to warn an employee that his/her entry record is outside the working standard hours. For example: if the employee arrives before 8:15 AM , the system needs to show a message requiring an explanation for the employee’s arrival before the standard arrival time. If the employee offers an explanation, the system accepts the en ...Show All

• angelok2 ROW_NUMBER() and projected row count.

  Is there a way without rerunning the select query to get the "total row count" using ROW_NUMBER and BETWEEN as such.. SELECT * FROM ( SELECT ROW_NUMBER () OVER ( ORDER BY Year DESC , Month DESC , Day DESC ) as RowNum , e . id , e . Title FROM Events e ) as DerivedTableName WHERE RowNum BETWEEN @startRowIndex AND ( @startRowIndex + @maximumRows ) - 1 typically i wo ...Show All

• PaulWelby MIRROR database questions

  Hello all. I was reading an article by Rich Heiges called Mirroring - A New Look at HA. It left me with 2 questions (A) Can I change the operating modes of the principal and mirror roles on the fly, or do I have to stop the MirROR process (B) It said that MIRROR supports 32-bit to 64-bit H/W interoperability -- but will it support interoperability between 32-bit and 64-bit instances of the database Thanks! Th ...Show All

• NathanINTJ LIKE % question

  Hello, I'm working on a project where I have a drop-down menu (collectionlist) of different words, which are part of a title which is located in my database. The bolded line is where I'm having my problems. I'm not sure how to place the LIKE statement. I will give you a quick example of what I would like to do: In the CollectionList, there is the word head. In my database, there is the title, head with earrings . I would like t ...Show All

• szevvy Connection from SQL 2005 to Informix 2000

  Hi All, I'm trying to set up a SSIS package to pull data from a data sourse on an Informix 2000 server. I'm currently using an OpenLink driver to access the data through ODBC, however when I try to query it through BIDS or using the SQL management Studio's import feature it says that the objects don't exist for what I'm querying.. I can view the tables in the query builder, just not query them Has anyone any suggestions as to how I might ...Show All

• bbauer rsReportServerDatabaseUnavailable

  I have to reinstall SQL Server cause a failure. Before I installed it, I create the reportserver database with the configuration tool and now I can't acces report server with this error rsReportServerDatabaseUnavailable. Login failed for user 'NT AUTHORITY\Servicio de red'. Any Ideas Thanks in advance How do tou change user account Make sure sql server and sql server agent ...Show All

• Phildotnet SQL Server 2005 data export wizard did not transfer stored procedures

  OK, I got the data transferred, but now  SQL Server 2005 data export wizard did not transfer stored procedures. .. I am transferring from SQl Server Express 2005. Just trying to get the starter kit working, it used to be easier... Please help The only option to connect to the server is by clicking connect button. It remebers the old settings. It would be nice to have it saved in registered Servers. However it still shows me all server ...Show All

• JamaSaru refresh data best way?

  Hi There I have a production server and a training server.On a monthly basis the training server needs to have data refreshed from the production server.This consists of approximately 1000 tables, with a few hundered thousand rows from many of the tables. I was wondering what would be the best way to accomplish this in integration services.Obviously i do not want to create a task for each of the 1000 tables, and the data needs to be copied ...Show All

• Jonathan Pickard Problems creating full-text population schedule via Management Studio

  I am trying to schedule an hourly incremental update of the FT catalog on an indexed query. I have tried creating the catalog and schedule on both a remote machine (my workstation) and directly on the server. I get different errors on the two machines. I have tried creating the scheduled updates during the catalog creation process as well as seperately. I am able to create the catalog and update it manually in both cases. I cannot get th ...Show All

• Justine MSSQL2005 Analysis Service Distinct Count

  hi, i am currently trying to build a distinct count on my cube (mssql2005 analysis services). But after i added the discount count on the field i want to and start the processing, the following errors appear. - Errors in the OLAP storage engine: The sort order specified for distinct count records is incorrect. - Errors in the OLAP storage engine: An error occurred while processing the 'FACT VIEW STATISTIC' partition of the 'FACT VIE ...Show All

• Ian Finnimore How do I consume a DataReader Destination in VB.Net?

  Hi All,    I am attempting to consume the output of an SSIS data flow task in VB.Net.    I want to read the contents of a DataReader Destination into an object and loop through or display the results. Thanks in advance, Andy The BOL topic that you want on this subject is "Loading Data Flow Results into a Client Application." This topic mentions the DtsClient reference as well as the other r ...Show All

• shani241982 Publication Configuration Error

  Hey Everyone, I am trying to setup publishing on SQL Server 2000 Enterprise. I will be subscribing from a SQL Mobile 2005 database so I have installed the SQL Server 2000 SP3a Replication Components, .NET Framework 2.0, and the SQL Server 2005 Mobile Edition Server Tools. I was able to go through the 2005 Mobile Web Synchronization Wizard with no problems. However, when I try to run the Configure Publishing and Distribution Wizard, I get ...Show All