Hi Hari,
I see that you respond to my question but unfortunently i
cant see your response, its shown to me "message
unavailable"
It is possible that you send me your response to
jorge.mmendes@.optimus.pt or respond again to this post.
I'll appreciate your kindness
RegardsHi,
SQL 7 do not have those properties. COllation setting in SQL 7 is server
wise not database specific.
Execute the below command to get those details.
sp_helpsort
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:ae8f01c4796a$63773eb0$a501280a@.phx.gbl...
> Hi Hari,
> I see that you respond to my question but unfortunently i
> cant see your response, its shown to me "message
> unavailable"
> It is possible that you send me your response to
> jorge.mmendes@.optimus.pt or respond again to this post.
> I'll appreciate your kindness
> Regards
Showing posts with label collations. Show all posts
Showing posts with label collations. Show all posts
Friday, February 10, 2012
Check Server and Database Collations (Hari Prasad)
Hi Hari,
I see that you respond to my question but unfortunently i
cant see your response, its shown to me "message
unavailable"
It is possible that you send me your response to
jorge.mmendes@.optimus.pt or respond again to this post.
I'll appreciate your kindness
Regards
Hi,
SQL 7 do not have those properties. COllation setting in SQL 7 is server
wise not database specific.
Execute the below command to get those details.
sp_helpsort
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:ae8f01c4796a$63773eb0$a501280a@.phx.gbl...
> Hi Hari,
> I see that you respond to my question but unfortunently i
> cant see your response, its shown to me "message
> unavailable"
> It is possible that you send me your response to
> jorge.mmendes@.optimus.pt or respond again to this post.
> I'll appreciate your kindness
> Regards
I see that you respond to my question but unfortunently i
cant see your response, its shown to me "message
unavailable"
It is possible that you send me your response to
jorge.mmendes@.optimus.pt or respond again to this post.
I'll appreciate your kindness
Regards
Hi,
SQL 7 do not have those properties. COllation setting in SQL 7 is server
wise not database specific.
Execute the below command to get those details.
sp_helpsort
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:ae8f01c4796a$63773eb0$a501280a@.phx.gbl...
> Hi Hari,
> I see that you respond to my question but unfortunently i
> cant see your response, its shown to me "message
> unavailable"
> It is possible that you send me your response to
> jorge.mmendes@.optimus.pt or respond again to this post.
> I'll appreciate your kindness
> Regards
Check Server and Database Collations (Hari Prasad)
Hi Hari,
I see that you respond to my question but unfortunently i
cant see your response, its shown to me "message
unavailable"
It is possible that you send me your response to
jorge.mmendes@.optimus.pt or respond again to this post.
I'll appreciate your kindness
RegardsHi,
SQL 7 do not have those properties. COllation setting in SQL 7 is server
wise not database specific.
Execute the below command to get those details.
sp_helpsort
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:ae8f01c4796a$63773eb0$a501280a@.phx.gbl...
> Hi Hari,
> I see that you respond to my question but unfortunently i
> cant see your response, its shown to me "message
> unavailable"
> It is possible that you send me your response to
> jorge.mmendes@.optimus.pt or respond again to this post.
> I'll appreciate your kindness
> Regards
I see that you respond to my question but unfortunently i
cant see your response, its shown to me "message
unavailable"
It is possible that you send me your response to
jorge.mmendes@.optimus.pt or respond again to this post.
I'll appreciate your kindness
RegardsHi,
SQL 7 do not have those properties. COllation setting in SQL 7 is server
wise not database specific.
Execute the below command to get those details.
sp_helpsort
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:ae8f01c4796a$63773eb0$a501280a@.phx.gbl...
> Hi Hari,
> I see that you respond to my question but unfortunently i
> cant see your response, its shown to me "message
> unavailable"
> It is possible that you send me your response to
> jorge.mmendes@.optimus.pt or respond again to this post.
> I'll appreciate your kindness
> Regards
Check Server and Database Collations
Hello,
I create one script that gives me the server and database
collations.
This server has SQL Server 2000 and there's no proble but
when i execute the script in one server with SQL Server
7.0 it doesn't work because there are two functions that
doesn't exists in SQL Server 7.0
The following functions are not working:
DATABASEPROPERTYEX('database_name', 'collation')
SERVERPROPERTY('collation')
I've seen DATABASEPROPERTY on SQL 7.0 but it has no
options for the collation.
Can anybody tell me how can i turn arround this little
problem?
I need to check Server and Database collations in this
server.
Regards
Hi,
SQL 7 do not have those properties. COllation setting in SQL 7 is server
wise not database specific.
Execute the below command to get those details.
sp_helpsort
Thanks
Hari
MCDBA
You could check the sort and charec
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:acf201c47965$7a651840$a501280a@.phx.gbl...
> Hello,
> I create one script that gives me the server and database
> collations.
> This server has SQL Server 2000 and there's no proble but
> when i execute the script in one server with SQL Server
> 7.0 it doesn't work because there are two functions that
> doesn't exists in SQL Server 7.0
> The following functions are not working:
> DATABASEPROPERTYEX('database_name', 'collation')
> SERVERPROPERTY('collation')
> I've seen DATABASEPROPERTY on SQL 7.0 but it has no
> options for the collation.
> Can anybody tell me how can i turn arround this little
> problem?
> I need to check Server and Database collations in this
> server.
> Regards
>
I create one script that gives me the server and database
collations.
This server has SQL Server 2000 and there's no proble but
when i execute the script in one server with SQL Server
7.0 it doesn't work because there are two functions that
doesn't exists in SQL Server 7.0
The following functions are not working:
DATABASEPROPERTYEX('database_name', 'collation')
SERVERPROPERTY('collation')
I've seen DATABASEPROPERTY on SQL 7.0 but it has no
options for the collation.
Can anybody tell me how can i turn arround this little
problem?
I need to check Server and Database collations in this
server.
Regards
Hi,
SQL 7 do not have those properties. COllation setting in SQL 7 is server
wise not database specific.
Execute the below command to get those details.
sp_helpsort
Thanks
Hari
MCDBA
You could check the sort and charec
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:acf201c47965$7a651840$a501280a@.phx.gbl...
> Hello,
> I create one script that gives me the server and database
> collations.
> This server has SQL Server 2000 and there's no proble but
> when i execute the script in one server with SQL Server
> 7.0 it doesn't work because there are two functions that
> doesn't exists in SQL Server 7.0
> The following functions are not working:
> DATABASEPROPERTYEX('database_name', 'collation')
> SERVERPROPERTY('collation')
> I've seen DATABASEPROPERTY on SQL 7.0 but it has no
> options for the collation.
> Can anybody tell me how can i turn arround this little
> problem?
> I need to check Server and Database collations in this
> server.
> Regards
>
Check Server and Database Collations
Hello,
I create one script that gives me the server and database
collations.
This server has SQL Server 2000 and there's no proble but
when i execute the script in one server with SQL Server
7.0 it doesn't work because there are two functions that
doesn't exists in SQL Server 7.0
The following functions are not working:
DATABASEPROPERTYEX('database_name', 'collation')
SERVERPROPERTY('collation')
I've seen DATABASEPROPERTY on SQL 7.0 but it has no
options for the collation.
Can anybody tell me how can i turn arround this little
problem?
I need to check Server and Database collations in this
server.
RegardsHi,
SQL 7 do not have those properties. COllation setting in SQL 7 is server
wise not database specific.
Execute the below command to get those details.
sp_helpsort
Thanks
Hari
MCDBA
You could check the sort and charec
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:acf201c47965$7a651840$a501280a@.phx.gbl...
> Hello,
> I create one script that gives me the server and database
> collations.
> This server has SQL Server 2000 and there's no proble but
> when i execute the script in one server with SQL Server
> 7.0 it doesn't work because there are two functions that
> doesn't exists in SQL Server 7.0
> The following functions are not working:
> DATABASEPROPERTYEX('database_name', 'collation')
> SERVERPROPERTY('collation')
> I've seen DATABASEPROPERTY on SQL 7.0 but it has no
> options for the collation.
> Can anybody tell me how can i turn arround this little
> problem?
> I need to check Server and Database collations in this
> server.
> Regards
>
I create one script that gives me the server and database
collations.
This server has SQL Server 2000 and there's no proble but
when i execute the script in one server with SQL Server
7.0 it doesn't work because there are two functions that
doesn't exists in SQL Server 7.0
The following functions are not working:
DATABASEPROPERTYEX('database_name', 'collation')
SERVERPROPERTY('collation')
I've seen DATABASEPROPERTY on SQL 7.0 but it has no
options for the collation.
Can anybody tell me how can i turn arround this little
problem?
I need to check Server and Database collations in this
server.
RegardsHi,
SQL 7 do not have those properties. COllation setting in SQL 7 is server
wise not database specific.
Execute the below command to get those details.
sp_helpsort
Thanks
Hari
MCDBA
You could check the sort and charec
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:acf201c47965$7a651840$a501280a@.phx.gbl...
> Hello,
> I create one script that gives me the server and database
> collations.
> This server has SQL Server 2000 and there's no proble but
> when i execute the script in one server with SQL Server
> 7.0 it doesn't work because there are two functions that
> doesn't exists in SQL Server 7.0
> The following functions are not working:
> DATABASEPROPERTYEX('database_name', 'collation')
> SERVERPROPERTY('collation')
> I've seen DATABASEPROPERTY on SQL 7.0 but it has no
> options for the collation.
> Can anybody tell me how can i turn arround this little
> problem?
> I need to check Server and Database collations in this
> server.
> Regards
>
Check Server and Database Collations
Hello,
I create one script that gives me the server and database
collations.
This server has SQL Server 2000 and there's no proble but
when i execute the script in one server with SQL Server
7.0 it doesn't work because there are two functions that
doesn't exists in SQL Server 7.0
The following functions are not working:
DATABASEPROPERTYEX('database_name', 'collation')
SERVERPROPERTY('collation')
I've seen DATABASEPROPERTY on SQL 7.0 but it has no
options for the collation.
Can anybody tell me how can i turn arround this little
problem?
I need to check Server and Database collations in this
server.
RegardsHi,
SQL 7 do not have those properties. COllation setting in SQL 7 is server
wise not database specific.
Execute the below command to get those details.
sp_helpsort
Thanks
Hari
MCDBA
You could check the sort and charec
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:acf201c47965$7a651840$a501280a@.phx.gbl...
> Hello,
> I create one script that gives me the server and database
> collations.
> This server has SQL Server 2000 and there's no proble but
> when i execute the script in one server with SQL Server
> 7.0 it doesn't work because there are two functions that
> doesn't exists in SQL Server 7.0
> The following functions are not working:
> DATABASEPROPERTYEX('database_name', 'collation')
> SERVERPROPERTY('collation')
> I've seen DATABASEPROPERTY on SQL 7.0 but it has no
> options for the collation.
> Can anybody tell me how can i turn arround this little
> problem?
> I need to check Server and Database collations in this
> server.
> Regards
>
I create one script that gives me the server and database
collations.
This server has SQL Server 2000 and there's no proble but
when i execute the script in one server with SQL Server
7.0 it doesn't work because there are two functions that
doesn't exists in SQL Server 7.0
The following functions are not working:
DATABASEPROPERTYEX('database_name', 'collation')
SERVERPROPERTY('collation')
I've seen DATABASEPROPERTY on SQL 7.0 but it has no
options for the collation.
Can anybody tell me how can i turn arround this little
problem?
I need to check Server and Database collations in this
server.
RegardsHi,
SQL 7 do not have those properties. COllation setting in SQL 7 is server
wise not database specific.
Execute the below command to get those details.
sp_helpsort
Thanks
Hari
MCDBA
You could check the sort and charec
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:acf201c47965$7a651840$a501280a@.phx.gbl...
> Hello,
> I create one script that gives me the server and database
> collations.
> This server has SQL Server 2000 and there's no proble but
> when i execute the script in one server with SQL Server
> 7.0 it doesn't work because there are two functions that
> doesn't exists in SQL Server 7.0
> The following functions are not working:
> DATABASEPROPERTYEX('database_name', 'collation')
> SERVERPROPERTY('collation')
> I've seen DATABASEPROPERTY on SQL 7.0 but it has no
> options for the collation.
> Can anybody tell me how can i turn arround this little
> problem?
> I need to check Server and Database collations in this
> server.
> Regards
>
Subscribe to:
Posts (Atom)