3 Questions

Dear Professionals,
1. Could any one explain in a simple word "what Collation play a role in
SqlServer"
2. I want the restrict all the user to connect only from SA login .. can't
connect through windows authentication.. what I have to do for this ?
3. Which license would be good Per seat or Per processor.
Thanks
NOOR
Noor,
#1. Multi language support.(you asked for a word , okay that was 3:-)
#2: Remove all Windows logins including builtin\administrators and non-sa
sql logins.Juist curious, why do you want to do that?Removing buitin\admin
needs to be done very carefully.
#3. Difficult to say.If one was better than the other why would Microsoft
give you two?Depends on your requirement.See
'How to Buy'
http://www.microsoft.com/sql/howtobuy/default.asp
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Noorali Issani" <naissani@.softhome.net> wrote in message
news:O1Q8UN7QEHA.3140@.tk2msftngp13.phx.gbl...
> Dear Professionals,
> 1. Could any one explain in a simple word "what Collation play a role in
> SqlServer"
> 2. I want the restrict all the user to connect only from SA login .. can't
> connect through windows authentication.. what I have to do for this ?
> 3. Which license would be good Per seat or Per processor.
> Thanks
> NOOR
>
|||Thanks Dinesh..
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:%236xQRa8QEHA.3728@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Noor,
> #1. Multi language support.(you asked for a word , okay that was 3:-)
> #2: Remove all Windows logins including builtin\administrators and non-sa
> sql logins.Juist curious, why do you want to do that?Removing buitin\admin
> needs to be done very carefully.
> #3. Difficult to say.If one was better than the other why would Microsoft
> give you two?Depends on your requirement.See
> 'How to Buy'
> http://www.microsoft.com/sql/howtobuy/default.asp
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Noorali Issani" <naissani@.softhome.net> wrote in message
> news:O1Q8UN7QEHA.3140@.tk2msftngp13.phx.gbl...
can't
>

2006-07-28 00:00:00

This is the result I get in Word as I handle a document that merges data
from the database. The field Date_Fin_Membre returns me this result
even if the query stipulates
WHERE (dbo.Membre.Date_Fin_Membre = CONVERT(Char(10),
dbo.Membre.Date_Fin_Membre, 101)). I have also tried other types of
conversion without any success. I just need the date not the following
hours, minutes and seconds.
thanks
You might be using CONVERT(Char(10), dbo.Membre.Date_Fin_Membre, 101)
only for checking in where clause, you will have to specify the same in
Select columns as well.
something like this:
Select
CONVERT(Char(10), dbo.Membre.Date_Fin_Membre, 101) from XYZTable
Where
dbo.Membre.Date_Fin_Membre = CONVERT(Char(10),
dbo.Membre.Date_Fin_Membre, 101))
Regards,
|||Thanks, it solved my problem.
*** Sent via Developersdex http://www.codecomments.com ***

2006-07-28 00:00:00

This is the result I get in Word as I handle a document that merges data
from the database. The field Date_Fin_Membre returns me this result
even if the query stipulates
WHERE (dbo.Membre.Date_Fin_Membre = CONVERT(Char(10),
dbo.Membre.Date_Fin_Membre, 101)). I have also tried other types of
conversion without any success. I just need the date not the following
hours, minutes and seconds.
thanksYou might be using CONVERT(Char(10), dbo.Membre.Date_Fin_Membre, 101)
only for checking in where clause, you will have to specify the same in
Select columns as well.
something like this:
Select
CONVERT(Char(10), dbo.Membre.Date_Fin_Membre, 101) from XYZTable
Where
dbo.Membre.Date_Fin_Membre = CONVERT(Char(10),
dbo.Membre.Date_Fin_Membre, 101))
Regards,|||Thanks, it solved my problem.
*** Sent via Developersdex http://www.codecomments.com ***

2006-07-28 00:00:00

This is the result I get in Word as I handle a document that merges data
from the database. The field «Date_Fin_Membre» returns me this result
even if the query stipulates
WHERE (dbo.Membre.Date_Fin_Membre = CONVERT(Char(10),
dbo.Membre.Date_Fin_Membre, 101)). I have also tried other types of
conversion without any success. I just need the date not the following
hours, minutes and seconds.
thanksYou might be using CONVERT(Char(10), dbo.Membre.Date_Fin_Membre, 101)
only for checking in where clause, you will have to specify the same in
Select columns as well.
something like this:
Select
CONVERT(Char(10), dbo.Membre.Date_Fin_Membre, 101) from XYZTable
Where
dbo.Membre.Date_Fin_Membre = CONVERT(Char(10),
dbo.Membre.Date_Fin_Membre, 101))
Regards,

