Embedded Word Document in RDL

I have a word document that I would to migrate to reporting services
2005. Instead of recreating the word document in reporting services, I
would like to know if I can embed the word document in a report? If
not, what other options are there?
Thanks.If you would like the word document to be hosted by RS then in your project
add a new existing item and then select your Word file. Then you can deploy
it. Note that when you update it and want to redeploy I have found that I
have to delete it from the report server first prior to deployment.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"TCogan" <tcogan@.starcon.org> wrote in message
news:1174500858.861820.168170@.y66g2000hsf.googlegroups.com...
>I have a word document that I would to migrate to reporting services
> 2005. Instead of recreating the word document in reporting services, I
> would like to know if I can embed the word document in a report? If
> not, what other options are there?
> Thanks.
>|||On Mar 21, 1:45 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> If you would like the word document to be hosted by RS then in your project
> add a new existing item and then select your Word file. Then you can deploy
> it. Note that when you update it and want to redeploy I have found that I
> have to delete it from the report server first prior to deployment.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "TCogan" <tco...@.starcon.org> wrote in message
> news:1174500858.861820.168170@.y66g2000hsf.googlegroups.com...
>
> >I have a word document that I would to migrate to reporting services
> > 2005. Instead of recreating the word document in reporting services, I
> > would like to know if I can embed the word document in a report? If
> > not, what other options are there?
> > Thanks.- Hide quoted text -
> - Show quoted text -
I have tried that and that does work. But I was trying to find the
best way to migrate the word document into an RDL file. I want it to
be an RDL file because I have some other data that I want to
incorporate into the report from a database. I am not sure this can
be done, but I would like to avoid from having to recreate the word
document in an RDL file.|||There might be a third party tool that allows this but not straight out of
the box.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"TCogan" <tcogan@.starcon.org> wrote in message
news:1174503465.010122.233220@.p15g2000hsd.googlegroups.com...
> On Mar 21, 1:45 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> If you would like the word document to be hosted by RS then in your
>> project
>> add a new existing item and then select your Word file. Then you can
>> deploy
>> it. Note that when you update it and want to redeploy I have found that I
>> have to delete it from the report server first prior to deployment.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "TCogan" <tco...@.starcon.org> wrote in message
>> news:1174500858.861820.168170@.y66g2000hsf.googlegroups.com...
>>
>> >I have a word document that I would to migrate to reporting services
>> > 2005. Instead of recreating the word document in reporting services, I
>> > would like to know if I can embed the word document in a report? If
>> > not, what other options are there?
>> > Thanks.- Hide quoted text -
>> - Show quoted text -
> I have tried that and that does work. But I was trying to find the
> best way to migrate the word document into an RDL file. I want it to
> be an RDL file because I have some other data that I want to
> incorporate into the report from a database. I am not sure this can
> be done, but I would like to avoid from having to recreate the word
> document in an RDL file.
>

Email task - no error - no mail

I am trying to explore the email task in SSIS. I have a task which has only the email task. When I run its not throwing any error instead it says successfuly run but I am not recieving mail. I dont know how to trace this, could someone help me on this?

I'm sending email by sript component because in the company I cant send via SMTP...

Do you want to try send by script?

Regards!

|||Yes, I can make a try on it. Please send the script. Thanks.|||

Dhanasu wrote:

I am trying to explore the email task in SSIS. I have a task which has only the email task. When I run its not throwing any error instead it says successfuly run but I am not recieving mail. I dont know how to trace this, could someone help me on this?

Perhaps it's getting caught up in a spam filter. Or the SMTP server isn't letting that e-mail through. Have you talked to the server admin?|||

here you have...

Code Snippet

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.Net

Imports System.IO

Public Class ScriptMain

' The execution engine calls this method when the task executes.

' To access the object model, use the Dts object. Connections, variables, events,

' and logging features are available as static members of the Dts class.

' Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.

'

' To open Code and Text Editor Help, press F1.

' To open Object Browser, press Ctrl+Alt+J.

Public Sub Main()

Dim strServer As String = "mail.Grupo.com"

Dim strSender As String = "pedro"

Dim strTo As String = "mswail@.mail.com"

Dim strSenderAlias As String = "Pedro"

Dim strSubject As String = "SUCESS Import CLiq - " & Today()

Dim strBody As String = "OK"

Dim sUri As String

sUri = "http://" + strServer + "/Exchange/" + strSenderAlias

sUri = sUri + "/%23%23DavMailSubmissionURI%23%23/"

Dim myUri As System.Uri = New System.Uri(sUri)

Dim HttpWRequest As HttpWebRequest = CType(WebRequest.Create(myUri), HttpWebRequest)

