Search results for query: *

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...

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...

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 ?

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 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...

I am trying add or edit a table row and get this error message: 'GETMAXVERSION' is not a recognized function name The updatelineage function requires 2 arguments If I create a new table, I am able to edit it, but not with old entries in old tables. Any suggestions ?

Hello, I am trying to make a successful replication and currently the SQL Server never had one before. So I need to change the Server to be a distributor but I get this message : Error 14113. Couldn't copy DISTMDL.MDF DISTRIBUTION.MDF .. What's the problem here ? All directories exists.