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.

So you were able to create the tables (please create them in their own database, and not in any of the system databases (master, msdb, tempdb, model))

Maybe using the GUI...

great solution Bob.

Nice application of outer apply. Still have to get used to that feature 😎

start with:

Select ...

from information_schema.tables

where table_name like '%yourcryteria%'

order by table_name

Just like the others, I would suggest to first concentrate on TSQL, Management studio and sqlserver organisation (detailed if needed), then you'll get to sqlcmd for deployment facilities,...

If this is a single shot action (migration ?) it may be best to use Microsofts migration assistant for Oracle. It can be downloaded free from here :

http://www.microsoft.com/sql/migration/

This may...

barryocteau (4/11/2009)

---

I have a DotNetNuke database that functions well enough but when in SSMS the Tables item doesn't expand to show tables, the same with System Tables. Other databases display...