Answer Questions

• simon_ Execution of SSIS package - security issues

  Hi all, I am currently trying to execute my first SSIS package and am having a lot of trouble with (what i believe to be) SQL security. During the development of the package i was testing all my connection managers with the sa account. Now that i have deployed the package i want to use another account with less privelages so that my setup is more secure. I have created a new login which maps to both the database my SSIS package is using and also to the msdb database. I have created a schema and user in each of these databases which i had initially set with minimal rights. This caused certain parts of my package to fail. I then set up the login with a sysadmin server role which worked no problem at all. Finnally i then gave the schema for t ...Show All

• John Veson Need information about protocols in SQL Server 2005.

  I want to know the followings for an installation of SQL Server 2005 which is installed by accepting all the defaults: 1. Which protocols under SQL Server 2005 Network Configuration are enabled by defaults 2. Which protocols under SQL Native Client Configuration are enabled by defaults Will the answers for #1 and #2 vary: - among different editions of SQL Server 2005 including Express - among different Windows O/S - if SQL Server 2005 are installed by upgrading an existing instance of SQL Server 2000 or MSDE 2000 - due to the service accounts used by SQL Server Browser service or SQL Server Database service - due to any other factors 3. Which protocols under SQL Server 2005 Network Configuration need to be enable ...Show All

• A kid DateTime parameter format issue?

  Hi All: I create a report with a DateTime parameter, i would love to use DD/MM/YYYY this format, but it doesn't work . it works when i change to usa datetime format ,YYYY-MM-DD, any helps are appreciated. thanks Nick Hi, I have a report which has a datetime parameter, when i choose the datetime from calendar control , then click view report button. if i choose 13/12/2006, it would give a error, because the report think it's 13 is month , how can i fix this issue. also i want keep dd/MM/yyyy format Thanks Nick hi Nick this is an example of what I use this is put in as an expression - Layout view on a table =Format(Fields!Date3.Value, "dd/MMM/yyyy" ) hope this helps ...Show All

• Chintan Vyas Visual C++ 2005 (C++/CLI) - Newbie with ADO

  Hi, I've been working for about 20 years now with databases on other platforms but am at my first step with ADO. I created an application which is drawing as requested different forms on screen using GDI+, eventually DirectX. Now I'm at the stage of saving several infos into a Database. For simplicity, I would like to use a database for which there is no need to install any other components. I thought of using Access Database but I realized that I'm unable to create it except from Microsoft Access which is not installed on my machine... When programming with Clarion (SoftVelocity), apart interfacing with Oracle, any other files (ex: TopSpeed files) could be designed from within application designer and then created from scratc ...Show All

• DaveRogers Report Title

  I have a report with three datasets and I would like the report title to adjust dynamically based on the column width of each dataset's report. I would appreciate your help in making this change. ...Show All

• steal Dealing with quotes in a quote encapsluated column

  I know this issue has been raised here before, but I have a different angle/question on it. Flat File source, SQL Destination. No column from the source file has a consistent real width, just consistent to be less that the SQL column. Issue: CHAR(12), SMALLINT, CHAR(78), BIGINT "100012",0,"This is the ""Memo"" of the record, it needs to be imported.",12 This row errors out due to the double quotes around the word MEMO. Additionally, the entire package stops processing due to there being a comma in the memo after the quote encapsulation is escaped. Has this issue been addressed in any of the SP's If not, how about this thinking: 1.) Character index the pattern ," and take the ...Show All

• dfl import database

  I need to import a database from MS SQL 2000. I created the database. Then I create the database scripts and run them in sql express but I get this error. "The specified schema name "username" either does not exist or you do not have permission to use it." I have also tried to use DTS on MS SQL 2000 to export the data into text file. I do not have the ability to copy the mdf files and attach them in SQL express or make a backup. Thanks for the links it make a little more sense now. Hi, Thanks for the information, please click on Help full button if you feel answer is usefull. Hemantgiri S. Goswami SQL Server introduced the schema whci ...Show All

• grellsworth Error in Message Box display when report is deploy in the Production Server

  Hi All Experts, I deployed a sample report in the production server with a date validation in it. The validation is working properly in the Report Designer with this code, that checks if the user inputs an incorrect date range. Function CheckSignificantDate(StartDate as Date, EndDate as Date) as Integer Dim msg as String msg = "" If (StartDate > EndDate) Then msg="Period From should not be later than Period To" End If If msg <> "" Then MsgBox(msg, 16, "Report Validation") Err.Raise(6,Report) 'Raise an overflow End If End Function Now, the problem is when i access the report via URL and then put an incorrect date range. The error message appeared in the other pag ...Show All

