Answer Questions

• jturpin Connect to sqlexpress from network computer

  Hi Please if any one can answer.I am developing .net vb app sqlexpress database. In single user work ok.In multiuser from other computer on network I cannot get data.Any form without data workok fine . The error I am getting is as follows. Application attempted to perform operation not allowed by the security policy. request for permission of type 'System.data.sqlclientpermission,system.data, version=2.0.0.0.,culture=Normal, publickeytoken=b77a5c561934e089' Zaabdullah Hi Zaabdullah, You will most likely get a better response by posting on one of the VB.NET forums. It seems that the security policy for the Assembly needs to be corrected to allow acc ...Show All

• Dordorgum Trouble converting a Varbinary (Object) to a String through Script task

  I have an Execute SQL Task that queries for the contents of a file (which is declared as a varbinary type). My SSIS package needs to write these contents into a temporary location, so what I do is that I pass the result into a System.Object variable. I then use that variable in a Script Task. Problem is whenever I execute my script task and DirectCast or CType the variable to a string (which is what the contents of the file is), I get a "Conversion from type '_ComObject' to type 'String' is not valid." Any ideas on how to go about this problem Solved it... I just used an Export Column data transformation task on this. ...Show All

• DanMeyers Breakpoints in script component

  Does anybody know if the breakpoints are supported in the script component I've got a script that I want to debug and make sure it's doing what it should be but everytime I set a breakpoint it loses them when I click ok on the script editor. I've tried setting precompile to false but thats not working. What do I need to do to be able to use breakpoints Saitham8 Saitham8 wrote: why The usual time/resources limitations - did not have time to implement them. go figure. (somebody really needs to create a work around for this time limitation thing :P ) any chance of it getting put in at a later time and is there a work around the only way i know how t ...Show All

• Tryin2Bgood Daylight Savings change

  All, I am curious if there is anything to worry about with the recently adopted change to the Daylight Savings settings and SQL Server Are there any required patches, suggestions, etc Thank you The link above is right. In short you will need to update your operating system, which should happen automatically through Windows Update, but there is no need to patch SQL Server. We were recently reviewing all components to check if there is potential area that needs updating, and we have not identified any. Regards, Maciek Sarnowicz Take a look here http://www.microsoft.com/windows/timezone/dst2007.mspx Denis the SQL Menace http://sqlservercode ...Show All

• Puzzled T-Log : Recovery Model

  Does Transaction log in Simple recovery model behave like Full during the transaction or it behaves like Bulk Logged To make my Q simple, if I do BULK operation (BULK INSERT) & my DB is in simple recovery model, does T-Log records BUlk Operation OR it does it log FULL until the BULK operation is complete. In SQL 2005, when T-logs are restored in Log Shipping, is the destinatin DB available, or it goes to Loading state as in SQL 2000 It will not be exactly the same as either in all cases, but SIMPLE will be very close to BULK. -- Peter Byrne Microsoft SQL Server Storage Engine This posting is provided "AS IS" with no warranties, and confers no rights. wrote in message news:cd6210eb-d7bf-40d7-9e4b-4 ...Show All

• hemo Can co-installations of MS SQL 2005 Express and Oracle 10g XE database server interfere with MS SQL?

  Hi - I may not sound desparate, but I really am. I have spent many days now trying to install and re-install Microsoft SQL 2005 Express. I still cannot connect to the database! I have read this forum and tried various suggestions, like setting the remote connections and TCP/IP + Named Pipes. Still doesnt work! The environment is Dell Dimension 24000 (I86) with WinXPPro. Out of desparation, I downloaded and installed Oracle 10g XE. It works just fine ! My question is: Does the Oracle database server interfere with connecting to the Microsoft SQL 2005 Express server Also, I notice that there are an awful lot of questions posted on this Forum concerning just getting your software up and running. Are there that many stupid folk ...Show All

• Pravindabade Unable to generate model off of an Analysis Services Data Source

  Hello, Our company is doing some basic research into using analysis services as a solution for our customers. I've taken our database and built an analysis services project in BI Studio and deployed it to Analysis Services on my local machine I connect to Reporting Services in Management Studio, create a folder for the cube, give my Windows user acct. Content Manager permission, create the Data Source (conn string = "Provider=SQLNCLI.1;Data Source=(local)\SQLServer2k5;Integrated Security=SSPI;Initial Catalog=STI-PDB" -- copied from the Analysis Services project in BI Studio), and go to "Generate Model". What I get is an rsModelGenerationError, sub [Create Perspective From Cubes] with a connection issue at the base: Eith ...Show All

