Does SQL2000/MSDE run on XP Tablet?

Hello there,

i have a great doubt: does MSDE run on XP Tablet Edition? I bought a beautiful notebook but didn't notice that it runs XP tablet...

Thanks in advance

Yes it does

Does SQL 7 server run well in Win Server 2k3 or do I have to upgra

I currently have one machine running windows 2000 server that I promoted to a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
6.0. Do you have any advice here?
Please help, and thank you.
Db
Db
SQL Server 7 is not supported on Windows 2003. So while it might work its
not a good idea to try it. If you do gey any issues you will have trouble
getting help. If you want to use the server you should upgrade to SQL Server
2000.
Regards
John
"kwizyu" wrote:

> I currently have one machine running windows 2000 server that I promoted to a
> PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
> and I want to migrate the win2k pdc to win server 2k3, that I will promote to
> a high-end domain controller. I wonder if someone with expertise in this
> matter could tell me the steps I should follow to accomplish this with the
> least headache. Also, does SQL 7 still run well on win2k3 server or am I
> required to upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
>
|||kwizyu wrote:
> I currently have one machine running windows 2000 server that I
> promoted to a PDC. It also runs SQL 7 server and IIS 5.0. I acquired
> windows server 20003, and I want to migrate the win2k pdc to win
> server 2k3, that I will promote to a high-end domain controller. I
> wonder if someone with expertise in this matter could tell me the
> steps I should follow to accomplish this with the least headache.
> Also, does SQL 7 still run well on win2k3 server or am I required to
> upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking"
> them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
SQL 7 is not certified to run on Windows Server 2003. Personally, I use
SQL 7 on a Virtual PC running Windows Server 2003. But this is just for
development when a real SQL 7 server is unavailable.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Ugh, not to mention that you don't want to be running SQL Server of any
version or edition on a Domain Controller. You like cheap thrills, huh?
I know; I know. It's not your fault; however, the whole point of
distributed computing is to segment and isolate functionality on seperate
and distributed platforms. If you're going to lump everyting into a single
installation, you might as well be running on a mainframe or mini-computer.
Can anyone say stone age?
Sincerely,
Anthony Thomas

"kwizyu" <kwizyu@.discussions.microsoft.com> wrote in message
news:9191D846-1696-4CE2-A2EF-5BC2FCE3161E@.microsoft.com...
I currently have one machine running windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server
20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
6.0. Do you have any advice here?
Please help, and thank you.
Db

Does SQL 7 server run well in Win Server 2k3 or do I have to upgra

I currently have one machine running Windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003
,
and I want to migrate the win2k pdc to win server 2k3, that I will promote t
o
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in II
S
6.0. Do you have any advice here?
Please help, and thank you.
DbDb
SQL Server 7 is not supported on Windows 2003. So while it might work its
not a good idea to try it. If you do gey any issues you will have trouble
getting help. If you want to use the server you should upgrade to SQL Server
2000.
Regards
John
"kwizyu" wrote:

> I currently have one machine running Windows 2000 server that I promoted t
o a
> PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 200
03,
> and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
> a high-end domain controller. I wonder if someone with expertise in this
> matter could tell me the steps I should follow to accomplish this with the
> least headache. Also, does SQL 7 still run well on win2k3 server or am I
> required to upgrade SQL? Prior experience showed me that sometimes web sit
es
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
>|||kwizyu wrote:
> I currently have one machine running Windows 2000 server that I
> promoted to a PDC. It also runs SQL 7 server and IIS 5.0. I acquired
> windows server 20003, and I want to migrate the win2k pdc to win
> server 2k3, that I will promote to a high-end domain controller. I
> wonder if someone with expertise in this matter could tell me the
> steps I should follow to accomplish this with the least headache.
> Also, does SQL 7 still run well on win2k3 server or am I required to
> upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking"
> them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
SQL 7 is not certified to run on Windows Server 2003. Personally, I use
SQL 7 on a Virtual PC running Windows Server 2003. But this is just for
development when a real SQL 7 server is unavailable.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Ugh, not to mention that you don't want to be running SQL Server of any
version or edition on a Domain Controller. You like cheap thrills, huh?
I know; I know. It's not your fault; however, the whole point of
distributed computing is to segment and isolate functionality on seperate
and distributed platforms. If you're going to lump everyting into a single
installation, you might as well be running on a mainframe or mini-computer.
Can anyone say stone age?
Sincerely,
Anthony Thomas
"kwizyu" <kwizyu@.discussions.microsoft.com> wrote in message
news:9191D846-1696-4CE2-A2EF-5BC2FCE3161E@.microsoft.com...
I currently have one machine running Windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server
20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
6.0. Do you have any advice here?
Please help, and thank you.
Dbsql

