Answer Questions

• sweetyk18 debugging stored procedures in BIDS

  Is it possible to debug stored procedures in BIDS If I go to the 'Server Explorer' --> 'Stored Procedures' and right click on my stored procedure I see nothing related to dubugging from drop down menu. ...Show All

• Deadlock42440 SQL Server Indirect Package Configurations

  Hi all I am trying to create indirect package configurations so that: 1) My configuration data is stored in a SQL Server table, and 2) The location of that table is stored in an environment variable. Achieving #1 is easy, but when I hit the "Configuration location is stored in an environment variable", I strike problems. I can specify a environment variable no problems, but there doesn't seem to be anywhere in the documenta ...Show All

• Zulban multiple instances of Reporting Services - is it possible?

  Hi there, is it possible to host multiple Reporting-Webs and Reporting-Databases on a single Server What I want is to create two virtual directories http://myserver/reports http://myserver/reports_internal and each web points to a different Database with different reports. Best regards Markus Yes, this is supported and should work fine. It would be ver ...Show All

• Hanas 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" ...Show All

• OliverC XML data source

  Hi! I would like to use a xml file as a data source's configuration file: the user should change the data of Data Source and initial catalog values on it, and then I would take those values and use them to creat the connect string. But I don't want to publish this xml file. Is there anyway I can read from a xml file, not using http://server/file Thank you! There are a couple of ways to ...Show All

• Zycl0ne Globale Function

  Hi ! Is it possible to declare a gloable function in reportServer that all reports could access For each reports that use the same function i've declared it in the code property of the rapport but it will be easier if i could share the function for all reports. Thanks ! You could move the functions into a custom assembly. Check the "custom assembly" section of this BOL page: http://msdn2.micro ...Show All

• Heinz Blob as text

  Hi, I have a conversion application which convertts an access database to an sql server(different versions). I'm using stored procedures. The thins is that I export the OLe Object form access to SQL varbinary. what I do is to convert the binary data from the OLE Object to string using ToBase64String. The thing is that when I execute the SQL statement I get the following error: Error:Operand type clash: text is incompatible with varbinar ...Show All

• Sridhar Text field problem

  Hi, in MSDN is written reguarding WRITETEXT : data Is the actual text , ntext or image data to store. data can be a literal or a variable. The maximum length of text that can be inserted interactively with WRITETEXT is approximately 120 KB for text , ntext , and image data. I am tring to insert a text which has around 9000 charcters using WRITETEXT which is less then 10KB , but surprise: after the execution of the sq ...Show All

• coewar Dynamic Database Source Changing

  Hi, I am building a data warehouse for a customer who has systems located in two different countries. I need to import that data from four seperate databases, which all share the same structure. To do this i have created 20 packages to import that data from the source database. What i would like to do, is at run time set which database the SSIS package should get its data from. In sql 2k this was easy with a global variable that was ...Show All

• tanging SQL Server International Learning Survey

  If you live outside of the United States or Canada we want to know more about your experience learning about SQL Server. How did you initially learn to use SQL Server What are your preferences for learning about new features What can we do to make SQL Server easier to learn and use Send email to wssinfo@microsoft.com to obtain a secure code and link to participate in a survey. Complete the survey for a chance to win a portab ...Show All

• rstuven Establishing a remote connection..!

  How can I establish a remote connection for using remote database in SQL Server 2K5 Thanks. my scenario : my computer is into a LAN. I want to connect from my PC to a database on another computer in this LAN. I have username and password for logging in to the another computer in SQL Server Authentication mode. please help me! Take a look at this link: http://msdn2.microsoft.com/en-us/library(d=robot)/ms188721.aspx ...Show All

• Babant using string[] as a data type in table definition

  Hi, How can I use a data type like : string[ ] to define a column in my database that is connected to my C# project Thanks, Aya. Ok, what can I do if I need to create a table that contains enumerator list as : {x,y,z,..........} Use the VARBINARY datatype.     -- Adam Machanic Pro SQL Server 2005, available now http:// ...Show All

• Fabio Mattiussi Scheduling the SSIS Package

  Hi, I want to schedule an SSIS package to run always. So I tried scheduling the SSIS Package as a Job in the SQL Server Agent and I have set the Schedule Type as " Start automatically when SQL Server Agent Starts ". I have used an WMI Event Watcher task to raise an event when the file dropped in a folder. And I have provided the configuration file also properly in the job. But still my package is not running properly. The ap ...Show All

• donjuawnu Cube Roles - How to restrict access to certain members

  I have a dimension called Account that has five levels. I'm trying to define a cube role to deny access to accounts in the lowest level that starts with the letters GL. I tried applying a filter in the dimension data tab in the role designer, however, this only seems to create a static rule. The account structure gets updated all the time and I want to restrict access to all accounts that start with the letters GL now and in the future. When ...Show All

• Old John SQl sa user problem

  I am having following problem: Please help me. Cannnot connect to IIG/sqlExpress login failed for user 'sa'. The user is not associated with a trusted SQL server connection (Microsoft SQL Server Error 18452) Looks like you are using sql authentication while the mixed mode authentication is off during installation. You can turn on mixed mode authentication or use intergrated authentication. ...Show All