JacekO (4/15/2009)

---

...I tried to exeute it directly in query window to test it's impact on the temp tables but the server claims it does not exist. So who the heck...

An other alternative to Gregs proposal:

(Only a referenced table cannot be truncated without first removing the relationship.)

from BOL: "Truncate table"

You cannot use TRUNCATE TABLE on tables that:

- Are referenced...

As I learned from Gail Shaw, the issue of outdated statistics with sql2000 caused by the way your data is added/deleted/updated shouldn't be an issue with sql2005 anymore. Its statistics...

from bol:

Temporary Tables

You can create local and global temporary tables. Local temporary tables are visible only in the current session, and global temporary tables are visible to all sessions. Temporary...

Aparently The BusinessEntity table is an implementation of a SuperType table.

Tables Person, Store and Vendor are Subtypes

As is with that implementation, BusinessEntity only provides a means of unique key for...

Can you add SP1 ? support.microsoft.com/kb/968369

BTW. your version numbers are incorrect !

They don't publish like 10.00.***

but the results I get are like 10.0.*** (SP1)

(with both

SELECT SERVERPROPERTY('productversion')

select @@VERSION

)

And...

You are correct.

Apparently MS is also promoting the .Net infrastructure to achieve optimal integration.

If you are developing a new application it is recommended that you consider using ADO.NET and the...

Use SQLNCLI as much as you...

Technically that isn't a problem.

However, symantically that doesn't make sence to me.

If the BusinessentityID is non nullable, you must first assing the person to an existing business entitiy ?

If BusinessentityID...

XML columns start "in row" ...

My little test: ( never mind the xml content 😉 )

-- my test database

Create database SSC_Test

go

use SSC_Test

go

Create table T_SSC (

...

- Is you sqlserver instance enabled for tcp/ip connections ?

- is there a firewall active ? (you may need to open some ports)

manohar (4/14/2009)

---

As per the table structure there are only two columns

QuestionID BIGINT (Primary key)

QuestionXML NTEXT

Will it be a problem if the datatype is NTEXT...

And also we wil store XML...

SMO stands for SQLServer Management Objects.

Meaning a layer with a number of methods and properties specifically made for managing sqlserver.

You wouldn't want to use that layer for your "normal" querying...

New Commer (4/15/2009)

---

Hi ,

for a process the time frame is

-StartDate-|-EndDate-|--Starttime-|-EndTime-

-15/04/09-|-16/04/09-|---10:00---|--14:30--

both days the total hrs spent on the process is 9 hrs

Now how to get the result via query...

Typical for a child object is that it cannot exists without a parent object.

So the parent object has to exist first, only then you can use that parent key in...