try this:

EXEC @retval = sp_replicationdboption '<database>', '<publication type>', 'false'

where <database> is the name of the database you published objects from, and <publication type> is eg. 'merge publish' depending on what...

Triggers in SQL Server fire on a statement basis (means that for each statement you issue, even if it affects multiple rows), and not on a row basis, and always...

Try the following: create a file anywhere (eg. on the desktop) named for example "x.udl" (the ".udl" is important). Then double click the file -> the system built-in connection string...

take a look at

http://www.sqlservercentral.com/scripts/contributions/246.asp

for all table related stuff. enhancing that to print out 'create table ...' etc. should not be a big deal.

hi! you might want to have a look at the following link, to get the check constraint names manually at least.

http://www.sqlservercentral.com/scripts/contributions/246.asp

best regards,

c.

quote:

---

1. The security sistem has detected a try of an attack for degrading the server MSSQLSvc/CIFE01:1433. ...

2. The security system cannot establish...

quote:

---

Ok. Let's say I have SQL 2000 Server on Win2K Advanced server, will Standard Edition replicate on Win98?

---

January 20, 2003 at 9:33 am