sp_executesql

Technical Article

RE: Not valid operation

  • Reply

I found this quote at http://www.mcse.ms/archive85-2004-2-364893.htmlSteve 2004-02-06, 11:33 amUpdate on this. I have turned on journaling on the specific table I am trying to update, and updating/insert/delete works. The problem is, that our 400 people do not want journaling turned on. I have read that having the commit level set to *NONE the odbc connection doesnt […]

You rated this post out of 5. Change rating

2005-03-29

Technical Article

RE: FileGroup Backup/Restore

  • Reply

As long as you have a complete transaction log history, I'm fairly sure this would work.  If you have the possibility of an accidental delete though, that's your real problem.  I realize that there may be a thousand possible reasons why it has to be setup in a way that allows it, but I would […]

You rated this post out of 5. Change rating

2004-03-17

Technical Article

RE: Removing the time from a datetime database field

  • Reply

More than one way to skin that cat. for the sake of simplicity, I would use Antares686 solution. I bet it is also the one with best performance. At least compared to those which use a UDF.But...select cast(cast(getdate() as bigint) as datetime) select getdate() select dateadd(d,datediff(d,0,getdate()),0) select cast(cast(getdate() as bigint) as datetime)                                                        ------------------------------------------------------ 2004-02-25 […]

You rated this post out of 5. Change rating

2004-02-25

Blogs

Enabling an Index: #SQLNewBlogger

By

I don’t do a lot of work with disabled index, but I learned how...

Back to Boston for SQL Saturday

By

I’m leaving again tomorrow for a trip. This time I head back to Boston...

T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?

By

Most of us who work with data have, at least a few times, been...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers