Answer Questions

• Bobo1234 Updating a text field with a sub-query

  I have always avoided text fields because of lack of motivation to learn the ways to work with it...but I can't avoid it with the current project I'm working on. I need to copy information from an old database into one with similar structure...a lot of the information is there, but some things still need to be synch'ed up.  The problem I'm having is copying the description field from the old database to the new one because they are text fields.  If I were doing this with varchars I would use the query below...but since they aren't I get the "can't use text fields in sub-queries" error.  Can anybody explain to me how I would accomplish this task UPDATE courses SET courses.Description =     (SELECT Descr ...Show All

• Chatanya Question about user management

  Good evening, I have to admit that I've just started using Reporting Services. I've just managed to intall it on a Windows 2003 Server, running SQL Server 2005 Developer Edition. The first issue I've noticed after installation is associated with the ability to manage the users that have access to the reporting services, as well as what roles they are associated with. After a bit I figured that reporting services was using Windows Users. That's not much of a problem in my situation, although I'd prefer if it was something more like ASP.NET 2 Membership and Roles. Nevertheless, eventhough I've managed to find this one out I didn't seem to find a way to manage the permissions of the users. Could someone help me out on this one ...Show All

• ForEverLearning SSIS vs. Excel's CSV parser

  Hi All, I’ve been battling with a client who’s supplied us with what they consider to be a legitimate CSV file. 1st off let me say that I understand that there’s no CSV “specification” per say, but here’s the situation regardless. The client has a test string in one of their fields that looks something like this: He said "STOP" so, of course he stopped The CSV best practice requires that you double quote, so a valid CSV filed would look like this: He said ""STOP"" so, of course he stopped Once this is placed into a comma delimited CSV it looks something like this "Col1","Col2" "He said ""STOP"" so, of course he stopped","value in col2" --------------- ...Show All

• Grigs Database mail configuration

  I have configured database mail using the wizard, but when I try to send a test message I receive the following error: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 Exception Message: Cannot send mails to mail server. (Failure sending mail.) Is there some more configuration I must do I have enabled mail using the surface area configurator. Thanks I would try using xpsmtp mail and forget standard SQL mail...it is a pain in the rear. You can get it (yes it is free) here http://www.sqldev.net/xp/xpsmtp.htm It is easy to set up and use and has teriffic documentation. I know this is not an answer to your question but I hope th ...Show All

• Eias Nabhan SAP connection

  Hi everyone, We are trying to send data from SQL into SAP-BW as far as We are it look like every thing is set at SAP side but We can't send data. Does any one has information about what should I set in SQL side because all the information that SAP people konw is that I have to create a user in SQL but they don't know any thing about the security. Thanks. It is actual for you now Hi, I'm using RFC via SAP DB Connector, I set the information at SAP side to connect to SQL and it's working fine I can see tables and it's data with in the SAP data source builder but when I try to upload data into an infoobject I can't read any data SAP sends the message no idoc read from source system. ...Show All

• R Raghu NS with Remote DB Server?

  Hi everybody, In good old times with a one server everything worked fine. Now I have 2 servers: web server + DB server. I have deployed NS Instance to the Web server with DBs created on the DB server. Installs nice and easy. However, my Subscription management App (ASP.Net based) crashes with message: Login failed for user ''. The user is not associated with a trusted SQL Server connection . [NSException: Notification Services failed to get the metadata for the specified instance. Instance Name: NSInstance SqlServerError: Source: .Net SqlClient Data Provider Number: 18452 State: 1 Class: 14 Server: DBSERVER\DB Message: Login failed for user ''. The user is not associated with a trusted SQL Server connection. Procedu ...Show All

• haihtomy Using CTE in data paging

  I explore a possibility of using Common Table Expression (CTE) instead of temporary table in data paging. But the problem is that it looks like I can reference CTE only once in my script. I need to return data for a current page as well as the row count for entire selection. Here is my script: with names(row_num, first_name, last_name) as ( select row_num = row_number() over(order by last_name, first_name), first_name, last_name from contacts where last_name like 's%' and first_name like 'm%' ) select row_num, first_name, last_name from names where row_num between 41 and 60 -- 3rd page order by row_num select count(*) from names go It selects 20 records, however it displays an error when it tries to execute select count(*): ...Show All

• dtsn ability to use variables in package configurations and set their values at runtime

  Hi, My scenario: I am using a FTP Connection Manager and the configuration setting for it is being set in the package configuration xml file. So the xml file contains the Ftpserver, FTp server username and password. The package is picking up the values from the xml file and is executing successfully. I have to do this because I was not able to provide an expression to the Connection Manager Server Password property. Now, I want to pick up the ftp details from a database table and set it in the xml file during runtime. Is this possible OR something like using the <Configuration ConfiguredType="Property" Path="\Package.Connections[FTP Connection Manager].Properties[ServerPassword]" ValueType=" Variable "><ConfiguredValue ...Show All

• EKRON sp_cycle_agent_errorlog fails/SSMS recycle Agent log fails

  Hi, The sp_cycle_agent_errorlog stored procedure fails on our primary SQL Server 2005 server; the SSMS context menu option (right click Error Logs under SQL Server Agent in object explorer) to recycle the agent log also fails. If we run the SP then we get the following: Msg 22022, Level 16, State 1, Line 0 SQLServerAgent Error: 32. If we try the SSMS option we get this (in a nice dialog): Cycle agent error log failed for JobServer 'UKSQL04'. (Microsoft.SqlServer.Smo) Additional information: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) SQLServerAgent Error: 32. (Microsoft SQL Server, Error: 22022) We are running SQL Server 2005 x86 Enterprise E ...Show All

