Do both databases have the same indexes?  Have you updated statistics and/or rebuilt indexes on the smaller database recently?

John

No.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=48&messageid=351167#bm351190

John

This is how you do it.  If your foreign key constraints are on composite keys, then the logic gets a little bit more complicated, but it isn't difficult to work...

Assuming you're using SQL Server 2000, the sysreferences table should contain the information you're looking for.

John

John

It sounds like you're going to use replication and automate the creation of new articles every day or week after the tables have been created.  Or perhaps you can use...

Colin

From Books Online (DBCC DBREINDEX topic):

DBCC DBREINDEX is not supported for use on system tables

John

Thiyagarajam

I think if you look up sp_xml_preparedocument and OPENXML in Books Online, you will be able to find a way to achieve what you're looking for.

John

Do you have a backup you can restore from without losing more than an acceptable amount of data?

TJ

Sounds like you have a corruption in your database and you need to run DBCC CHECKDB.

John

Dion

I haven't read through this, but it may have what you want.

http://www.simple-talk.com/sql/t-sql-programming/writing-to-word-from-sql-server/

John

Ben

Read up in Books Online about what the ISNULL and COALESCE functions do.  In this instance they are equivalent.

If @FUND_ID is not null, the last line of your query will...

What command did you use to defrag your indexes?  Have you considered rebuilding them?

John

Bagath

There's an undocumented extended stored procedure called xp_eventlog.  I don't know exactly what it does or even whether it would be right for what you want, but I'm sure you'll...

Kumaran

The only way I know is like this:

(1) Script out your logins, jobs and so on

(2) Back up your user databases

(3) Uninstall SQL Server

(4) Install SQL Server RTM

(5) Apply SP3a

(6)...

Yes - my free download also included SQL Refactor and SQL Doc but only had a licence key for SQL Prompt.  When I contacted Red Gate they apologised for any...