Dim sQuery As String

sQuery = "To: " & strTo & vbNewLine & _

"Subject: " & strSubject & vbNewLine & _

"Date: " & Date.Now & vbNewLine & _

"X-Mailer: My DAV mailer" & vbNewLine & _

"MIME-Version: 1.0" & vbNewLine & _

"Content-Type: text/plain" & vbNewLine & _

"Charset = ""iso-8859-1""" & vbNewLine & _

"Content-Transfer-Encoding: 7bit" & vbNewLine & vbNewLine & _

strBody

Dim myCred As NetworkCredential = New NetworkCredential("GRUPOCGD\rhs0002", "275007")

Dim myCredentialCache As CredentialCache = New CredentialCache()

myCredentialCache.Add(myUri, "Basic", myCred)

HttpWRequest.Credentials = myCredentialCache

HttpWRequest.Headers.Set("Translate", "f")

HttpWRequest.ContentType = "message/rfc822"

HttpWRequest.ContentLength = sQuery.Length

HttpWRequest.Timeout = 300000

HttpWRequest.Method = "PUT"

Dim ByteQuery As Byte() = System.Text.Encoding.ASCII.GetBytes(sQuery)

HttpWRequest.ContentLength = ByteQuery.Length

Dim QueryStream As Stream = HttpWRequest.GetRequestStream()

QueryStream.Write(ByteQuery, 0, ByteQuery.Length)

QueryStream.Close()

Dim HttpWResponse As HttpWebResponse = CType(HttpWRequest.GetResponse(), HttpWebResponse)

Dim iStatCode As Integer = CType(HttpWResponse.StatusCode, Integer)

Dim sStatus As String = iStatCode.ToString()

myCred = Nothing

myCredentialCache = Nothing

HttpWRequest = Nothing

HttpWResponse = Nothing

QueryStream = Nothing

Dts.TaskResult = Dts.Results.Success

End Sub

End Class

|||I am wiating for the reply from the admin. The from and to addresses are mine, so there are no possibility for Spam filter. If the SMTP is in error I hope I should get error message !!!|||

The SMTP i am trying is incorrect. I used the correct SMTP and it worked.

Question: Why does the SSIS not throwing error on incorrect SMTP.

|||

Dhanasu wrote:

The SMTP i am trying is incorrect. I used the correct SMTP and it worked.

Question: Why does the SSIS not throwing error on incorrect SMTP.

You mean you used the wrong server?

|||Yes, i was using wrong server.|||

Dhanasu wrote:

Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.|||

Phil Brammer wrote:

Dhanasu wrote:

Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.

If the SMTP server is invalid, because it will not be able to find that server at all, it wont throw any error for opening the connection I agree. But since its not able to find the server specified in the connection manager, it should throw the error for this right?

Thanks
|||

Karunakaran wrote:

Phil Brammer wrote:

Dhanasu wrote:

Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.

If the SMTP server is invalid, because it will not be able to find that server at all, it wont throw any error for opening the connection I agree. But since its not able to find the server specified in the connection manager, it should throw the error for this right?

Thanks

When I set it up to point to a server that doesn't exist, I get an error message: "[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.". "

So if the OP above didn't get an error message and the task succeeded, then it must've been a valid SMTP server, just not the correct one.|||

An added question: Since the mail task is directly bind with the SMTP I can send emails from anonymous email as the "from email id". Is this an issue in my server configuration or in SSIS "send task"?

sql

Email task - no error - no mail

I am trying to explore the email task in SSIS. I have a task which has only the email task. When I run its not throwing any error instead it says successfuly run but I am not recieving mail. I dont know how to trace this, could someone help me on this?

I'm sending email by sript component because in the company I cant send via SMTP...

Do you want to try send by script?

Regards!

|||Yes, I can make a try on it. Please send the script. Thanks.|||

Dhanasu wrote:

I am trying to explore the email task in SSIS. I have a task which has only the email task. When I run its not throwing any error instead it says successfuly run but I am not recieving mail. I dont know how to trace this, could someone help me on this?

Perhaps it's getting caught up in a spam filter. Or the SMTP server isn't letting that e-mail through. Have you talked to the server admin?|||

here you have...

Code Snippet

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.Net

Imports System.IO

Public Class ScriptMain

' The execution engine calls this method when the task executes.

' To access the object model, use the Dts object. Connections, variables, events,

' and logging features are available as static members of the Dts class.

' Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.

'

' To open Code and Text Editor Help, press F1.

' To open Object Browser, press Ctrl+Alt+J.

Public Sub Main()

Dim strServer As String = "mail.Grupo.com"

Dim strSender As String = "pedro"

