From experience i have learnt that many applications that are billed as limited use and short lifespan, become semi permanent and even permanent solutions. The quick and dirty approach could...

The ChangeRequestContact table is the best way to handle this type of data. As an added daat integrity measure i would place a constraint on the table only allowing one...

I use Visio for Enterprise Architects for this. It has a fairly good reverse engineering function allowing you to connect to the database and extract all the SQL object metadata....

What I find works quite well is the convert function. eg

select convert(varchar(11), getdate(), 106)

will return the date in the format dd MMM yyyy for the format specified (106 in...

Thanks to all for asistance. The answer was in the article mentioned by sa24. The article indicates that the installation could have problems configuring the database if terminal services is running. You...

To PaperStreet, thank you for a comprehensive answer. I am still up a creek without a paddle though. I ahve tried so many things now, I can't even remember the...

I would suggest that you create a new database on the same server. You then need to retrive info on the datbase you setup using sp_helpdb NewDatabase. This together with...

select

  t1.ID,

  t1.LastName,

  t1.FirstName,

  m.VALUE as Email,

  p.VALUE as Phone

from

  Table1 t1

left outer join

  Table2 m on t1.ID = m.ID and m.COMMUNICATION = 'Email'

left outer join

  Table2 p on...

/*

May need to make some registry changes after installing Oracle client - check the following keys

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Transaction Server\Microsoft\MSDTC\MTxOCI]\Local Computer\My Computer]    

 "OracleXaLib"="oraclient8.dll"  

 "OracleSqlLib"="orasql8.dll" 

 "OracleOciLib"="oci.dll"

-- Adding linked server (from SQL Server Books Online):

sp_addlinkedserver...

At what level are you looking to store off time - days, fractions of days or hours. It sounds like you need to track days employees were off work which...

I seems to me that you need to do deferred processing. This can be done by letting the trigger insert an entry in a 'driver' table that another procedure can...

If you know Oracle syntax, this should suffice

Left outer join

Oracle = select * from table1, table2 where table1.field1 = table2.field1 (+)

SQL = select * from table1 left outer join table2...

The simplest solution to getting a simple list of fields is to run the following sql in query analyzer with the output set to comma delimited text.

select * from tablename...

I found the best approach is to detach the original database files and copy them to the new location and then reattaching both sets of files again.