What database does it say it exists in?

g.brennan (7/13/2008)

---

Assuming you are using some form of integer as identity, you have a misconception about actual byte storage in the low-level workings of a computer. Recall that integer...

I really can't give you a meaningful VB example, since it's going to be specific to your application. In VBA, you would create a filesystem object, define a textstream...

Generally, since it reduces IO from the disk, it will probably result in an improvement in performance.

In most modern computers, the CPU has clock cycles to spare that can be...

You're welcome.

The NullIf thing will only work if the value is -1 (or am I missing something). I'm assuming the possibility exists for any valid negative integer.

And yes, subtracting the...

Cool biz.

The way to get the result you're looking for is:

select

case contacttitle

when 'Owner' then 'Honcho'

else 'Peon'

end as Newtitle

from customers

"If" is a flow control, not a data function.

I guess it depends on your hardware, but Crystal is pretty resource hungry (or was last time I played with it), and might cut into what SQL Server wants.

With that...

Since Enterprise is an upgrade from Standard, you should be able to use that without any problems. Call/e-mail MS customer support if you need their exact answer on it,...

Either some application is trying to connect to the server using that, or some person is.

Have you traced what that login is doing in the database and server? (Profiler...

Assuming this is a temp table, created by someone else, why are you trying to drop it anyway? There's generally no need to do so, and if they are...

Carl Federl (7/11/2008)

---

Although tables that begin with a # are normally temporary tables, it is possible to create a permanent table by enclosing the name with [ and ]

create table...

Can you give me a table structure for those last two tables? I think they're the last ones I'm missing. (And sample data, of course.)

I think I can...

A delete trigger will have effectively zero impact on inserts and updates. It will have an impact on deletes, obviously, but if you just dump the "deleted" table contents...