Emailing report details

Hi,
I have a simple report that displays a page of text. I want to add a
button to it and
when the button is clicked a new outlook email is created with the
report as body, ready for the user to enter an email address.
Yes I know reports have subscriptions, they want a more adhoc
solution.
And users don't want the extra clicks of saving the report to file and
attaching it themselves.
Can it be done, is there an example?
thanks in advance.On Aug 1, 11:07 pm, paulhux...@.hotmail.com wrote:
> Hi,
> I have a simple report that displays a page of text. I want to add a
> button to it and
> when the button is clicked a new outlook email is created with the
> report as body, ready for the user to enter an email address.
> Yes I know reports have subscriptions, they want a more adhoc
> solution.
> And users don't want the extra clicks of saving the report to file and
> attaching it themselves.
> Can it be done, is there an example?
> thanks in advance.
There are not really any options available for this type of
functionality (aside from what you mentioned). If exporting the report
to PDF and attaching it to an email is an option, I would suggest
going the custom/ASP.NET application route. There is an open source
library available that can assist you in doing this: iTextSharp
(http://sourceforge.net/projects/itextsharp/http://itextsharp.sourceforge.net/tutorial/
). Otherwise, you will need to design a custom application that
includes a report viewer control that incorporates an SSRS report.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Aug 3, 11:31 am, EMartinez <emartinez...@.gmail.com> wrote:
> On Aug 1, 11:07 pm, paulhux...@.hotmail.com wrote:
> > Hi,
> > I have a simple report that displays a page of text. I want to add a
> > button to it and
> > when the button is clicked a new outlook email is created with the
> > report as body, ready for the user to enter an email address.
> > Yes I know reports have subscriptions, they want a more adhoc
> > solution.
> > And users don't want the extra clicks of saving the report to file and
> > attaching it themselves.
> > Can it be done, is there an example?
> > thanks in advance.
> There are not really any options available for this type of
> functionality (aside from what you mentioned). If exporting the report
> to PDF and attaching it to an email is an option, I would suggest
> going the custom/ASP.NET application route. There is an open source
> library available that can assist you in doing this: iTextSharp
> (http://sourceforge.net/projects/itextsharp/http://itextsharp.sourceforge.net/tutorial/
> ). Otherwise, you will need to design a custom application that
> includes a report viewer control that incorporates an SSRS report.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
****************************
thanks Enrique|||On Aug 2, 9:05 pm, paulhux...@.hotmail.com wrote:
> On Aug 3, 11:31 am, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Aug 1, 11:07 pm, paulhux...@.hotmail.com wrote:
> > > Hi,
> > > I have a simple report that displays a page of text. I want to add a
> > > button to it and
> > > when the button is clicked a new outlook email is created with the
> > > report as body, ready for the user to enter an email address.
> > > Yes I know reports have subscriptions, they want a more adhoc
> > > solution.
> > > And users don't want the extra clicks of saving the report to file and
> > > attaching it themselves.
> > > Can it be done, is there an example?
> > > thanks in advance.
> > There are not really any options available for this type of
> > functionality (aside from what you mentioned). If exporting the report
> > to PDF and attaching it to an email is an option, I would suggest
> > going the custom/ASP.NET application route. There is an open source
> > library available that can assist you in doing this: iTextSharp
> > (http://sourceforge.net/projects/itextsharp/http://itextsharp.sourcefo...
> > ). Otherwise, you will need to design a custom application that
> > includes a report viewer control that incorporates an SSRS report.
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> ****************************
> thanks Enrique
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

EM query strange behavior

