Thanks for pointing out ! I should have been more clear !

what I meant by sybase is SYBASE ASE 12.5.4 or 15.0.3

and...

Mainly dump is used for SYBASE where as backup is used for SQL.

dump database [dbname] to 'compress::/<pathname>.bak' ==> for sybase

backup database [dbname]

to disk = 'd:\tempdbackup\dbname.bak'

HTH,

\\K

RaviShankar1234 (4/13/2010)

---

Hi Folks,

Here is my question, I have database that is in full recovery mode, I have mdf and ldf files on two different drives and Logfile continuously growing.

a. My...

RaviShankar1234 (4/13/2010)

---

Hi Folks,

Here is my question, I have database that is in full recovery mode, I have mdf and ldf files on two different drives and Logfile continuously growing.

a. My...

Hello,

Thanks for posting back as this can help others having similar problem to get resolved.

Glad could help !

Thanks,

\\K

Garadin (4/8/2010)

---

If the situation is really as simple as your example, then you can check it with case statements... (Note: sorry, not on a SQL Server atm, so not...

Garadin (4/8/2010)

---

If the situation is really as simple as your example, then you can check it with case statements... (Note: sorry, not on a SQL Server atm, so not...

mangeshd (4/6/2010)

---

You can easily check the article settings by querying the <publisher db name>..sysarticles table. Check the values of INS_CMD, UPD_CMD and DEL_CMD. You will have to do this in...

Hello,

Sorry my bad .. your code works fine .. Thanks a lot 🙂

Also, is there a way that I can use this code's output and compare with a standard table....

Hello,

Sorry my bad .. your code works fine .. Thanks a lot 🙂

Also, is there a way that I can use this code's output and compare with a standard table....

COldCoffee (4/4/2010)

---

Buddy, here is the code u had requested.. It will loop thro the PubName CTE and execute sp_helpArticle for each PublicationName without WHILE Loop. Please note that i have...

COldCoffee (4/4/2010)

---

Buddy, here is the code u had requested.. It will loop thro the PubName CTE and execute sp_helpArticle for each PublicationName without WHILE Loop. Please note that i have...

Hello,

Before dropping anything, it is better to script your replication settings first. I would go for creating both : Drop and Create scripts.

This will be more useful if you...

Steve Jones - Editor (4/2/2010)

---

I think you'd have to have multiple checks, since each publication/article would have potential separate settings.

What I might do is find the settings in the system,...

BertusJ (3/30/2010)

---

We have set up transactional replication in a SQLServer 2005 standard edition between two locations.

Everything work fine except that the .ldf file at the subscriber site is growing and...