whether the command was run with ONLINE or not is not saved anywhere, I'm pretty sure.

peek at this scripting example, it essentially the same way i do it:

http://www.sqlservercentral.com/scripts/Indexing/63620/

generate the script...

the size of the vendor database is one of the things i'd like to know up front;

that's a decent initial indicator for me.

if the entire database is say, 500 meg,...

abhas (11/22/2013)

---

Hi All,

I am ahving a table which contains around 150 columns and millions of rows.

Now I am facing challenge to find among those which records are updated?

there is no...

RTaylor2208 (11/22/2013)

---

A few questions:

1. If you run the trace without filters for a short period of time do you see any of the events you want to capture being...

this is much better:

IF EXISTS (SELECT OBJECT_ID('tempdb.dbo.#tmp'))

DROP TABLE #tmp

CREATE TABLE [dbo].[#tmp] (

[DBName] NVARCHAR(128) ...

gchappell (11/21/2013)

---

i need a query to return the top 10 tables in each database on a server. have used EXEC sp_msforeachtable 'sp_spaceused ''?''' which returns what I need for one...

terrencepierce (11/21/2013)

---

Hey, I appreciate the test. I have a list of thousands of entries (people have a habit of typing the same thing very different ways) that I need...

/*

(No column name)(No column name)Comment

14123abcFishing lake 123abc

19876poiElk Hunting trail 876poi

*/

;WITH MyCTE([Comment])

AS

(

SELECT 'Fishing lake 123abc' UNION ALL

SELECT 'Elk Hunting trail 876poi' UNION ALL

SELECT 'Non qualifying comment'

)

SELECT PATINDEX('%[0-9]%',Comment),

SUBSTRING(Comment,PATINDEX('%[0-9]%',Comment),30), --assuming only 30 chars...

you are right; after i saw your post, i realized i misread the requirement and that...

with a set list of databases, you could create a view that does multi database calls like this:

CREATE VIEW [dbo].[VW_PERSON_DETAIL]

AS

SELECT

'Database1' AS DB,

...

great job providing the DDL!

i'm assuming the key indicator here is the OrderQty - ReceivedQty columns to determine the status.

this seems to work for me in limited testing:

select * ,

orderStatus...

the issue here is an orphaned user: that is, you have a SQL login [sw] , but you restored the DATABASE from another server....that local.sw <> restoreddb.sw , based on...

Snargables (11/20/2013)

---

How can u have the same tablename in sysobjects w/ different id's. It's making one of my processes fail. The difference in the records is the uid. I didnt...

it might be the product of someone who thought to keep their database design as if it were secret and proprietary, and have no PK's so you can't deduce the...

in that case, it sounds like you only have the SQL server Manangement Studio tools, and not a local...