A couple of things with my new report

I have made a report in SRS and am not sure of how to do some of the functions I need.

In SQL I can use UPPER to convert to upper case, SRS doesn't seem to like this. When I add UPPER to the SQL in my SRS report, the report runs but the line that is to be upper case is missing. If I remove the UPPER word from my query it works fine just displaying in lower case. Am I doing something wrong?

In Excel 2007 (I am converting my report from Excel to SRS) there is a function called NETWORKDAYS (Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term.) Is there something similar I can use in SRS?

Thanks.

Why not put all of your TSQL into a stored procedure? I have just completed a project where this was done.

>Use NETWORKDAYS to calculate employee benefits that accrue based on thenumber of days worked during a specific term.) Is there somethingsimilar I can use in SRS?
It is possible to write such a function - I wrote one recently - will try and find a reference to it.

|||Table definition and stored procedure to add workdays is

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Holiday]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Holiday]
GO
if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Holiday]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [dbo].[Holiday] (
[Id] [int] IDENTITY (1, 1) NOT NULL ,
[YYYYMMDD] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
END
GO
ALTER TABLE [dbo].[Holiday] WITH NOCHECK ADD
CONSTRAINT [PK_Holiday] PRIMARY KEY CLUSTERED
(
[Id]
) ON [PRIMARY]
GO
CREATE UNIQUE INDEX [IX_Holiday] ON [dbo].[Holiday]([YYYYMMDD]) ON [PRIMARY]
GO
execsp_addextendedproperty N'MS_Description', N'Date in yyyyMMdd notation',N'user', N'dbo', N'table', N'Holiday', N'column', N'YYYYMMDD'
GO
CREATE FUNCTION dbo.fnAddWorkdays(@.FROM DATETIME, @.DAYS INT)
-- Purpose:
-- Calculate Date @.DAYS in future from @.FROM
-- Copyright (C) 2007 Clive Chinery
--
-- This library is free software; you can redistribute it and/or
-- modify it under the terms of the GNU Lesser General Public
-- License as published by the Free Software Foundation; either
-- version 2.1 of the License, or (at your option) any later version.
--
-- This library is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
-- Lesser General Public License for more details.
--
-- You should have received a copy of the GNU Lesser General Public
-- License along with this library; if not, write to the Free Software
-- Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
RETURNS DATETIME AS
BEGIN
DECLARE @.YYYYMMDD CHAR(8)
WHILE @.DAYS > 0
BEGIN
SET @.FROM = DATEADD(day, 1, @.FROM)
SET @.YYYYMMDD = SUBSTRING(REPLACE(CONVERT(CHAR(20), @.FROM, 126), '-', ''), 1, 8)
IF DATEPART(weekday,@.FROM) NOT IN (1, 7) BEGIN
IF NOT EXISTS(SELECT * FROM Holiday WHERE YYYYMMDD = @.YYYYMMDD) SET @.DAYS = @.DAYS - 1
END
END
RETURN @.FROM
END
GO
SELECT dbo.fnAddWorkdays(GETDATE(), 1)
SELECT dbo.fnAddWorkdays(GETDATE(), 2)
SELECT dbo.fnAddWorkdays(GETDATE(), 3)

-- I will write another function later today.

A couple of things with my new report

I have made a report in SRS and am not sure of how to do some of the functions I need.

In SQL I can use UPPER to convert to upper case, SRS doesn't seem to like this. The report runs but the line that is to be upper case is missing. If I remove the UPPER word from my query it works fine just displaying in lower case. Am I doing something wrong?

In Excel 2007 (I am converting my report from Excel to SRS) there is a function called NETWORKDAYS (Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term.) Is there something similar I can use in SRS?

Thanks.

You should be able to use UPPER in your SQL, certainly works for me....

i.e.

Code Snippet

select
acct.accno,
UPPER(nonpers.name) as 'name',
term.amount,
term.eod_balance,

|||

Hello Joe,

There are 2 ways to fix your upper case requirement:

1. Like Will said, you can do it straight from your SQL query.

2. The equivalent function from within SSRS is UCase. Use it like this: =UCase(Fields!Field1.Value)

As for your other question, I think you'll have to write a custom function to handle that.

Hope this helps.

Jarret

sql

A CLR SVF works on my DB instance but not on the other one

Hello,

I have scalar valued function that simply convert a date from UTC to LET by using the .NET functions..

The code is very simple:

PartialPublicClass UserFunction

<Microsoft.SqlServer.Server.SqlFunction(isDeterministic:=True, Name:="ConvertLETDatetoUTC")> _

PublicSharedFunction ConvertLETDatetoUTC(ByVal DateLETFormat As SqlDateTime) As DateTime

' Add your code here

Dim DateLETFormatToConvert AsDate

DateLETFormatToConvert = DateLETFormat.Value

Return DateLETFormatToConvert.ToUniversalTime

EndFunction
End Class

select ConvertLETDatetoUTC('2007-06-25 10:00:00')

Now the problem is that the function works properly on my sql server instanc but in the moment I deploy the same code on the sql server instance on a remote machine the conversion doesn't work that means that date I pass is not converted.

On the SQl server machine there the .net framework 1.1 and 2.0 ...

I really don't know what to check to solve the problem .. some idea?

Thank you

Can you debug the procedure ? I would use something like the Pipe.Send command to send some debbuging information if you are not able to debug the procedure right on the server. Its hard to tell where the problem is based on, so debugging using SQLPipe should be a good alternative for you.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||As Jens says, you probably should debuf the function - however I don't believe you can use SqlPipe in the function as it is a UDF. But, are you getting any errors, or is it just the wrong data coming back? If it is wrong data, what collation and default regional settings does the remote server have?

Niels
|||

Hi,

thank you for the reply...

I was able from my development environment to debug and the statement:

DateLETFormatToConvert.ToUniversalTime

doesn't change a comma to my date!!

It is really weird but I don't know which settings (windows or sql server) I should check..

Thankx

Marina

|||Check the Windows settings.

Niels
|||

Hello,

I checked the window settings and I found out that the PC where the SQL server instance that gives me problem, use as Date Time zone: (GMT) Casablanca,Monrovia

while my Date time zome is Amsterdam, Rome...

The DBA told met that all the server in test and production has this setting and it cannot be changed.

Could be this the reason of the difference?

If yes hor an I make my .net code run as it should?

Thank you

Marina B.

|||No, I don't think that's the issue. Do you know what the regional setting for dates etc is, not the actual timezone?

Niels
|||

On both server the Regional and Language Options use the English(United Kingdom) formats and the

sQL collation is:

SQL_Latin1_General_CP1_CI_AS

something to do maybe with the .Net framework installed?

ThankX

Marina B.

A CLR SVF works on my DB instance but not on the other one

Hello,

I have scalar valued function that simply convert a date from UTC to LET by using the .NET functions..

The code is very simple:

Partial Public Class UserFunction

<Microsoft.SqlServer.Server.SqlFunction(isDeterministic:=True, Name:="ConvertLETDatetoUTC")> _

Public Shared Function ConvertLETDatetoUTC(ByVal DateLETFormat As SqlDateTime) As DateTime

' Add your code here

Dim DateLETFormatToConvert As Date

DateLETFormatToConvert = DateLETFormat.Value

Return DateLETFormatToConvert.ToUniversalTime

End Function
End Class

select ConvertLETDatetoUTC('2007-06-25 10:00:00')

Now the problem is that the function works properly on my sql server instanc but in the moment I deploy the same code on the sql server instance on a remote machine the conversion doesn't work that means that date I pass is not converted.

On the SQl server machine there the .net framework 1.1 and 2.0 ...

I really don't know what to check to solve the problem .. some idea?

Thank you

Can you debug the procedure ? I would use something like the Pipe.Send command to send some debbuging information if you are not able to debug the procedure right on the server. Its hard to tell where the problem is based on, so debugging using SQLPipe should be a good alternative for you.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||As Jens says, you probably should debuf the function - however I don't believe you can use SqlPipe in the function as it is a UDF. But, are you getting any errors, or is it just the wrong data coming back? If it is wrong data, what collation and default regional settings does the remote server have?

Niels
|||

Hi,

thank you for the reply...

I was able from my development environment to debug and the statement:

DateLETFormatToConvert.ToUniversalTime

doesn't change a comma to my date!!

It is really weird but I don't know which settings (windows or sql server) I should check..

Thankx

Marina

|||Check the Windows settings.

Niels
|||

Hello,

I checked the window settings and I found out that the PC where the SQL server instance that gives me problem, use as Date Time zone: (GMT) Casablanca,Monrovia

while my Date time zome is Amsterdam, Rome...

The DBA told met that all the server in test and production has this setting and it cannot be changed.

Could be this the reason of the difference?

If yes hor an I make my .net code run as it should?

Thank you

Marina B.

|||No, I don't think that's the issue. Do you know what the regional setting for dates etc is, not the actual timezone?

Niels
|||

On both server the Regional and Language Options use the English(United Kingdom) formats and the

sQL collation is:

SQL_Latin1_General_CP1_CI_AS

something to do maybe with the .Net framework installed?

ThankX

Marina B.

A binary field problem

why does mssql encrypt or convert the values (entered through sql query into a binary field) into hexadecimal values. When I query and print them from php, it displays some unicode characters. How do I solve this?Hi
shaktishakya
Welcome to TSDN.

You have reached the right place for knowledge shairing.

Here you will find a vast resource of related topics and code.

Feel free to post more doubts/questions in the forum.

But before that give a try from your side and if possible try to post what/how you have approached to solve the problem.

It will help Experts in the forum in solving/underestanding your problem in a better way.

Please follow the posting guidelines in every new post/reply.

90 day trial

I want to convert my 90 day trial of SQL 2005 to the 2005 standard version,
is there an easy way to do this without having to resetup my databases which
a 3rd party setup for us
thanksHi,
From what I know, the trial versions of SQL Server cannot be changed to
Licensed intallations.
0. Turn off your applications that access the trial server.
1. Backup all your databases.
2. Detatch all the user databases (See your Books Online documentation to
see what the system databases are).
3. Uninstall the trial server.
4. Install licensed SQL and follow the instructions for disaster recovery
for the master database. This will recover your logins (with passwords and
SIDs) and linked servers, etc.
5. Attach the user databases you detached in step 2.
That is the basic outline. Use your Books Online documentation to fill in
the details.
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"Leonard" <Leonard@.discussions.microsoft.com> wrote in message
news:A69038E1-62CB-420F-B7DA-293ABCB6B2A5@.microsoft.com...
>I want to convert my 90 day trial of SQL 2005 to the 2005 standard version,
> is there an easy way to do this without having to resetup my databases
> which
> a 3rd party setup for us
> thanks
>|||Hi Leonard,
Check out the following link.
http://technet.microsoft.com/en-us/library/ms143393.aspx
--
Ekrem Ã?nsoy
"Leonard" <Leonard@.discussions.microsoft.com> wrote in message
news:A69038E1-62CB-420F-B7DA-293ABCB6B2A5@.microsoft.com...
>I want to convert my 90 day trial of SQL 2005 to the 2005 standard version,
> is there an easy way to do this without having to resetup my databases
> which
> a 3rd party setup for us
> thanks
>|||HEY
So reading the document in the link it looks like it will upgrade to SQL
2005 std ok, have I read it right?
"Ekrem Ã?nsoy" wrote:
> Hi Leonard,
> Check out the following link.
> http://technet.microsoft.com/en-us/library/ms143393.aspx
> --
> Ekrem Ã?nsoy
>
>
> "Leonard" <Leonard@.discussions.microsoft.com> wrote in message
> news:A69038E1-62CB-420F-B7DA-293ABCB6B2A5@.microsoft.com...
> >I want to convert my 90 day trial of SQL 2005 to the 2005 standard version,
> > is there an easy way to do this without having to resetup my databases
> > which
> > a 3rd party setup for us
> >
> > thanks
> >
>|||Yep, you can go for it.
--
Ekrem Ã?nsoy
"Leonard" <Leonard@.discussions.microsoft.com> wrote in message
news:D0E6A03A-E719-4424-986A-8AE0043ECDCA@.microsoft.com...
> HEY
> So reading the document in the link it looks like it will upgrade to SQL
> 2005 std ok, have I read it right?
>
>
> "Ekrem Ã?nsoy" wrote:
>> Hi Leonard,
>> Check out the following link.
>> http://technet.microsoft.com/en-us/library/ms143393.aspx
>> --
>> Ekrem Ã?nsoy
>>
>>
>> "Leonard" <Leonard@.discussions.microsoft.com> wrote in message
>> news:A69038E1-62CB-420F-B7DA-293ABCB6B2A5@.microsoft.com...
>> >I want to convert my 90 day trial of SQL 2005 to the 2005 standard
>> >version,
>> > is there an easy way to do this without having to resetup my databases
>> > which
>> > a 3rd party setup for us
>> >
>> > thanks
>> >

8114 Workaround

The very simplified version of my problem is that these

Select DISTINCT Cast(KWID as NUMERIC)
FROM OV_MID

Select DISTINCT Convert(Numeric,KWID)
FROM OV_MID

should work, but don't because KWID is a varchar and somewhere in there is something that won't convert.

I get this error:
Server: Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to numeric.

I would love to find out which rows are causing the error, but more importantly I would like to have a Null value where the conversion doesn't work and the numeric values where it does work.

I have already deleted all obvious non-numeric characters, but I believe there are some line terminators being read as carriage returns in this table. :confused:

Any workaround or way to determine which rows have KWID that cannot be converted to numeric would be most appreciated.

Thanks!Just in case anyone actully reads this and has the same question. I solved it with:

SELECT
Case
When ISNUMERIC(KWID) = 1
THEN Cast(KWID as NUMERIC)
ELSE Cast(null as NUMERIC)
END
FROM OV_MID

maybe that will help someone else out who is going as crazy as I was. :o

6.5 Servercrash

Hello,
we have a NT4-Server with SQL 6.5 SP5 running.
The xx.DAT Database is already here.
Who can I read the Data in the DAT-File?
Who can I convert the DAT-File to a SQL2000
Here is the origin text in german:
Unser SQL 6.5 Server ist gecrasht.
Die SQL 6.5 Datenbank xxx.DAT habe ich noch.
Wie kann ich diese auf einem anderen 6.5 System wieder aktivieren.
Am besten jedoch wäre eine Möglichkeit, dieses DAT-File gleich auf einem
SQL2000 Server einzubinden.
Wer kann mir helfen?
Alexander
fter a Harddisk-Crash> Who can I read the Data in the DAT-File?
SQL Server 6.5.
> Who can I convert the DAT-File to a SQL2000
You need to have a 6.5 server running and then you can upgrade using the SQL Server 2000 upgrade
wizard, script and DTS or some other method.
So, you need to have a working 6.5 installation to get to the data. You can then read about the
commands DISK REINIT and DISK REFIT. Hopefully they will work for you.
Unless, the files are actually backup files from the 6.5 server (performed with the DUMP command).
If so, read about the LOAD command.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
news:e180po$5s9$02$1@.news.t-online.com...
> Hello,
> we have a NT4-Server with SQL 6.5 SP5 running.
> The xx.DAT Database is already here.
> Who can I read the Data in the DAT-File?
> Who can I convert the DAT-File to a SQL2000
> Here is the origin text in german:
> Unser SQL 6.5 Server ist gecrasht.
> Die SQL 6.5 Datenbank xxx.DAT habe ich noch.
> Wie kann ich diese auf einem anderen 6.5 System wieder aktivieren.
> Am besten jedoch wäre eine Möglichkeit, dieses DAT-File gleich auf einem
> SQL2000 Server einzubinden.
> Wer kann mir helfen?
>
> Alexander
> fter a Harddisk-Crash
>|||Hi Tibor,
thank you for your answer.
with the command DISK REINIT , i had receive an error. The File have maybe a
mistake.
Is there any other way got get the data out of the DAT-File?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
im Newsbeitrag news:OnOzi5vWGHA.1220@.TK2MSFTNGP02.phx.gbl...
>> Who can I read the Data in the DAT-File?
> SQL Server 6.5.
>
>> Who can I convert the DAT-File to a SQL2000
> You need to have a 6.5 server running and then you can upgrade using the
> SQL Server 2000 upgrade wizard, script and DTS or some other method.
> So, you need to have a working 6.5 installation to get to the data. You
> can then read about the commands DISK REINIT and DISK REFIT. Hopefully
> they will work for you.
> Unless, the files are actually backup files from the 6.5 server (performed
> with the DUMP command). If so, read about the LOAD command.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
> news:e180po$5s9$02$1@.news.t-online.com...
>> Hello,
>> we have a NT4-Server with SQL 6.5 SP5 running.
>> The xx.DAT Database is already here.
>> Who can I read the Data in the DAT-File?
>> Who can I convert the DAT-File to a SQL2000
>> Here is the origin text in german:
>> Unser SQL 6.5 Server ist gecrasht.
>> Die SQL 6.5 Datenbank xxx.DAT habe ich noch.
>> Wie kann ich diese auf einem anderen 6.5 System wieder aktivieren.
>> Am besten jedoch wäre eine Möglichkeit, dieses DAT-File gleich auf einem
>> SQL2000 Server einzubinden.
>> Wer kann mir helfen?
>>
>> Alexander
>> fter a Harddisk-Crash
>|||Hi
It is not clear if you have SQL Server 6.5 running or not! There are quite a
few differences between SQL Server 6.5 and SQL 2000, therefore there is not
the same automatic conversion options that you would have with SQL 7.0. If
SQL Server 6.5 is running, you can use DTS to transfer the information,
although I would take the script and bcp route.
John
"Alexander Koch" wrote:
> Hi Tibor,
> thank you for your answer.
> with the command DISK REINIT , i had receive an error. The File have maybe a
> mistake.
> Is there any other way got get the data out of the DAT-File?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
> im Newsbeitrag news:OnOzi5vWGHA.1220@.TK2MSFTNGP02.phx.gbl...
> >> Who can I read the Data in the DAT-File?
> >
> > SQL Server 6.5.
> >
> >
> >> Who can I convert the DAT-File to a SQL2000
> >
> > You need to have a 6.5 server running and then you can upgrade using the
> > SQL Server 2000 upgrade wizard, script and DTS or some other method.
> >
> > So, you need to have a working 6.5 installation to get to the data. You
> > can then read about the commands DISK REINIT and DISK REFIT. Hopefully
> > they will work for you.
> >
> > Unless, the files are actually backup files from the 6.5 server (performed
> > with the DUMP command). If so, read about the LOAD command.
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> > Blog: http://solidqualitylearning.com/blogs/tibor/
> >
> >
> > "Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
> > news:e180po$5s9$02$1@.news.t-online.com...
> >> Hello,
> >> we have a NT4-Server with SQL 6.5 SP5 running.
> >> The xx.DAT Database is already here.
> >>
> >> Who can I read the Data in the DAT-File?
> >> Who can I convert the DAT-File to a SQL2000
> >>
> >> Here is the origin text in german:
> >> Unser SQL 6.5 Server ist gecrasht.
> >> Die SQL 6.5 Datenbank xxx.DAT habe ich noch.
> >> Wie kann ich diese auf einem anderen 6.5 System wieder aktivieren.
> >> Am besten jedoch wäre eine Möglichkeit, dieses DAT-File gleich auf einem
> >> SQL2000 Server einzubinden.
> >>
> >> Wer kann mir helfen?
> >>
> >>
> >> Alexander
> >> fter a Harddisk-Crash
> >>
> >
>
>|||How did you execute DISK INIT? On what version of SQL Server? What error message? This process is
not trivial, so you might want to hire a consultant who knows his/her way around 6.5 to do this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
news:e189kl$q8n$03$1@.news.t-online.com...
> Hi Tibor,
> thank you for your answer.
> with the command DISK REINIT , i had receive an error. The File have maybe a mistake.
> Is there any other way got get the data out of the DAT-File?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb im Newsbeitrag
> news:OnOzi5vWGHA.1220@.TK2MSFTNGP02.phx.gbl...
>> Who can I read the Data in the DAT-File?
>> SQL Server 6.5.
>>
>> Who can I convert the DAT-File to a SQL2000
>> You need to have a 6.5 server running and then you can upgrade using the SQL Server 2000 upgrade
>> wizard, script and DTS or some other method.
>> So, you need to have a working 6.5 installation to get to the data. You can then read about the
>> commands DISK REINIT and DISK REFIT. Hopefully they will work for you.
>> Unless, the files are actually backup files from the 6.5 server (performed with the DUMP
>> command). If so, read about the LOAD command.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
>> news:e180po$5s9$02$1@.news.t-online.com...
>> Hello,
>> we have a NT4-Server with SQL 6.5 SP5 running.
>> The xx.DAT Database is already here.
>> Who can I read the Data in the DAT-File?
>> Who can I convert the DAT-File to a SQL2000
>> Here is the origin text in german:
>> Unser SQL 6.5 Server ist gecrasht.
>> Die SQL 6.5 Datenbank xxx.DAT habe ich noch.
>> Wie kann ich diese auf einem anderen 6.5 System wieder aktivieren.
>> Am besten jedoch wäre eine Möglichkeit, dieses DAT-File gleich auf einem
>> SQL2000 Server einzubinden.
>> Wer kann mir helfen?
>>
>> Alexander
>> fter a Harddisk-Crash
>>
>|||Hi Tibor,
my SQL 6.5 Server is still running.
I executed the command DISK REINIT successfully. But The answer from the
server was, that the Database had maybe an error.
Did you know a tool, that read a DAT-File outside of the SQL-Server?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
im Newsbeitrag news:ubYawi9WGHA.1480@.TK2MSFTNGP03.phx.gbl...
> How did you execute DISK INIT? On what version of SQL Server? What error
> message? This process is not trivial, so you might want to hire a
> consultant who knows his/her way around 6.5 to do this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
> news:e189kl$q8n$03$1@.news.t-online.com...
>> Hi Tibor,
>> thank you for your answer.
>> with the command DISK REINIT , i had receive an error. The File have
>> maybe a mistake.
>> Is there any other way got get the data out of the DAT-File?
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
>> schrieb im Newsbeitrag news:OnOzi5vWGHA.1220@.TK2MSFTNGP02.phx.gbl...
>> Who can I read the Data in the DAT-File?
>> SQL Server 6.5.
>>
>> Who can I convert the DAT-File to a SQL2000
>> You need to have a 6.5 server running and then you can upgrade using the
>> SQL Server 2000 upgrade wizard, script and DTS or some other method.
>> So, you need to have a working 6.5 installation to get to the data. You
>> can then read about the commands DISK REINIT and DISK REFIT. Hopefully
>> they will work for you.
>> Unless, the files are actually backup files from the 6.5 server
>> (performed with the DUMP command). If so, read about the LOAD command.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
>> news:e180po$5s9$02$1@.news.t-online.com...
>> Hello,
>> we have a NT4-Server with SQL 6.5 SP5 running.
>> The xx.DAT Database is already here.
>> Who can I read the Data in the DAT-File?
>> Who can I convert the DAT-File to a SQL2000
>> Here is the origin text in german:
>> Unser SQL 6.5 Server ist gecrasht.
>> Die SQL 6.5 Datenbank xxx.DAT habe ich noch.
>> Wie kann ich diese auf einem anderen 6.5 System wieder aktivieren.
>> Am besten jedoch wäre eine Möglichkeit, dieses DAT-File gleich auf
>> einem
>> SQL2000 Server einzubinden.
>> Wer kann mir helfen?
>>
>> Alexander
>> fter a Harddisk-Crash
>>
>>
>|||> Did you know a tool, that read a DAT-File outside of the SQL-Server?
I haven't seen such tool.
Again, this process is not trivial, so you might want to hire a consultant who knows his/her way
around 6.5 to do this. Or open a case with MS support. I assume that you have read about the command
in Books Online, of course.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
news:e1d2r3$50o$02$1@.news.t-online.com...
> Hi Tibor,
> my SQL 6.5 Server is still running.
> I executed the command DISK REINIT successfully. But The answer from the server was, that the
> Database had maybe an error.
> Did you know a tool, that read a DAT-File outside of the SQL-Server?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb im Newsbeitrag
> news:ubYawi9WGHA.1480@.TK2MSFTNGP03.phx.gbl...
>> How did you execute DISK INIT? On what version of SQL Server? What error message? This process is
>> not trivial, so you might want to hire a consultant who knows his/her way around 6.5 to do this.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
>> news:e189kl$q8n$03$1@.news.t-online.com...
>> Hi Tibor,
>> thank you for your answer.
>> with the command DISK REINIT , i had receive an error. The File have maybe a mistake.
>> Is there any other way got get the data out of the DAT-File?
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb im Newsbeitrag
>> news:OnOzi5vWGHA.1220@.TK2MSFTNGP02.phx.gbl...
>> Who can I read the Data in the DAT-File?
>> SQL Server 6.5.
>>
>> Who can I convert the DAT-File to a SQL2000
>> You need to have a 6.5 server running and then you can upgrade using the SQL Server 2000
>> upgrade wizard, script and DTS or some other method.
>> So, you need to have a working 6.5 installation to get to the data. You can then read about the
>> commands DISK REINIT and DISK REFIT. Hopefully they will work for you.
>> Unless, the files are actually backup files from the 6.5 server (performed with the DUMP
>> command). If so, read about the LOAD command.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
>> news:e180po$5s9$02$1@.news.t-online.com...
>> Hello,
>> we have a NT4-Server with SQL 6.5 SP5 running.
>> The xx.DAT Database is already here.
>> Who can I read the Data in the DAT-File?
>> Who can I convert the DAT-File to a SQL2000
>> Here is the origin text in german:
>> Unser SQL 6.5 Server ist gecrasht.
>> Die SQL 6.5 Datenbank xxx.DAT habe ich noch.
>> Wie kann ich diese auf einem anderen 6.5 System wieder aktivieren.
>> Am besten jedoch wäre eine Möglichkeit, dieses DAT-File gleich auf einem
>> SQL2000 Server einzubinden.
>> Wer kann mir helfen?
>>
>> Alexander
>> fter a Harddisk-Crash
>>
>>
>

6.5 Servercrash

Hello,
we have a NT4-Server with SQL 6.5 SP5 running.
The xx.DAT Database is already here.
Who can I read the Data in the DAT-File?
Who can I convert the DAT-File to a SQL2000
Here is the origin text in german:
Unser SQL 6.5 Server ist gecrasht.
Die SQL 6.5 Datenbank xxx.DAT habe ich noch.
Wie kann ich diese auf einem anderen 6.5 System wieder aktivieren.
Am besten jedoch wre eine Mglichkeit, dieses DAT-File gleich auf einem
SQL2000 Server einzubinden.
Wer kann mir helfen?
Alexander
fter a Harddisk-Crash> Who can I read the Data in the DAT-File?
SQL Server 6.5.

> Who can I convert the DAT-File to a SQL2000
You need to have a 6.5 server running and then you can upgrade using the SQL
Server 2000 upgrade
wizard, script and DTS or some other method.
So, you need to have a working 6.5 installation to get to the data. You can
then read about the
commands DISK REINIT and DISK REFIT. Hopefully they will work for you.
Unless, the files are actually backup files from the 6.5 server (performed w
ith the DUMP command).
If so, read about the LOAD command.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
news:e180po$5s9$02$1@.news.t-online.com...
> Hello,
> we have a NT4-Server with SQL 6.5 SP5 running.
> The xx.DAT Database is already here.
> Who can I read the Data in the DAT-File?
> Who can I convert the DAT-File to a SQL2000
> Here is the origin text in german:
> Unser SQL 6.5 Server ist gecrasht.
> Die SQL 6.5 Datenbank xxx.DAT habe ich noch.
> Wie kann ich diese auf einem anderen 6.5 System wieder aktivieren.
> Am besten jedoch wre eine Mglichkeit, dieses DAT-File gleich auf einem
> SQL2000 Server einzubinden.
> Wer kann mir helfen?
>
> Alexander
> fter a Harddisk-Crash
>|||Hi Tibor,
thank you for your answer.
with the command DISK REINIT , i had receive an error. The File have maybe a
mistake.
Is there any other way got get the data out of the DAT-File?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
im Newsbeitrag news:OnOzi5vWGHA.1220@.TK2MSFTNGP02.phx.gbl...
> SQL Server 6.5.
>
> You need to have a 6.5 server running and then you can upgrade using the
> SQL Server 2000 upgrade wizard, script and DTS or some other method.
> So, you need to have a working 6.5 installation to get to the data. You
> can then read about the commands DISK REINIT and DISK REFIT. Hopefully
> they will work for you.
> Unless, the files are actually backup files from the 6.5 server (performed
> with the DUMP command). If so, read about the LOAD command.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
> news:e180po$5s9$02$1@.news.t-online.com...
>|||Hi
It is not clear if you have SQL Server 6.5 running or not! There are quite a
few differences between SQL Server 6.5 and SQL 2000, therefore there is not
the same automatic conversion options that you would have with SQL 7.0. If
SQL Server 6.5 is running, you can use DTS to transfer the information,
although I would take the script and bcp route.
John
"Alexander Koch" wrote:

> Hi Tibor,
> thank you for your answer.
> with the command DISK REINIT , i had receive an error. The File have maybe
a
> mistake.
> Is there any other way got get the data out of the DAT-File?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
> im Newsbeitrag news:OnOzi5vWGHA.1220@.TK2MSFTNGP02.phx.gbl...
>
>|||How did you execute DISK INIT? On what version of SQL Server? What error mes
sage? This process is
not trivial, so you might want to hire a consultant who knows his/her way ar
ound 6.5 to do this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
news:e189kl$q8n$03$1@.news.t-online.com...
> Hi Tibor,
> thank you for your answer.
> with the command DISK REINIT , i had receive an error. The File have maybe
a mistake.
> Is there any other way got get the data out of the DAT-File?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
im Newsbeitrag
> news:OnOzi5vWGHA.1220@.TK2MSFTNGP02.phx.gbl...
>|||Hi Tibor,
my SQL 6.5 Server is still running.
I executed the command DISK REINIT successfully. But The answer from the
server was, that the Database had maybe an error.
Did you know a tool, that read a DAT-File outside of the SQL-Server?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
im Newsbeitrag news:ubYawi9WGHA.1480@.TK2MSFTNGP03.phx.gbl...
> How did you execute DISK INIT? On what version of SQL Server? What error
> message? This process is not trivial, so you might want to hire a
> consultant who knows his/her way around 6.5 to do this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
> news:e189kl$q8n$03$1@.news.t-online.com...
>|||> Did you know a tool, that read a DAT-File outside of the SQL-Server?
I haven't seen such tool.
Again, this process is not trivial, so you might want to hire a consultant w
ho knows his/her way
around 6.5 to do this. Or open a case with MS support. I assume that you hav
e read about the command
in Books Online, of course.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
news:e1d2r3$50o$02$1@.news.t-online.com...
> Hi Tibor,
> my SQL 6.5 Server is still running.
> I executed the command DISK REINIT successfully. But The answer from the s
erver was, that the
> Database had maybe an error.
> Did you know a tool, that read a DAT-File outside of the SQL-Server?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
im Newsbeitrag
> news:ubYawi9WGHA.1480@.TK2MSFTNGP03.phx.gbl...
>

6.5 server dates not showing dates with ss:fff

When i view a date on sql 6.5 it is showing as '22 Nov 2004 14:50', if
however i convert it to char 109 it gives me the full date ie 'Nov 22 2004
2:50:56:477PM'. Is there a setting on either the pc or sql that is causing
this ?
Thanks in advance.What application are you using to view the date? This is a pure client appli
cation issue, so this is
where you should look for such a setting. More info on datetime:
http://www.karaszi.com/SQLServer/info_datetime.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"billu" <billu@.discussions.microsoft.com> wrote in message
news:AC7E65A4-3F5C-4BF8-92BB-9EC9F8D17AE6@.microsoft.com...
> When i view a date on sql 6.5 it is showing as '22 Nov 2004 14:50', if
> however i convert it to char 109 it gives me the full date ie 'Nov 22 2004
> 2:50:56:477PM'. Is there a setting on either the pc or sql that is causing
> this ?
> Thanks in advance.|||i am using isql to view results. For some reason it only returns back a smal
l
part of the time field, it is only when i convert it that i get the full dat
e.
I have looked at the site but am still none the wiser ?
"Tibor Karaszi" wrote:

> What application are you using to view the date? This is a pure client app
lication issue, so this is
> where you should look for such a setting. More info on datetime:
> http://www.karaszi.com/SQLServer/info_datetime.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "billu" <billu@.discussions.microsoft.com> wrote in message
> news:AC7E65A4-3F5C-4BF8-92BB-9EC9F8D17AE6@.microsoft.com...
>
>|||OK, so the programmers who wrote ISQL decided to display the datetime in tha
t particular way. I
suggest that you use CONVERT to get the desired display format for your date
time values.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"billu" <billu@.discussions.microsoft.com> wrote in message
news:BA62CD8F-2512-427F-B078-ABB245743D4B@.microsoft.com...[vbcol=seagreen]
>i am using isql to view results. For some reason it only returns back a sma
ll
> part of the time field, it is only when i convert it that i get the full d
ate.
> I have looked at the site but am still none the wiser ?
> "Tibor Karaszi" wrote:
>|||Take a look at your workstation's Regional Settings from the Control Panel.
Also, take a look at the ISQL(/w) settings to see if you've got it set up to
default to your workstation's Regional Settings.
Sincerely,
Anthony Thomas
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uy$0Q317EHA.3828@.TK2MSFTNGP09.phx.gbl...
OK, so the programmers who wrote ISQL decided to display the datetime in
that particular way. I
suggest that you use CONVERT to get the desired display format for your
datetime values.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"billu" <billu@.discussions.microsoft.com> wrote in message
news:BA62CD8F-2512-427F-B078-ABB245743D4B@.microsoft.com...
>i am using isql to view results. For some reason it only returns back a
small
> part of the time field, it is only when i convert it that i get the full
date.[vbcol=seagreen]
> I have looked at the site but am still none the wiser ?
> "Tibor Karaszi" wrote:
>
application issue, so this[vbcol=seagreen]
2004[vbcol=seagreen]
causing[vbcol=seagreen]

6.5 server dates not showing dates with ss:fff

When i view a date on sql 6.5 it is showing as '22 Nov 2004 14:50', if
however i convert it to char 109 it gives me the full date ie 'Nov 22 2004
2:50:56:477PM'. Is there a setting on either the pc or sql that is causing
this ?
Thanks in advance.
What application are you using to view the date? This is a pure client application issue, so this is
where you should look for such a setting. More info on datetime:
http://www.karaszi.com/SQLServer/info_datetime.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"billu" <billu@.discussions.microsoft.com> wrote in message
news:AC7E65A4-3F5C-4BF8-92BB-9EC9F8D17AE6@.microsoft.com...
> When i view a date on sql 6.5 it is showing as '22 Nov 2004 14:50', if
> however i convert it to char 109 it gives me the full date ie 'Nov 22 2004
> 2:50:56:477PM'. Is there a setting on either the pc or sql that is causing
> this ?
> Thanks in advance.
|||i am using isql to view results. For some reason it only returns back a small
part of the time field, it is only when i convert it that i get the full date.
I have looked at the site but am still none the wiser ?
"Tibor Karaszi" wrote:

> What application are you using to view the date? This is a pure client application issue, so this is
> where you should look for such a setting. More info on datetime:
> http://www.karaszi.com/SQLServer/info_datetime.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "billu" <billu@.discussions.microsoft.com> wrote in message
> news:AC7E65A4-3F5C-4BF8-92BB-9EC9F8D17AE6@.microsoft.com...
>
>
|||OK, so the programmers who wrote ISQL decided to display the datetime in that particular way. I
suggest that you use CONVERT to get the desired display format for your datetime values.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"billu" <billu@.discussions.microsoft.com> wrote in message
news:BA62CD8F-2512-427F-B078-ABB245743D4B@.microsoft.com...[vbcol=seagreen]
>i am using isql to view results. For some reason it only returns back a small
> part of the time field, it is only when i convert it that i get the full date.
> I have looked at the site but am still none the wiser ?
> "Tibor Karaszi" wrote:
|||Take a look at your workstation's Regional Settings from the Control Panel.
Also, take a look at the ISQL(/w) settings to see if you've got it set up to
default to your workstation's Regional Settings.
Sincerely,
Anthony Thomas

"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uy$0Q317EHA.3828@.TK2MSFTNGP09.phx.gbl...
OK, so the programmers who wrote ISQL decided to display the datetime in
that particular way. I
suggest that you use CONVERT to get the desired display format for your
datetime values.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"billu" <billu@.discussions.microsoft.com> wrote in message
news:BA62CD8F-2512-427F-B078-ABB245743D4B@.microsoft.com...
>i am using isql to view results. For some reason it only returns back a
small
> part of the time field, it is only when i convert it that i get the full
date.[vbcol=seagreen]
> I have looked at the site but am still none the wiser ?
> "Tibor Karaszi" wrote:
application issue, so this[vbcol=seagreen]
2004[vbcol=seagreen]
causing[vbcol=seagreen]

6.5 server dates not showing dates with ss:fff

When i view a date on sql 6.5 it is showing as '22 Nov 2004 14:50', if
however i convert it to char 109 it gives me the full date ie 'Nov 22 2004
2:50:56:477PM'. Is there a setting on either the pc or sql that is causing
this ?
Thanks in advance.What application are you using to view the date? This is a pure client application issue, so this is
where you should look for such a setting. More info on datetime:
http://www.karaszi.com/SQLServer/info_datetime.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"billu" <billu@.discussions.microsoft.com> wrote in message
news:AC7E65A4-3F5C-4BF8-92BB-9EC9F8D17AE6@.microsoft.com...
> When i view a date on sql 6.5 it is showing as '22 Nov 2004 14:50', if
> however i convert it to char 109 it gives me the full date ie 'Nov 22 2004
> 2:50:56:477PM'. Is there a setting on either the pc or sql that is causing
> this ?
> Thanks in advance.|||i am using isql to view results. For some reason it only returns back a small
part of the time field, it is only when i convert it that i get the full date.
I have looked at the site but am still none the wiser ?
"Tibor Karaszi" wrote:
> What application are you using to view the date? This is a pure client application issue, so this is
> where you should look for such a setting. More info on datetime:
> http://www.karaszi.com/SQLServer/info_datetime.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "billu" <billu@.discussions.microsoft.com> wrote in message
> news:AC7E65A4-3F5C-4BF8-92BB-9EC9F8D17AE6@.microsoft.com...
> > When i view a date on sql 6.5 it is showing as '22 Nov 2004 14:50', if
> > however i convert it to char 109 it gives me the full date ie 'Nov 22 2004
> > 2:50:56:477PM'. Is there a setting on either the pc or sql that is causing
> > this ?
> > Thanks in advance.
>
>|||OK, so the programmers who wrote ISQL decided to display the datetime in that particular way. I
suggest that you use CONVERT to get the desired display format for your datetime values.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"billu" <billu@.discussions.microsoft.com> wrote in message
news:BA62CD8F-2512-427F-B078-ABB245743D4B@.microsoft.com...
>i am using isql to view results. For some reason it only returns back a small
> part of the time field, it is only when i convert it that i get the full date.
> I have looked at the site but am still none the wiser ?
> "Tibor Karaszi" wrote:
>> What application are you using to view the date? This is a pure client application issue, so this
>> is
>> where you should look for such a setting. More info on datetime:
>> http://www.karaszi.com/SQLServer/info_datetime.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "billu" <billu@.discussions.microsoft.com> wrote in message
>> news:AC7E65A4-3F5C-4BF8-92BB-9EC9F8D17AE6@.microsoft.com...
>> > When i view a date on sql 6.5 it is showing as '22 Nov 2004 14:50', if
>> > however i convert it to char 109 it gives me the full date ie 'Nov 22 2004
>> > 2:50:56:477PM'. Is there a setting on either the pc or sql that is causing
>> > this ?
>> > Thanks in advance.
>>|||Take a look at your workstation's Regional Settings from the Control Panel.
Also, take a look at the ISQL(/w) settings to see if you've got it set up to
default to your workstation's Regional Settings.
Sincerely,
Anthony Thomas
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uy$0Q317EHA.3828@.TK2MSFTNGP09.phx.gbl...
OK, so the programmers who wrote ISQL decided to display the datetime in
that particular way. I
suggest that you use CONVERT to get the desired display format for your
datetime values.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"billu" <billu@.discussions.microsoft.com> wrote in message
news:BA62CD8F-2512-427F-B078-ABB245743D4B@.microsoft.com...
>i am using isql to view results. For some reason it only returns back a
small
> part of the time field, it is only when i convert it that i get the full
date.
> I have looked at the site but am still none the wiser ?
> "Tibor Karaszi" wrote:
>> What application are you using to view the date? This is a pure client
application issue, so this
>> is
>> where you should look for such a setting. More info on datetime:
>> http://www.karaszi.com/SQLServer/info_datetime.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "billu" <billu@.discussions.microsoft.com> wrote in message
>> news:AC7E65A4-3F5C-4BF8-92BB-9EC9F8D17AE6@.microsoft.com...
>> > When i view a date on sql 6.5 it is showing as '22 Nov 2004 14:50', if
>> > however i convert it to char 109 it gives me the full date ie 'Nov 22
2004
>> > 2:50:56:477PM'. Is there a setting on either the pc or sql that is
causing
>> > this ?
>> > Thanks in advance.
>>