• Sanjib SQL Execute Task

  Hi how would you use a package variable in inline sql, is there a format utilized Are there any steps I need to take to do that I currently have the SQL Execute task inside a ForEach Loop container, which has the variable mapping for the ID that i need for the SQL Execute task. I just need to know the syntax to use parameters in my query in my task. here is the current code which doesnt work: INSERT INTO LAFProcess.ProcessList (WorkListID, CreatedOn, ProcessStartedOn, Status) SELECT WorkListID, GetDate(), NULL, 2 FROM LAFProcess.WorkList WHERE Status = 2 AND LoanApplicationID = " + @[User::LoanApplicationID] +" UPDATE LAFProcess.WorkList SET Status = 1 WHERE LoanApplicationID = " + @[User::LoanApplicationID] +& ...Show All

• AlexUC SQL SERVER 2005 Backup

  I am new to sql server 2005.I am trying to set up databse backup using databse management.but some how it is not working and i am getting error after all settings done. Can any one have experience on this. plz i am in desperate trouble. I am thanksful to you in advance. Thanks, Bharat. Hi andrea, Thanks for yr reply.. But as per i know sql server agent is required if you want to take backup of live databse and i am trying to copy database to some other location on hard drive. Same way i was doing for sql server 2000.after storing databse files on hard drive i used symantec backup utility to take this on tape drive. Is this the different than sql 2000 plz want yr sugges ...Show All

• Preeteesh SQL server: How to see tables

  I have VS and SQL server database engine installed in the my office PC (Both legal copies). I would like to see the tables and like to create the new tables / databases as well for learning. How to do that Please help me.... Hi, here are some web sites for beginer tutorial , also take a look at SQL Server Books Online which will gives you idea about everything you wants to know about SQL Server. http://www.sql- http://www.sql- tutorial .net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp Hemantgiri S. Goswmai Here is a good example using SQL Server Express: http://msdn2.microsoft.com/en-us/library/ms233763(vs.80).aspx Greetz, Geert Geert Verhoeven Consultan ...Show All

• y0ngb00n XML Configuration Files -- BIDS vs. dtexec

  Hoping someone can help me out quickly on this. I have a package with package configurations enabled.  I have an XML file specified for a configuration, with the connection string being loaded from the configuration.  After configuring this, the package knows that the connection string for the connection should be loaded from the XML file.  When I run the package within BIDS, it finds the XML file at the specified path, grabs the connection string, and runs fine.  Assume for the minute that the XML file is located at c:\config\datasources.dtsConfig. Now, I want to run the package using dtexec and I thought I could specify a different location for the XML file using the /config command-line parameter.  Assume I have ...Show All

• j_a_m_e_s Error installing SQL Server 2005 editions on Windows VISTA

  There are numerous posts regarding this error when installing SQL Server 2005 on Windows Vista RTM thus I am starting a new thread in order to get resolution one way or another: SQL Server Setup failed to execute a command for server configuration. The error was [SQL Native Client]Windows user or group "\USERNAME\SQLServer2005MSFTEUser$USERNAME$MSSQLSERVER" not found. Check the name again... The error occurs when installing SQL Server 2005 Developer Edition, SQL Server Express SP1, SQL Server Express SP2 CTR (with or without the SP2 Toolkit package installed beforehand). The error occurs with or without UAC. The installation then fails. Please advise if you have any insights. SQL Server Express SP2 CTR was announced as a workable v ...Show All

• SupaDevil Problems with replicating large batch inserts

  I have transactional replication set up between 2 SQL Server 2005 databases on 2 different boxes. Both the log reader and distribution agent run in continuous mode. The distributor is residing on a third SQL Server box. We are having performance issues with replication when there are large batch deletes/inserts happening on the publisher. There is a batch job that runs for about 8-10 hours everyday on the publisher and deletes/inserts thousands of records as part of transactions. The amount of time to replicate all this data on the subscriber is around 13-15 hours which is not acceptable to our user community. While monitoring I found that the distribution database (MSRepl_commands table) at times has millions of record ...Show All

• vtortola Error when Deploying Cube

  Hey guys, Have a really strange error, I have a AS Cube designed and ready to go. Have been deploying it previosly and was erroring out due to attributes not being found in the tables. So ive worked on fixing all of them and now, i have an error message occuring and all it says is: Server: The Operation has been cancelled. I havnt cancelled anything, it doesnt show any more details for the error either.. Is there a log file somewhere that i can look further into Or has anyone had this message before I am stumpped and now its annoying me as i was so close to having my first cube up and deployed... Thanks in advance Scotty Looks like its a perfomance issue. long-running queries can lock the system as a whole. ...Show All

• Soundbyte Chart in Report Builder

  hi there I am just designing a simple chart in Report Builder - but when trying to drag any field into the value field of the chart (it doesn't change colour and won't accept any field). If I drag a field into the category or series the curser changes and on approaching the chart properties they seem to change colour. Can someone help to what can be wrong thanks Dianne Dianne, You can create a new expression to count the number of calls. Go to the entity that contains CallId. On top of the fields area of the Explorer, you'll find a New Field icon. Click on it. Alternately, go to the Report menu and select New Field. You're defining a new field for your report. Give your new field a ...Show All