• gve2002 Error creating first SQL Express database via VWD 2005 Express: "User does not have permission to perform this action"

  I get an error dialog when I try to create a new SQL database , both via the Add New Item dialog and the property wizard of a new SqlDataSource control. The error is: Local Database File: User does not have permission to perform this action. I've searched for help with this. I ensured the App_Data folder exists and I added the local ASP.NET account to the group that have R/W access to it (although the RO flag is in an unchangeable tri-state on the folder). The SQL Server Express error log is clean and indicates full functionality. Everything is running locally. No VWD installation errors. Any ideas Thank you! Hi Mike, Thanks, we found the problem. Our Local Secu ...Show All

• IamHuM restore msdb - MSDE 2000

  hi. i'm trying to restore msdb (dmp)... the dmp was taken from MS Desktop Engine 2000 and i'm trying to restore it to ms sql server 2000. is this possible if not, how can i restore msdb to MSDE 2000 can't remember the command. (matter is a little urgent) Thanks! The structure does not differ from MSDE or a greater version of SQL Server 2k. use the kb article here to go the offical way. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- First, Stop the SQL Server Agent Service, then start the SQL Server Service and execute it: RESTORE DATABASE msdb FROM DISK='c:\backup\msdb_backup.bak' Regards and Happy new Year, http://sqlserver2000.databases ...Show All

• Tim Wagner OLE DB or ODBC error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

  Hi, I have one client and one server. In both hosts I created an OS-user named User1. The user have been given various role under the prefix SQLServer2005. The default instance of SQL Server and instance (background-process) of Analysis Service are also run under User1. I connected via Management Studio to Analysis Service directly in the server. I set the permission to access Analysis Service to Everyone. This means everyone should be able to use Analysis Service. I have set ODBC data source to the server. Testing was successful. I created a project to create a cube. The tables are fairly small (total 300 MB, biggest one 290). On project setting (created at client) I set the server host as deployment target. I ma ...Show All

• yanivpinhas "Now" for time dimesion selection

  A common requirement we see is to report against a sliding time window. However, as far as I can tell, SSAS has no native ability to give me the "Now" time dimension member (that is, the year, month, day, ..., dimension member for the current moment in time). Is that correct Are there any techniques people have used to derive that info It seems like something other people must have run in to. Kevin, You can use the VB Now() function and then format the result to build a member matching the format you use for the date in your time dimension. Here is an example against "Adventure Works". I had to subtract 900 days from the current time to render a member that exists in the "Da ...Show All

• Tito Jermaine 64 bits known issues and limitations

  Hi, It appears that quite a few limitations and issues are to be considered when contemplating switching to a 64 bits edtion, regardless of the vendor. When switching to 64 bits, lot of things can stop working as you expect, in any section of the SQL Stack. Two Questions: - Is there any comprehensive list of known issues as well as possible workarounds (That would let me know quickly if I would be in major trouble) - Any roadmap to get these limitations or issues eliminated in a not too future release Thanks, Philippe ...Show All

• lali.b Incremental updates query not working for proactive chaching

  Hi all, I'm trying to set up Proactive caching on a large dimension with incremental updates. I have read all the info on MSDN and followed what seems like a straight forward process but am still having difficulties. I've enabled proactive caching on the dimension with the following settings... Update the cache when data changes: Silence Interval - 10 secs Silence Override - 10 mins Scheduled Polling: Polling Interval - 10 secs Enabled Incremental Updates - TRUE Polling Query; Select Max (DocumentKey) As MaxDocumentKey From DIMENSION_Documents Processing Query; Select DocumentKey, DocumentBaseTypeName, DocumentTypeNa ...Show All

• ThE ViKinG SQL 2005 Uninstall/Install Problem WMI Configuration related

  Hi, I'm the following encountering WMI error message when invoking SQL2005 setup. The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine CAPRICORN Error:2147942405 (0x80070005). For help, click: http://go.microsoft.com/fwlink LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=70342 I'ver found other postings related to WMI errors and tried the WMI fix batch, but to no avail. I noted the error code I have is 2147942405 which is different from other postings. And from examining setup log generated, this seems to be security related, but cannot find much help combing thru msdn/google, etc Any help is greatly appreciated. -Jam ...Show All