Not sure if this will help but try running this query... It will show you pages allocated for some system objects as well. Also sum up the MBs_Used column...

DIFF is a table alias to the #diffs table.

I created the #diffs table earlier in the batch here

SELECT * INTO #diffs

FROM [db1].dbo.tableA

EXCEPT

SELECT * FROM [db2].dbo.tableB

------------------

Then...

One fun thing to know about ORDER BY is that w/o a ORDER BY statement in the ENTERPRISE version of SQL you can't rely on the fact that SELECT *...

Lowell,

Nice!!! I've never seen this in use before but it looks like it could work nice with IP addresses and subnet masking. Where did you ever learn this...

Your posting was a little vague. I think that lead the the last poster to give you an answer which would work for NEW values in table A that...

If you change your SSMS window to return results as text instead of on a grid (theres a button to the left of the results as grid button to do...

CREATE PROCEDURE dbo.help_friend_with_homework (@NumberOfRecords INT)

AS

BEGIN

SET NOCOUNT ON

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'CHEATTABLE')

CREATE TABLE CHEATTABLE (id INT, name varchar(50));

WITH i_copied_this_from_the_internet_CTE AS

( SELECT row_number() OVER (ORDER BY...

It's used for Kerberos.

I think the server 2003 admin kit has the setspn tool which allows you to manually set a sql instances SPN but the perferred method...

sg 207, Level 16, State 1, Procedure ABC_Utility_DB, Line 37

Invalid column name 'CATALOG_NAME'.

where this mentioned in BOL? In BOL its only explaining to change INFORMATION_SCHEMA.SCHEMATA sys.databases after you change compatibility...

Thanks for the reply,

We are in the middle of moving to a new storage system to hopefully allow us to do block level replication to our DR location. We...

It's always good to know the differences b/t the 2 products:) Microsoft loves to keep us on our toes and make us earn our pay!:) I just updated...

Just an FYI I found out while testing that the startup parameters are sometimes a little fussy. I was changing the startup params by going to

Start->Programs->MS SQL SERVER...

Great article. I'm planning on using this method to create a gantt chart for all of our sql server agent jobs based on the MSDB metadata. I wish...

Alot of this code can be optimized so you don't have to use the cursors. Here's a copy of a re-written script

At the bottom is a place to supply...