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...

not to public.

if they need to run sp_Oa*, then only grant it to one specificl role or user/login that will actually need and use it.

depending on what they are actually...

your local server has a number of aliases, and you might need to specifically look in Administrative tools>>Services to see if you have named instances.

assuming a default isntance, you could...

no solution, just consumable data:

i ran out of interest int he issue after converting to usable data:

;WITH MyCTE([EmpNo],[BudgetYearStart],[BudgetYearEnd])

AS

(

SELECT convert(int,'2698'),convert(date,' 2013-02-01'),convert(date,'2014-01-31') UNION ALL

SELECT '67682',' 2013-01-01','2013-12-31' UNION ALL

SELECT '43320',' 2013-02-01','2014-01-31' UNION ALL

SELECT...

Beatrix Kiddo (11/20/2013)

---

finally, you add the linked server on server A, and make sure you use the mapping idea fromt eh screenshot: login not defined = not be made, and...

ok perfect, if he's using a SQL login, it really goes towards the screenshot i provided.

on the remote server, a database role (in the apropriate database(s)(ie LIMITED_ACCESS), and make sure...