Lowell (2/24/2009)

---

No if you've got developers who never make mistakes, you are fine giving them full access anytime they want to update production, but I haven't met one of those...

This is something that I read on BOL. I dont know if it is applicable in your case.

"When executing the BULK INSERT statement by using sqlcmd or osql, from one...

The question is a bit vague. But from what I could understand, you have an app that is running that is connected to the DB and is polling for something,...

To install...

Run your profiler and check the reads and also the Plan. See if when running from SSMS is using the same plan. Probably a different plan is being used by...

Also check under what user the SQL Service is running. Is it running under Local User or Network user.

Also add one more thing...

Before any delete or Bulk Update, or DDL statements, Take a Back up...

I dont read/watch about Sci Fi. I more a fan of thrillers and Spy. Tom Clancys books are what I like more. I used to watch Star Trek.

It took me more than 2 hrs to catch with this thread from where I left. This is one long thread.. 🙂

I wonder if the Grass he means is the Grass I have heard about...:hehe:

From White house they kicked him and where does he go? Where he can make more mess....

Steve, I agree on that....:-) This is one of the best threads...

This thread has been really busy the past two days...:D

Are we getting too many lazy guys or is the standard of Basic SQL knowledge going down or we are having...

I would recommend not to remove the back up.... If something happens you loose everything.

Maybe some has a Back Job set up. That is why Back up is being...

Here is another guy...

Hi,

Thanks for ur valuable information.

Its is possible to recover deleted records or deleted one table without backup(in Oracle having Flashback Query or Flashback Table or Recyclebin...

Mr White house really is going to top all Twit Lists from all sites for sure... 😛 Man o Man. This guy is either too dumb or a damn good...