Thanks for the update, and glad you got your SPN error resolved. Those can be tricky.

Thanks for the update.

The default trace also might have more information for you if it has not rolled over.

Bru brings up a great point. The Dev edition is equivalent to Enterprise, with all features enabled. However if you use something like compression, it may not be there in...

Snow http://twitpic.com/rueuy

Service Broker kicks things off. If you have a stored procedure or other process that receives the message and can connect to Oracle, then you are fine. Or if you...

Gus has a good solution. If you want absolute days, maybe enclose it in an ABS() function?

Hmmm, hammer and screw. I might have to try that one. Gotta go have another cup of coffee to get ready 😀

blandry (12/2/2009)

---

... For example, and as anyone knows, the "best" football team in the world are the New England Patriots and of course they are led by Tom Brady, an...

The "change" is from the user point of view. Most people would consider a change from 1 to 1 being no change. However the engine probably does not do a...

Is that the result from the xp_cmdshell? If so, the path appears to be valid. It should be the DB Engine service account that reads the file. Can you...

The source code is attached to the article as a zip file now.

It's not corrupt. Likely you have permissions that are conflicting, and there are DENYs that override the GRANTs.

Make a new login, give it permissions to a specific object, INSERT to...

Jeff,

I'm not sure what my passion is. It's a question I ask myself constantly, but so far nothing has struck me.

About 8 or 9 years ago my wife and I...

I've warned my wife a few times that a full time horse job may not be as much fun as it is now. She's keeping it in mind, and making...

With SQL Authentication, you now must add a "login" to the server and a "user" to the database you are accessing. go to the security folder under your server (databases,...