My procedure have code in it that is part from sp_spaceused.

I ran a Profiler to see what Enterprise Manager executes on my server when I press taskpad.

select sum(convert(float,size)) * (8192.0/1024.0)...

I created a SP that I execute every day to keep track of database growth. The results are inserted into a table that I created prior to this (_dataused). Before...

Hello!

Did you tried to check your database with DBCC CheckDB? Maybe the problem is still there and is waiting for SQL Server to read a bad sector or something. If...

I think Toad is a great tool especialy with Quest backgroung developing Toad for Oracle. The support is also great. I have open some support cases on other products from Quest...

If you have slow connections to your remote servers I suggest creating a web page that reads data from a table located on a local server. Every time a job...

I think there is nothing wrong with this procedure being executed on every query on a linked server. I believe now this is normal and I will explain why:

When a...

If your database was not detached using sp_detach_db or your server was not shutted down cleanly you CAN'T use sp_atach_single_file_db.

Still, there is a workarround on this. I did use once...

Maybe the network is very busy on that hours. Measure the counters regarding your network.

7M/sec seems very slow

I have a 170GB database that takes 106 minutes to backup.

You can also try this link:

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26

I think the tool for this it's called SQLRecon 1.0 or SQLPing

I am using transactional replication between SP4 servers and SP3 servers where both are subscribers or publishers and I have no problem with this. I must admit that the SP4...

To view how much space is ocupied you could click the database name in Enterprise Manager and then View->Taskpad.

For as much as I know SQL Server Engine find a page...

You didn't specify if you have push or pull subscriptions. If you have push subscriptions than it's really simple. You simply install SQL Server and restore (or atach) your subscriber...

I don't have something simpler than this. It shows exactly the data you would normaly found in EM clicking your database and then View->Taskpad. I use this SP to...

That's true. Think about a situation when your subscribers get's desincronized. You don't need to generate snapshot for all tables when you know exactly what are the publications for those...

I think you must first allow anonymous pull subscriptions on the web server.