Viewing 15 posts - 796 through 810 (of 1,098 total)
Execute SELECT @@TRANCOUNT to see if there is an opened transaction. If you get <> 0 then close it with commit or rollback (this is up to you), and then...
March 25, 2003 at 10:11 am
No you can't. You could have an instance of SQL 2000 and another of 6.5 or 7.0.
Always installing first the 6.5 or the 7.0
March 25, 2003 at 10:05 am
But how did you create that schedulle?, did you specify to start at one specific time?
March 25, 2003 at 9:36 am
Also check the scope of the #temp table. Because that table is only visible to that connection. Check changing the temp table to a global temp table creating it like...
March 25, 2003 at 9:33 am
If you run the DTS inside a job with windows autenthication, then it will run with the SQL Agent Login account.
To change the local system account, use your login to...
March 25, 2003 at 9:29 am
The jobs are running with an schedulle you specify at that out, or you define an idle condition, and you are letting them run when the CPU is idle?
March 25, 2003 at 7:24 am
Yes it's a timeout problem, a connection problem. Re start the agent. Agree to set the job to notify you.
March 25, 2003 at 7:17 am
I have that error usually because of out slow WAN connection. Is not a big problem, maybe if you try stating the agent again later. This was the distribution agent...
March 25, 2003 at 5:40 am
you could also execute a select top 1 intid from test ORDER BY intid DESC
OR SELECT MAX(intID) FROM Test in your stored procedure
March 24, 2003 at 1:49 pm
I never use a situation like yours, the only problem I can think of is the one I told you. Can you try instead of using merge replication, using transactional...
March 24, 2003 at 1:34 pm
The value from the test table is different than from the inserted table?
March 24, 2003 at 1:04 pm
I have 74 subscribers to one publisher, and is very common that I have those kind of problems, since some months ago (before I started) they lost the data with...
March 24, 2003 at 12:14 pm
Does all kind of replication involves the same articles, I mean the same tables?
Because publisher A will undone any changes that the subscriber D made and that will be replicated...
March 24, 2003 at 12:04 pm
What you have to do is map the network location within SQL server. If you map it from windows (DOS), SQL server doens't recognize the mapping so it won't see...
March 24, 2003 at 10:30 am
Viewing 15 posts - 796 through 810 (of 1,098 total)