Recent content by Laffern

I need to delete my database. So I deleted its running publication and still receive an error message from the SQL Server, that a publication is running. Is there a way to destroy the publication information completely ?

While I can read a whole row of a database table with SELECT *, how it works with pushing data into Tables ? Actually, I read row from an external server and want push it into my local database. Both databases, the server and mine have the same table schema already. Due to the number of columns...

not sequential ... that's the problem

Example Rows Columns : ID, Group, Date 1 - G1 - 30.04.2005 2 - G2 - 29.04.2005 3 - G1 - 28.04.2005 4 - G1 - 27.04.2005 5 - G2 - 26.04.2005 6 - G3 - 25.04.2005 7 - G2 - 24.04.2005 8 - G2 - 23.04.2005 9 - G4 - 22.04.2005 10 - G5 - 21.04.2005 Main row is ID 6 (Today). I need this output : 5 -...

I have a problem with a SQL Statement. For example : I have 10 Rows in the database with the ID 1 to 10. The main row is selected by date. Then 3 other rows should be selected. 1 row above the main one and 2 below the main row, and they aren't selected by date. The "TOP" syntax doesn't work...

It's a merge replication. Yesterday I found an option to modify subscribtion length and switched it to unlimited (possible performance problems may occur). But that cannot be the best solution.

Anybody knows the error's background ? Made a replication between the SQL Server and PDA Devices. After few sucessfull attempts, the error occurs. The subscription becomes invalid. Is there a way to stop this ?

I get this error while trying to do an INSERT "Data Conversion failed" [OLE DB status value] What's that ?

That's strange. Each table has rows with NO identity.

Is there a way to find out which column is an identity one ?

I got the error 25016 while inserting into a table. The solution from the msdn: Ensure that no duplicate key violations have occurred. Such violations may occur when users insert records into a table with an identity column. SQL Server CE remote data access (RDA) does not manage identity...

I have found the solution for this error. http://support.microsoft.com/default.aspx?scid=kb;en-us;278894 They've changed the link. Haven't found it at my first attempt.

I have a problem while creating a new publication. -Error 1913: There is already an index on table 'table_name' named ... and so on if you go to http://www.oogle.de and write this search term : publication error Error:1913 the first result describes a microsoft bug. But this page doesn't...

The problem was the replication itself. I have deleted all replication related entries and now it works.

No, happened after I deleted the publication for this database. I think this is the reason and that some parts were not deleted from the DB. I have still problems solving it.