That's always been a pet peeve.

GUI asks for the amount of free space.

fillfactor is the other way around

Do you have a small fillfactor or large pad_index size on the 2005 server? If by default you have a fillfactor set with a low value on the server it...

Log shipping works with either full or bulk recovery, but this is still not a candidate for reporting, access to the database will either be prevented while logs are being...

Are you using two instances on the same server, different servers, or trying to work this across a single SQL Server instance?

Download the ODBC client from http://dev.mysql.com/downloads/%5B/url%5D and use a DTS datapump to move the data (if you're on SQL Server 2000)

Ignacio A. Salom Rangel (12/4/2008)

I...

No, Integration Services are fine, try connecting from another machine, you should not see an issue.

Sometimes when performing a service pack update, patch, or even BOL update something can get...

Try [ ] around the BEGIN USE ?

thusly

DECLARE @command varchar(1000)

SELECT @command = 'IF ''[?]'' LIKE (''JM%'')

BEGIN USE [?] select prefix, dataversion from system END'

EXEC sp_MSforeachdb...

Try within your sp_msforeachdb puttin [ ] around the ?. This will then ensure that you capture non standard naming convention databases.

I have had this problem in the past. Connecting from my local machine was fine, however from the server itself was an issue (although this could happen from any client...

That's an unusual issue.

I'd recommend downloading robocopy(part of the window resources kits) for large file copies. It handles logging, automatic continuation in the event of a problem, and whole host...

I would recommend copying the backup file over to the other server and restoring locally. Network latency can cause problems with the restore process, and in all it would be...

I so cannot take credit for this and cannot remember where I found it, but this will show all the current sessions, the blocking, the queries etc.

You could remove the...

Vivien Xing (12/2/2008)

Most of DBAs can go towards Exceptional DBA (Brad McGehee’s ebook) to add more values to wherever s/he is. DBA job may be just a starting point...

Just been flicking through BOL and it appears as though my earlier statement was not accurate, there is a way you can enable it to compress on the subscriber side...