|
how can i insert aur select data to sql Server through public IP, is there any configuration for this...? i have my own physical server do there any different setting for this. or any different connection string . i m very much fed up for this can any one help me out.
|
|
|
|
|
install the client on the workstation within the network and you can connect via enterprise manager or sql analyzer also any tool utilzing OLE, ODBC database standards.
On a public IP you have to designate the port via your firewall. Microsoft default is 1433. e.g. 192.168.1.1:1433
Looking for consultant check out my site. I think my profile designates location.
Best Regards,
Bob Zagars
|
|
|
|
|
I have a storeproc contain this script (I retype so maybe have some incorrect syntax) :
create storeproc Pro
@strLinkedServerName varchar(200)
As
set @sql = 'sp_addlinkedserver ' + @strLinkedServerName
sp_executesql @sql
set @sql = 'Select * from ' + @strLinkedServerName + '.dbo.Northwind.Customer'
sp_executesql @sql
You see I must always use dynamic sql to execute a query to get the Linked server name dynamically. But when use dynamic sql, it's hard for me to check the syntax, and some times it take longer time to execute these query.
So I would like to have a mapping name to linked server. For example, I have a mapping name (like constant that affect to all store in one DB, it's similar to the way you declare a variable in webconfig file and can get it from every where) that we can set somewhere, Constant = "ServerA" (linked server name).
so in my proc I can write script like this :
create storeproc Pro
As
set sp_addlinkedserver Constant
Select * from Constant.dbo.Northwind.Customer'
If you have any idea about it please tell me. Thank you very much,
Hieu Tang
|
|
|
|
|
pls i need some sample application that could help me understand the process of inserting data using ADO.Net into the database
welbert
|
|
|
|
|
I've built up a Windows 2003 Enterprise Server and installed the SQL
Server 2005 Developer Edition. For some reason in the server
configuration MMC there's no "Network Connections" to expand and enable
TCP/IP connections. I just read that different versions of SQL Server
disable that feature depending on (what it didn't say)... However I
installe it on my desktop (XP SP2) and have that feature but my
development server doesn't.
Is something wrong with the install or is this by design that the
developer edition will not allow network connections on a server grade
operating system? If that's the case thanks Microsoft so much for being
able to test...
Some assembly required.
Code-frog System Architects, Inc.
|
|
|
|
|
Rex,
Looks like its a configuration issue according to this site.
SQL Server 2005 Features Comparison[^]
[snip]The table below presents details about each of the editions. Not included in the table are SQL Server Developer and Evaluation editions; these editions have the same features as the SQL Server Enterprise but have different licensing policies.[/snip]
I have not yet had an opportunity to dig into the SQL server edition I received from the VS launch event. My server is horribly under powered for SQL server 2005, so I'm not sure how the configuration is hosed up.
[edit]On second thought, perhaps Dev edition isn't licensed to run on a Server?[/edit]
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[^]
-- modified at 7:12 Wednesday 18th January, 2006
|
|
|
|
|
I have installed the Sql Server 2005 and after installing without any problems I am trying to connect to the server instance but there is an error, it could not connect and blah.
I have tried to make a new instance with
Start /wait <dvd drive="">:\Servers\setup.exe /qb INSTANCENAME=MSSQLSERVER ADDLOCAL=SQL_Engine,SQL_Replication SAPWD=<pass>
Same install without problem until it is almoust finished and an error appears:
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
The computer running SQL Server Setup does not meet minimum system requirements for this SQL Server release.Microsoft SQL Server is not supported on this operating system. For details, see Hardware and Software Requirements in the readme or in SQL Server Books Online.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=28018&EvtType=sqlca%5csqlcax.cpp%40DetectSKUOS%40DetectSKUOS%40x6d72
------------------------------
BUTTONS:
OK
------------------------------
I have fowlowed the link but there is nothing.
I have AMD64 1GB RAM HDD SATA 160GB WinXP PRO SP2
PLS PLS PLS PLS HELP
"Tow things are infinite,
the Universe and human stupidity,
and I am not so sure about the former!"
Albert Einstein
|
|
|
|
|
The clue is in the name SQL SERVER 2005. SQL Server is designed to run on server editions of Windows. The only two exceptions to this are the Express Edition (which is limited and so is not scalable) and the Developer Edition (which is not licensed for production environments).
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
-- modified at 16:16 Tuesday 17th January, 2006
|
|
|
|
|
Hello
Isn't it possible to create a new GUID while you're in a UDF?
I've tried the following:
set @ID = NEWID()
but that doesn't work.
Thank you in advance
|
|
|
|
|
NEWID()[^] is a non-deterministic function (because it produces a different output each time it is run based on the same input, which is nothing). User Defined Functions[^] cannot contain non-deterministic functions.
See the second linked item for a list of other functions you cannot use in a UDF.
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
I have a problem with my project.
In this project, we have two options to view the details of a particular employee details.
1. we have provided a new desktop(say X) for this project
so u can view the details of particular employee number.
2. Here, another option(say Y) is also available. From this also, u can view the details of any employee number.
My problem is,
Now I am able to view the details of from Y, but not from X. This is occuring for only one employee number. The remaining employee numbers are working fine and I can able to see the details from the two options(ie., X and Y).
front end is ASP and database is SQL Server2000
So what is expecting error here??
I need this urgently
if any can provide the result, i will be thankful to them
bhasker78@rediffmail.com
Thanks and Regards
Bhasker P
|
|
|
|
|
Bhasker P wrote: we have provided a new desktop
What does that mean?
Bhasker P wrote: So what is expecting error here??
Sounds like a problem with your application logic. However you have not provided any details on that. You just provided vague information about the user interface in abstract.
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
Here new desktop means, We created new interface(say Y) to access the applications of project through this desktop only. This is a web application and this is provided for client side.
And another thing, you can view this data from another interface(say X) also
Now the Problem is, here we are seeing the data about a particular empnumber from X only. And this particular empnumber is not visible from Y.
And this is happening for only one empnumber.And the remaining all empnumbers working fine.
Bhasker P
|
|
|
|
|
pls guys help,how can I update more than one record in the table,actually I need to update dates,adding 12 months to the dates.
eg.
data from DB
date approved expiry date
2005/05/12 2005/11/12
2005/05/28 2005/11/28
2005/06/28 2005/12/28
so how to I add 12 months to the date approved so as to get the expiry date extended with 12 months.
getting something like this:
latest data expiry date
2005/05/12 2006/05/12
2005/05/28 2006/05/28
2005/06/28 2006/06/28
pls guys pls I need a C# code to do that.;P
|
|
|
|
|
minkinin wrote: pls guys pls I need a C# code to do that
C# code does not alter the database, the best it can do is to forward some SQL code to the database. You need SQL code to solve your problem.
The SQL you need is something like this:
UPDATE MyTable SET [expiry date] = dateadd(year, [latest date]);
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
Thanks a lot Colin,this is exactly what I wanted
and is working perfect;P
|
|
|
|
|
I have in the distant past been able to debug SQL Stored procedures in the .NET ide, and now I have not been able to figure out the correct configuration. If anyone has this knowledge please give me and a multitude of others an hand with this very helpful tool. Thanks in advance for your help.
SL
|
|
|
|
|
You have to enable SP-Debugging in the .net-project.
'A programmer is just a tool which converts caffeine into code'
|
|
|
|
|
Hi i am havin a bit of trouble tryin to get a match based on a null value in a table, there are 4 tables based on the id that is on the bottom table which is null in some of them, i use dif ids to get to the top table and use the namethat is in there this is the code i am using i am just wondering ifanyone has any ideas of how to work around this problem
select ssg.Name + ' ' + supt.Name + ' ' + st.Name as name, st.name as '4th', supt.name as '3rd', ssg.name as '2nd', sg.name as '1st'
from session s
left join sessionActivity sa on sa.SessionId = s.Id
left join SessionType as st on st.ID = sa.SessionType
left join SessionSuperType as supt on supt.ID = st.SuperTypeId
left join SessionSubGroup as ssg on ssg.ID = supt.SessionSubGroupId
left join SessionGroup as sg on sg.ID = ssg.SessionGroupId
where sg.Id <> 8
and sg.Id <> 9
and s.ID = 50
|
|
|
|
|
how can i perform multiple update in one trip to the server
love you all
|
|
|
|
|
Put multiple statements in the SqlCommand.
For example:
INSERT INTO MyTable(a,b,c) VALUES (@a1, @b1, @c1);
INSERT INTO MyTable(a,b,c) VALUES(@a2, @b2, @c2); Just separate the statements with a semi-colon.
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
-- modified at 8:03 Tuesday 17th January, 2006
|
|
|
|
|
Hello. I would like to call a function that retrieves the table name. and then use the name in a statement. like this:
UPDATE GetTableName() SET bla bla... and so on
Is this possible? I return the tableName as a VARCHAR, but this does not seem to work.
All help is appreciated, thanks!
/Joel
|
|
|
|
|
u can find the table name by the following:
select name from sysobjects where type='u' and name='tablename'
then u can set in ur update code
abhinav
|
|
|
|
|
HOW CAN I DO MULTIPLE UPDATE IN ONE TRIP TO THE SERVER
LOVE U ALL
|
|
|
|
|
Yes.
And, by the way, do you know your caps lock key is broken?
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
