Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error during snapshot replication (2005)

Status
Not open for further replies.
jeffmoore64

jeffmoore64

Programmer
Mar 23, 2005
207
US
Here is the error I get as seen in the log file viewer.
Notice the last line!!! This is SQL that the server is generating.
Anyone have any ideas on how to fix this?
TIA
Jeff

Code: 
Step Name		Run agent.
Duration		00:00:39
Sql Severity		0
Sql Message ID		0
Operator Emailed		
Operator Net sent		
Operator Paged		
Retries Attempted		0

Message
Category:COMMAND
Source:  Failed Command
Number:  
Message: select * from "dbo"."whm09_2" where 1 = 2
 
Status
Not open for further replies.

Similar threads

torquinian
  • Locked
  • Question
Error 0x80131904 when trying to connect to database
Replies
0
Views
176
torquinian
torquinian
DougNaf
  • Locked
  • Question
SQL 2016 - DB attachment and error 3415
Replies
1
Views
162
fredericofonseca
fredericofonseca
griffitd
  • Locked
  • Question
SQL 2005 replication hanging
Replies
0
Views
60
griffitd
griffitd
gioacchinolupi
  • Locked
  • Question
Deleted SQL Server Database 2005 1
Replies
1
Views
236
TimothyCarr
TimothyCarr
bluto99
  • Locked
  • Question
Replication snapshot retention
Replies
1
Views
69
yelworcm
yelworcm

Part and Inventory Search

Sponsor

Back
Top