I had a similar experience yesterday and found this SSC thread very helpful: Agent XPs automagically being disabled

While configuring a new cluster, on one of the nodes I needed to...

Check out this thread: How can I unencrypted a stored procedure

You say Automatic Update, I hear unexpected reboot. Not something I'd want on one of my db servers.

I recently ran into this issue: "SQL Server allows for only 10 levels of nesting in CASE expressions" (http://msdn.microsoft.com/en-us/library/ms181765.aspx).

I've only had issues with this in scripts that run across linked...

You should just have to grant them access to the db and then grant them select permissions on the view.

USE [DATABASE]

GO

CREATE USER FOR LOGIN

GO

GRANT SELECT ON [SCHEMA].[VIEW] TO...

My first thought would be that some of the tables you're INNER JOIN-ing don't have data in them. You might try using an OUTER JOIN instead (http://msdn.microsoft.com/en-us/library/ms187518.aspx).

Example:

SELECT DR.DigitizeRefID,DR.RecordID

FROM...

Found this to be a good checklist for inheriting db servers and a "primer of database maintenance best-practices for all the involuntary DBAs".

http://technet.microsoft.com/en-us/magazine/2008.08.database.aspx

+ 1

Also helpful & free (eBook) download from SSC:

SQL Server Tacklebox - Essential Tools and Scripts for the day-to-day DBA by Rodney Landrum

http://www.sqlservercentral.com/articles/books/67536/

So it's delete from TabC where ..., delete from TabB where..., and then delete from TabA where...?

If you're sure it's not a data issue, you might try putting GO statements...

Which table (A, B or C) are you deleting from?

Are there any foreign key dependencies on the table your deleting from?

DECLARE @tblname NVARCHAR(255)

SET @tblname = 'YOUR TBL NAME HERE'

SELECT DISTINCT OBJECT_NAME(parent_object_id)

FROM sys.foreign_keys

WHERE referenced_object_id = OBJECT_ID(@tblname)

It depends on what you mean by "count of each record based on the name". Using a GROUP BY is going to give you a unique count on the combination...

I was just looking at this yesterday on a beta server. I was running typeperf (http://technet.microsoft.com/en-us/library/bb490960.aspx) w/ 15 metrics every 15 sec for 2 hours and output to...

Full Outer Joins - http://msdn.microsoft.com/en-us/library/ms187518.aspx

declare @t1 table (SomeId int)

declare @t2 table (SomeId int)

insert into @t1 values (1), (2), (3)

insert into @t2 values (1), (2), (4)

selectisnull(t1.SomeId, t2.SomeId) as SomeId

from@t1...

Kind of stripped it down but something along this line might work.

DECLARE @results TABLE (

ItemID VARCHAR(100),

InvcKey INT,

Processed BIT DEFAULT 0

)

DECLARE @lineitems TABLE (

InvcKey INT,

ItemID VARCHAR(100)

)

INSERT INTO @results (InvcKey, ItemID)

SELECT '304662',...