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?

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

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

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

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 all! I am trying to create graphs directly from an SQL database that will show more than on data series. Is this possible or am I up the creek? Currently I can get one line only when more than one data set is returned. The graph genreator simply combines the two data sets. Also on the x...

Hi all The error coming up is "init is not defined". Even thought it is defined within the body tag. The whole of the code is place below. The first section of code is to check that at least one field has been changed. This prevents the query from returning all the records in the...

Hi ALL We are trying to validate a form on submit. I want to check all of the input fields to make sure at least one of them has been changed. This will avoid the query extracting ALL recordes from the table. Below is the form code I am using. Can anyone provide the code to do this validation...

Hi all How can you specify a higher length for datatypes text and ntext using SQL server 2000. I have used the sp_tableoptions to increase the available characters to 7000 sp_tableoption tablename text in row 7000 however I need about 10,000 characters. How do I insert and retrive the...

<a href=&quot;#&quot; onClick=&quot;opener.location.reload(true);self.close()&quot;><font size=&quot;4&quot;>Close window after entering</font></a> I found the code worked very well in IE browser but it doesn't work at all in Netscape browsers . Is there a solution for this if so could please...

Hi all, function = unload(){ opener.location.reload(true) } & then just close your popup as you did it before 2. refresh opener before closing: &quot;><a href=&quot;#&quot; onClick=&quot;opener.location.reload(true);self.close()&quot;><font size=&quot;4&quot;>Close window after...

Hi all, I need somebody to help me out with this javascript below, which work well in IE but not in Netscape for dropdown validation. Can anyone give me a soultion for this problem. function checkforblanks() { for (var i = 0; i < arguments.length; i += 2) { if...

function = unload(){ opener.location.reload(true) } & then just close your popup as you did it before 2. refresh opener before closing: &quot;><a href=&quot;#&quot; onClick=&quot;opener.location.reload(true);self.close()&quot;><font size=&quot;4&quot;>Close window after...