This is not as complete as those tools, but it should do about 80% of it and it is free:

ALTER proc spUtil_CompareTableDefs(

@Schema1 SYSNAME

, @Table1 SYSNAME

, @Schema2 SYSNAME

, @Table2 SYSNAME

)

AS

/*

Compares the...

So far as I know, this is not an "automatic" feature of either VB6, SQLServer or ADO.

I have noticed something like this before also. In some of my functions it is actually faster (significantly so) to convert all of the arguments from Nvarchar to Varchar,...

Heh. You don't know how many times I saw...

OK, it appears that the SQL string that you are building is greater than 4000 characters, which is too big for your varchar(4000) strings.

The problem is that you add in...

What does "but for some reasons its not compatible with sql 2000" mean? Are you getting an error message? If so, then what is the message?

You probably want the "Audit Schema Object Access event" which records both sucessful and unsucessful attempts and then filter out the sucessfull events.

It isn't clear what "InvoiceTotal" is supposed to be. Could you post the table definitions and some sample data?

Yes, but they make these things very hard to find in SQL 2005.

In SSMS, expand the "Security" folder, then the "Users" subfolder under it.

Right-click on the User whose permissions you...

You would need to implement some way of tracking this yourself. The most common way is to add a "ModifiedDate" column to your tables an a trigger on the...

Yep, I figured.

Please do not cross-post.

please do not cross-post.

Please do not cross-post.

Megistal:

These are not the numbers that I get. Can you please supply a script that demonstrates what you are saying?

Thanks,