Lowell (7/10/2009)

---

first, let me thank you for the CREATE TABLE and INSERT code; it helps enourmously. way to go!

here's one way to do it; here i'm assuming the column is...

Possibly, but the original request actually asked how to remove the 10th character. What if the character to be removed from the 10th position...

Look up the STUFF function in BOL (Books Online, the SQL Server Help System). Based on the description of your problem, this is just what you need.

select stuff('PQ19188PFHAA',10,1,'')

Actually, Jack, I should have been more specific. I'd still have a regularly scheduled t-log backup process running. The Alert would just run that job outside its normal...

I see someone has already shown a method, but I still want to post my code (as attachment to avoid frustration on my part).

Please pay close attention to the setup...

You can create an Alert in SQL Server Agent based on the SQL Serverperformance condition that the transaction log is greater than a certain percentage. The response to that...

Here is one solution, but I had to upload it as an attachment. I am really getting tired of this intermittent issue of not being able to post code...

Regarding SET ROWCOUNT for SQL Server 2005 Books Online:

Using SET ROWCOUNT will not affect DELETE,...

sqlguru (7/10/2009)

---

You are doing the job of the DB Engine in the worst possible way (using fake pointers identifiers). Why stop there? Why not use text files for storage and...

ian.dunlop (7/10/2009)

---

Anybody a bit of a running total Guru !

I have a table that I want to be able to add a column for a running total for GWP.

GWP is...

Best thing you can do at this point is open up BOL (Books Online, the SQL Server Help System) and start reading about transaction logs. The following link is...

Failover won't do you any good as it is the same database that will be used when SQL Server comes up on the other node.

Another option that could be also be developed is a SQL Server Broker application to transfer the data.

It will either create a new trace file, trace_2.trc if trace.trc and trace_1.trc already exist, or it may start appending to the current trace file if it hasn't reached its...

Florian Reischl (7/9/2009)

---

Thanks for your responses.

At work I use IE8 on XP x32, without any problems using SharePoint or OfficeLive there. In my case it just don't work on a...