Reformatting the Agent job output for easier reading:

Executing the query "DBCC CHECKDB(N'SLine2') WITH NO_INFOMSGS " failed with the following error:

Table error: table 'doc' (ID 142623551). Data row does not...

You'll have to zip it first and then attach the zip file. dtsx is not a supported extension afaik.

e4d4 (1/2/2013)

---

opc.three (1/2/2013)

---

A slight tweak to your second query will show you how similar OFFSET and TOP can be:

USE AdventureWorks2012

SELECT TOP 100

[TransactionID]

...

mvargas109 (1/2/2013)

---

Executed as user: LAVOISIER\SQLAGENTACCOUNT. ...600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved.

Started: 2:00:00 PM Progress: 2012-12-30 14:00:00.68 ...

A slight tweak to your second query will show you how similar OFFSET and TOP can be:

USE AdventureWorks2012

SELECT TOP 100

[TransactionID]

...

By default all users are a member of the Fixed Server Role public, and this cannot be changed. Also by default, all members public can see all databases on the...

Bhuvnesh (1/1/2013)

---

opc.three (1/1/2013)

---

With the query written this way I can highlight the SELECT statement in the USING clause to see what would be deleted without changing the query or carrying...

Exactly.

Then I don't really need to add the rest of the GRANT statements since they are now...

This statement made the Developers role the owner of the Test schema. In being the owner, any grants you attempted to do that overlapped the permissions afforded by schema ownership...

meridius10 (1/1/2013)

---

Some of the databases I used were constructed by firms using SQL Server 2005 as a back end, so I guess it would be a major decision for them...

What I provided is a set-based solution and it won't get much faster than that. If you want to store the current server name in the myIDnumber you could try...

I think you have the DDL you posted mixed up with what you are after. The FK references BC_Display. Can you please post the table definition for both BC_ShiftSummary and...

1. Learn Extended Events well enough to where I never need to use Profiler/Trace again. That is, as long as I am working on a SQL Server 2012 instance.

2. Learn...

I have had good luck with MelissaData and they provide solutions for most of the areas you listed. They provide custom components as well so you can access their tools...

Lynn Pettis (1/1/2013)

---

Was noted, just responding to the alternate way the most recent responder posted. Plus, that is the beauty of this...