Recent content by philrm

Is it possible to set up a range of ip addresses outside of which you can not access the server. Can't find it but seem to remember something about it. The server is a stand alone win2k sp4 unit without ADS on it.Has anuone got any ideas?

Thanks Very much Guys have it working well now

This does not work. The command runns successfully but does not add the identity column. What I am trying to do is import an excel speadsheet as a table, Add an identity column to the table based on the maximum value of an ID column + 1 from a table T_soil_site. Hope this makes it a bit clearer

Can you use a variable to set the identity seed on an identity column something like this? DECLARE @maxsitenum int SET @maxsitenum = (select max (site_id) From T_SOIL_SITE) ALTER TABLE sheet1$ ADD column_b INT IDENTITY (@maxsitenum,1)

Can anyone tell me how to script or where i can find a script to report on howmany records are in each table of a Microsift SQL 2000 database. I'm sure this is fairly easy but can't seem to find it. Thanks in advance

I know nothing about this area but have been asked to pull together information for a project. We are proposing to set up a central server for running models of land use and land managment and the interaction with the ecosystem. The serever will be somthing like an 8 way win 2000 advanced server...

Thanks bperry that was the advice I was given. What I am struggeling with is the logic of the code. I can write the simple selects and inserts but when it comes to using if else etc I fall flat. I am actually a systems admin not a programmer. Can anyone help me with the logic of what I need to...

Hi there I have Three tables T1, T2 and T3. The primary key in T1 links to T2 but T2 has a different primary key. T1 also links to T3 in the same manner. IE both are 1 to many relationships. When a new entry is made in T2 I need to check if there was data entered into a particular field (F1)...

Hi Rosko Is it possible to provide me with this code. I am not that familiar with SQL. Thanks

Hi there I have Three tables T1, T2 and T3. The primary key in T1 links to T2 but T2 has a different primary key. T1 also links to T3 in the same manner. IE both are 1 to many relationships. When a new entry is made in T2 I need to check if there was data entered into a particular field (F1)...

I have Three tables T1, T2 and T3. The primary key in T1 links to T2 but T2 has a different primary key. T1 also links to T3 in the same manner. IE both are 1 to many relationships. When a new entry is made in T2 I need to check if there was data entered into a particular field (F1). If there is...

HI All Has anyone ever stored pdf files in sql server? Can it be done as a blob? If so, do I need to write code to do it in a third party produc like VB, or can I use an sql update/insert statment?

Hi there Do anybody know how to calculate percentage based on stored value eg If beer equals 3 votes and pizza equal 2 votes. how do i display the percentage of votes for beer and for pizza.

Hi everyone I am building a Coldfusion web site and need some advise on an sql issue. To populate a date field in a data editing form I am using a select * from. However for some reason this is returning yyyy-mm-dd hh:mm:ss. When the users edit this date field they have to use mm-dd-yy format...

I do not know much about perl. Does it interact with coldfusion server. IE can the code be inserted inside a cfm page and work correctly. If so I will give it a go