This is my question too! I would really appreciate it if anyone can say how to tell the source server of an abf file, please.

Thanks!

I have the same thing going on since the installation of SP4.  It displays more diagnostic info.  It doesn't mean that anything has changed with the disk, imho, you're just...

I have the same thing going on since the installation of SP4.  It displays more diagnostic info.  It doesn't mean that anything has changed with the disk, imho, you're just...

I have a similar partitioned view.  It works very well if you join on the partitioning column, but doesn't help at all if you don't.  Don't have any statistics since...

As a person being trained by a DBA who telecommutes part-time, I notice at least one drawback to having that DBA unavailable at the wrong time.

We have saved lots and lots of time spent explaining "data discrepancies" by having the rules centralized in stored procedures and functions....  I wouldn't like to think of life without...

I use : exec sp_MSforeachtable @command1 = "dbcc dbreindex ( '?' ) "

I use the simple recovery mode (it's a data warehouse), but still find the dbcc shrinkdatabase important.  I...

I've had the log growth to 1.5 times the size of the data filegroup using reindex.  So I make sure I have enough disk free and do a dbcc shrinkdatabase...

read about the changes for TargetServerRole in SQL2K SP3

I can step thru my stored procedures with QA,no problems

quote:

---

having to key in all the column names. Call me lazy! [:)

---

Don't key...

the download page says it's version 760.09. Where did you get the 766 from? I am concerned about verifying which SP I have installed on various servers.

Thanks

We have that problem on the first xp_sendmail after the mail server is rebooted, then it's fine for subsequent xp_sendmails.

Probably not the same thing as your question, but I have noticed that after a shrinkdatabase, the sp_helpdb size goes down, and often the sp_spaceused reserved size goes up!

We use WA and approles where we can, but that's not too many places. Packages and other 3rd party tools don't really seem to like WA, so we don't...