Answer Questions

• SolTecLLC Dialog security with different instances of a service

  I am in the process of evaluating the use of Service broker for messaging in a load balanced configuration, and am not having any success.  My configuration is as follows.   1) Master database on Box #1 which is the initiator of all dialogs 2) Target database on Box #2 3) Target database on Box #3   One of my goals is that the databases on Box #2 and #3 are as close to identical as possible.   My ...Show All

• JulianSerna File.Exist Access

  Hello, In reporting services, for one of the report, I need to look in to a folder to see if the image exist. If the image exist then display that image or display other temp image.  I know I can't do file.exist function in embeded code. What policy and permission do I need to modify in order to have report to be able to look in to a folder and see if the file exist Please, help. Thanks, Darcy ...Show All

• MARIU5 Welcome to the Notification Services Discussion Forum!

  I'd like to welcome you to the SQL Server 2005 Notification Services discussion forum.  This is a place where you can ask questions about scenarios, deployments, technical questions, or just simply troubleshooting questions. Notification Services is a part of SQL Server 2005 that enables event processing and notification distribution at Internet scale.   I hope it becomes a vital part of your organization's information distributi ...Show All

• Erik Ropez Access vs. SQL Server

  Dear experts, I am currently using Microsoft Access and the current size of my database is about 250Mb. I need to incorporate an additional set of data which could potentially double the size of the database or more. I am considering whether to switch to a more professional database manager like SQL. I have the following questions: 1. How much data can Access realistically handle before performance starts to degrade materially 2. What i ...Show All

• RoxanaT save unicode data into MSDE SQL

  Dear Expert: I am facing a problem which is after the Asia characters saving to SQL server (MSDE version), value in the field will be showed in all question marks, the develop enviroment which I used is Visual Studio .Net 2003 C# and in Windows XP Sp2, the system is already configured to Unicode, I have also set the field type in database is nVarChart, when I manually key in these Asia characters into the database, it shows the correct word, w ...Show All

• John M-W Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

  After getting an RPC error when trying to login to my server via either consol or Terminal services, then rebooting, I can no longer connect to SSIS Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ Connect to SSIS Service on machine "BG-22SQL" failed: ...Show All

• Keith Organ referenced relationship error

  I try to add dimension with referenced relationship. I defined everything like explaination in Books online, but when I try to save cube, I always get message: "Cube 'Cube' cannot be saved because of the following errors: Errors in the metadata manager. The 'Key' intermediate granularity attribute of the'IntDim' measures group dimension does not have an attribute hierarchy enabled." I enabled this attribute hierarchy fo ...Show All

• Tim Haines connection string based CREATE CUBE supported in AS 2005.

  Hi, I am trying to use the CREATECUBE functionality in AS 2005 through connection string property, but getting following error: Microsoft OLE DB Provider for Analysis Services 2005: The following system error occurred: Unspecified error . csSourceDSN=PROVIDER=MSOLAP;DATASOURCE=WOTTRANSUBHSXP\DEV;INITIAL CATALOG=National; CREATE CUBE [National] ( DIMENSION [Line], LEVEL [All Line] TYPE ALL, LEVEL [Line], LEVEL [Brand], LEVEL [I ...Show All

• al kerr Dynamic Login & User Creation

  Hello. I'm trying to create a new login and username inside a trigger using variables. This code works: create login testUserName with password = 'testPassword' The problem comes when I try to use variables for the username and password like this. create login @username with password = @password Does anybody know how to get around this problem BTW, the error message it gives is this, but I really doubt that semic ...Show All

• Jason10001 rda localconnection

  get the following erroer when trying to connect to local db on ppc both emulator and device using vb 2005 to create a PPC 2003 appliction Unknown connection option in connection string: provider. the error occurs at the following code rdaPress.LocalConnectionString = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=\My Documents\newsprint.sdf" any help would be appreciated Thanks GS ...Show All

• SlowLearner Why can't the password be saved??

  Hi! I want to modify a package stored on the server from my client machine, and everything goes great. The only problem I get is that when I try to run it by double-clicking it I have to re-write the password in the connection string, i.e. "pwd=asdasd", because it is not saved by the package itself even though the checkbox in the Connection Manager tab (in the SSIS Designer) is checked. What can I do to save it automatically ...Show All

• fcp Bug in Flat File Connection Object: Risky!!!!

  I was wondering if any others on this list are getting a bug with the Flat File connection object --where in both csv (coma delimited) or flat files (tab delimited) where strange characters(like two bold vertical lines)   are appearing in the file viewer while setting up a connection forcing the CRLF to end in the wrong place. They look like two bold vertical lines Im testing the same files with both the old DTS from SQL Server 2000 a ...Show All

• Rik SQL Server 2000 stop responding

  Hey We have a MS SQL 2000 with SP4 running on a Windows 2000 Server with SP4. Hardware is a HP DL380 G3, with 3Gb RAM. We have a problem with the SQL stop responding. Rest of the system is function okay. There are no error in any logs.... not in event viewer, MS SQL, HP.... A restart solve the problem and everything works fine for some dayes. I can't find any systematic in when the problem occurs. Please help! /Romme ...Show All

• kalpna server is not a subscriber (SQL2005)

  Just setup 2 boxes w/ SQL Server 2005 (Developer Ed) (SP1) Server A: Tablet PC running XP (publisher/distributor) Server B: running Win2K (subscriber) Setup replication and recv'd error: 'server B is not a subscriber'. This error is very vague and does not offer any direction to look for a solution. unable to locate help on a solution from online books. thx. for your review and input to this issue..bt ...Show All

• RG314 FTP Delete task in SQL agent

  I have a FTP task created using SSIS that need to delete lot of files in a directory. This task is working fine if I'm Executing the SSIS package manualy but not working if I'm scheduling the SSIS package in SQL agent job. Anybody have faced this kind if situation is there any solution for this . have you gotten a resolution on this problem I am having the same issue on a FTP send task and it works fine when I ...Show All