SA

your restored database should not be fragmented, at least not if there's enough continous space on the disk available. When you restore the database to a different machine, the first...

Thanks or the reply Skeane.

I know that there are issues than comparing data from different collations, even though they look very much the same. But in my case the whole...

I find it hard to believe that the Publisher database would be inaccesible after the snapshot agent stopped. Probably the agent is still retrying.

What kind of error do you get....

Thanks for your reply, but I found the reason for this behaviour.

I had checked the start parameters before (in EM and the registry) and it looked to be ok....

Hello guys,

I think I solved it. The reason why my jobs there not scheduled properly was because I didn't define a jobserver. Even though EM showed the job as a...

Bill,

I checked before. All the jobs and the schedules are enabled. And it happens to all schedules I create through sp_add_job_schedule. And no, the jobs don't have a end date...

Maybe one more information, I recognized that xp_enumerrorlogs only returns the logs 1 to 7, but not 0 (which is the current log). Executing sp_readerrorlog works and returns the content...

MG,

thanks for the hint. And yes I should have realised that I ran into the same issue before.

Markus

Question1, will the added column break your application and/or procedures? it depends. If you use select * and your application can't handle the extra column it might break. Also INSERT...

Shailendra

in the registry there's a setting HKey_Local_Machine\Software\Microsoft\MSSQLServer\MSSQLServer\LoginMode

If you change this to 2, Sql logins are allowed and you can use the sa account to logon (if you know the password).

Markus

Hema

for a comparison of the two have a look at this article http://www.sqlservercentral.com/columnists/pibison/logshippingvsreplication.asp.

Markus

Santosh,

SQL2K5 Ent edit. can only be installed on W2k SP4 or W2K3 SP1. If it's just the client tools you need you can also install them on WinXP SP2.

Markus

Skeane

we use transactional replication with push subscriptions on SQL2K SP4. The reason why it's not working is probably that the distributor server is not defined as a linked server on...

Skeane,

yes I connect with my windows account which has sysadmin permissions on the the subscriber, the distributor and the publisher. And as I wrote before the procedure sp_MShelpsubscriptionjobname can be...

Hello everybody,

I think I solved the issue. First of all the procedure in question resides in the master and not in the distribution database. Second the fact that I couldn't...