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...

You do? Never saw my points increase for the 2 articles I wrote here on SSC.

Just checked with a couple of my coworkers and they say the same thing, SharePoint should be browser agnostic, meaning the modern browsers should all work. Why IE 8...

Florian Reischl (7/9/2009)

---

Jan Van der Eecken (7/8/2009)

---

Paul White (7/6/2009)

---

That looks vaguely like German :unsure:

(Flo: consider Donaudampfschiffahrtsgesellschaftskapitän¹)

edit: better still:

Donaudampfschifffahrtselektrizitätenhauptbetriebswerkbauunterbeamtengesellschaft²

or

Rindfleischetikettierungsüberwachungsaufgabenübertragungsgesetz³

(Ok so...

Did a little Googling and found it. Did you run it with the db_id? Example: DBCC FLUSHPROCINDB(4)

I don't even see DBCC FLUSHPROCINDB in SQL Server 2005 Books Online. Either it doesn't exist or is undocumented.