As for you SQL code, I think that you need one change:

Insert into #BakDir exec xp_cmdshell 'dir /B'

declare @file varchar(max)

Select @File = FileName from #BakDir

-- you do not need the...

Jonathan Beck (4/14/2008)

---

I get the following error:

Msg 15281, Level 16, State 1, Procedure xp_cmdshell, Line 1

SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned...

b.carlson (4/14/2008)

---

I have a different issue, when I close the program I get an error which is being caused by the "SelectedIndexChanged" event of the comboboxes. It seems when the...

Thanks!

Please post this in an appropiate forum.

Jeff: I think that's an article.

Glad we could help.

You will want to look at "Not IN(...)" or "Not EXISTS(...)"

Wow. OK, well first, you are definitely in the wrong forum, I would suggest a T-SQL forum or similar here on this site.

And secondly, read this link to see...

Well, there are a number of ways to go with this, a UNION being the most obvious and some folks use those fancy OVER-based functions, however I like this one:

Create...

And does it work now?

Use this stored procedure to create your views (modify it for your specific needs). Whenever the tables' columns change, re-run this procedure instead of recompiling the views:

Alter Proc spCreate_Status_View(@Table...

Harrumph. You know "Joel" at least had some letters in common with Jason S.'s real name...

🙁

Well, generically, you do not need COMPUTE.

If you would like a more specific answer, you might want to give us a more specific example to work with.

Suggested level name: SSCursorBane