After searching for a problem I finally discovered the merge replication was not syncronyzing and told it to syncronize. The error went away.

However, I would still like to know...

sorry, meaning different databases with distinct but related purposes. One is our data on 13F filings (stocks), one is for our N30D filings (mutual funds), one for staff that...

We have stored procedures that hit different regions in our database and when a large change comes along it requires changes to many of them. It would be fewer,...

I dream of having SQL Server 2000. For now, I must work with SQL Server 7.0. Some of the replicated tables have 40,000 to 90,000 rows.

Is there an...

I agree with Steve. There is almost always a way to write a query without using dynamic SQL as you have just seen you can use the CASE statement...

Thanks for removing the duplicate posts!

Our stored procedures change so often because we are always adding new features. For example we will soon be modifying a feature so that...

I guess part of the reason I am not against dynamic SQL is that when I arrived at bigdough.com in May 2000 almost all stored procedures were dynamic SQL. ...

I was surprised that deleting a column didn't break replication as I have looked at the stored procedures that update the data on the subscriber. I'll look into this...

I also discovered that I can delete columns from syscolumns for a table with transactional replication and replication doesn't break. I deleted the columns from the publisher not the...

For those interested I have found a way to modify a column (I have only tested this with a bit column so far) that allows NULLs to not allow NULLs...

I'll try that for merge replication. I am at this moment trying to do this for transactional replication and I know I can't drop a column in transactional replication...

I didn't imply I could keep up. I know I couldn't. I don't have that much free time. However the most read or highest rated articles could...

I do my best to keep track of errors I know can occur and test for them during my testing.

Some times, I think part of the problem is (at least...

Or

your development efforts are interupted every 5 minutes by someone stating there is a database problem that needs immediate attention.

Robert Marda

I work at a small company (about 100 employees). Our DBA and myself have local admin rights to all our SQL Servers. Even with this we have limited...