Does SQL 7 server run well in Win Server 2k3 or do I have to upgra

I currently have one machine running windows 2000 server that I promoted to a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
6.0. Do you have any advice here?
Please help, and thank you.
DbDb
SQL Server 7 is not supported on Windows 2003. So while it might work its
not a good idea to try it. If you do gey any issues you will have trouble
getting help. If you want to use the server you should upgrade to SQL Server
2000.
Regards
John
"kwizyu" wrote:
> I currently have one machine running windows 2000 server that I promoted to a
> PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
> and I want to migrate the win2k pdc to win server 2k3, that I will promote to
> a high-end domain controller. I wonder if someone with expertise in this
> matter could tell me the steps I should follow to accomplish this with the
> least headache. Also, does SQL 7 still run well on win2k3 server or am I
> required to upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
>|||kwizyu wrote:
> I currently have one machine running windows 2000 server that I
> promoted to a PDC. It also runs SQL 7 server and IIS 5.0. I acquired
> windows server 20003, and I want to migrate the win2k pdc to win
> server 2k3, that I will promote to a high-end domain controller. I
> wonder if someone with expertise in this matter could tell me the
> steps I should follow to accomplish this with the least headache.
> Also, does SQL 7 still run well on win2k3 server or am I required to
> upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking"
> them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
SQL 7 is not certified to run on Windows Server 2003. Personally, I use
SQL 7 on a Virtual PC running Windows Server 2003. But this is just for
development when a real SQL 7 server is unavailable.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Ugh, not to mention that you don't want to be running SQL Server of any
version or edition on a Domain Controller. You like cheap thrills, huh?
I know; I know. It's not your fault; however, the whole point of
distributed computing is to segment and isolate functionality on seperate
and distributed platforms. If you're going to lump everyting into a single
installation, you might as well be running on a mainframe or mini-computer.
Can anyone say stone age?
Sincerely,
Anthony Thomas
"kwizyu" <kwizyu@.discussions.microsoft.com> wrote in message
news:9191D846-1696-4CE2-A2EF-5BC2FCE3161E@.microsoft.com...
I currently have one machine running windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server
20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
6.0. Do you have any advice here?
Please help, and thank you.
Db

Does SQL 2005 runs on other platforms them MS windows ?

I could not find in the documentation but someone told me that there is a way.

YOu will be able to connect to the SQL Server from any platform where you can find an appropiate driver, but the shipped client tools from MS and the service will only run on WIndows platforms.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Does SQL 2005 runs on other platforms them MS windows ?

I could not find in the documentation but someone told me that there is a way.

YOu will be able to connect to the SQL Server from any platform where you can find an appropiate driver, but the shipped client tools from MS and the service will only run on WIndows platforms.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Does SP1 change the way strings or data are processed?

We've just patched our Dev server, and, of our 3 servers (Dev, Test, Prod), we see major changes in the output of a raw data import process that runs nightly. Each night we import tables from a Remedy helpdesk system running on Oracle and place each ticket into a row on a table, tracking the changes and history of the ticket, etc. This includes tracking when supervisor groups are changed during the course of a ticket (ie Helpdesk to Data Comms to Billing etc). Now, after SP1, the results on Dev are skewed with partial strings showing in the From and To fields, broken in odd places (like the middle of words).

