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...

Charles,

I'm not sure why it's not working for you, but I once succesfully placed database files on a mapped drive. Unfortunately it's quite some time ago so I don't remember...

Not sure if  understand you quetion correct, but an Insert will always be executed per row. You can't just insert a column.

Markus

Charles,

if you have a share on your NAS server which you map on your SQL server to a drive letter it is possible to attach the datafiles.

Even though I...

Cody,

look at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\'Auditlevel'

Markus

Adel,

In SQL 2K there's no option to specify the order in which tables are replicated. Anyhow what would be right for inserts, will be wrong for deletes. So you either...

Brian,

I understand that system functions are somehow different from user defined ones, but I expected at least some message saying you can't grant select permission instead of "Invalid objectname"....

Look in BOL for INSTED OF TRIGGERs. There are some examples.

Markus 

What type of accent marks are you looking for. SQL_Latin1_General_CP1_CI_AS supports quite a lot of accented characters like ç,ê,è,ë,ï etc.

You can create a simple list of all the characters...

Yes Marlon,

the migration assistent supports both SQL2000 and SQL 7. Basically what it does is checking your server and databases for any incompatibilites. Like using code which is no longer...

Fryere,

when you try to update a view which contains columns from more than one table you need to define an INSTEAD OF Trigger on your view. The trigger should when...

Do you use MOM2005 to monitor the system ? I remember a script in MOM 2005 which (sometimes) generates this error. The script is called "SQL Server 2000 Replication Monitoring"....

Why do you want the total percentage ?

It would be like the average of all the individual ones. And while this "total" could still be fine, individual database can...

Tim,

look under Your_Db\Tables\tablename\triggers

The other folder database triggers  is only for trigger on the database level like ddl triggers.

Markus

Obviously, SQL Server is still thinking that your database is still part of the replication. Unfortunately you don't write what kind of replication you (tried) to set up or how...