If you mean that you want to update the values explicitly, forget it. You cannot update values in an IDENTITY column.

Nor should there be any need to. Or more precisely,...

jkelly (8/9/2013)

---

M$ tools, while often great and powerful, are so full of bloat as it is - removing a piece of functionality like a keystroke shortcut cannot be excused by...

dwilliscp (8/9/2013)

---

Sorry should have added.. 64bit. Any change that would effect Disaster Recover, has to be done by the App Admin team. So I put in a request, and will...

Since there is a theory that SQL Server is being paged out, you should make sure that the service account for SQL Server has the Windows permission "Lock pages in...

Chris first computes the sums over (Fiscal_Name, Period_Name, Fund_Name, Function_Name, Project_Name, Account_Name, Department_Name, Scenario_Key, Scenario_Name)

With these sums he then goes on to compute the sum over all columns but the...

Can you also post the output of "SELECT @@version"

jkelly (8/8/2013)

---

Aside: Anyone remember [ctrl-B]? Used to let you grab the splitter bar between the query window and the result pane instead of having to play air hockey with your...

If you run out of workers, this is likely to be due to one of the following (or a combination thereof):

1) There are simply too many active users.

2) There are...

If the order of the INSERT statements is to be respected, we need to add an IDENTITY column:

Create table #Test1

(Name Varchar (50),

pos int IDENTITY (1,1))

Here is a query for...

SQLSteve (8/8/2013)

---

Step 3 is proving more difficult..

select @backupcommand = ''Backup database '+ dbo.quotestring(@DatabaseName) + ' to disk = ''' + dbo.quotestring(@subdir) + '\' + dbo.quotestring(@DatabaseName) + '_''...

To add what Jacob says, look closer at the output (and note that for some reason you have posted it upside-down, so read from the bottom):

08/07/2013 12:35:56,spid27s,Unknown,AND PurchaseOrderID = 1255...

I think that doing that with Transactional Replication would be very difficult, as you would have to write a lot of custom code. But I am not an expert in...

So did you read my post to the end and tried the link?

I have a confession to make: I have not worked much with fulltext indexes; only read a book and played a little with it.

For all my answers in this thread...

ashish.shevale (8/7/2013)

---

Yes. Sometimes it is more efficient that way.

I have not investigated it, but it should covered in...