Has anyone noticed any changes in which post-SP1 SQL Server 2005 processes strings? Does it automatically trim spaces or convert NULLs etc?

The data import should be identical between Dev and the other servers.

Hi,

compare the ANSI NULL settings of your two instances. Right click on the instance > Properties > Connections > Default Connection Options.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Jens K. Suessmeyer wrote:

Hi,

compare the ANSI NULL settings of your two instances. Right click on the instance > Properties > Connections > Default Connection Options.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

No, the options appear to be the same.

More on the particular symptom:

We get the audit trail string from the import and break it down on the pattern ' to ' (note the spaces) only now, under SP1, it seems to be trimming the space after 'to' so it is really trying to split on ' to', but the procedure isn't searching for ' to' and thus it is being broken as described originally.|||More information...

There seems to be a change in the way data types are handled/defined. Can anyone confirm?

Un-Patched
-
declare @.stringmax varchar(max)
declare @.string varchar(10)
set @.stringmax = 'Boo '
set @.string = 'Boo '

select len(@.string) as [string_len]
select len(@.stringmax) as [stringmax_len]
select datalength(@.string) as [string_datalength]
select datalength(@.stringmax) as [stringmax_datalength]

Returns:

string_len
3

stringmax_len
4

string_datalength
4

stringmax_datalength
4

Patched returns:
--

string_len
3

stringmax_len
3

string_datalength
4

stringmax_datalength
4
...

According to the Books Online, LEN was always supposed to ignore trailing spaces, but it looks like it wasn't ignoring them in VARCHAR(MAX) under the first release.

I couldn't find this 'fix' on any of the associated change documents for SP1. Does anyone know if there are any similar 'gotchas'?

Document Map doesnt display in IE7

Can anyone help,

I have created a report which works great when the users run from IE6, but when anyone runs report from IE7, the report displays ok, but the document appears to build but displays absolutely nothing.

Has anyone seen this problem with IE7 using Reporting Services 2000?

Thanks people

See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=971203&SiteID=1.

Document Last Page Printout

I am using Crystal Reports 8.5. I could not setup a print out of a word or phrase in the last page of a document, when the document runs into more than 1 page, under Page Footer. If the document is only 1 page, then the word will print on the first page.

What I am trying to do is to design the report format to print an invoice, and if the invoice runs into more than 1 page, to print the word or phrase only on the last page. I have done all the groups, etc. and the report runs ok.

It will be appreciated if anyone can advise and help. Thank you.just try to put that word or phrase in the Report footer section.

Do While Skip in Selecting...

Hello:

I have one table and it contains a column named ID Number, and a column named Date. I have a Do While statement that runs a SQL select statement a few times based on the number of records with the same ID Number. During the Do While statement the information is copied into another table and deleted from the old table. After I look at the results, I see that at the second Do While loop, the data was not selected and the Select statement did not run... so the old variable value from varValue is used again... Any reasons on why?

Here is a code snippet of what is going on:

 Do While varCount < varRecordCount
 conSqlConnect.Open()
 cmdSelect = New SqlCommand ("Select * From temp_records_1 where [id number]=@.idnumber and date<@.date", conSqlConnect)
 cmdSelect.Parameters.Add( "@.accountnumber", "10000" )
 cmdSelect.Parameters.Add( "@.date", dtnow )
 dtrdatareader = cmdSelect.ExecuteReader()
 While dtrdatareader.Read()
 If IsDbNull(dtrdatareader("value")) = false Then
 varValue = dtrdatareader("value")
 End If
 End While
 dtrdatareader.Close()
 conSqlConnect.Close()
'#####The information above is copied to another table here
'#####The record where the information was received is deleted.
 varCount = varCount + 1
 Loop

Any ideas?After playing around with this for a while, I found that the select statement is incorrect. The part where it says date<@.date... this selects more than one row, instead of just selecting one row.

I read articles that discuss using select MAX(column) but that will only return one column... how can I select a row based on a column with the maximum value?|||ok... great got it working now... just post the answer here for future reference... I went ahead and did Select Top 1 * instead of Select *... it solved everything...