|
I'm using SQL Server 7 on the LAN network and I would like to block other SQL Servers from detecting or at least from accessing it.
The server still must allow access to users via applications so logins must exist. I just don't want other SQL servers on the network to be able to connect to and import/export, view table and SP, etc.
Any ideas?
|
|
|
|
|
CAn't be done. Best you can do is lock it down so that your applications use a login that has limited permissions, and make sure noone has the details of the admin account.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
It cannot be done. You need to have the particular server just not be accessed by the others.
"Find it your bloody self - immediately!" - Dave Kreskowiak
|
|
|
|
|
May this work.
In sql server's properties, theres one check box as "register in ad server". Try to uncheck it and then see.
thanks,
|
|
|
|
|
CREATE FUNCTION dbo.abc (@a int)
RETURNS @Products TABLE (
CategoryName nvarchar(15)
, ProductID int)
can i , through this function type return more then one value ,I mean , scalar function return one value, or u can say in the programming languages like c# we can use ref keyword for the function parameters to get the updated value.are these parameters , refererence like parameters in c#.
and one more thing , how can i use the these updated parameters in the stored procedure , that are declared in the function under
TABLE( CategoryName nvarchar(15)
, ProductID int)
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
Functions can either return a single scalar value or a table variable. Stored procedures can return more than one value if you append the OUTPUT keyword to any of your parameter declarations.
I don't understand the second part of your question. Your function returns a table variable. What do you mean by 'updated parameters'?
Paul Marfleet
|
|
|
|
|
How use of function, cursor, trigger in stored procedure in sql server
|
|
|
|
|
These are three separate areas that I recommend you reading up on by googling or buying a book.
In themselves they are fairly weighty topics so if you could be more specific you may get more specific help.
Do you understand what the these three components do?
Based on SQL Server 2000(and over-simplifying):
A function is used for returning a single value, or a table.
A cursor allows you to process one row at a time in a table, so that you can manipulate the data row by row.
A trigger is a rule that is applied to a table when an insert, update or delete s performed.
Hope this helps...
You always pass failure on the way to success.
|
|
|
|
|
I would recommend reading pl/sql from Ivan byross (sorry for spelling mistakes).
|
|
|
|
|
can i use the reference parameteres in the sql user defined functions.
actuallty i wanted to retrieve two values from the function.
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
|
ThanQ
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
Here is a link to an article that clearly explains about the three types of User-Defined function's that can be Implemented in sql server.
UDF's Explained with a real world example[^]
Regards
J O H N ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
"Even eagles need a push." David McNally
|
|
|
|
|
ThanQ
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
From Data menu when I select Add new data source. I get wizard which shows
3 options , after selecting database as first option It shows second page
Of new connection,I get Add Connection box. On which change Button gives list of available databases. (All this for first chapter of ADO.net step by step.)
I have installed SQL server 2005.net,VC#2005.net still it does not show SQL server option in list. It just shows Microsoft SQL server database file,which is of no use.
Will any one will help me for same.
When I open SQL server 2005,it really does not have anything like Query analyser
or Enterprise Manager.
|| ART OF LIVING ||
|
|
|
|
|
You really need to RTFM rather badly.
SQL Server 2005 == Microsoft SQL Server.
SQL Server management Studio ~= Enterprise manager + query Analyzer.
There is no such thing as SQL Server 2005.net (drop the .net).
sounds like the book you chose is a crappy one. Using the wizards is always a bad Idea, since you never get a real idea of how the code should be done, but a least common denominator solution instead.
|
|
|
|
|
Hi friends,
what is the boolean or bit datatype available in ORACLE ?
Please help me.
Regards,
Jegastar.
|
|
|
|
|
Google this question and you will discover that there is no boolean data type in Oracle just as there is no boolean data type in SQL Server.
You always pass failure on the way to success.
|
|
|
|
|
GuyThiebaut wrote: there is no boolean data type in SQL Server
But theres bit datatype in sql server 2005.
|
|
|
|
|
|
Your post has been tagged as Spam. What part of Point 10[^] is beyond your comprehension?
If you want to advertise, I suggest buying ad space[^] on CP.
|
|
|
|
|
His post is a bit ambiguous, it seems to imply he'll create a Microsoft SQL Server MVP a month. He plainly cannot do that.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
He did put some work into the site, just not into customizing the stock DotNetNuke layout.
I was trying to figure out if it another case of plagurism, but I couldn't come up with any matches anywhere. The site looks legit, though just having a site does give you an MVP.
I wonder what our resident SQL guru Colin thinks about his site??
|
|
|
|
|
I may not be quite up to Colin's guru status, but I don't think that the site offers too much. It creates a SQL Server Community MVP a month? Hmmm - what qualities are they actually expecting of a developer. There are lots of other good sites on SQL Server, such as SQLTeam[^].
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Dave Kreskowiak wrote: If you want to advertise, I suggest buying ad space[^] on CP.
Though I didn't get to see their ad, I can only imagine with a username like SQL Gurus... I've got everything I need here, and I don't need really any other website 
"Find it your bloody self - immediately!" - Dave Kreskowiak
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
