Did you enclose the whole operation as a "distributed transaction"? ... like:

begin distributed tran

do-whatever-you-have-to-do

commit work

Is anything wrong with Microsoft documentation?

In my opinion - in a case like this...

tassadaque (8/2/2010)

---

In my web application project i have packages, modules and documents (such as creatememo, createcircular,CreateEmployee). in my database i created tables for packages, associated modules and objects (employee, memo,...

jere42 (8/3/2010)

---

I just ran across a database here at work that has several tables where the name ends with a $. For example: Calls$

What does the $ signify and is...

scottichrosaviakosmos (8/2/2010)

---

I am currently working on sql server2008 and trying to fetch data from oracle 10.2 . when i right click on my linked server and click test connection it...

As a rule of thumbs, when you bump into a many-to-many relationship consider adding a bridge table to convert such m-to-m relationship into two 1-to-m.

Hope this helps.

Minto access (7/31/2010)

---

...2 servers are going to production within 2 days.

...didn't provide me any documents also.

So please give me suggestions what are the activities need to test or to create...

Raunak Jhawar (7/25/2010)

---

bozworth hollinz (5/10/2010)

---

I'm working on a strategy to deploy ddl changes to a schema. However, I have the requirement to maintain the data within the schema. Does anyone...

Couple of questions about "Projects" table.

Is there one and only one row per "project" in Projects table?

When you say "Project has resources" do you mean "Projects" table knows which "resources"...

nice smile 😀

:blink: This is very confusing. There is...

:w00t: interesting approach.

Shall I understand you are...

hxkresl (7/21/2010)

---

One more question on partitioning. Is it common to add a DateCreated column to every table and assign every table to the same partition scheme so that related...

sandyinfowave (7/23/2010)

---

I have been assigned a new job of Migrating the databases from Sybase to SQL Server 2008.....Can anybody help me in providing the documentation and any suggestions on how...

It is read-only... until you restore it 🙂