Search results for query: *

hi there, I cannot start the SQL Service Agent. When I select Start in Enterprise Mgr., I get error 1056 (an instance is already running). But the Service Manager shows that it is not running (a red colored box for the agent instead of a green arrow). The status bar says it is stopping. If...

hi there, i'm running snapshot replication on sql 2000 (SP2). the snapshot agent fails with the following message: "The process could not bulk copy out of table '[dbo].[syncobj_0x4145433644344643]'." "I/O error while writing BCP data-file (Source: ODBC SQL Server Driver (ODBC)...

hi there, i'm running snapshot replication on sql 2000 (SP2). the snapshot agent fails with the following message: "The process could not bulk copy out of table '[dbo].[syncobj_0x4145433644344643]'." "I/O error while writing BCP data-file (Source: ODBC SQL Server Driver (ODBC)...

hi there, i'm running the database maintenance plan in sql 2000. when the job tries to check data and index linkage", the log comes up with status failed with the following message: "[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be...

hi there, i'm running snapshot replication between 2 databases on 2 remote servers. i use the DEFAULT options. but it always seem to fail. i get the following message: "error 4813" Expected the text length in data stream for bulk copy of text, ntext, or image data." this also...

hi there, i'm a newbie to this. my transaction log is running out of control!!! i've set transaction log backups mon-fri running every hour during working hours. with the option "remove inactive entries from transaction log" ticked (is this the same as "truncating the...

hi all, i'm replicationing between 2 databases on 2 different servers. how can i tell that replication is actually working?? the type of replication is "snapshot" and the distribution agent updates the subscription every 5 minutes. cheers

hi there. i'm setting up a db maintenance plan (running windows 2000). but when i run the jobs, it fails i get the following message in job history: "sqlmaint.exe failed. [SQLSTATE 42000][Error 22029]. The step failed." microsoft support says this: CAUSE The string for the target...

hi there, i got to work from the weekend and tried to start up sql (2000) when i got the following message: "An error 1060- (the specified service does not exist as an installed service). occurred while performing this service operation on the mssqlserver service" need help...

i backup my sql backups to disk. when i run nt backups the backup exec can't access the data and log files because it is "sharelocked". how do you backup sql 2000 files that are sharelock?? does sql have to be "turned off" before the nt backups begin?? if so, is there a way...