Answer Questions

• MSNasianuk join problem

  Hi All I am tring to get some data from the customer table and linking it to a view select ca.account_status, cs.code from customer as ca inner join v_customer_status as cs on ca.account_status = cs.description The reference between the tables is the account_status and the description The error I am getting back is: Server: Msg 446, Level 16, State 9, Line 1 Cannot resolve collation conflict for equal to operation. Not sure ...Show All

• Loane Sharp since uninstall of ADAM service does not start anymore

  hideho, since the uninstall from ADAM and delteting the VSTFS databases and reboot the sqlserver cannot be started anymore, not after many reboots and trials with whatever.... does anyone have expirences on that problem already Irie Mikky many thanks, a lifesaver Try checking what network protocols are enabled for the SQL Server instance in the SQL Computer Manager.  If the VIA protocol is enabled disable it and then try start ...Show All

• Ben Hall (UK) SSIS Send Mail Task - Failure Sending Mail

  Hi Everyone, Hopefully someone out there will have an idea as this is driving me nuts. I've setup a task to email on success/failure and keep receiving the following message when executed: Progress: The SendMail task is initiated. - 0 percent complete [Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.". Progress: The SendMail task is completed. - 100 percent complete Task Send Ma ...Show All

• Damjan_D COnfiguring Number of records per page?

  Is there a way I can specify how many records per page should be displayed > This is a very basic functionality that needs to go in the deployment at any cost for us ...any ideas. thanks How about in a Matrix Here's a working example. The attached report has a self contained dataset and the same table twice, once using a list control with groupping applied. Hope this helps. < xml version="1.0" encoding="u ...Show All

• Trent Swanson Copying dimensions using XML

  Hi, I have created a number of dimensions for a project, each with multiple hierarchies etc. Now, due to a late-breaking spec change, I have had to quite seriously alter the underlying DSV, and without thinking about it I renamed it as well. As far as I can tell, using the VS UI, I will have to re-create these dimensions from scratch, using the new DSV. Is there any way I can re-use the existing dimensions and edit the XML to point to t ...Show All

• ReinerZ Securables for Application Role in Management Studio do not stick

  Securables for Application and Database Roles do not show after they have been setup. I do the following: Select an Application Role from Database -> Security -> Roles - Application Roles and select Properties from the context menu Select Securables page Select Add on the Securables panel Select a couple of objects to add Check some Explicit permissions for each securable object added Click on OK No errors are re ...Show All

• Hey all How to import/export databases from remote server to local SQL 2005 Express

  I've successfully installed SQL2005 express edition and SQL Server Management Studio Express. All seems well except there does not appear to be any way to import databases from other servers to my local server. The remote servers are running SQL Server 7. In the Management Studio Express I can connect to the remote databases and work with them, but I can neither import them into my local machine, nor can I export from remote to local (the opt ...Show All

• William Lowers How to reference different databases on different servers in one query

    Check out the 'Linked Servers' topic in the Books Online I think I'm not using the right syntax I've created the linked server by: sp_addlinkedserver @server = 'REMOTESRV' , @provider = 'SQLOLEDB' , @srvproduct = '' , @datasrc = ' 129.113.271.58 \ku.univ' The log was: Command(s) completed successfully. I then tried to issue an SQL Statement as you ...Show All

• inetcnslt Missing Notification Services Folder in Object Explorer

  Hello, I'm trying to understand how Notifications Services work and i'm looking under Microsoft Sample Tutorial for more information but I always get stuck at this point... To create the instance of Notification Services In Object Explorer, right-click Notification Services and select New Notification Services Instance . Click Browse , locate the TutorialICF.xml file, and then click Open . The default location for thi ...Show All

• Mukhthar Deploying Custom Task to Production Server

  This seems like a rather simple questions that I've hesitated posting for a day now, but as of yet I can't really find an answer through my searches online. My SSIS package is using a couple of the Konesans Transforms, this worked fine on my development box with my dev SQL server. The time has come now to deploy my package to my production SQL server. The instructions on installing the transforms on my dev box all uses Visual Studio to ad ...Show All

• Eckmar The package execution failed. The step failed.

  when i right click and execute the package from the Management Studio, it runs fine, everytime. When i schedule a job to execute it, it fails, everytime. "The package execution failed. The step failed." i have made sure that the package and job ran using credentials with more than enough access to everything. Still, with no luck. PLEASE! I am at my wits ends here, and the boss is getting antsey... Any and all help is greatly a ...Show All

• Timothy J. Suhr importing and exporting tables

  Hello Everybody, Not sure if this is the correct Forum, anyway lemme me know your views. I have SQL Server running in two remote machines (in different geographical locations). I need to import a database from one SQL Server installation to another installation. What is best possible solution: 1) Transfering the .mdf and .ldf file from one installation to another installation 2) Generating the records of all the tables i ...Show All

• Robert E. Spivack Using SMO and ClickOnce deployment

  Hi, I'm writing an app that I want to use ClickOnce deployment with. The app may have to ask the user for the Server and Database name to connect to if it is the first time it has been run. I'm thinking of using Sql SMO but I see the requirements for this include MDAC 9.0. Can anyone tell me how this could affect a clickonce deployed app I'm no export with clickonce, sorry. I'm hopeing it is possible to deploy MDAC 9.0 via clickonce too. Any hel ...Show All

• Aquila_au How to get the URL to access a report?

  hi, all I am just starting to use the SQL Server 2005 report service. And I also made some reports, and I am thinking how to get the URL to access the report, especially when I have some parameters need to be passed into the report. Basically it's something like this: http://servername/reportserver /Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&Year=2002 where Year is a paramet ...Show All

• ExpediteBiz Internal Activation - calls stored procs in other DBs

  Hi all I am using internal activation on a queue to process the messages, should an error be encountered I call stored procedure A in the same database to log the error. Part of the processing in stored procedure A is a call to stored procedure B in another database (on the same server), however I have not been able to get this call to B to work. Currently I get the error "The server principal XXXXXX is not able to access the database YY ...Show All