Or you might just be a DBA if...

everyone comes to you when there is a problem with the data only to hear you respond that it is a data entry...

For me, I am not anxious for .NET to come out. I am unsure if it will be a good thing or a bad thing. If our programmers...

This will never be done in our production environment until we are satisfied that there are no adverse affects to replication.

Thus far, I still haven't found out why...

Does anyone know how SQL Server calls the sp's created by transactional replication? Or where this takes place?

Robert Marda

Well I found out what was blocking the change and ran the following to make the change:

UPDATE sysobjects SET replinfo = 0

WHERE name = 'TestAlterTable'

ALTER TABLE dbo.TestAlterTable ALTER COLUMN YesNo...

I have read the article by Andy. That will work, I just thought the other way should work since the column name was staying the same. I am...

I have done something similar but on a smaller scale (much smaller) and for a different purpose than trending table sizes. Daily I insert into a table how many...

I have added columns to a replicated table and SQL Server has allowed this. IT just gives me the warning that the new column is not included in replication....

I hadn't thought of that, however it is true I don't ever remember hearing anything about DBA's in high school and unless people do start talking about databases and DBA's...

Andy:

We have some stored procedures that have 25 to 27 different fields a user can modify. These directly affect how the stored procedure limit the result set. About...

Sorry for so many posts that are the same. I kept getting an error stating there was a problem and thought the post had not gone through.

Robert Marda

mbova:

I think the major thing about security is this:

Normally you can give execute permissions to a user for a stored procedure and the stored procedure will run fine.

However, with dynamic...

So where would I put this code so I can execute it? In a DTS task?

Robert Marda

I know I'm late coming into this conversation, but thought I'd add my opinion.

I like using Enterprise Manager and have no desire to seek out a better tool. I...

Thanks for the explanations! I learn something new every day.

Robert Marda