Dim strTo As String = "mswail@.mail.com"

Dim strSenderAlias As String = "Pedro"

Dim strSubject As String = "SUCESS Import CLiq - " & Today()

Dim strBody As String = "OK"

Dim sUri As String

sUri = "http://" + strServer + "/Exchange/" + strSenderAlias

sUri = sUri + "/%23%23DavMailSubmissionURI%23%23/"

Dim myUri As System.Uri = New System.Uri(sUri)

Dim HttpWRequest As HttpWebRequest = CType(WebRequest.Create(myUri), HttpWebRequest)

Dim sQuery As String

sQuery = "To: " & strTo & vbNewLine & _

"Subject: " & strSubject & vbNewLine & _

"Date: " & Date.Now & vbNewLine & _

"X-Mailer: My DAV mailer" & vbNewLine & _

"MIME-Version: 1.0" & vbNewLine & _

"Content-Type: text/plain" & vbNewLine & _

"Charset = ""iso-8859-1""" & vbNewLine & _

"Content-Transfer-Encoding: 7bit" & vbNewLine & vbNewLine & _

strBody

Dim myCred As NetworkCredential = New NetworkCredential("GRUPOCGD\rhs0002", "275007")

Dim myCredentialCache As CredentialCache = New CredentialCache()

myCredentialCache.Add(myUri, "Basic", myCred)

HttpWRequest.Credentials = myCredentialCache

HttpWRequest.Headers.Set("Translate", "f")

HttpWRequest.ContentType = "message/rfc822"

HttpWRequest.ContentLength = sQuery.Length

HttpWRequest.Timeout = 300000

HttpWRequest.Method = "PUT"

Dim ByteQuery As Byte() = System.Text.Encoding.ASCII.GetBytes(sQuery)

HttpWRequest.ContentLength = ByteQuery.Length

Dim QueryStream As Stream = HttpWRequest.GetRequestStream()

QueryStream.Write(ByteQuery, 0, ByteQuery.Length)

QueryStream.Close()

Dim HttpWResponse As HttpWebResponse = CType(HttpWRequest.GetResponse(), HttpWebResponse)

Dim iStatCode As Integer = CType(HttpWResponse.StatusCode, Integer)

Dim sStatus As String = iStatCode.ToString()

myCred = Nothing

myCredentialCache = Nothing

HttpWRequest = Nothing

HttpWResponse = Nothing

QueryStream = Nothing

Dts.TaskResult = Dts.Results.Success

End Sub

End Class

|||I am wiating for the reply from the admin. The from and to addresses are mine, so there are no possibility for Spam filter. If the SMTP is in error I hope I should get error message !!!|||

The SMTP i am trying is incorrect. I used the correct SMTP and it worked.

Question: Why does the SSIS not throwing error on incorrect SMTP.

|||

Dhanasu wrote:

The SMTP i am trying is incorrect. I used the correct SMTP and it worked.

Question: Why does the SSIS not throwing error on incorrect SMTP.

You mean you used the wrong server?

|||Yes, i was using wrong server.|||

Dhanasu wrote:

Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.|||

Phil Brammer wrote:

Dhanasu wrote:

Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.

If the SMTP server is invalid, because it will not be able to find that server at all, it wont throw any error for opening the connection I agree. But since its not able to find the server specified in the connection manager, it should throw the error for this right?

Thanks
|||

Karunakaran wrote:

Phil Brammer wrote:

Dhanasu wrote:

Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.

If the SMTP server is invalid, because it will not be able to find that server at all, it wont throw any error for opening the connection I agree. But since its not able to find the server specified in the connection manager, it should throw the error for this right?

Thanks

When I set it up to point to a server that doesn't exist, I get an error message: "[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.". "

So if the OP above didn't get an error message and the task succeeded, then it must've been a valid SMTP server, just not the correct one.|||

An added question: Since the mail task is directly bind with the SMTP I can send emails from anonymous email as the "from email id". Is this an issue in my server configuration or in SSIS "send task"?

email send/receive

How can I have my email download automatically instead of clicking send/receive all the time?

create an activation stored procedure that calls a CLR stored porcedure which calls a webservice which checks your mail.

are you sure you posted this in the correct forum?

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.
> > >
> > >
> > >
> >
> >
> >
>
>

Editor

Hi!

I like a new sql editor instead of the query analyzer.
The QA dont show the outlining, bracket injuctions and intellilist.
Help!
Wich editor able this functions?

Try the SQL Buddy:

http://sqlbuddy.sourceforge.net/

HTH, Jens Suessmeyer.

|||Thanks!

The buddy is a good, but dont able the outlining and bracket conjunctions!

Another?