Check to make sure service broker is enabled?

SELECT is_broker_enabled FROM sys.databases WHERE name = 'msdb';

Are you seeing the errors in the logs after the fact? Perhaps there's transaction blowing out the log and then rolling back so by the time you see the error...

But where's the fun in that?

DECLARE @CMD NVARCHAR(500)

SET @CMD = '

if db_id(''*'') > 4

USE [*]

EXEC sp_msforeachtable @command1=''DBCC DBREINDEX (''''?'''','''''''', 100)'', @command2=''print ''''?''''''

'

EXEC sp_msforeachdb @CMD, @replacechar =...

SQLBOT (2/10/2010)

---

Only do what GT says if you like running the snapshot agent and doing table locks on the publisher.

If you just wait it will all catch up when...

I was just about to respond that the...

Woops, sorry, yes I misunderstood your problem.

Revised.. 🙂

declare @dbname varchar(255), @sql varchar(255)

declare c_dblist cursor for

select name from master.dbo.sysdatabases order by name

open c_dblist

fetch next from c_dblist into @dbname

while @@fetch_status =...

</snip>

</snip>

How can I loop through each database on a server...

Also, if you have the Object Explorer Details panel open, once you've selected the...

It might be easier to just query sys.databases state and state_desc columns to see the current state of the database. If you're dead set on touching the db you could...

i took the liberty to update the script a little bit to allow better sorting based on different columns, such as Data.

By changing the Data column to a BigInt and...

Oops, yeah that's also a remnant from our environmental needs. The information in our current version also contains servernames, dbnames,...

Using sp_mstablespace won't give you any unused space that the table is holding and sp_msforeachtable won't return internal tables. We were having issues pinpointing our space discrepancies, which were largely...

I wasn't trying to steal your thunder, that's where I learned it from 😀

I was just trying...

The client_net_address should represent the address of the client machine making the connection. If you're connecting directly from your machine it should show your address. If you're connecting through, say,...

Seattle, WA