Robert:

All this demonstrates is that the views are binding their output columns when they are saved. This should not be unexpected since, as virtual tables, they have...

Well, A) you don't have a choice, you must have a transaction log. and B) just because it is not being used for Restore/recovery does not mean that it...

Forcing all data access through stored procedures is the industry best practice for database applications development because of:

1) Security

2) Separability of function

3) Performance

4) Manageability

When you have to perform an operation on a number of rows and there...

Bob Fazio (3/28/2008)

---

Am I in some sort of...

Barkingdog (3/28/2008)

---

Last week our main development box (sql 2005) was so heavily utitlized (CPU near 95% solid) that when develoeprs tried to connect to it they would time out. I...

The windows account that is executing BCP at the command does not have a windows logon to the SQL server.

Try this:

SELECT * from tblA

where tblA.id not in (select tblB.id from tblB)

Look at the [font="System"]SQL_VARIANT_PROPERTY[/font] function.

IMHO, views are highly preferrable. As a previous poster noted: only use UDF's if it can't be done with a view.

You would probably get better response if you moved this to one of the "Working with Oracle" forums on this site.

Read my prior post: http://www.sqlservercentral.com/Forums/FindPost473248.aspx

In fact, I would recommend reading the whole thread as it has lots of good stuff from other posters.

Rats! Sorry, George, I...

You're welcome, let us know how it works out Dugi.

It...