|
Try to ping that server with its name from different locations and see if you can see it
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Try to do this we use to do connect to remote servers and uses odbc connection your port address should be 1433
goto SQL Server Configuration Manager ----> Network configuration ------> Protocols for your Server
and see Named Pipes and TCPIP should be enable , you can use either one of them at a time
also make sure you to check aliases and your SQL Browser is running and in connection string try server name
like ".\SQLServer" not "machineName\instanceName"
and are you using sql express then also see your configuration file located in
C:\WINDOWS\Microsoft.NET\Framework\yourFrameWOrkVersion
I hope so it will solve the problem
Best Of Regards,
SOFTDEV
Sad like books with torn pages, sad like unfinished stories ...
|
|
|
|
|
I have 2 columns in the table.
Want to create script for new column, and it's IS_Nullable value should be No.
Can u please provide me teh script to do so?
|
|
|
|
|
if not exists(Select * from syscolumns where name ='yourfldname' and id in(Select id from Sysobjects where xtype ='U' and name ='yourtablename'))
ALTER TABLE yourtablename add yourfieldname bit default(0) not NULL
Best Of Regards,
SOFTDEV
Sad like books with torn pages, sad like unfinished stories ...
|
|
|
|
|
hi experts
in my table i have a column with name Date and id
Date id
2009-7-13 218665
2009-7-14 218665
2009-7-15 218665
2009-7-16 218665
2009-7-19 218665
2009-7-20 218665
2009-7-21 218665
i want to know weather rows r present from one date to another like from date and to date
if i have give from date =2009-7-13 and to date = 2009-7-20 it shuld compare with the date column it should not show all the rows are present because 200-7-17 is not available....
if i have given from date = 2009-7-12 and to date= 2009-7-16 even it shuld not show because 2009-7-12 is not present and vice versa
plz guide me
|
|
|
|
|
How about this?
if(exists(select col1 from temptable where col1 = @fromDate or col1 = @toDate))
begin
select col1,col2 from tablename
where (col1 between @fromDate and @toDate)
end
else
begin
select 'Table does not contains one of the date.'
end
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
no friend it was not working even the columns r getting which r out of dates
|
|
|
|
|
Missed out the first part. Sorry.
AFAIK you will need to write a while loop to do this matching all the dates between the range. But beware, from whatever I have read in the forums, looping techniques might cause performance related issues.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
can u work out on that iam not getting good idea abt while loop
|
|
|
|
|
venu656 wrote: can u work out on that
Will I get paid for that? I guess no. Then I wont.
Here are the links that will help you.
While loop in SQL[^]
DateAdd function in SQL[^]
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
no yaar i cant pay iam still under bankrupt so let me describe that
|
|
|
|
|
your database should store dates and datetimes as such, not as strings. stringed dates just beg for problems.
|
|
|
|
|
thats not a big problem of string i want to know how to check each and every field in the date
|
|
|
|
|
when you store dates as real dates, not strings, you could use date functions[^]; stored as strings, you can try and apply string substringing, however you could be subject of regional setting difference problems.
|
|
|
|
|
If there can only be one entry per date then you can compare the number of rows returned with the number of days between the two dates.
Other than that I cannot help.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
hai sir
the date is one fiels but we are comparing here one fiels with fromdate and todate
|
|
|
|
|
A date does not contain subfields. You're prolly referring to the parts called "day", "month" and "year", but it takes all three to create a date.
A date is not internally stored as a combination of "day, month, year", but as a number, representing "days passed since <startdate>".
The date that you "see" (the string) is a visual representation of the same fact, but formatted for your local culture. It's a visualisation of the date (the plain number in the database) in a specific, culture-dependant string.
In other words; if it fits in a DateTime , then you won't have to check whether the month is larger than "12"
|
|
|
|
|
Hi everybody.
I would like to know about dictionaries: How do they work?
By "dictionary" I mean a program that translates a word from one language to another.
So my questions are:
1. What kind of database do they usually use to store data?
2. How do they search so quickly?
3. Where can I get more info about dictionaries/their development?
PS if it's not the right place I posted at.
|
|
|
|
|
msn92 wrote: 1. What kind of database do they usually use to store data?
A fast, embedded database. Often some custom format.
msn92 wrote: 2. How do they search so quickly?
Indexes
msn92 wrote: 3. Where can I get more info about dictionaries/their development?
Download the Ergane[^] dictionaries, and take a look at the structure. The dictionaries are in MS-Access format, and they should provide a decent starting point.
Measuring programming progress by lines of code is like measuring aircraft building progress by weight.
-- Bill Gates
|
|
|
|
|
Thank you for your reply Eddy Vluggen!
Could MS-Access database be "A fast, embedded database" ?
|
|
|
|
|
msn92 wrote: Could MS-Access database be "A fast, embedded database" ?
Yup, those databases are actually the datafiles that the Ergane-application itself uses
"The wine is good, but the meat is rotten"
|
|
|
|
|
Hello. I was tried figuring out how to use my different pc to perform DML/DDL operation in Mircosoft SQL Server and whose effect will be shown in Main PC. There demo is described below.
3 PC. 2 PC = Client for DML/DDL Operation. 1 PC = Server to reflect changes.
OS in 3 PCs = XP Pro.
All 3 PCs have Sql Server 2005 installed.
Now.. what I want to do is .. if I do any DML/DDL operation from those two pcs which acting as a client the changes should affect in the Main Server PC.
I m not figuring out the way to LINK those two PC's SQL Server with the Main PC's SQL Server.
Please assist me in finding a technique to solve this problem. We already connect these 3 pcs successfully with LAN but not getting a way to solve this problem.
|
|
|
|
|
Is the SqlServer on these PCs the Express version?
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
This sounds weird and not very good.
Do you want all 3 servers to reflect the changes made in 1?
There is not way that I know of to do this 'on the fly', you can use something like Red-Gate SQL Compare and data compare to synchronise the structure but this is a seperate operation, it generates a script that could be run on each server.
Backup/Restore will include the data (obviously)
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I have Developer Edition of SQL Server.
What actually will happen is 2 data entry operators will enter datas from 2 pcs and the changes should be made in the database reside in my Server PC. It doesn't matter for me if those 2 pcs are having SQL Server installed.
My main concern if DML/DDL from 2 pc should affect Server PC.
|
|
|
|