Just a quick comment...on a production system you must use the backup/restore method. In order to detach a DB, you must have all users out of it, and while it's...

Just a comment on using Transactional replication...you can set up latency just as in Log Shipping in one of two ways:

1) Use continuous transactional replication with a "-PollingInterval" of 300...

I don't know if there is a way to check whick records were unlocked, but I would recommend running a DBCC CHECKDB in that database, then check to see if...

Give this a whirl:

select * from information_schema.view_column_usage where view_name='TR_Rating' 

OR

select * from information_schema.view_column_usage where table_name = 'T120'

-Dan

Ah, sorry about that...yes, its only in SQL 2000.

-Dan

Without seeing the query youhave, I'm not sure if I can help, but maybe a CASE statement will do the trick, something like this:

 

SELECT 

...

Also, If you are getting run-time errors in your stored-procs, you can use the SET XACT_ABORT ON option in the proc. This will automatically rollback any transactions that are...

I would recommend using a table variable instead of a temp table in your stored procs. The table var is much more efficient and it won't lock tempdb like...

I have seen it freeze occasionally, but not regularly. I do get ?JavaScript? errors or something like that quite often, though.

-Dan

Looks like I found the problem...buried deep inside one of the sub procs was a global temp table (##). Gotta hate legacy code.

-Dan

I did a little testing, and this is what I got:

It looks like all GETDATE() calls in a single statement are evaluated at the beginning of the statement (parse time)?

I find default parameters to be very useful when a single stored proc is being used by multiple versions of client software (ie-web, client/server). If one of the applications...

Here's a "quick and dirty" method for all tables in a single DB:

EXEC sp_MSForEachTable 'EXEC sp_spaceused ''?'''

-Dan

Actually your primary key could be both columns (memID, buddyID) together. It is probably best to create the primary key as non-clustered, due to the randomness of inserts. Another...

Thanks for the reply. The problem is that there is nothing coming back to scroll. The server has not yet sent the results from the PRINT statement to the...