I'm not a TX log expert, but I believe that is header information for the TX Log or for the backup. If you run TX Log backups a file...

With this limited information I can only guess that you have 2 objects on the report that both reference the same data.

There is no setting I'm aware of that would cause this. Could be an some kind of special character in the data that is signalling an end of file.

SQL Server Agent only stores a limited number of rows of history total and per job. That can be set using SSMS on the History tab of the SQL...

For deadlocks you are better off using trace flag 1222 which writes them to the event log.

You can use profiler to define a trace and then export the definition as...

I doubt very much is the last of a primary key is the issue and the lack of an identity column certainly isn't the issue.

Working with XML in...

drew.allen (10/12/2011)

---

You have to be careful with the joins, if either of the tables has a one-to-many relationship. You could potentially be double-counting some of the records I would...

Dev @ +91 973 913 6683 (10/12/2011)

---

Didn’t you try to explain...

Perry Whittle (10/12/2011)

---

Jack

I always disable windows firewall on corporate domain computers. If you need to ringfence a set of servers use a dedicated firewall product. If you want a good...

Thanks guys. Here's what happened. I did the move to the other node and everything came up, in cluster manager okay, but I couldn't connect to SQL from...

Thanks guys. Unfortunately this is for a client, and they put the cluster into production before doing any testing of the fail over and before letting me know so...

rstelma (10/11/2011)

---

Hi,

I hope you guys can help me get something straightened out here. I ran this query on the Master DB:

select f.name

, i.name

...

I don't think I'd call this a bug. SQL Server can use the Primary Key or a Unique Constraint/index to as the reference column(s) for a foreign key. ...

Thanks Perry. I hadn't seen that blog by Paul. Fortunately I've never needed to recover from a corrupt transaction log.

GilaMonster (10/8/2011)

---

Agreed, restore from backup. If you have a good backup strategy, you'll only lose since the last log backup.

If there is no backup, it might be possible to...