Search results for query: *

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

Hi UNIMENT This is not what I wanted. I wanted the current Html table information which is displayed on the screen to be exported to execl when the user Click on the button called "View the table in Excel" ? That all I am wanting. Thanks

Hi all, How to export data using html table information which is displayed on the screen to excel? Currently what the users have to do is drag the mouse over the html table and then click ctrl c to copy the information which is displayed as raw html table and then open up excel and paste it...

Thanks tlbroadbent I ran the sp_changedbowner and that fixed the issue. One of the web developers could not get an odbc to work because the anon login on the database was conflicting with the anon user and login he was trying to set up. I do not know what happend but I suspect the web developer...

The login for dbo on one of the databases on our sql 2000 server has been changed to anon?? How can I change this back to what it should be??? Does this indicate a security breach. I have tried the SP_CHANGE_USER_LOGIN but dbo is not an allowed user name. Any help would be appreciated. Thanks...

Hi starway Well half the problem is solved. But the other half of the problem is not yet solve. Can I validate the required field as well as the number field in two different format as you can see from the source code "onSubmit="return checkFields()" as well as...