Database

17-Jan-06 20:08

Fellow Professionals,

Is there anyway to get the NT users associated with the server in SQL Server 2000? I know xp_enumgroups gets a list of NT Groups but I can not find a stored procedure that returns that information. Does SQL 2005 have it? My other alternative is to write a .NET object and obtain this information from the local network.

Well can anyone help me? Please let me know.

Best Regards,

Bob Zagars

Colin Angus Mackay17-Jan-06 20:54

17-Jan-06 20:54

Bob Zagars wrote:
Is there anyway to get the NT users associated with the server in SQL Server 2000?

SELECT name 
FROM master..syslogins
WHERE IsNTUser = 1

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

Bob Zagars17-Jan-06 23:52

17-Jan-06 23:52

That gives me registered users what about user not yet regisered. Stored procedure:

xp_enumgroups
Provides a list of local Microsoft® Windows NT® groups or a list of global groups defined in a specified Windows NT domain.

Syntax
xp_enumgroups ['domain_name']

They do not have to be registered on the database just within a Windows NT domain.

Best Regards,

Bob Zagars

S Douglas18-Jan-06 0:40

S Douglas

18-Jan-06 0:40

Bob Zagars wrote:
They do not have to be registered on the database just within a Windows NT domain.

If they haven’t been registered in SQL Server then SQL server won’t know about them. You will need to interrogate the Domain it self, if it’s an Active Directory Domain (I think it’s called tree now) here is a vb script that lists all disabled users, a minor mod and it could dump out all users.

List All the Disabled User Accounts in Active Directory[^]

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[^]

Bob Zagars18-Jan-06 5:46

18-Jan-06 5:46

S. Douglas,

Thanks I will check it out and let you know if it works.

Bob Zagars

how to access the Sql Server Publicly

S Douglas18-Jan-06 5:53

S Douglas

18-Jan-06 5:53

No problem...

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[^]

raheeli17-Jan-06 18:15

raheeli

17-Jan-06 18:15

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.

Re: how to access the Sql Server Publicly

Bob Zagars17-Jan-06 20:18

Map linked server to a constant

17-Jan-06 20:18

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

12324r32353217-Jan-06 16:34

12324r323532

17-Jan-06 16:34

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

How to use Insert/Update/Delete....

welbert17-Jan-06 15:48

welbert

17-Jan-06 15:48

pls i need some sample application that could help me understand the process of inserting data using ADO.Net into the database

welbert

SQL Server 2005 Developer Edition Network Connections...

code-frog17-Jan-06 12:51

code-frog

17-Jan-06 12:51

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.

Re: SQL Server 2005 Developer Edition Network Connections...

S Douglas18-Jan-06 1:07

S Douglas

18-Jan-06 1:07

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

SQL SERVER 2005 BIG PROBLEM

Micu Radu17-Jan-06 6:07

Micu Radu

17-Jan-06 6:07

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

Re: SQL SERVER 2005 BIG PROBLEM

Colin Angus Mackay17-Jan-06 10:14

Re: create new GUID in UDF?

17-Jan-06 10:14

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

create new GUID in UDF?

waterispoison17-Jan-06 5:38

waterispoison

17-Jan-06 5:38

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

Colin Angus Mackay17-Jan-06 10:12

Re: Reg:Data is not visible

17-Jan-06 10:12

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

Reg:Data is not visible

Bhasker P17-Jan-06 4:57

Bhasker P

17-Jan-06 4:57

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

Colin Angus Mackay17-Jan-06 5:04

Re: Reg:Data is not visible

17-Jan-06 5:04

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

Bhasker P18-Jan-06 0:15

Bhasker P

18-Jan-06 0:15

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

updating many records in the Table

minkinin17-Jan-06 2:07

minkinin

17-Jan-06 2:07

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

Re: updating many records in the Table

Colin Angus Mackay17-Jan-06 2:30