Search results for query: *

Hi All According to the MS site. SQL Server 2005 Enterprise edition has extended support until 12/4/2016 yet service pack 4 is one year on from 13/12/2010. Am I reading this wrong? when is end of life support for a system that is Microsoft SQL Server 2005 - 9.00.5000.00 (X64) Thanks

We have many third party applications that rely on SQL 2005 databases. My question is, am I able to host these on a 2008 R2 instance with compatibility set appropriately? Would there be any issues? Thanks

Has anyone seen this before? I have a transfer database task using online method with copy and when the database has copied all the destination table triggers have dissapeared.

OK Chaps get your thinking caps on We have a program that sends out email via DBMail. Last week the mail servers went down and the only way I found out about it was I happened to be working on a SSIS package that used DBMail. The annoying thing was the NT guys knew about it but did'nt inform...

Hi All A friend of mine owns a three storey pub and bed and breakfast. He already has a domestic wireless network setup for his flat on the top floor. He is missing out on bookings as people are demanding wireless conectivety. This is victorian building with fairly thick walls and as such his...

Never really thought about this before but why does the first example work and the second does'nt update any rows (Note the where clause) UPDATE tbl1 SET Widget1 = tbl2.Widget2 FROM tbl1 INNER JOIN tbl2 ON tbl1.TransID = tbl2.TransID WHERE tbl1.Widget1 IS NULL UPDATE tbl1 SET Widget1 =...

Hi All does somebody have a script or example to search through all user tables in a database and change all smalldatetime fields to datetime? Thanx

Hi All I am migrating a db where the previous developer used a nvarchar field to hold dates. Subsequently there is all sorts of rubbish in the field that causes the script to fall over when transferring into a datetime field. Does anyone know of a way I can search for all string entries in the...

Hi All Access 2000. I have a form with a subform that contains a listview control. Everything worked fine until a few days ago when I noticed the items in the control were not displaying. The items are there as I can loop through the list and debug.print the values. Column headers, checkboxes...

Hi All I have come to this forum as I really don't know where else to put it. My question is, does anyone know of a method of adding a scanned document to another scanned document? eg scan1.pdf is 12 pages long. Add another page at a later time to make it 13 pages long. Thanks in advance

Hi all Could someone please give me an example of how to do a keyword search on an OCRd PDF or Word document contents and return the successful matching file names This is not to search the filenames but the document contents. Thanks in advance

Hi I have come into an organisation where all the tables are in a real mess. I would like to start creating primary keys for some tables but am a little stuck on how to cater for existing data. The triggers and sequences part is no problem. I have created a column called autonumber and now need...

Hi All I am an experienced database applications developer in SQL Server and would like to do the same with Oracle. Can anyone suggest any good training books that would help me make the transition. From what I understand PL/SQL is the equivalent of TSQL? I am not really interested in database...

Hi If I have an update trigger on a table and the table is updated, how can I identify to the trigger the updated record that initiated the trigger? I need to have a system that records changes to a financial database. My idea is that the trigger can insert a record into a logging table. If...

Hi With Access 97 using VBA how can I open a new document based on a word template. Using getObject it opens the template itself not a document based on the template. Any help appreciated

Hi All Using Access 97 db shared on a network. Some of the data is individually sensitive so I have set a password, disabled the shift key and all the other good bits but am intrigued as to how to prevent one of the users creating another db and linking to the tables and viewing data that does...

Hi All Can anyone think of a way of searching for a particular file name in all folders on a drive using vba Thanks

Hi All Access 97 db with vba references to visio 2002! Some of our 200+ workstations have visio installed and others do not so I am getting 'cannot find library' type errors. How can you remove missing references or add references programatically depending on the software configuration of the...

Hi all I have written a procedure in Access 97 that programatically creates an organisation chart in Visio 2002 which works great. Some of the machines at work do not have visio installed so I would like to disable the create chart button. How can I check if Visio is installed? Thanks in advance

Hi Guys and Gals I need to be able to have a Organisation chart automatically populated from an access database. Is Visio the answer? Which version?