Answer Questions

• SpoBo sql server mobile 2005 and emulated storage card

  Using shared folder in windows mobile 5 emulator,  it is not possible to create a database (sqlserver mobile 2005)   in the emulated storage card. The error "sql mobile made an unsupported request to the host operating system. Minor Err 25133 is raised.  Reading or writing file from/to  the emulated storage card occurs without error. Is this a bug of  SqlCeEngine thank you vincenzo     ...Show All

• Shankar K removing replication table

  Hi all, Can Enterprise Manager remove a table from replicating to another server I've tried looking at the article tab of the property of the publication but couldn't find a way to delete a table from the article. Any idea Thanks! Sachin, Me too. Step 5 should have been "dropped the database" instead of table. Best Regards~ Don Not sure if this is a recommended approach but you can ...Show All

• Mustafa AYGUN Cannot find my default instance

  Hi, I'm using SQL server 200 Personal Edition. I had a named instance created at the time of installation and a default instance later. Now my default instance crashed and I want to rebuild my master db. But neither can I find my default instance in the drop down in the rebuildm dialog box (Only the named instance is present) nor is it allowing me to edit the server name in the drop down. What should I do Thanks in advance. ...Show All

• EricPaul Error Updating Installed Files

  Well I need to know HOW TO REMOVE MANUALLY every pieace of the Database Services for my SQL Server Express CTP previous installation because the final release won't let me update this Database Services, any suggestion besides removing manually the services thank you all Good to hear you've gotten it figured out, thanks for posting back to the forum. - Mike You should be able to remove the CTP from the ...Show All

• JustJeff INSERTs given me the BLUES

  cstring = cstring + "VALUES('%" + txtWatchID.Text + "%','%" + txtcenter + "%'" & _ cstring = "INSERT INTO tblNEW (watch_id, service_center_num, repair_envelope, store_number" cstring = cstring + "date_purchase, transaction_num, cust_fname, cust_lname, product_code" cstring = cstring + "value_watch, failure_date, service_date, failure_code, repair_code" cstring = cstr ...Show All

• cynistersix Recover data from .mdf and .ldf file?

  Hello! Hopefully someone can help me with the following (potentially huge) problem: We've got a simple database application running on microsoft sql desktop engine. This database contains two tables. Up until now all worked fine, but probably due to a programma that crashed part of the database seems to be corrupted or broken while today only one table contains/returns data and the other table does not return any values! When I open the ...Show All

• jeusdi Transfering and verifying data using temp tables

  Hi, I need to write code that uses temp tables to check data and transfer it to another table. As I understand, data has to be transfered to temp table, and then a loop will check each row for data integrity and move the valid rows into a new table. The code looks something like this. The problem is with this code, the destination table (table 3) contains only one record instead of 375. What am I doing wrong Select CustomerID, StaffID, Sequen ...Show All

• David A. Coursey Derived Column Task failing with error 0xC0049067

  I have a package that fails as soon as it hits the first Data Flow that contains a Derived Column task. The task takes three date columns and looks for a date of 6/6/2079. If it is there, it is replaced with a NULL. This task worked fine until I installed the Non-CTP version of SQL 2005 SP1, earlier today. (I went from RTM 9.0.1399 to SP1 9.0.2047)Does anyone have any ideas Here is the error I am trapping: An error occurred while evaluat ...Show All

• Bhagvat Transactional Replication with Updateable Subscribers

  Hi, I really hope someone can help me with this one- it is most peculiar. I have a SQL Server 2005 publication and associated subscription. Both are sitting on the same server and the agents are impersonating the SQL Server Agent account. The SQL Server Agent account is in the Publication Access List, db_owner of the databases and in sysadmin. The publication is set for immediate updating with queued failover. Identity constraints are ...Show All

• Skyler dealing with .dll files after creating Assembly

  Hi I want to use CLR for developing database object such as stored procedures. I have read the "Getting Started with CLR Integration" from MSDN help and successfully create my first procedure . I create an assembly in SQLServer2005 with this code: CREATE ASSEMBLY helloworld from 'c:\helloworld.dll' WITH PERMISSION_SET = SAFE My questions are : How should I deal with helloworld.dll after creating A ...Show All

• Vijay L key columns heeeeeeelp

  hi i need some help,, i have a dimension like this: dimgeo fiDWHgeoid as my primary key and these attributes ficanalid fidivisionid figciaid with thier description fields: fcdesccanal fcdescdivision fcdescgcia the problem: how can i make a unique key that includes the three id`s i listed in only one and unique key so when i browse my cube it will display the correct match.. i'm really really new in this, i saw a property which is key ...Show All

• XE Paul Handling a double or float value for inserting into DataTime field.

  Hi, I was trying to enter the non-normalised exponential format of double or float value into the DataTime field in my data base. It is allowing to store any kind of data passed to this field. If the same non-normalised exponential value for eg: 4.235E-329 is passed to float or double field we are getting a TDS error but when same thing is used to store in DateTime field it is simply inserting the value. Now my concern is that SQL Server 2005 s ...Show All

• HiTech2000 Upgrade Advisor Analysis Wizard Error

  Hi, Analysis Wizard Error: "SQL Server version: 09.00.1399 is not supported by this release of Upgrade Advisor." Microsoft SQL Server 2005 Upgrade Advisor 9.00.2016.00 Microsoft SQL Server 2005 Upgrade Advisor Analysis Wizard 9.00.2016.00 Microsoft.SqlServer.AnalysisServices.UpgradeAdvisor.dll 9.00.2016.00 Microsoft.SqlServer.BestPracticesAnalyzer.UpgradeAdvisor ...Show All

• Erik Poirier Problem with User Defined Function

  I wrote a UDF to get a rolling average based upon a date passed to the UDF. The error I get is: Server: Msg 102, Level 15, State 1, Procedure fn_RollAverage, Line 26 Incorrect syntax near ')'. SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO CREATE FUNCTION fn_RollAverage(@CURVE_DATE AS SMALLDATETIME) RETURNS @TBLRESULT TABLE (US0001M_Index AS FLOAT, US0003M_INDEX AS FLOAT, US0006M_INDEX AS FLOAT, US0012M_INDEX AS FLOAT, usswap2_i ...Show All

• Nino B identity_insert in SQL 2005

  Hi, we're currently doing test runs to make our application run on SQL 2005. In one of our projects, we need to replicate data from one master database to several slave databases. As the primary keys need to be the same, I used the "set identity_insert <table name> on" command to insert the exact same keys in the respective identity columns. This has always worked on our SQL 2000 databases. However, in the test runs on SQL 2005, I get ...Show All