SQL Server 2005 Developer Edition Network Connections... - Database Discussion Boards

Re: NT User List

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

Re: NT User List

Bob Zagars18-Jan-06 5:46

Bob Zagars

18-Jan-06 5:46

S. Douglas,

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

Bob Zagars

Re: NT User List

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

how to access the Sql Server Publicly

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

Bob Zagars

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

Map linked server to a constant

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

Colin Angus Mackay

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

Re: create new GUID in UDF?

Colin Angus Mackay17-Jan-06 10:12

Colin Angus Mackay

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

Re: Reg:Data is not visible

Colin Angus Mackay17-Jan-06 5:04

Colin Angus Mackay

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

Re: Reg:Data is not visible

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

Colin Angus Mackay

17-Jan-06 2:30

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

Re: updating many records in the Table

minkinin17-Jan-06 21:38

minkinin

17-Jan-06 21:38

Thanks a lot Colin,this is exactly what I wanted
and is working perfect;P

debugging SQL Server Stored Procedures in .NET ide

culbysl17-Jan-06 0:57

culbysl

17-Jan-06 0:57

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

Re: debugging SQL Server Stored Procedures in .NET ide

André Ziegler17-Jan-06 3:57

André Ziegler

17-Jan-06 3:57

You have to enable SP-Debugging in the .net-project.

'A programmer is just a tool which converts caffeine into code'

Null Match Prob

tadhg8816-Jan-06 23:41

tadhg88

16-Jan-06 23:41

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

multiple update

sood_is_in16-Jan-06 22:35

sood_is_in

16-Jan-06 22:35

how can i perform multiple update in one trip to the server

love you all

Re: multiple update

Colin Angus Mackay17-Jan-06 2:03

Colin Angus Mackay

17-Jan-06 2:03

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

retrieving table name

waterispoison16-Jan-06 22:24

waterispoison

16-Jan-06 22:24

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

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.