Answer Questions

• engloon HOW to Retrieve an image from sql server and display it in ASP.net using "imagemap or image" ?

  Ok, the problem is that , i have a field called "Attach" in sql of type image, when selecting it , the field is getting data of type BYTE(). which am being unable to display them on an Image on the panel. using the following vb.net code: 'Dim sel2 As String 'Dim myCom As SqlCommand 'Dim conn As New SqlConnection 'Dim drr As SqlDataReader 'Dim image As System.Drawing.Image 'sel2 = "select * from attach where att_desc = '" & DropDownList1.SelectedItem().Text & "' and doc_code = " & w_doc_code & " and subcode = " & w_doc_subcode & " and doc_num= " & w_doc_num & " " 'conn.ConnectionString = ("server=developer01;u ...Show All

• unthreaded system account for sql2005

  I have a big trouble with update from MS SQL 2000 to SQL 2005. Because my aplication runs as System Service, I use system account for login to SQL server. At the SQL 2000 I created SQL account like "DOMAIN\PC_NAME$" and service started at PC_NAME was able to logon on the SQL2000 server. But on the SQL2005 it DOESN'T work. Does anybody have some idea how to create system account on SQL2005 to log on SQL server from another computer under system service account Thanks for your help. This acount (doamin/pcname$) cannot be created on SQL2005. What was the error you get when you are starting the SQL 2005 services using that domain account Make sure it is a local ...Show All

• madenci R

  Hello - I have a report based on a query that currently uses the = operator and I'd like to change it to the LIKE operator and allow a wildcard...using the %. So...from something like, "....WHERE zipcode = @ZipCode" to "...WHERE zipCode = @zipCode plus the wildcard character. Is this possible Thanks, - will Thanks for the replies. I ended up using a stored procedure and just concatenate the '%' to the incoming parameter. I could not get it to work with an inline sql query in my report....and besides, I was planning on using stored procs anyway. Will Durning wrote: Hello - I have a report based on a query that currently uses the = operator and I'd like to change it to the LIKE op ...Show All

• Smitty1276 Connection Strings

  I have created a SSIS package, and got it to perform as I want. I am having a problem though with connecting to my data source (OLE DB Source) using SQL Server Authentication. If I use Integrated security, I have no problems. If I use SQL Server Authentication, I get errors. Here is the connection string that works: Provider=SQLNCLI.1;Data Source=.\SqlExpress;Integrated Security=SSPI;Initial Catalog=MyDataBase Here is the connection string that fails: Provider=SQLNCLI.1;Data Source=.\SqlExpress;Persist Security Info=True;Password=**********;User ID=myUserid;Initial Catalog=MyDataBase The strange thing is that when I use the Connection Manager dialog screen and click on "Test Connection", I get the response t ...Show All

• Joe Morel - MSFT Redirect Rows Move good and bad recs to bad table.

  I use a redirect row method for error of OLE DB Destination For sqlServer2005. For some resone even though only 1 record has error and should be redirect, all the record in the current batch (I think depending on the "maximum insert commit size") are redirect. the only way for me to get the exact bad record is to set the above parameter to 1, but then it takes hours to run the package. also I always get the same error in the errorCode column - " -1071607685" why Thanks for your help. I can't use other then fast load b'c I have an Identity column in the destination, and I need the "idnory identity" of the fast load. Also, I can't use the SQL Server ...Show All

• ap231 ADOMD.net 9.0 (client) and CubeDef.LastProcessed

  What is this property (CubeDef.LastProcessed) supposed to return as it does not return the date the cube was last processed Does AMO provide this info more reliably TIA Dave FWIW AMO works for AS2005 when retrieving the last processed datetime. Doesnt work for AS2000 or local cubes. Hi Dave, It's a bug - CubeDef.LastProcessed returns the last time the server was restarted as far as I know. See http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=124606 ...for more details. Take a look at the comment posted by furmangg on April 28th on this entry on my blog for some code which does what you want: http://cwebbbi.spaces.live.com/Blog/c ...Show All

• Andrew Baker Granting UPDATE for only certain columns in a table

  I have tried using the SQL statement shown below to grant UPDATE permissions for a single column in a single table to a user with db_datareader privileges. grant update (col_1 ) on trs . dbo.table_1 to calc When I then run a SQL script that has an UPDATE for col_1 on trs.dbo.table_1, I get an error message Msg 230, Level 14, State 1, Line 2100 UPDATE permission denied on column 'col_2' of object 'table_1', database 'TRS', schema 'dbo'. Why is the error message referring to "col_2" when my SQL statement is trying to update "col_1" When I performed the "grant" I did it with an account that has db_owner, db_securityadmin, and db_ddladmin privileges. This worked in SQL Server 20 ...Show All

