|
papa1980 wrote: my program don't work on other computer give me error with server name so my server name is "NIKOLA-I2IIHEHC"
Is the problem your experiencing related the connection string? It’s of poor design to hard code the server name into your application. Store the server name in an ini file or xml file.
ZeePain! wrote: This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.
thedailywtf.com[^]
|
|
|
|
|
Hi there!
Can you help me how to define global variables in MS SQL 2000 or 2005 (@@...) and create a function that auto-start when MS SQL server start. I've searched a lot in google but i still can't found the answer 
Thanks in advance
|
|
|
|
|
I cant say any thing about 2005 but there is no global variable in 2000. Use a status table instead.
Farhan Noor Qureshi
if (this == this) thow this;
|
|
|
|
|
Hi! Thanks to reply 
The global variables that i want to define are something like @@CONNECTIONS, @@FETCH_STATUS (and anything that begins with @@).
Can you help me, please
|
|
|
|
|
Like I said, I am not aware of any user defined global variables in SQL 2k. But I suggest a solution. Say, you have a table with two columns, VarName, VarValue that acts as a list of name-value pair. You could write User defined functions that read-write data for each name-value. Here is an example.
<br />
VarName VarName<br />
-------------------<br />
City London<br />
Country UK<br />
Then you could write UDFs like GetCity(), SetCity(), GetCountry(), SetCountry() etc
Farhan Noor Qureshi
if (this == this) thow this;
-- modified at 13:46 Tuesday 29th November, 2005
|
|
|
|
|
Hi!!
I have a winery name coming from the table, and I concatenated this text string with xxx to see the amount of spaces after the winery name. I did it like this:
SELECT RTRIM(Wnr_Name) + ' xxx' FROM tblWineries;
There are some wineries with spaces after it, and some not. I went to into Enterprise Manager and none of the wines had spaces. How do I remove these sapces? I've tried RTRIM and LTRIM, but none work. Some of the results:
Amani Vineyards xxx
Backsberg Cellars xxx
Beaumont Wines xxx
Can you see that some has extra spaces.
Regards
|
|
|
|
|
ma se wrote: SELECT RTRIM(Wnr_Name) + ' xxx' FROM tblWineries;
There is a space between the first apostrophe and the xxx...That could be why it is not working?
Paul
|
|
|
|
|
There is a reason for a space between the first apostrophe and the xxx. It is there to separate the two strings. If I were to take away the space, then those with the extra space will only have one space, and the rest will look like:
ABC Wineryxxx
So I I put the space in so that it can look like:
ABC Winery xxx
And some wineries have an extra space, which makes the outcome look like:
ABC Winery xxx
|
|
|
|
|
Hmmm, I see why you put a space before the xxx. Are you sure that the "spaces" are not really ASCII character 255 (which is a blank) by some weird reason? You may want to look at the ascii value of the returned wineries to see if this may be the case.
|
|
|
|
|
hello
have a small problem and want help
i have a domain and a webservice application and i want to connect them toghether and i dont found the good statmet to connect them plz help
thanx
tedy
|
|
|
|
|
hello
have a small problem and want help
i have a domain and a webservice application and i want to connect them toghether and i found the good statmet to connect them plz help
thanx
tedy
|
|
|
|
|
7mam wrote: i want to connect them toghether and i found the good statmet to connect them
Your question doesn’t make a whole lot of sense.
Why cant you run your web service on your domain?
ZeePain! wrote: This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.
thedailywtf.com[^]
|
|
|
|
|
|
SQL Server 2000 Enterprise does not work on Windows XP* because it is a server product designed for use in large companies. It is designed to run on a Server therefore the installer will not permit you to install it on a non-server product.
*I modified this so the sentence would make sense as the OP decided to delete the original message and the context was lost as a result
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
-- modified at 10:04 Saturday 26th November, 2005
|
|
|
|
|
Given your previous question[^] I am now curious as to where you got Enterprise Edition from. If, only a few hours ago, you were desperate for a free version of SQL Server 2000 did you suddenly win the lottery in order to afford the several thousands of pounds/dollars that Enterprise Edition costs?
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
nice ))).I have it from one years but the problem is because the comuter of witch i shoot install it has windows xp no some of server version so i can't use it.
-- modified at 7:57 Saturday 26th November, 2005
|
|
|
|
|
hi
clous you give me please url of link for downloading of ms sql server 2000 who is free i don't know the exacly additional name of that product.
thank you
|
|
|
|
|
|
But i need sql 2000 not 2005????
|
|
|
|
|
if i download this free version i will can to add my back up from sql2000
???
|
|
|
|
|
You can try it. I'm guessing that it will probably work, but will be a one way operation, i.e. you won't be able to backup the new database and install it on SQL Server 2000
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
thank you but probabry is not enought???
|
|
|
|
|
I think this just represents a different way of working. If I didn't find the documentation that said one way or the other what the situation was then I'd create a little prototype to see what would happen. In otherwords, I'd have downloaded SQL Server 2005 express and attempted to restore a SQL Server 2000 database to it to see if it would work or not.
I guess I take a more proactive approach to getting things done.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
papa1980 wrote: But i need sql 2000 not 2005????
Search for MSDE. The desktop-edition from SQL-Server 2000 is free, but has some restrictions.
'A programmer ist just a tool which converts caffeine into code'
|
|
|
|
|
Hello I want to insert record in access database using ado.net data adapter , not by command object. by suppling query at run time means Writing Query In a text Box .
Please suggest me.
Manoj
-- modified at 1:45 Saturday 26th November, 2005
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
