Hi, does anybody know a nice tool to automatically compare and show
only the structural differences between two databases, this is, the
differences in the columns of a table, constrains, data type, etc.
Thanks

I have these tables:
CREATE TABLE [dbo].[COREAttribute] (
    [oid] [uniqueidentifier] NOT NULL ,
    [CLSID] [uniqueidentifier] NOT NULL

I was hoping someone may be able to help me with a tricky T-SQL
problem.
I need to come up with a SELECT statement that does basically the
following:

I get Invalid object name 'bstr'. when I try to run this query
Select distinct c0.oid, c1.Value, c2.Value, c3.Value
From
(SELECT oid FROM dbo.COREAttribute

I'm working on an application where the original developer used the
field name 'index'. This works ok when accessing the table from MS
Access through query, but when I try to reference it via SQL with
either a statement from Enterprise Manager or a stored procedure I'm

Database log of my DB is around 2GB.
The database is using FULL recovery option.
I want to reduce the file size of the log cause it takes up a lot of
space.

I have 5 databases, each about 20GB in size. I need to copy the data to
a new server for reporting purposes. Initially I wanted to setup
transactional replication; however, the database schemas often change
(adding or modifying tables) and in order to accomodate those changes

I want to know the differences between SQL Server 2000 stored
procedures and oracle stored procedures? Do they have different
syntax? The concept should be the same that the stored procedures
execute in the database server with better performance?

I currently run the client tools on my WinXP Pro box, and connect to multiple
servers throughout the country in our organization. Each server has SQL
accounts that we use to authenticate, and we do not use domain accounts.
Every month when our network password changes the list of ...

I have a unique index based on the following columns:
ProjectID (int)
MaterialCatalogID (int)
Material catalogues are pretty much static but projects are dynamic and

I have a few create table statements which create temporary tables
that has row definitions which exceeds the 8060 size limit, this causes
a warning message being generated (Message 1708).
Is there a way I can disable/avoid the warning message from being

Hi, i restored a backup from a database thas has replication configured.
When i restored it the system tables that the merge replication creates
are restored too. I was investigating on internet and I found that i can
delete it using this query:

SQLServer 2000, after installing SP4 I get a lot of stop errors as
noted in the subject. KB suggests hardware failure but so far I haven't
found any faulty componants. The errors started happening just after
installing SP4. Anyone else noticed this?

I'm having this query:
SELECT
    ss.subscription_id AS SubscriptionId,
    s.id AS ScopeId,

I have two stored procedures
ALTER PROCEDURE dbo.qryCountOne
(@inputID int)
AS SELECT COUNT(*) AS CountOne FROM  dbo.TableOne WHERE