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

parissa_bakhshi (10/8/2011)

---

Think it's not a real cluster when you have different network names. What was the reason for using different network names for SQL resources? You can install a new...

Stefan Krzywicki (10/8/2011)

---

L' Eomot Inversé (10/7/2011)

---

Stefan Krzywicki (10/7/2011)

---

I've spent my entire career trying to take jobs I don't think I'm quite qualified for, that gives me room to grow and...