Once again has been proven simple rocket science is what it takes to get lucky.

I extrapolated Pauls (sql_kiwi) "Constructing a Plan series", Gails Indexing articles, Jeffs Anty RBAR laws and...

Most of the times that is a good thing ;-):w00t:

also keep in mind MSDTC needs some authentication settings shut off when connecting from or to Windows 2000 !

same player shoot again, hit ball when lights are on 😉

I would doublecheck the msdtc settings and stop/start it once more.

You would have to post the scripts for us to be able to interpret the reason of your syntax error.

You cannot truncate tableA if tableB references it (via FK) (or...

Thank you for correcting that.

Of course the message should have been "never...

Attaf_T (3/20/2011)

---

I Have Table (Materials)

In this table there are column (Cost float)

I Update this table

Update Materials Set Cost = 0.37421

NOW:

When i read data i have this data:...

Coldcoffee popped up the correct question.

Keep in mind when you put things into a variable to be executed, you should double the quotes !

Schedule your backup job(steps) in a sqlagent...

henryvuong1000 (3/19/2011)

---

This morning, I made a backup copy of the SQL Server database. Because the log file has grown too big (over 15GB), I first shrank it to 1mb. After...

GilaMonster (3/18/2011)

---

No, but I suspect it has to do with log growth. Since the mirror's down,...

You can use truncate with any table that ins't being referenced by a dependent table.

However, you dan use "delete from ...", but that may generate a load of log entries.

To...

Anyone in for SQL2005 mirroring and replication ?

http://www.sqlservercentral.com/Forums/Topic1080627-291-1.aspx

( I don't have the combination )

it complains because the table is being refered to by another table.

Drop the FK constraint on the refering table and you'll be ok.

Keep in mind to add the FK after...

you should use the DMVs to get the most reliable results.

sysprocesses itself is a backward compatibility view. It has more statuses documented in BOL than sys.dm_exec_requests.

sys.dm_exec_sessions also has a...

Remark from BOL (2-nd ref)

This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views...