• sidhuvirgoster transaction log size growing very large

  hi all, my tlogs at the subscriber are growing very large irregardless of my recovery mode. any help using snapshot-push replication thanks, joey SQL 2000 I disagree. I have the same issue on all of my 10 ten subscribers. I run a "backup log [dbname] with truncate_only" every 12 hours to keep the log manageable. hi all, this is very much replication related. anyway its  not only tlogs that is growing. my data files are growing as well since i turned 'delete record that match the row filter option on" i am replicating to datamart and dealing with large volume of data every end of the week.   i think i can mimimize this the si ...Show All

• The Markus How to apply SQL Server 2005 Express SP1 to the version of SQL Server 2005 Express which installs with Visual Studio 2005?

  When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media. How can apply SQL Server 2005 Express SP1 to update this existing instance Currently, if I run this query: SELECT @@version I get the following: Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2) After applying SP1, I should get 9.00.2047.00. Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1: http://msdn.microsoft.com/vstudio/express/sql/download/ Thank you, Bashman ...Show All

• KevinBurton Reusability & SSIS - issues they do not write in books about

  I have a simple requirement: Each package needs to have Error Handling - which needs to Execute a SQL statement. It's the same Stored Proc - where each package passes in its ID. Ok - I get that part about creating a custom task and so on for reusabilty. But - lets say that after deploying this task in 20 packages - I need to change the name of the Stored Proc. What is going to happen in that case Correct me if I'm wrong - but after deploying the new version of the custom task - do I need to go to each package and update the reference to new version Jamie Thomson wrote: Jon Limjap wrote: I think for what you want to do you have to save your script in a legitimate VB 2005 class library and register that class library ...Show All

• mvsure Row height issue on export to Excel

  Hi all, I've been having some problems with a report on export to Excel. I have four tables, contained within a rectangle at the top of the report, followed by a second page of tables dynamically generated by the data being fed into the report. On export to Excel, the top sections of tables appear to export with a fixed row height that does not show all of the string contained within the cell. I've had similar issues before with "title" textboxes, but these are usually easily solved by expanding the height of the box within the report. In this case, this hasn't worked! Any idea Regards, Jon If you have other tables at the same horizontal level, or other ...Show All

• Coroebus What is necessary to create SDF-Files on desktop legally?

  I want to write a PC application that prepares a SQL Server Mobile Files (.SDF) and sends it to a PocketPC. I get this error message: "SQL Mobile usage is restricted on this platform. To use SQL Mobile, you must install SQL Server 2005, Visual Studio 2005, or the Tablet PC SKU" If I install "SQL Server 2005 Express" the error message disappears and everything works fine. Question: Is it allowed to create SDF-Files if "SQL Server 2005 Express" is installed or is it necessary that my customers buy "SQL Server 2005" Hi,     SQL Mobile is UNRESTRICTED on Windows CE based devices.     But I could not figure out why do you want SQL Mobile to be used on DESKTOP.  &nbs ...Show All

• White Hawk SQL Server CE doesn't show in Reference dialog

  I already have VS2005 SP1 installed and after installing : SQLServerCE31-EN.msi SSCE31SDK-ENU.msi SSCE31VSTools-ENU.exe When I create a Smart Device project and and try to add a reference to SQL Server CE only the old version (3.0.3600.0) shows up. How do I get the new one (3.1) to show up Can you post the exact error messages you are getting System.Data is a namespace installed with Visual Studio, so that sounds unrelated to SQL Server CE Hi JadeS I am having the exact same problem and I am losing my mind! I cannot get the new version of the System.Data.SqlServerCe.dll file to appear in the references section. Yes, i can browse to the correct file, and it then appears in the referenc ...Show All