You didn't say if you want INNER or OUTER join, so I suppose INNER.

You didn't say which columns you want to retrieve, so I included SomeColumns as a placeholder. Replace...

You need the OLEDB provider for Oracle in order to create a linked server.

The fact that ODBC doesn't work should be a clue that something is wrong, though.

Did you set...

A 200 MB .sql file? I guess it contains data, does it?

Run it using sqlcmd.

If you need to edit, try with a different text editor.

You trigger will work only when a single row is modified.

It won't handle multiple rows.

INSERTED represents a table and you have to account for multiple rows in it.

They're just aliases.

What else did you want to know?

As you suspected, the answer is no.

Does the application perform some kind of logging? Maybe you can find something in there.

Duplicate post.

Replies here please:

http://www.sqlservercentral.com/Forums/Topic1510007-392-1.aspx

Why don't you simply revoke permissions?

Not advisable. Use the agent stored procedures in msdb for this kind of things.

I think the error message is clear enough.

That extended property is trying to add layout information on the view designer, you can safely skip it.

You mention Windows Server 2008 R2, Windows 7 and Windows XP.

Where's SQL Server?

You have a database with a data file on a UNC path? Really??

Stefan Krzywicki (10/29/2013)

---

One interview I was on around 4 years ago we spent half the interview with me brainstorming how to fix or approach a weird problem. At the end...

Very hard to tell without seeing the code.

Can you gie us more details?

You're missing quotation marks around the second WHERE predicate:

contentRepoHandle like % '+@ctype+ '%

should be

contentRepoHandle like ''%'+@ctype+ '%''

The same applies to %pdf%

I would use resource governor, given that you can classify the incoming connections effectively.

I would also raise the cost threshold fro parallelism to a value of 20/25. In my experience...