I am wondering about this as well. My current solution was to create a table that described the rules and associated tables that understand how the rules are to...

Koustav:

Would you mind sharing how you used columns_updated() with that many columns. I am getting overflow errors and I would greatly appreciate seeing your example code if you wouldn't...

Very little sleep and data type issues are making me cranky... sorry as well... my bad.

I think I am going to take your point on the fact that mathmatically 0...

well... thanks for your thoughts... but there is no need to be insulting.

On sort of the same front, why is it when you define a field as decimal(6,6), which means that we only want data on the right side of the decimal,...

Andy:

Good thoughts... I will take a look again at the profiler when I get a chance. I did however do exactly that when I was trying to figure this...

Andy:

I think you are right about the LSN thing... but what is confusing is that if I simply use the backup that was created with the GUI then I can...

Francisco:

I am not positive about this, however I don't think that you can use the Ip address to qualify the path, I believe that you have to use a DNS...

Guys:

This is an alternate look at the large tables in a database. Thought it may help.:D

--drop table #tmp

create table #tmp(

[name] varchar(100),

[rows] int,

[reserved] varchar(20),

[data] varchar(20),

[index size] varchar(20),

[unused] varchar(20)

)

insert into #tmp

exec...

Guys, I am setting up a DR database and have a question about the distribution database. In our scenario there are already replication publications on the existing server. ...