• Florim Another Major Flaw with Reporting Services!

  Where is the text (.txt) export functionality I don't see any ascii text export mechanism without the .csv extension. Where is actual .TXT file of the reports. How do I get a .txt conversion out of the reports without messing with the .csv files. I would've wanted direct .txt export from the generation mechanism. This seems extremely basic form of reporting generation. I can't believe you can't get txt report out of reporting services. Enkh. I definitely agree with ENKHT. I have the same issue. One of our external partners expect a txt file with specfic columns and associated data. In other words, they read each line and know exactly where the start and end point of each column. And h ...Show All

• Peter Lillevold Getting error 0x80004005

  Hi Everybody, Iam a sql server developer,iam on a migration project,iam encountering an error when iam editing the control flow task.it says the sql server doesnot exist or access denied,pls can anyone help me on this. Thanks and Regards, sg I didnot indicate the path for connection manager correctly. Regards, sg Hey i have access.thanks for ur reply. i found out the cause of the error. Thanks, sg Just out of curiosity, are you sure that you have access to the SQL Server that you are trying to connect to Can you connect through SQL Server Management Studio What was the cause so that oth ...Show All

• roychoo Problem with calculating values

  I have problem with calculating values, let me give an example: Fact table: tableID docID authorID numMetadata numSubDocs 1 10 1 3 5 2 10 14 3 5 3 10 6 3 5 4 49 2 1 0 5 49 4 1 0 6 15 8 6 1 ..... I want to get in a report like this: docID numMetadata numSubDocs 10 3 5 49 1 0 Grand total: 4 5 ...Show All

• Luis Arevalo SQL Server vs. XML Configurations

  I have been experimenting with both XML and SQL Server Configurations. Management would really like to go with the SQL Server Configurations, but I seem to be having problems with them. The main goal is to be able to create a configuration for each connection and have every package refer to its specific configuration, therefore in the future we could change say our SA password and only have to update this in a few places rather than for every package. In order to experiment with the problem I am having I developed 2 identical packages, except one uses SQL Server Configurations and the other uses XML. The configurations save the exact same properties. With the XML package I can go into the configuration file and change say the passwor ...Show All

• Flamin XML Path returns multiple children instead of one record

  I have a query that is returning multiple XML records instead of one record with multiple children when a joined table has more than one record . Here is a simplified version of the query : SELECT Person . PersonID AS "Traveler/PersonID" , Profile . ProfileID AS "Traveler/Profile/ProfileID" , EmailAddress . EmailAddressID AS "Traveler/Profile/EmailAddess/EmailAddressID" FROM Person INNER JOIN Person_Profile ON Person . PersonID = Person_Profile . PersonID INNER JOIN Profile ON Person_Profile . ProfileID = Profile . ProfileID LEFT OUTER JOIN Profile_EmailAddress ON Profile . Profile ...Show All

• Alexnaldo Santos DB2 and SQL 2005

  I have a SQL 2005 server. I want to make calls to a DB2 server to retrieve a list of rows from a table. How can I access the DB2 server from Microsoft SQL Server Management Studio You can either use a linked server with direct four-part notation access or use the OPENQUERY or OPENDATASOURCE to access the source. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• 小朱 Attach database failed error 9004

  Hi, i need to attach my db, but i receive this error: an error occurred while processing the log for database 'xyj'. Could not open database 'xyj' . Create database is aborted. (Microsoft Sql Server, error 9004). Can you help me Dear Kevin, i want to thank you very much for your help... the db is ok now... Best regards Gigi hi maiko, the solution that i used to solve my proble was: - create a new db with the same name of the lost db; - put the db in emergency mode; - stop sql service and replace the mdf file; - start sql service; - the db is probably corrupted for the disk crash...and you have to reindex all table. bye Gigi I have these exact problem but on sql s ...Show All

• Preeteesh OLAP Analysis Services - Remote Connection issue

  Hi! does anybody tell me how to connect remotely to an OLAP Analysis Server I have defined a local windows account on the OLAP server and added it to AS cube roles. Despite that I still can't connect remotely to the AS server. Thanks, Chris If this is about connecting with SQL Management Studio (or BI Development Studio) to Analysis Services 2005: - you need to have a Windows account in the domain of the 2 machines (the AS2005 machine and the client machine from where you want to connect remotely) - temporarily make the user a server administrator on the AS2005 (to eliminate the potential permission problems); you can do this with SQL Management Studio, right click on the server ...Show All