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

I downloaded it last Friday (2009-04-10) and just wanted to let you know it the install on my 32-bit Dev Edtn instance went fine.

Initial test seem OK.

We currently don't have...

FYI Lynn also posted a nice overview of common date routines.

http://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx

If you have the dba edition, you should be able to do far more then reverse engineer and forward engineer.

http://blogs.msdn.com/gertd/

http://sqlblogcasts.com/blogs/simons/archive/tags/Data+Dude/default.aspx

Indeed, must have been a dyping error 😉

INFORMATION_SCHEMA views also work with pre sql2005 versions.

To only select actual tables you need to add the where clause

Where TABLE_TYPE = 'BASE TABLE'

did you test this ?

Select datediff(dd, dateadd(mm,-18,getdate(), getdate)

i.e. determine the number of days ( dd ) between the getdate minus 18 months (12+6) and the current date.

It will not hurt...

here's an example we tested to restrict some non-sa (but dbo) actions.

In your case you'll need to check for event type "DROP_TABLE".

/****** Object: DdlTrigger [ddlDatabaseTriggerNonSA] Script...

AFAIK, you cannot do this with the active job.

What I mean is that you can modify a job step using msdb.dbo.sp_update_jobstep

but those modifications will only get active with the...

I haven't experimented with the migration assistant for oracle, but the one for access also has an option to migrate the data.