Drop The End Of An Ip Address
Mar 7, 2006
does anyone know how to drop the last part of an ip address? I've been searching various sites for string functions and havn't come up with anything that works. What I want is something that will "find the third occurance of a "." and then return everything to the left of it"
I've tried various types of InStr and even found a SUBSTRING_INDEX function, but apparently it's only for mysql.
i'm using sql server and linking tables thru access
fisk
View 11 Replies
ADVERTISEMENT
Oct 9, 2006
Hi,I found this SQL in the news group to drop indexs in a table. I need ascript that will drop all indexes in all user tables of a givendatabase:DECLARE @indexName NVARCHAR(128)DECLARE @dropIndexSql NVARCHAR(4000)DECLARE tableIndexes CURSOR FORSELECT name FROM sysindexesWHERE id = OBJECT_ID(N'F_BI_Registration_Tracking_Summary')AND indid 0AND indid < 255AND INDEXPROPERTY(id, name, 'IsStatistics') = 0OPEN tableIndexesFETCH NEXT FROM tableIndexes INTO @indexNameWHILE @@fetch_status = 0BEGINSET @dropIndexSql = N' DROP INDEXF_BI_Registration_Tracking_Summary.' + @indexNameEXEC sp_executesql @dropIndexSqlFETCH NEXT FROM tableIndexes INTO @indexNameENDCLOSE tableIndexesDEALLOCATE tableIndexesTIARob
View 2 Replies
View Related
Feb 27, 2008
Hi All
I want to know that if different users have access to a database with same loginName and password then how can I get the IP address of a particular user through a query.
Thanks in advance Anisha
View 1 Replies
View Related
Sep 13, 2000
Does anyone know how to get the machine IP address from a Transact-SQL statement ?
Eyal
View 1 Replies
View Related
Dec 14, 2004
Hi,
I am making a DTS package and would like to:
1) create a file then,
2) transfer this file to another location(not on the same server).
How would i do the ftp part ?
The file transfer protocol task only lets u download from another site; how would i upload a file to another site ?
thanks.
Clayton
View 4 Replies
View Related
May 4, 2006
Hello,I want to block certain mac address to access my MS-SQL server. for that what can i do. for exampleI want to block the mac address [abc]. how is it possible to block the mac address [abc]
View 2 Replies
View Related
Feb 27, 2008
Hi all
I want to know that if different users have access to a database with same loginName and password then how can I get the IP address of a particular user through a query.
Thanks in advance
Anisha
View 2 Replies
View Related
Aug 2, 2005
Someone told me that some non-US address do not have State/Province, andsome might not have Postal Code. Is this true?
View 3 Replies
View Related
Sep 24, 2006
Hi All,We have an MS SQL server that is within the company firewall. We want aparticular database to be availabe to a vendor to build a website.When we had to develop a website on another vendors machine they gaveus following details.SQL Address: testdata.data.comSQL Port: 1234SQL testUsr Password: testPassword1. How do we go about doing this?*******The SQL Server has 5 other databses. I have already created a databaseuser for just that database.2. So If the vendor registers their enterprise manager with ourinformation, can I make them see only their database? Or does all theother database also get displayed. They are not able to access anyinformation on the other databases. But they can see it.Is it possible to prevent them from seeing the other databases?Tx in advance
View 1 Replies
View Related
Dec 28, 1999
Hi folks.
Here i have small problem in transactions.I don't know how it is happaning.
Up to my knowldge if you start a transaction in side the transaction if you have DML statements
Those statements only will be effected by rollback or commit but in MS SQL SERVER 7.0 and 6.5
It is rolling back all the commands including DDL witch it shouldn't please let me know on that
If any one can help this please tell me ...........Please............
For Example
begin transaction t1
create table t1
drop table t2
then execute bellow statements
select * from t1
this query gives you table with out data
select * from t2
you will recieve an error that there is no object
but if you rollback
T1 willn't be there in the database
droped table t2 will come back please explain how it can happand.....................
Email Address:
myself@ramkistuff.8m.com
View 1 Replies
View Related
Jun 19, 2006
Ok...I'm sick of this.
I'm migrating data from three (third-party, propietary) systems that my company has been using into one common system. The problem with this is that address information in these systems is about as standardized as a bag of rocks. One product simply has 6 address lines, and does not segregate the information (city, state, zip, etc...). Another one has dedicated lines, but users have taken it upon themselves to "invent" ways to enter data (international customers/vendors have data in weird fields, but no rhyme, reason, or cohesion to the madness). The third one is just as bad.
I'm looking for a script-based, SQL implemenation (stored procedures?) for standardizing the addresses into a common format. Does anyone know of anything?
View 4 Replies
View Related
Feb 15, 2005
Hi
I want to know that is there a system sp or table or somewhere in sql server that I can get ip address or mac address of clients that connect to sql server?
thanx
View 1 Replies
View Related
Jul 4, 2007
I am fairly new to SQL and am trying to write a function to parse the ip address into 4 sections. I have been searching through the forums to see if anyone has a posted example of parsing an ip address but could not find one.
I am wondering what would be the best method of doing this, or if anyone has an example.
Thank you
View 6 Replies
View Related
Oct 24, 2007
Hi,
My problem is -
I have a trigger for auditing the changes(insert/update/delete) in the database table.That is done and is working fine. But I need to have the client's IP address from where the changes are done. That I need in T-SQL, that means, not in any web form but in the SQL/T-SQL.
As I have checked many forums, I got that there is extended stored procedure in master database named xp_cmdshell which has xplog70.dll and when we execute this stored procedure with 'ipconfig' we can get the IP Address. But I do not need that in master database. I need that in my database say myDB.
So how to proceed further. I don't know whether to create extended SP which contains DLL or is there any other option.
Pls help
Thanks in advance
View 14 Replies
View Related
Feb 13, 2004
Parsing Address
This is not really a reply, but I saw the problem and the replies look very promissing.
I'm using ss2k, I have a table with an address column.
here is some example of the records under ADDRESS :
WILLOW CREEK PL
RED BARN DR
RED BARN DR
CARRINGTON DR
RENNER RD
EDMONTON CT
SPRINGBRANCH DR
HILLROSE DR
CEDAR RIDGE DR
LARTAN TRL
PRESIDENT GEORGE BUSH HWY
What I want to do is to write script that runs daily and parse the street names (RED BARN) and street types (Dr, PL , etc.. ) to 2 colums. As u can see there is no fixed length or fixed number of words ...etc ...
Any help would be really appreciated.
thnks
View 3 Replies
View Related
Apr 17, 2004
I need some help devising my tables.
I have a company table and a address table. I have created a linked table with two foreign keys from the company table and the address table respectively.
This set up allows me to apply more than one address per company which is fine. My problem is that I need a way to prevent a company from entering exactly the same address twice.
In the address table i have the following fields:
AddressKey - PK
CompanyKey - FK
Address 1 - 3
Town
County
Country
PostCode
In the company table I have the following fields.
CompanyKey - PK
FirstName
Secondname
And finally in the link table I have the following:
CompanyKey - FK
AddressKey - FK.
Now, if i entered the following into the address table Assuming that company id of 1 was already entered into the company table.
AddressKey - 1, CompanyKey = 1, Address1 = 11 Address2= Taylor
I need a way of preventing this from happening.
AddressKey - 2, CompanyKey = 1, Address1 = 11 Address2= Taylor
As can be seen the PK - FK values are unique and are correct for referential integrity, but the actual address is the same.
Any help we be mostly appreciated.
Cheers
Wayne
View 13 Replies
View Related
Aug 4, 2006
1A apple street
11 apple street
1B apple street
i want to select only the first address. how do i do it?
View 8 Replies
View Related
Aug 10, 2005
Hi:I need to store MAC Addresses. What is the standard way of storing thistype of attribute? Datatype? I can't find any discussions about thisanywhere.Thx for any pointers.
View 1 Replies
View Related
Jan 11, 2007
Hi
I've got an openrowset query that works perfectly if I enter the computer name, but it fails when I enter the IP address.
Is there a setting somewhere that I need to enable to make this happen?
Thanks in advance
View 5 Replies
View Related
Aug 28, 2006
I have an excel file on a web server on a different location to the sql server. I want to use OPENROWSET to query the excel file, but it doesn't seem to like using a URL.
Is this the case, or am I doing it wrong? Works fine when I use a local address (eg c:excelfile.xls) when testing locally, but I need to use a URL in production.
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=http://mydot.com/excelfile.xls','SELECT * FROM [page1$]')
View 1 Replies
View Related
Jan 29, 2008
Hi guys.
i know the funcation that v can use to get the local Machine Name '@@server' , it's return the server name
is it' possible that or is there any way to get the IP address of the Machine..
Thanks and looking forwrad.
-MALIK
View 3 Replies
View Related
Aug 29, 2006
Whoever implemented this... needs fired. If its not done fine.
But its still pretty much unusable.
I have a simple 5 text files I need to import... no brainer, they are all comma delimeted.
Works great in 2000 DTS. I import the package it blows up, will take me hours to get right "Converting" all the columns. These are simple text fields, ive learned not to even attempt anything else.
Are they basically "done" with SSIS? And just letting us wade through the horror that is SSIS?
I am pondering creating a dw but with all my diverse data sources I couldnt dream of the endless hours upon hours i would have to spend to get it to work with SSIS.
Or maybe someone can explain to me how to easily turn off these stupid trucation, conversion errors it is determined to force upon my dts packages.
Uhg, about to uninstall 2005 and go back to 2000... I can't schedule a "legacy" dts package to run on sql2005 without the nightmare of "dtsrun"...
View 4 Replies
View Related
Jul 28, 2007
hi there, i have a invoice template that when printed has a box for the users address (which there always will be) and a box for their delivery address if they are having the items delivered. However sometimes they dont have things delivered and so the record in the delivery table does not exist. In this case it will throw an error, how can i avoid this. the code im using i have posted below string sql = "SELECT [del_address], [del_post_code], [del_date], [del_time] From tbl_del WHERE order_ID = " + intOrderID;
//This creates a sql command which executes the sql statement.SqlCommand sqlCmd = new SqlCommand(sql, myConn);
myConn.Open();SqlDataReader dr = sqlCmd.ExecuteReader();
//This reads the first result from the sqlReader
dr.Read();
try
{
//string strDel_Address = dr["del_address"].ToString();
if (Convert.ToString(dr["del_charge"].ToString()) != null)
{
//delivery items lblDelAddy.Text = dr["del_address"].ToString();
lblDelPCode.Text = dr["del_post_code"].ToString();
View 3 Replies
View Related
Jan 22, 2008
Does somebody know if it's possible to ban an IP address in the sql server, from somebody who makes 5 attempts to log in ?
Because I saw in my computer management / windows logs / application that somebody is trying to guess the password of 'sa'. Every second I get 5 attempts to login ...
regards
View 3 Replies
View Related
Dec 27, 2003
THE LAYOUT:
I have two tables: "Applicant_T" and "StreetSuffix_T"
The "Applicant_T" table contains fields for the applicant's current address, previous address and employer address. Each address is broken up into parts (i.e., street number, street name, street suffix, etc.). For this discussion, I will focus on the street suffix. For each of the addresses, I have a street suffix field as follows:
[Applicant_T]
CurrSuffix
PrevSuffix
EmpSuffix
The "StreetSuffix_T" table contains the postal service approved street suffix names. There are two fields as follows:
[StreetSuffix_T]
SuffixID <-----this is the primary key
Name
For each of the addresses in the Applicant_T table, I input the SuffixID of the StreetSuffix_T table.
THE PROBLEM:
I have never created a view that would require the primary key of one table to be associated with multiple fields of another table (i.e., SuffixID-->CurrSuffix, SuffixID-->PrevSuffix, SuffixID-->EmpSuffix). I want to create a view of the Applicant_T table that will show the suffix name from the StreetSuffix_T table for each of the suffix fields in the Applicant_T table. How is this done?
View 6 Replies
View Related
Mar 18, 2004
I have a database that allows a client to have multiple addresses, could be a home, business, vacation, etc... I'm trying to deside if I should put the Company Name and Title fileds in the tblClientAddresses table or keep it with the tblClient table. We do mailings to clients and if the mail is going to a home address the company and title should be excluded. If I put them in the tblClients table I really have no way of knowing if we are mailing to a home or a company. If i put the company and title with the address it makes sence that this would solve the issue.
Looking for any thoughts or suggestions?
Thank you,
View 2 Replies
View Related
Aug 21, 2002
Currently running SQL Server 7.0 on numerous Windows NT 4.0 SP6 servers.
Need to change the IP address of these servers to a private scheme.
What effect will this have on SQL Server 7.0
Thanks
View 1 Replies
View Related
Nov 2, 1999
I have SQL ver 7.0 running on NT ver 4.0 sp5
I had to change the name of the server from server1 to server2
now I am Getting a message
"Your SQL server installation is either corrupt or has been tampered with (Unknown package id). Please rerun setup"
is there any other way besides rerunning setup ?
Thanks in Advance ??
Peter
View 2 Replies
View Related
Apr 22, 2003
Hello,
Soon, we are going to redesign our servers and their positioning insofar as web access is concerned. The SQL Server will go to a DMZ.
Its IP Address (as well as hostname) is to be changed. Can you offer suggestions about what to be aware of on these two items?
I've been involved in a hostname change befoew (and, it's a pain), but never an IP Address.
Thanks, MichaelG
View 2 Replies
View Related
Aug 19, 2002
We changed the TCP/IP address on on of our BDC's this weekend (also runs SQL 6.5). Now some of our client workstations are not able to connect to the database using TCP/IP. They can connect with named pipes, but it doesn't "stick" on a reboot. It goes back to connecting with tcp/ip. Some of the client workstations can connect with tcp/ip. Could someone help me with this? I'm confused. I can ping the server by name from the workstations and it resolves the tcp/ip address correctly.
View 2 Replies
View Related
Dec 5, 2005
Hi im trying to save the location of images to a sql server db in the form of a url, i am trying to find out what datatype this comes under here. In ms access u can just select the hyperlink option in the data type dropdown and it saves the address entered into these fields as a hyperlink to the database. How can u do this in sql server ?????
View 3 Replies
View Related
Apr 18, 2013
We got data from a dns server that looks like:
some columns.... |121.12.250.2.somestring......|
The ip address should look like 2.250.12.121:
We could use charindex, substring and len to cut the 4 parts of the ip and rebuild it in the right format.
Starts with
SELECT
CHARINDEX('.',mycolumn)
,LEFT(mycolumn, CHARINDEX('.',mycolumn) - 1) as part_four_of_ip
,CHARINDEX('.', SUBSTRING(mycolumn,CHARINDEX('.',mycolumn) - 1),len(mycolumn)
as position_of_second_dot
........ and so on.....
This will cause an awful long code. How to shorten that code?
View 3 Replies
View Related
Oct 22, 2013
I have a table with the following :
Cust id Address
1234 25 main street apt 78961
5678 25 ohio dr apt 567891
7890 25 lee lane apt 6789
I want to pull only the 6 consecutive numbers from my address , so only cust id 5678 should be displayed.
View 11 Replies
View Related
