Bad_Karma (5/10/2012)

---

I can't believe it...Rebooting the server fixed the issue. Thanks for the help, if it wasn't for that link I honestly don't know how long that would have taken...

Yes, you are right - this setting probably doesn't apply to your...

Bad_Karma (5/9/2012)

---

Thanks for link, unfortunately after enabling "Allow inprocess", I'm unable to hit the oracle server from any account. However I did notice something that I did not do, and...

Check this link and make sure you have followed all the steps, including enabling “Allow inprocess” for the OraOLEDB provider:

http://www.ideaexcursion.com/2009/01/05/connecting-to-oracle-from-sql-server/[/url]

Bad_Karma (5/9/2012)

---

Well, thats what I attempted to do when I created...

Ah, so you can use the linked server when using your Windows Auth login, but SQL Agent uses NT AUTHORITY and does not have access to the linked server. ...

So why would you even notice that Windows Authentication works, when you have designated SQL Server Authentication only, using the AMSCRYSTAL login? Can you run a query straight from...

And you've verified that the 'hard-code creds' work on the Oracle server? Have you set up the Linked Server security by checking 'Be made using this security context', and...

If you are not opposed to hard-coding in empty nodes in an ISNULL, this works:

SELECT

W.RecID,

W.field1, (

SELECT

U.RecID2,

U.field2,

isnull((

SELECT

P.RecID3,

P.field3,

P.field4,

P.field5

FROM

@tmp3 P

WHERE

P.RecID3 = U.RecID2

FOR XML PATH ('Innermost'), ROOT('InnermostRoot'),TYPE ),

'<InnermostRoot><Innermost>

...

Can you show me what your 3 rows should look like?

SELECT j.[job_id], j.[category_id], c.name [category_name]

FROM [msdb].[dbo].[sysjobs] j

JOIN [msdb].[dbo].[syscategories] c

on j.category_id = c.category_id

🙂

capn.hector (5/4/2012)

---

your right those dont really look like bad fragmentation numbers. im at the end of my knowledge here. with the incorrect data getting in have you tried...

capn.hector (5/4/2012)

---

Coming from BOL:

When a unique clustered index is created on a view, the result set is stored in the database just like a table with a clustered index is...

That's what we were thinking when we rebuilt the indexes - but why would that happen, especially more than once? Is it common for view indexes to get out...

Wonderful. Thanks!

Should be done during downtime - rebuilding indexes places table locks and prevents access during the rebuild process - unless you use REBUILD WITH ONLINE = ON.

USE my_db

GO

EXEC sp_MSforeachtable @command1="print...