Jeff Moden (3/26/2008)

---

Todd Engen (3/26/2008)

---

Jeff,

Try changing "DROP" to "DELETE", or set a WHERE clause with EventClass = 47 for Object : Deleted events.

Opening the traces in Profiler will resolve the...

Adam Haines (3/26/2008)

---

I was thinking about this myself. I then found this online.

-- DEMO: Create an EventId table and populate it with definitions of each ID number

CREATE TABLE...

Seems that the ODBCBCP ordinal 29 error has been seen before....

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=22744

I just went and opened the trace up (double-click on the file mentioned)...they all show up as Object:Deleted/Altered/created (which is probably why you can't see it - it doesn't...

By the way, I'm still waiting to hear the "inconvenient answer" to why Mars' icecaps are melting at the same rate of speed as ours....

http://news.nationalgeographic.com/news/2007/02/070228-mars-warming.html

Now - that's what I call...

Actually - it's one of my favored names for those....:D

'cause that's usually what I end up doing when I find them.....:Whistling:

Hmm - I'm seeing dropped tables....You looking at the right trace? mine seems to automatically roll over after a certain size.

Look at the ObjectName column? I'm seeing table...

Mid-day blindness due to lack of caffeine....hehe...

glad we agree:hehe:

dfalso (3/26/2008)

---

and this doesn't:

create proc usp_inner1 as

begin

create table #temp ( thisfield int )

end

create proc usp_inner2 as

begin

select * from #temp

end

create proc usp_outer as...

Jeff Moden (3/26/2008)

---

Even if you are - shouldn't you be keeping

the audit trail of the updates to said stored procedure? You know, as in Source control? It...

richardd (3/26/2008)

---

Thankfully, this has been fixed in Vista - the reminder message is now a balloon-tip from the system tray.

If you have 2000 SP3 or XP SP1 or higher, you...

carlos (3/26/2008)

---

@jeff

Thanks for the response. That was what I suspected.

Same question, different scenario. What happens when one issues two separate INSERT statements in a single batch? For example:

INSERT INTO myTable

...

I'm thinking he's referring to this:

http://www.rainingdata.com/products/dbms/d3/d3datamodel.html

All data is by default stored in a cube. (sorry - no experience either, but I have seen a marketing blurb on it before).

The best...

Jeff Moden (3/26/2008)

---

How do you know that, Matt? ...

They will both do the same thing ultimately, assuming the backups are good. the main downside to this approach is that if you do full backups twice a week,...