2006-07-26 00:00:00

This is the result I get in Word as I handle a document that merges data
from the database. The field Date_Fin_Membre returns me this result
even if the query stipulates
WHERE (dbo.Membre.Date_Fin_Membre = CONVERT(Char(10),
dbo.Membre.Date_Fin_Membre, 101)). I have also tried other types of
conversion without any success.
thanksI haven't worked with OLE automation in Office in some time, but can't
you specify the field type in Word? It soulnd like it's looking for a
date/time formatted field in Word.

HTH,
Stu|||Fernand St-Georges (fernand.st-georges@.videotron.ca) writes:
> This is the result I get in Word as I handle a document that merges data
> from the database. The field Date_Fin_Membre returns me this result
> even if the query stipulates
> WHERE (dbo.Membre.Date_Fin_Membre = CONVERT(Char(10),
> dbo.Membre.Date_Fin_Membre, 101)). I have also tried other types of
> conversion without any success.

Maybe you could explain what's wrong with the result? Maybe it's an
error to you that the end date for a member is in the future, but I
don't know your business.

If you are talking about the time portion, then the WHERE clause is not
the place to handle it.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland, What i believe his problem is,
when he is trying to show date like "07/26/2005" while he is getting
"2006-07-26 00:00:0"

He is not converting the same date in the SELECT list

Mistakingly, he is doing something like this:

Select dbo.Membre.Date_Fin_Membre, Col2, Col3, ......
WHERE (dbo.Membre.Date_Fin_Membre = CONVERT(Char(10),
dbo.Membre.Date_Fin_Membre, 101)).

insteed of

Select CONVERT(Char(10), dbo.Membre.Date_Fin_Membre, 101), Col2, Col3,
......
WHERE (dbo.Membre.Date_Fin_Membre = CONVERT(Char(10),
dbo.Membre.Date_Fin_Membre, 101)).|||Zero.NULL (manish19@.gmail.com) writes:
> Erland, What i believe his problem is,
> when he is trying to show date like "07/26/2005" while he is getting
> "2006-07-26 00:00:0"

Of course, we could start some betting on what output Fernand really
wants. I think my odds are better. 2006-07-26 is a well-formatted date,
and complies with international standards. 07/26/2005 does not even look
like a date to most people in this world. I seem to recall that there
is one country where they use this format, but Fernand does not seem
to live there.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||That's right, we can only think about the possible situation on the
basis of provided data, and I have got this idea just because of style
of conversion Fernand used to compare dates.

In Where clause he used CONVERT(Char(10), dbo.Membre.Date_Fin_Membre,
101)), which converts date in char in mm/dd/yy format, but at the same
time he did not provide the information of what kind of conversion he
is using in Select List for this date column. He is puzzled with the
kind of result he is getting for this date column but did not written
what kind of result he has expected. That is what I am suspecting here
that his date display requirement is the same as he did in where clause.|||Hi Fernand St-Georges
Can you please explain ur problem. Please let us know, whats the
expected result and how the system is behaving now

best Regards,
Chandra
http://groups.msn.com/SQLResource/
http://chanduas.blogspot.com/
------------

*** Sent via Developersdex http://www.developersdex.com ***

2005 local server name help

