Finding collation in 7.0

Hi all,
I am trying to upgrade to SQL 2000 and was instructed by a consultant to
make sure to use the same collation\sort order in 2000 that I have been
using in 7.0. He assured me that this necessary for Great Plains, which is
the only system we have on top of the DB. I am sure it's in the master db,
but I can't find it!
Any help?Andrew,
sp_helpsort
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"S" <andrewgbl@.hotmail.com> wrote in message
news:uiZbMmdZDHA.2588@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> I am trying to upgrade to SQL 2000 and was instructed by a consultant to
> make sure to use the same collation\sort order in 2000 that I have been
> using in 7.0. He assured me that this necessary for Great Plains, which
is
> the only system we have on top of the DB. I am sure it's in the master
db,
> but I can't find it!
> Any help?
>
>

Find SQL Servers 2000 & 2005 on the net

In order to find SQL Servers 2000, in my .NET application, I successfully use
"SQLBrowseConnect" from ODBC32.DLL. But this doesn't seem to find instances
of SQL Servers 2005.
Is there anything else available to do this job? Thanks for any hint.
Axel Hecker
To see SQL 2005 instances using enumeration APIs, the SQL Browser service
needs to be running on each SQL 2005 server and the instance not explicitly
hidden.
Hope this helps.
Dan Guzman
SQL Server MVP
"AxelHecker" <AxelHecker@.discussions.microsoft.com> wrote in message
news:73AB9D63-3B29-4926-A2F8-0330DDFF5D11@.microsoft.com...
> In order to find SQL Servers 2000, in my .NET application, I successfully
> use
> "SQLBrowseConnect" from ODBC32.DLL. But this doesn't seem to find
> instances
> of SQL Servers 2005.
> Is there anything else available to do this job? Thanks for any hint.
> Axel Hecker
>
|||Thanks for your reply!
SQL Browser service is running, and the instance is not hidden. But I think
I found out what was wrong: I assumed that SQLBrowseConnect would also find
local instances (which is not true).
Thanks anyway,
Axel Hecker
"Dan Guzman" schrieb:

> To see SQL 2005 instances using enumeration APIs, the SQL Browser service
> needs to be running on each SQL 2005 server and the instance not explicitly
> hidden.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "AxelHecker" <AxelHecker@.discussions.microsoft.com> wrote in message
> news:73AB9D63-3B29-4926-A2F8-0330DDFF5D11@.microsoft.com...
>
>

Find SQL Servers 2000 & 2005 on the net

In order to find SQL Servers 2000, in my .NET application, I successfully use
"SQLBrowseConnect" from ODBC32.DLL. But this doesn't seem to find instances
of SQL Servers 2005.
Is there anything else available to do this job? Thanks for any hint.
Axel HeckerTo see SQL 2005 instances using enumeration APIs, the SQL Browser service
needs to be running on each SQL 2005 server and the instance not explicitly
hidden.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"AxelHecker" <AxelHecker@.discussions.microsoft.com> wrote in message
news:73AB9D63-3B29-4926-A2F8-0330DDFF5D11@.microsoft.com...
> In order to find SQL Servers 2000, in my .NET application, I successfully
> use
> "SQLBrowseConnect" from ODBC32.DLL. But this doesn't seem to find
> instances
> of SQL Servers 2005.
> Is there anything else available to do this job? Thanks for any hint.
> Axel Hecker
>|||Thanks for your reply!
SQL Browser service is running, and the instance is not hidden. But I think
I found out what was wrong: I assumed that SQLBrowseConnect would also find
local instances (which is not true).
Thanks anyway,
Axel Hecker
"Dan Guzman" schrieb:
> To see SQL 2005 instances using enumeration APIs, the SQL Browser service
> needs to be running on each SQL 2005 server and the instance not explicitly
> hidden.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "AxelHecker" <AxelHecker@.discussions.microsoft.com> wrote in message
> news:73AB9D63-3B29-4926-A2F8-0330DDFF5D11@.microsoft.com...
> > In order to find SQL Servers 2000, in my .NET application, I successfully
> > use
> > "SQLBrowseConnect" from ODBC32.DLL. But this doesn't seem to find
> > instances
> > of SQL Servers 2005.
> >
> > Is there anything else available to do this job? Thanks for any hint.
> >
> > Axel Hecker
> >
>
>

Find SQL Servers 2000 & 2005 on the net

In order to find SQL Servers 2000, in my .NET application, I successfully us
e
"SQLBrowseConnect" from ODBC32.DLL. But this doesn't seem to find instances
of SQL Servers 2005.
Is there anything else available to do this job? Thanks for any hint.
Axel HeckerTo see SQL 2005 instances using enumeration APIs, the SQL Browser service
needs to be running on each SQL 2005 server and the instance not explicitly
hidden.
Hope this helps.
Dan Guzman
SQL Server MVP
"AxelHecker" <AxelHecker@.discussions.microsoft.com> wrote in message
news:73AB9D63-3B29-4926-A2F8-0330DDFF5D11@.microsoft.com...
> In order to find SQL Servers 2000, in my .NET application, I successfully
> use
> "SQLBrowseConnect" from ODBC32.DLL. But this doesn't seem to find
> instances
> of SQL Servers 2005.
> Is there anything else available to do this job? Thanks for any hint.
> Axel Hecker
>|||Thanks for your reply!
SQL Browser service is running, and the instance is not hidden. But I think
I found out what was wrong: I assumed that SQLBrowseConnect would also find
local instances (which is not true).
Thanks anyway,
Axel Hecker
"Dan Guzman" schrieb:

> To see SQL 2005 instances using enumeration APIs, the SQL Browser service
> needs to be running on each SQL 2005 server and the instance not explicitl
y
> hidden.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "AxelHecker" <AxelHecker@.discussions.microsoft.com> wrote in message
> news:73AB9D63-3B29-4926-A2F8-0330DDFF5D11@.microsoft.com...
>
>

find order by date range or order id

hi basically what i have is 3 text boxes. one for start date, one for end date and one for order id, i also have this bit of SQL

SelectCommand="SELECT [Order_ID], [Customer_Id], [Date_ordered], [status] FROM [tbl_order]WHERE (([Date_ordered] >= @.Date_ordered OR @.Date_ordered IS NULL) AND ([Date_ordered] <= @.Date_ordered2 OR @.Date_ordered2 IS NULL OR (Order_ID=ISNULL(@.OrderID_ID,Order_ID) OR @.Order_ID IS NULL))">

but the problem is it does not seem to work! i am not an SQL guru but i cant figure it out, someone help me please!

Thanks

Jez

If you use SqlDataSource, you can add this to the SqlDataSource:CancelSelectOnNullParameter="false"

And change your SelectCommand to:

SelectCommand="SELECT [Order_ID], [Customer_Id], [Date_ordered], [status] FROM [tbl_order] WHERE [Date_ordered] >= ISNULL(@.Date_ordered, Date_ordered) AND ([Date_ordered] <= ISNULL(@.Date_ordered2, Date_ordered) AND Order_ID=ISNULL(@.OrderID_ID,Order_ID)">

|||

hi thanks for the code, right near the end you put OrderID_ID instead of Order_ID, and missed one ) at the end, but thank you very much for your help!

Jez

|||

Thank you for catching the typos. Glad that you got the idea.

|||

hey i just wondered if i could pick your brains again quickly, i wanted to have the same statement, but also see if it would also take input from a querystring, so could i just do the same thing, put all the WHERE clause in brackets, put a "OR" then just put where order_ID = ? and in the select perameters just have where ? = querystringorderID ?

Jez