In the Enterprise Manager query tool, a query (the date entered in the
criteria field as 31.03.05) displays as an SQL statement:
SELECT *
FROM [TABLE]
WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
and yields the expected results.
However, changing query type to
DELETE FROM [SAME TABLE AS ABOVE]
WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
results in the opposite of what is to be expected - all records where
TRANS_DATE < [the entered time] is deleted.
The TRANS_DATE field is of type DATETIME, and I cannot see that there are
any properties either in the field or the table that separates it from all
my other DATETIME fields in any other tables, where this bizarre delete
action does not occur.
I assume this has to do with some configuration of the automatic
timeconversion that happens in the tool itself, but how to change this
conversion setting so as to produce more desired delete results?
And how is it that it only happens with data from one single table'
Thanks for answering.
Message posted via http://www.droptable.comHi
What happens when you run this:
DELETE FROM [SAME TABLE AS ABOVE]
WHERE (TRANS_DATE > '2005-03-31 00:00:00'
Regards
Mike
"Knut Bohn via droptable.com" wrote:

> In the Enterprise Manager query tool, a query (the date entered in the
> criteria field as 31.03.05) displays as an SQL statement:
> SELECT *
> FROM [TABLE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> and yields the expected results.
> However, changing query type to
> DELETE FROM [SAME TABLE AS ABOVE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> results in the opposite of what is to be expected - all records where
> TRANS_DATE < [the entered time] is deleted.
> The TRANS_DATE field is of type DATETIME, and I cannot see that there are
> any properties either in the field or the table that separates it from all
> my other DATETIME fields in any other tables, where this bizarre delete
> action does not occur.
> I assume this has to do with some configuration of the automatic
> timeconversion that happens in the tool itself, but how to change this
> conversion setting so as to produce more desired delete results?
> And how is it that it only happens with data from one single table'
> Thanks for answering.
> --
> Message posted via http://www.droptable.com
>|||Knut
I dont uderstand you.
> In the Enterprise Manager query tool, a query (the date entered in the
> criteria field as 31.03.05) displays as an SQL statement:
You said that the table's column is defined as datetime datatype and data
was entered as 31.03.05 which is thrown the error
--insert into table1 values ('31.03.05')
"The conversion of a char data type to a datetime data type resulted in an
out-of-range datetime value.
The statement has been terminated."
"Knut Bohn via droptable.com" <forum@.nospam.droptable.com> wrote in
message news:b10f4c5d93df49c6b3c31bee2a957db0@.SQ
droptable.com...
> In the Enterprise Manager query tool, a query (the date entered in the
> criteria field as 31.03.05) displays as an SQL statement:
> SELECT *
> FROM [TABLE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> and yields the expected results.
> However, changing query type to
> DELETE FROM [SAME TABLE AS ABOVE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> results in the opposite of what is to be expected - all records where
> TRANS_DATE < [the entered time] is deleted.
> The TRANS_DATE field is of type DATETIME, and I cannot see that there are
> any properties either in the field or the table that separates it from all
> my other DATETIME fields in any other tables, where this bizarre delete
> action does not occur.
> I assume this has to do with some configuration of the automatic
> timeconversion that happens in the tool itself, but how to change this
> conversion setting so as to produce more desired delete results?
> And how is it that it only happens with data from one single table'
> Thanks for answering.
> --
> Message posted via http://www.droptable.com|||Mike;
Same thing - deletes records with TRANS_DATE < entered value.
What's really bizzarre is that there's another datetime column in the
table, and running a delete with criteria filtered against those date
values yields the expected result.
Again, I really can't spot any differences in the respective data
properties of these two columns.
Uri;
I don't think I follow what you're getting at? The SELECT runs fine with
the date criteria entered as 31.03.05, but somehow things go off
differently with no other change thatn replacing SELECT with DELETE.
Message posted via http://www.droptable.com|||Hi
I did some test
CREATE TABLE #Test
(
col DATETIME
)
INSERT INTO #Test VALUES ('20050331')--Proper format to insert datetime
INSERT INTO #Test VALUES ('20050401')
INSERT INTO #Test VALUES ('20050328')
DELETE FROM #Test WHERE col>'20050331'--Deletes 1 row
SELECT* FROM #Test--Everything is ok
DROP TABLE #Test
--Another repro
CREATE TABLE #Test
(
col VARCHAR(30)
)
INSERT INTO #Test VALUES ('31.03.05')--with datetime this insert will be
failed
INSERT INTO #Test VALUES ('28.03.05')--with datetime this insert will be
failed
INSERT INTO #Test VALUES ('01.04.05')--with datetime this insert will be
failed
DELETE FROM #Test WHERE col>CONVERT(DATETIME,'2005-03-31',102)--Error is
thrown
SELECT CONVERT(DATETIME,REPLACE(col,'.',''),102) FROM #Test
--2031-03-05 00:00:00.000
--2028-03-05 00:00:00.000
--2001-04-05 00:00:00.000
--That's why it deletes wrong data
DELETE FROM #Test WHERE CONVERT(DATETIME,REPLACE(col,'.',''),112)
>CONVERT(DATETIME,'2005-03-31',102)
SELECT* FROM #Test
DROP TABLE #Test
"Knut Bohn via droptable.com" <forum@.droptable.com> wrote in message
news:c446a5e8529b4bc49709d20ca6d2518d@.SQ
droptable.com...
> Mike;
> Same thing - deletes records with TRANS_DATE < entered value.
> What's really bizzarre is that there's another datetime column in the
> table, and running a delete with criteria filtered against those date
> values yields the expected result.
> Again, I really can't spot any differences in the respective data
> properties of these two columns.
> Uri;
> I don't think I follow what you're getting at? The SELECT runs fine with
> the date criteria entered as 31.03.05, but somehow things go off
> differently with no other change thatn replacing SELECT with DELETE.
> --
> Message posted via http://www.droptable.com|||Uri,
Thaanks for taking the time to test this. However, I don't think it
explains the criteria oddity that occurs when in the query changing from
SELECT to DELETE?
best,
knut
Message posted via http://www.droptable.com

EM query strange behavior

In the Enterprise Manager query tool, a query (the date entered in the
criteria field as 31.03.05) displays as an SQL statement:
SELECT *
FROM [TABLE]
WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
and yields the expected results.
However, changing query type to
DELETE FROM [SAME TABLE AS ABOVE]
WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
results in the opposite of what is to be expected - all records where
TRANS_DATE < [the entered time] is deleted.
The TRANS_DATE field is of type DATETIME, and I cannot see that there are
any properties either in the field or the table that separates it from all
my other DATETIME fields in any other tables, where this bizarre delete
action does not occur.
I assume this has to do with some configuration of the automatic
timeconversion that happens in the tool itself, but how to change this
conversion setting so as to produce more desired delete results?
And how is it that it only happens with data from one single table?
Thanks for answering.
Message posted via http://www.droptable.com
Hi
What happens when you run this:
DELETE FROM [SAME TABLE AS ABOVE]
WHERE (TRANS_DATE > '2005-03-31 00:00:00'
Regards
Mike
"Knut Bohn via droptable.com" wrote:

> In the Enterprise Manager query tool, a query (the date entered in the
> criteria field as 31.03.05) displays as an SQL statement:
> SELECT *
> FROM [TABLE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> and yields the expected results.
> However, changing query type to
> DELETE FROM [SAME TABLE AS ABOVE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> results in the opposite of what is to be expected - all records where
> TRANS_DATE < [the entered time] is deleted.
> The TRANS_DATE field is of type DATETIME, and I cannot see that there are
> any properties either in the field or the table that separates it from all
> my other DATETIME fields in any other tables, where this bizarre delete
> action does not occur.
> I assume this has to do with some configuration of the automatic
> timeconversion that happens in the tool itself, but how to change this
> conversion setting so as to produce more desired delete results?
> And how is it that it only happens with data from one single table?
> Thanks for answering.
> --
> Message posted via http://www.droptable.com
>
|||Knut
I dont uderstand you.
> In the Enterprise Manager query tool, a query (the date entered in the
> criteria field as 31.03.05) displays as an SQL statement:
You said that the table's column is defined as datetime datatype and data
was entered as 31.03.05 which is thrown the error
--insert into table1 values ('31.03.05')
"The conversion of a char data type to a datetime data type resulted in an
out-of-range datetime value.
The statement has been terminated."
"Knut Bohn via droptable.com" <forum@.nospam.droptable.com> wrote in
message news:b10f4c5d93df49c6b3c31bee2a957db0@.droptable.co m...
> In the Enterprise Manager query tool, a query (the date entered in the
> criteria field as 31.03.05) displays as an SQL statement:
> SELECT *
> FROM [TABLE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> and yields the expected results.
> However, changing query type to
> DELETE FROM [SAME TABLE AS ABOVE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> results in the opposite of what is to be expected - all records where
> TRANS_DATE < [the entered time] is deleted.
> The TRANS_DATE field is of type DATETIME, and I cannot see that there are
> any properties either in the field or the table that separates it from all
> my other DATETIME fields in any other tables, where this bizarre delete
> action does not occur.
> I assume this has to do with some configuration of the automatic
> timeconversion that happens in the tool itself, but how to change this
> conversion setting so as to produce more desired delete results?
> And how is it that it only happens with data from one single table?
> Thanks for answering.
> --
> Message posted via http://www.droptable.com
|||Mike;
Same thing - deletes records with TRANS_DATE < entered value.
What's really bizzarre is that there's another datetime column in the
table, and running a delete with criteria filtered against those date
values yields the expected result.
Again, I really can't spot any differences in the respective data
properties of these two columns.
Uri;
I don't think I follow what you're getting at? The SELECT runs fine with
the date criteria entered as 31.03.05, but somehow things go off
differently with no other change thatn replacing SELECT with DELETE.
Message posted via http://www.droptable.com
|||Hi
I did some test
CREATE TABLE #Test
(
col DATETIME
)
INSERT INTO #Test VALUES ('20050331')--Proper format to insert datetime
INSERT INTO #Test VALUES ('20050401')
INSERT INTO #Test VALUES ('20050328')
DELETE FROM #Test WHERE col>'20050331'--Deletes 1 row
SELECT* FROM #Test--Everything is ok
DROP TABLE #Test
--Another repro
CREATE TABLE #Test
(
col VARCHAR(30)
)
INSERT INTO #Test VALUES ('31.03.05')--with datetime this insert will be
failed
INSERT INTO #Test VALUES ('28.03.05')--with datetime this insert will be
failed
INSERT INTO #Test VALUES ('01.04.05')--with datetime this insert will be
failed
DELETE FROM #Test WHERE col>CONVERT(DATETIME,'2005-03-31',102)--Error is
thrown
SELECT CONVERT(DATETIME,REPLACE(col,'.',''),102) FROM #Test
--2031-03-05 00:00:00.000
--2028-03-05 00:00:00.000
--2001-04-05 00:00:00.000
--That's why it deletes wrong data
DELETE FROM #Test WHERE CONVERT(DATETIME,REPLACE(col,'.',''),112)
>CONVERT(DATETIME,'2005-03-31',102)
SELECT* FROM #Test
DROP TABLE #Test
"Knut Bohn via droptable.com" <forum@.droptable.com> wrote in message
news:c446a5e8529b4bc49709d20ca6d2518d@.droptable.co m...
> Mike;
> Same thing - deletes records with TRANS_DATE < entered value.
> What's really bizzarre is that there's another datetime column in the
> table, and running a delete with criteria filtered against those date
> values yields the expected result.
> Again, I really can't spot any differences in the respective data
> properties of these two columns.
> Uri;
> I don't think I follow what you're getting at? The SELECT runs fine with
> the date criteria entered as 31.03.05, but somehow things go off
> differently with no other change thatn replacing SELECT with DELETE.
> --
> Message posted via http://www.droptable.com
|||Uri,
Thaanks for taking the time to test this. However, I don't think it
explains the criteria oddity that occurs when in the query changing from
SELECT to DELETE?
best,
knut
Message posted via http://www.droptable.com

EM query strange behavior

In the Enterprise Manager query tool, a query (the date entered in the
criteria field as 31.03.05) displays as an SQL statement:
SELECT *
FROM [TABLE]
WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
and yields the expected results.
However, changing query type to
DELETE FROM [SAME TABLE AS ABOVE]
WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
results in the opposite of what is to be expected - all records where
TRANS_DATE < [the entered time] is deleted.
The TRANS_DATE field is of type DATETIME, and I cannot see that there are
any properties either in the field or the table that separates it from all
my other DATETIME fields in any other tables, where this bizarre delete
action does not occur.
I assume this has to do with some configuration of the automatic
timeconversion that happens in the tool itself, but how to change this
conversion setting so as to produce more desired delete results?
And how is it that it only happens with data from one single table'
Thanks for answering.
--
Message posted via http://www.sqlmonster.comHi
What happens when you run this:
DELETE FROM [SAME TABLE AS ABOVE]
WHERE (TRANS_DATE > '2005-03-31 00:00:00'
Regards
Mike
"Knut Bohn via SQLMonster.com" wrote:
> In the Enterprise Manager query tool, a query (the date entered in the
> criteria field as 31.03.05) displays as an SQL statement:
> SELECT *
> FROM [TABLE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> and yields the expected results.
> However, changing query type to
> DELETE FROM [SAME TABLE AS ABOVE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> results in the opposite of what is to be expected - all records where
> TRANS_DATE < [the entered time] is deleted.
> The TRANS_DATE field is of type DATETIME, and I cannot see that there are
> any properties either in the field or the table that separates it from all
> my other DATETIME fields in any other tables, where this bizarre delete
> action does not occur.
> I assume this has to do with some configuration of the automatic
> timeconversion that happens in the tool itself, but how to change this
> conversion setting so as to produce more desired delete results?
> And how is it that it only happens with data from one single table'
> Thanks for answering.
> --
> Message posted via http://www.sqlmonster.com
>|||Knut
I dont uderstand you.
> In the Enterprise Manager query tool, a query (the date entered in the
> criteria field as 31.03.05) displays as an SQL statement:
You said that the table's column is defined as datetime datatype and data
was entered as 31.03.05 which is thrown the error
--insert into table1 values ('31.03.05')
"The conversion of a char data type to a datetime data type resulted in an
out-of-range datetime value.
The statement has been terminated."
"Knut Bohn via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in
message news:b10f4c5d93df49c6b3c31bee2a957db0@.SQLMonster.com...
> In the Enterprise Manager query tool, a query (the date entered in the
> criteria field as 31.03.05) displays as an SQL statement:
> SELECT *
> FROM [TABLE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> and yields the expected results.
> However, changing query type to
> DELETE FROM [SAME TABLE AS ABOVE]
> WHERE (TRANS_DATE > CONVERT(DATETIME, '2005-03-31 00:00:00', 102))
> results in the opposite of what is to be expected - all records where
> TRANS_DATE < [the entered time] is deleted.
> The TRANS_DATE field is of type DATETIME, and I cannot see that there are
> any properties either in the field or the table that separates it from all
> my other DATETIME fields in any other tables, where this bizarre delete
> action does not occur.
> I assume this has to do with some configuration of the automatic
> timeconversion that happens in the tool itself, but how to change this
> conversion setting so as to produce more desired delete results?
> And how is it that it only happens with data from one single table'
> Thanks for answering.
> --
> Message posted via http://www.sqlmonster.com|||Mike;
Same thing - deletes records with TRANS_DATE < entered value.
What's really bizzarre is that there's another datetime column in the
table, and running a delete with criteria filtered against those date
values yields the expected result.
Again, I really can't spot any differences in the respective data
properties of these two columns.
Uri;
I don't think I follow what you're getting at? The SELECT runs fine with
the date criteria entered as 31.03.05, but somehow things go off
differently with no other change thatn replacing SELECT with DELETE.
--
Message posted via http://www.sqlmonster.com|||Hi
I did some test
CREATE TABLE #Test
(
col DATETIME
)
INSERT INTO #Test VALUES ('20050331')--Proper format to insert datetime
INSERT INTO #Test VALUES ('20050401')
INSERT INTO #Test VALUES ('20050328')
DELETE FROM #Test WHERE col>'20050331'--Deletes 1 row
SELECT* FROM #Test--Everything is ok
DROP TABLE #Test
--Another repro
CREATE TABLE #Test
(
col VARCHAR(30)
)
INSERT INTO #Test VALUES ('31.03.05')--with datetime this insert will be
failed
INSERT INTO #Test VALUES ('28.03.05')--with datetime this insert will be
failed
INSERT INTO #Test VALUES ('01.04.05')--with datetime this insert will be
failed
DELETE FROM #Test WHERE col>CONVERT(DATETIME,'2005-03-31',102)--Error is
thrown
SELECT CONVERT(DATETIME,REPLACE(col,'.',''),102) FROM #Test
--2031-03-05 00:00:00.000
--2028-03-05 00:00:00.000
--2001-04-05 00:00:00.000
--That's why it deletes wrong data
DELETE FROM #Test WHERE CONVERT(DATETIME,REPLACE(col,'.',''),112)
>CONVERT(DATETIME,'2005-03-31',102)
SELECT* FROM #Test
DROP TABLE #Test
"Knut Bohn via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:c446a5e8529b4bc49709d20ca6d2518d@.SQLMonster.com...
> Mike;
> Same thing - deletes records with TRANS_DATE < entered value.
> What's really bizzarre is that there's another datetime column in the
> table, and running a delete with criteria filtered against those date
> values yields the expected result.
> Again, I really can't spot any differences in the respective data
> properties of these two columns.
> Uri;
> I don't think I follow what you're getting at? The SELECT runs fine with
> the date criteria entered as 31.03.05, but somehow things go off
> differently with no other change thatn replacing SELECT with DELETE.
> --
> Message posted via http://www.sqlmonster.com|||Uri,
Thaanks for taking the time to test this. However, I don't think it
explains the criteria oddity that occurs when in the query changing from
SELECT to DELETE?
best,
knut
--
Message posted via http://www.sqlmonster.com

em displays binary data

Using SS2000 SP3a. When displaying data from a user table in EM, instead of
the actual data displaying, the word "binary" will display.
How can I see the actual data?
Thanks,
--
Dan D.Use Query Analyzer for viewing data.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
Using SS2000 SP3a. When displaying data from a user table in EM, instead of
the actual data displaying, the word "binary" will display.
How can I see the actual data?
Thanks,
--
Dan D.|||I mean, use SELECT statements in Query Analyzer, to view data.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
Using SS2000 SP3a. When displaying data from a user table in EM, instead of
the actual data displaying, the word "binary" will display.
How can I see the actual data?
Thanks,
--
Dan D.|||We have 7 SQL Server boxes and what I'm describing only happens on one
server. I want to fix the problem. Do you have any ideas on how to fix it?
Thanks
"Narayana Vyas Kondreddi" wrote:

> Use Query Analyzer for viewing data.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
> Using SS2000 SP3a. When displaying data from a user table in EM, instead o
f
> the actual data displaying, the word "binary" will display.
> How can I see the actual data?
> Thanks,
> --
> Dan D.
>
>|||Could you check the datatype of that column, using sp_help (from Query
Analyzer), and see if it is any different to other databases.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:1AC2C424-CDE6-4303-A817-DCA79AB700B6@.microsoft.com...
We have 7 SQL Server boxes and what I'm describing only happens on one
server. I want to fix the problem. Do you have any ideas on how to fix it?
Thanks
"Narayana Vyas Kondreddi" wrote:

> Use Query Analyzer for viewing data.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
> Using SS2000 SP3a. When displaying data from a user table in EM, instead
of
> the actual data displaying, the word "binary" will display.
> How can I see the actual data?
> Thanks,
> --
> Dan D.
>
>|||I understood what you meant. And we do usually use the QA.
Thanks,
"Narayana Vyas Kondreddi" wrote:

> I mean, use SELECT statements in Query Analyzer, to view data.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
> Using SS2000 SP3a. When displaying data from a user table in EM, instead o
f
> the actual data displaying, the word "binary" will display.
> How can I see the actual data?
> Thanks,
> --
> Dan D.
>
>|||Sorry I wasn't clearer. It's ALL columns in ANY table that is displaying the
"binary" word. I had this happen on my local box once but I can't remember
how I fixed it.
"Narayana Vyas Kondreddi" wrote:

> Could you check the datatype of that column, using sp_help (from Query
> Analyzer), and see if it is any different to other databases.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:1AC2C424-CDE6-4303-A817-DCA79AB700B6@.microsoft.com...
> We have 7 SQL Server boxes and what I'm describing only happens on one
> server. I want to fix the problem. Do you have any ideas on how to fix it?
> Thanks
> "Narayana Vyas Kondreddi" wrote:
>
> of
>
>|||Then, I am not sure. Haven't seen that before. Have you searched KB for any
known issues? My last option would be to reinstall the client utilities.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:01BCB015-3A5D-4545-A652-5C1D4400CFAC@.microsoft.com...
Sorry I wasn't clearer. It's ALL columns in ANY table that is displaying the
"binary" word. I had this happen on my local box once but I can't remember
how I fixed it.
"Narayana Vyas Kondreddi" wrote:

> Could you check the datatype of that column, using sp_help (from Query
> Analyzer), and see if it is any different to other databases.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:1AC2C424-CDE6-4303-A817-DCA79AB700B6@.microsoft.com...
> We have 7 SQL Server boxes and what I'm describing only happens on one
> server. I want to fix the problem. Do you have any ideas on how to fix it?
> Thanks
> "Narayana Vyas Kondreddi" wrote:
>
> of
>
>|||I've been searching kb and the web. We're going to reinstall and see if that
fixes it.
Thanks
"Narayana Vyas Kondreddi" wrote:

> Then, I am not sure. Haven't seen that before. Have you searched KB for an
y
> known issues? My last option would be to reinstall the client utilities.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:01BCB015-3A5D-4545-A652-5C1D4400CFAC@.microsoft.com...
> Sorry I wasn't clearer. It's ALL columns in ANY table that is displaying t
he
> "binary" word. I had this happen on my local box once but I can't remember
> how I fixed it.
> "Narayana Vyas Kondreddi" wrote:
>
>
>

em displays binary data

Using SS2000 SP3a. When displaying data from a user table in EM, instead of
the actual data displaying, the word "binary" will display.
How can I see the actual data?
Thanks,
Dan D.
Use Query Analyzer for viewing data.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
Using SS2000 SP3a. When displaying data from a user table in EM, instead of
the actual data displaying, the word "binary" will display.
How can I see the actual data?
Thanks,
Dan D.
|||I mean, use SELECT statements in Query Analyzer, to view data.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
Using SS2000 SP3a. When displaying data from a user table in EM, instead of
the actual data displaying, the word "binary" will display.
How can I see the actual data?
Thanks,
Dan D.
|||We have 7 SQL Server boxes and what I'm describing only happens on one
server. I want to fix the problem. Do you have any ideas on how to fix it?
Thanks
"Narayana Vyas Kondreddi" wrote:

> Use Query Analyzer for viewing data.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
> Using SS2000 SP3a. When displaying data from a user table in EM, instead of
> the actual data displaying, the word "binary" will display.
> How can I see the actual data?
> Thanks,
> --
> Dan D.
>
>
|||Could you check the datatype of that column, using sp_help (from Query
Analyzer), and see if it is any different to other databases.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:1AC2C424-CDE6-4303-A817-DCA79AB700B6@.microsoft.com...
We have 7 SQL Server boxes and what I'm describing only happens on one
server. I want to fix the problem. Do you have any ideas on how to fix it?
Thanks
"Narayana Vyas Kondreddi" wrote:

> Use Query Analyzer for viewing data.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
> Using SS2000 SP3a. When displaying data from a user table in EM, instead
of
> the actual data displaying, the word "binary" will display.
> How can I see the actual data?
> Thanks,
> --
> Dan D.
>
>
|||I understood what you meant. And we do usually use the QA.
Thanks,
"Narayana Vyas Kondreddi" wrote:

> I mean, use SELECT statements in Query Analyzer, to view data.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
> Using SS2000 SP3a. When displaying data from a user table in EM, instead of
> the actual data displaying, the word "binary" will display.
> How can I see the actual data?
> Thanks,
> --
> Dan D.
>
>
|||Sorry I wasn't clearer. It's ALL columns in ANY table that is displaying the
"binary" word. I had this happen on my local box once but I can't remember
how I fixed it.
"Narayana Vyas Kondreddi" wrote:

> Could you check the datatype of that column, using sp_help (from Query
> Analyzer), and see if it is any different to other databases.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:1AC2C424-CDE6-4303-A817-DCA79AB700B6@.microsoft.com...
> We have 7 SQL Server boxes and what I'm describing only happens on one
> server. I want to fix the problem. Do you have any ideas on how to fix it?
> Thanks
> "Narayana Vyas Kondreddi" wrote:
> of
>
>
|||Then, I am not sure. Haven't seen that before. Have you searched KB for any
known issues? My last option would be to reinstall the client utilities.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:01BCB015-3A5D-4545-A652-5C1D4400CFAC@.microsoft.com...
Sorry I wasn't clearer. It's ALL columns in ANY table that is displaying the
"binary" word. I had this happen on my local box once but I can't remember
how I fixed it.
"Narayana Vyas Kondreddi" wrote:

> Could you check the datatype of that column, using sp_help (from Query
> Analyzer), and see if it is any different to other databases.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:1AC2C424-CDE6-4303-A817-DCA79AB700B6@.microsoft.com...
> We have 7 SQL Server boxes and what I'm describing only happens on one
> server. I want to fix the problem. Do you have any ideas on how to fix it?
> Thanks
> "Narayana Vyas Kondreddi" wrote:
> of
>
>
|||I've been searching kb and the web. We're going to reinstall and see if that
fixes it.
Thanks
"Narayana Vyas Kondreddi" wrote:

> Then, I am not sure. Haven't seen that before. Have you searched KB for any
> known issues? My last option would be to reinstall the client utilities.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:01BCB015-3A5D-4545-A652-5C1D4400CFAC@.microsoft.com...
> Sorry I wasn't clearer. It's ALL columns in ANY table that is displaying the
> "binary" word. I had this happen on my local box once but I can't remember
> how I fixed it.
> "Narayana Vyas Kondreddi" wrote:
>
>

em displays binary data

Using SS2000 SP3a. When displaying data from a user table in EM, instead of
the actual data displaying, the word "binary" will display.
How can I see the actual data?
Thanks,
--
Dan D.Use Query Analyzer for viewing data.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
Using SS2000 SP3a. When displaying data from a user table in EM, instead of
the actual data displaying, the word "binary" will display.
How can I see the actual data?
Thanks,
--
Dan D.|||I mean, use SELECT statements in Query Analyzer, to view data.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
Using SS2000 SP3a. When displaying data from a user table in EM, instead of
the actual data displaying, the word "binary" will display.
How can I see the actual data?
Thanks,
--
Dan D.|||We have 7 SQL Server boxes and what I'm describing only happens on one
server. I want to fix the problem. Do you have any ideas on how to fix it?
Thanks
"Narayana Vyas Kondreddi" wrote:
> Use Query Analyzer for viewing data.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
> Using SS2000 SP3a. When displaying data from a user table in EM, instead of
> the actual data displaying, the word "binary" will display.
> How can I see the actual data?
> Thanks,
> --
> Dan D.
>
>|||Could you check the datatype of that column, using sp_help (from Query
Analyzer), and see if it is any different to other databases.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:1AC2C424-CDE6-4303-A817-DCA79AB700B6@.microsoft.com...
We have 7 SQL Server boxes and what I'm describing only happens on one
server. I want to fix the problem. Do you have any ideas on how to fix it?
Thanks
"Narayana Vyas Kondreddi" wrote:
> Use Query Analyzer for viewing data.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
> Using SS2000 SP3a. When displaying data from a user table in EM, instead
of
> the actual data displaying, the word "binary" will display.
> How can I see the actual data?
> Thanks,
> --
> Dan D.
>
>|||I understood what you meant. And we do usually use the QA.
Thanks,
"Narayana Vyas Kondreddi" wrote:
> I mean, use SELECT statements in Query Analyzer, to view data.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
> Using SS2000 SP3a. When displaying data from a user table in EM, instead of
> the actual data displaying, the word "binary" will display.
> How can I see the actual data?
> Thanks,
> --
> Dan D.
>
>|||Sorry I wasn't clearer. It's ALL columns in ANY table that is displaying the
"binary" word. I had this happen on my local box once but I can't remember
how I fixed it.
"Narayana Vyas Kondreddi" wrote:
> Could you check the datatype of that column, using sp_help (from Query
> Analyzer), and see if it is any different to other databases.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:1AC2C424-CDE6-4303-A817-DCA79AB700B6@.microsoft.com...
> We have 7 SQL Server boxes and what I'm describing only happens on one
> server. I want to fix the problem. Do you have any ideas on how to fix it?
> Thanks
> "Narayana Vyas Kondreddi" wrote:
> > Use Query Analyzer for viewing data.
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
> >
> >
> > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
> > Using SS2000 SP3a. When displaying data from a user table in EM, instead
> of
> > the actual data displaying, the word "binary" will display.
> >
> > How can I see the actual data?
> >
> > Thanks,
> > --
> > Dan D.
> >
> >
> >
>
>|||Then, I am not sure. Haven't seen that before. Have you searched KB for any
known issues? My last option would be to reinstall the client utilities.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:01BCB015-3A5D-4545-A652-5C1D4400CFAC@.microsoft.com...
Sorry I wasn't clearer. It's ALL columns in ANY table that is displaying the
"binary" word. I had this happen on my local box once but I can't remember
how I fixed it.
"Narayana Vyas Kondreddi" wrote:
> Could you check the datatype of that column, using sp_help (from Query
> Analyzer), and see if it is any different to other databases.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:1AC2C424-CDE6-4303-A817-DCA79AB700B6@.microsoft.com...
> We have 7 SQL Server boxes and what I'm describing only happens on one
> server. I want to fix the problem. Do you have any ideas on how to fix it?
> Thanks
> "Narayana Vyas Kondreddi" wrote:
> > Use Query Analyzer for viewing data.
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
> >
> >
> > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
> > Using SS2000 SP3a. When displaying data from a user table in EM, instead
> of
> > the actual data displaying, the word "binary" will display.
> >
> > How can I see the actual data?
> >
> > Thanks,
> > --
> > Dan D.
> >
> >
> >
>
>|||I've been searching kb and the web. We're going to reinstall and see if that
fixes it.
Thanks
"Narayana Vyas Kondreddi" wrote:
> Then, I am not sure. Haven't seen that before. Have you searched KB for any
> known issues? My last option would be to reinstall the client utilities.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:01BCB015-3A5D-4545-A652-5C1D4400CFAC@.microsoft.com...
> Sorry I wasn't clearer. It's ALL columns in ANY table that is displaying the
> "binary" word. I had this happen on my local box once but I can't remember
> how I fixed it.
> "Narayana Vyas Kondreddi" wrote:
> > Could you check the datatype of that column, using sp_help (from Query
> > Analyzer), and see if it is any different to other databases.
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
> >
> >
> > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > news:1AC2C424-CDE6-4303-A817-DCA79AB700B6@.microsoft.com...
> > We have 7 SQL Server boxes and what I'm describing only happens on one
> > server. I want to fix the problem. Do you have any ideas on how to fix it?
> >
> > Thanks
> >
> > "Narayana Vyas Kondreddi" wrote:
> >
> > > Use Query Analyzer for viewing data.
> > > --
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
> > >
> > >
> > > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > > news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
> > > Using SS2000 SP3a. When displaying data from a user table in EM, instead
> > of
> > > the actual data displaying, the word "binary" will display.
> > >
> > > How can I see the actual data?
> > >
> > > Thanks,
> > > --
> > > Dan D.
> > >
> > >
> > >
> >
> >
> >
>
>

EM and QA displays different format for a date field

Hi,
I have a datetime field with a value '1/1/02'. EM display it as 1/1/02 But
Query Analyzer displays it as 2002-01-01 00:00:00.000 (I used SELECT * FROM
Table1)
So in Query Analyzer, I can't tell the fomat of it. I just wonder if your
PC does the same.
Thanks.You have a problem under standing of what a data value is and how it is
stored. It is actually just stored as numeric value, denoting offsets from
some time in the reasonably distant past. Format is based on the user. QA
uses a standard value, mostly because when you are using QA the goal is
usually to see ALL of the data.
Enterprise manager is probably using your system settings. When you
actually use the data, you can format it as you wish.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Chrissi" <anubisofthydeath@.hotmail.com> wrote in message
news:OqYzX0yUFHA.2136@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have a datetime field with a value '1/1/02'. EM display it as 1/1/02
> But Query Analyzer displays it as 2002-01-01 00:00:00.000 (I used SELECT *
> FROM Table1)
> So in Query Analyzer, I can't tell the fomat of it. I just wonder if your
> PC does the same.
> Thanks.
>|||Chrissi,
Different clients display things differently, with the possible
excepting of strings made up of printable ASCII with codes
from 32 to 127.
If you want the datetime displayed in a particular format, I'd
suggest you select CONVERT(varchar(40),yourDatetimeColumn,X
XXX),
where XXXX is the appropriate SQL Server format code (see the
Books Online article CAST and CONVERT).
If you do this, you won't be able to "edit" the datetime values
in Enterprise Manager, but that's not a good idea anyway. Better
to make changes programmatically with UPDATE or INSERT
statements.
Steve Kass
Drew University
Chrissi wrote:

>Hi,
>I have a datetime field with a value '1/1/02'. EM display it as 1/1/02 Bu
t
>Query Analyzer displays it as 2002-01-01 00:00:00.000 (I used SELECT * FROM
>Table1)
>So in Query Analyzer, I can't tell the fomat of it. I just wonder if your
>PC does the same.
>Thanks.
>
>

Editing stored procedures...

I'm not a "real" programmer. Excuse my ignorance.

I need to edit a stored procedure. I simply want to change the text that it displays. I do not intend to change its function.

I am using SQL Express and SQL Server Management Studio Express. I can select Modify for my stored procedure, but when I save it, it saves it as an SQL file to my hard disk. How do I affect the edits to the actual stored procedure?

Hi,

When you save the stored procedure you just save the sql statement (.sql file).
You have to execute the statement.

So : go to your Stored procedure
Select 'Modify'
Make the necessary changes
Execute the code ( press F5)

Succes,

Jef