you have to add the server with
exec sp_addserver 'newname','local'
the key word 'local' will set the serverid to 0.
-oj
"Mike" <mguissine@.hotmail.com> wrote in message
news:1151461463.763845.263690@.75g2000cwc.googlegroups.com...
>I have installed SQL Server 2005 and by mistake replace local server
> name with linked server.
> Ran sp_dropserver 'Localservername' and sp_addserver 'localservername'.
> After that I installed replication on same server and enable it as
> distributor and subscriber.
> It worked fime till server reboot
> After reboot, the replication stopped working. I find out that this is
> due to local server name not exists anymore (it's no record with id=0
> in sys.servers view).
> Now I have real big problem:
> 1. I can't drop linked and add a local server with same name since it
> used in replication.
> 2. I can't drop replication because it's trying to get server by name
> (apparently quering same view) and it returns NULL.
> Any help , please.
> Mike
>I have installed SQL Server 2005 and by mistake replace local server
name with linked server.
Ran sp_dropserver 'Localservername' and sp_addserver 'localservername'.
After that I installed replication on same server and enable it as
distributor and subscriber.
It worked fime till server reboot
After reboot, the replication stopped working. I find out that this is
due to local server name not exists anymore (it's no record with id=0
in sys.servers view).
Now I have real big problem:
1. I can't drop linked and add a local server with same name since it
used in replication.
2. I can't drop replication because it's trying to get server by name
(apparently quering same view) and it returns NULL.
Any help , please.
Mike|||you have to add the server with
exec sp_addserver 'newname','local'
the key word 'local' will set the serverid to 0.
-oj
"Mike" <mguissine@.hotmail.com> wrote in message
news:1151461463.763845.263690@.75g2000cwc.googlegroups.com...
>I have installed SQL Server 2005 and by mistake replace local server
> name with linked server.
> Ran sp_dropserver 'Localservername' and sp_addserver 'localservername'.
> After that I installed replication on same server and enable it as
> distributor and subscriber.
> It worked fime till server reboot
> After reboot, the replication stopped working. I find out that this is
> due to local server name not exists anymore (it's no record with id=0
> in sys.servers view).
> Now I have real big problem:
> 1. I can't drop linked and add a local server with same name since it
> used in replication.
> 2. I can't drop replication because it's trying to get server by name
> (apparently quering same view) and it returns NULL.
> Any help , please.
> Mike
>|||I maybe didn't explained things correctly..
I created linked server with 'LocalServerName' thas my local server
(id=0) does not exists anymore. Now I want to put it back. The right
steps to do it would be:
1. drop linked server. sp_dropserver 'name', 'droplogins'
2. create local server. sp_addserver 'name' , 'local'
The problem is that the server is used in replication, so I can't drop
it hense can't add new server with the same name. I can't do anything
with replication either...
The only way I think is to hack into system tables and change id to 0
for the linked server so it will become local. But it looks like in
SS2005 i don't have that option...
Mike
oj wrote:[vbcol=seagreen]
> you have to add the server with
> exec sp_addserver 'newname','local'
> the key word 'local' will set the serverid to 0.
> --
> -oj
>
> "Mike" <mguissine@.hotmail.com> wrote in message
> news:1151461463.763845.263690@.75g2000cwc.googlegroups.com...|||I maybe didn't explained things correctly..
I created linked server with 'LocalServerName' thas my local server
(id=0) does not exists anymore. Now I want to put it back. The right
steps to do it would be:
1. drop linked server. sp_dropserver 'name', 'droplogins'
2. create local server. sp_addserver 'name' , 'local'
The problem is that the server is used in replication, so I can't drop
it hense can't add new server with the same name. I can't do anything
with replication either...
The only way I think is to hack into system tables and change id to 0
for the linked server so it will become local. But it looks like in
SS2005 i don't have that option...
Mike
oj wrote:[vbcol=seagreen]
> you have to add the server with
> exec sp_addserver 'newname','local'
> the key word 'local' will set the serverid to 0.
> --
> -oj
>
> "Mike" <mguissine@.hotmail.com> wrote in message
> news:1151461463.763845.263690@.75g2000cwc.googlegroups.com...|||Ah. I see your delima. Dropping repl would be the only choice. Sorry.
-oj
"Mike" <mguissine@.hotmail.com> wrote in message
news:1151511040.077204.203160@.j72g2000cwa.googlegroups.com...
>I maybe didn't explained things correctly..
> I created linked server with 'LocalServerName' thas my local server
> (id=0) does not exists anymore. Now I want to put it back. The right
> steps to do it would be:
> 1. drop linked server. sp_dropserver 'name', 'droplogins'
> 2. create local server. sp_addserver 'name' , 'local'
> The problem is that the server is used in replication, so I can't drop
> it hense can't add new server with the same name. I can't do anything
> with replication either...
> The only way I think is to hack into system tables and change id to 0
> for the linked server so it will become local. But it looks like in
> SS2005 i don't have that option...
> Mike
>
> oj wrote:
>