Yes, that's one possible...

It looks to me like you've got a reasonably efficient proc there, so I have to ask, why do you want to change it to a view, instead of keeping...

Grant Execute permission on xp_cmdshell in Master to the user.

You can use "Select Top 20 ... Order By NewID()" (with the columns and tables in there where I have the elipses). That will give you a reasonably random...

I guess it depends on what data you are trying to move.

Most likely, a simple "Insert...Select" will do it. But I would need more information (possibly table structure), to...

I don't follow you.

Here's the scenario I'm talking about:

Table1 has a logging trigger on it that follows the "after-only" model I wrote about, because it's usual use is 10-20 updates...

My usual practice is to break up maintenance plans a bit. I'll rebuild some indexes one night, other indexes the next night, etc., and schedule that to repeat weekly/monthly.

Takes...

Yeah. But I don't use "Chatroom" as a language except for humor.

Yes, "ORLY" = "Oh, Really?", with a humorous overtone.

If you just do the "after-only" logging, to save space in the log for a table that gets far more updates than inserts, you need the original data, or you...

Is the browser service running? ("SQL Server Browser")

I have two different responses that I thought of for this article, and I really can't choose between them.

First response:

Second response:

Puns!

Everybody likes puns!

You every meet...

Load the data from the Oracle database into a temp table (the same stuff you're querying here, of course), then join to that temp table instead. See if that...

It's an Enterprise Edition feature. The reason the option exists is because you use the same Management Studio for all versions, even for multiple servers with different versions, at...

ORLY? (That was the whole point of my post.)

I'm confused now. If they're using Outlook to compose an e-mail, why use DBMail to send it? Or am I misunderstanding something?