Search results for query: *

George Thanks for the info but my company is contractually obligated to provide a Microsoft in support product. I'm trying to work out when we need to upgrade. Thanks

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

Oooh Yuk! The only way to do this would be with a function where the itemNumber is passed to the function and a concatenated string of values is returned. SELECT DISTINCT ICITEM.ITEMNO, yourfuncionname(ICITEM.ITEMNO) FROM ICITEM This would call the function within the select statement The...

The odd number is coming from the loop "SELECT n + @rc FROM dbo.Nums" The first row to go into the table is a insert values of 1 When you select n from dbo.nums it will pick the first row where the value will always be one SET @rc = 1 INSERT INTO dbo.Nums(n) VALUES(1) First row of the table...

Thanks Borislav I've just discovered that the database would automatically be upgraded. The compatibility flag should be used a as temporary measure to test application connectivitety.

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

Jim Correct me if i'm wrong but this smacks of a many to many relationship ie a contact can have many interests and an interest can have many contacts. If this the case then your schema is wrong and needs a link table to acheive what you want. If I'm barking up the wrong tree then you may need...

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.

Your right Thargy, however if your NT Administrators are'nt "Team Players" so to speak and the failiure was due to them doing a patch without testing it correctly and trying to cover their own backsides, you see my point. I don't care whether they messed up. It's part and parcel of the job but...

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

Ok Here are my thoughts From the main BT/ADSL entry point which is on the top floor and is also where the current wireless/modem router is situated. I buy one of those ethernet adapters that plug into the electrical circuit that pass connectivety via the building electrical system. That then...

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

Thanks Daniel Good explanation, that makes sense.

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

Panic over Thanks for the suggestion, I had already tried that but it was returning what looked to be valid dates. I then realised I was playing with UK date format but had not set DATEFORMAT dmy. Problem solved. There's a few US formatted dates in there, God knows how?

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

Here is a cracking site for listview controls and translating the properties http://www.cgplusplus.com/online-reference/maxscript-reference/source/listview_activex_control.htm

Ideally you would have to do this in VBA using dynamic SQL. You can have an Access pre-saved ODBC query holding all the connection values to the SQL database and change the SQL statement for the query on the fly. I think I may have given you enough buzz words to google what you need.

Add another column to the table called Locat or something similar and default the value "A" for location A and "B" for location B then set the primary key for the table to be ID and locat columns. That should do it.