Answer Questions

• Squintz RS 2005, VS 2005 and specifying printer trays

  I am trying to build a demo to prove the following can be done with SQL 2005 Reporting Services: 1. Export report as .pdf to file location. - Done 2. Use CSLA business objects with Reporting Services to reuse the object's ability to populate itself. - Done 3. Set certain reports to print from certain trays on a specific printer.  More specifically, for a certain report, I need the first page to print  from Tray 1 and all ...Show All

• Oleg_Ivanov Convert System.Net.NetWorkCredentials to IReportServerCredentials

  Hello, I have a reportviewer and I want to set its credentials with this line but I have that error. rptViewer.ServerReport.ReportServerCredentials = new System.Net. NetworkCredential (usuario, clave, dominio); Error 18 Cannot implicitly convert type 'System.Net.NetworkCredential' to 'Microsoft.Reporting.WebForms.IReportServerCredentials'. An explicit conversion exists (are you missing a cast ) C:\Inetpub\wwwroot\GescomDllo\Pr ...Show All

• Heathcliff Old Excel files after SQL2000 > SQL2005 migration

  Hello there! We are having some problems over here after our SQL2005 upgrade. If we try to use an excel file that previously accessed the SQL2000 database (same DSN name and credentials), and then try to refresh the data after the 2005 upgrade, we get the errormessage "[Microsoft][SQL Native Client][SQL Server]User 'DOMAIN\username' does not have permission to run DBCC TRACEON." We have tried to delete and recreate the DSN fil ...Show All

• GRTR Management Studio Gets Disconnected While in Standby

  Hi, I installed MS SQL Server 2005 Developer Edition on my laptop.  With MS SQL 2000, I can create temp tables and then put my laptop into standby mode.  When I come back and wake up my laptop, the temp tables will still be there because the query analyzer does not get disconnected from the standby mode.  With the new SQL Server 2005 whenever my laptop goes to standby mode, the management studio gets disconnected. A ...Show All

• Snowfun SQL Server Management Server causes DCOM errors on remote SQL 2000 Server

  I am running SQL Server Management Studio locally. One of the server registrations I have setup is for a SQL Server 2000 database on Windows 2000. The server registration uses a "SELECT" only sql account. Whenever I launch Management Studio, a DCOM error is generated on the server: Event Type: Error Event Source: DCOM Event Category: None Event ID: 10002 Date: 4/17/2006 Time: 9:34:43 AM User: [ ads domain ]\[ username ] Comput ...Show All

• l4ci query in textbox

  Can I directly write a query in textbox This textbox is in the header ="select field from tblHCVSRField where fieldid=1" I believe you can reference the value using this syntax: =First(Fields!YourField.Value , "DataSet1" ) Because it is in the head, it can't bind any dataset no, but you can create a dataset with that query and then get the column value from the textbox ...Show All

• BenJoldersma About Login Account

  Hi everyone, I have a simple question for you which is too important for me. My question is about logins in my own(local) server. I know that my local server(my computer's server) has to default login account which are called sa and BUILTIN/ADMINISTRATOR. While I am using my own server, I do not know which default login account is used by my Server since I use windows authentication while connecting to the Server. Another question is that while ...Show All

• Keithys Noob question: SELECT statement

  Hi, I'm very new to RS. I'm trying to find a single piece of data in a table. Do I need to create a seperate dataset for it or is there some way that I can insert a SELECT statement into a textbox Maybe a sub query of an existing dataset Thanks in advance. WOW! To date this has had 111 views and ZERO posts. Can noone help me No you can't do this. Your select statement m ...Show All

• Rachel Falzone - MSFT How can I get Transactional Republishing to work?

  I'm starting a new thread to keep things clean and simple. This is a transactional republishing issue. In my simplest scenario, I'm transactionally replicating a single table from database A to database B and then from database B to database C. (And C will need to transactionally replicate to D, but ignore that for now). All databases are on the same XP server (in this simplist version of the problem). This is SQL 2005 RTM. Publication A to B ...Show All

• ScottC1967 Upgrade from SQL 7 to SQL 2005

  I'm planning to upgrade a SQL server 7 database to a new server with SQL 2005 soon. I will follow the migration path for the upgrade and my question has to do with my back-out plan. When we go live on a Monday morning, I will leave my SQL server 7 box n stand-by mode in case anything goes wrong with the new server. Is there a way to get the new data back into my stand-by SQL server 7 in case the new SQL 2005 server has issues after goin ...Show All

• RonnieSES generate table or database schema

  what is the sql servre equivalent to 'describe' keyword. how do we generate the schema of the database and tables of a database. schema here refers to column names and its types. I'm just getting started with SQL Server, but does this mean that there is no simple equivalent to Oracle's "DESCRIBE" command All I need to see is a table's basic schema (column datatypes and length, null allowed). is t ...Show All

• Samuelson Ido Remote connection to SQLEXPRESS doesn't work!

  Hello, OK. It is not possible for me to get remote connection to a ssqlexpress database (error 40). I tried everything posted in this forum, MSDN site etc., I used named pipes, TCP/IP ports, disabled Zone Alarm etc. it is just not working. I can coonect the Northwind database using SQL Server Management Studio Express CTP without any problem. And I am trying to learn creating databases, tables, stored procedures etc. by using code sampl ...Show All

• LizS Object variable assigned to parent package

  Hi, I have a child package which executes a sql query and retrieves back a result set assigned to a object variable. Then i need to assign this object variable to a variable in the parent package, where it will be used as an ADODB Enumerator in a ForEach Loop Now, if this variable was, for example, a string, it'd be quite easy to put in a script task dts.variables("x").value = dts.variables("y").value where x is the variable in the parent packag ...Show All

• ondy1985 SSIS Performance compared to DTS

  I'm new to SSIS, and trying to feel my way around but I've got some questions about performance. I've used DTS for a number of years, and I read in Donald Farmers blog that SSIS was about 7 times faster than DTS (mileage may vary).  Well, I may be doing something very wrong, because I'm getting about 7 times slower! I have around 40 dimension tables, most of them have less than 100 rows.  Only two have 60,000 rows.  Then I have a ...Show All

• dotnetdumps Row and Cell Segurity

  I am trying to implement row-security in SQL 2005 but i make a query to make a view CREATE VIEW vwVisibleLabels AS SELECT     ID, Label.ToString() FROM       tblUniqueLabel WITH (NOLOCK) WHERE ID IN --Classification (SELECT ID   FROM tblUniqueLabelMarking WITH (NOLOCK)    WHERE CategoryID = 1 AND IS_MEMBER(MarkingRoleName) = 1) AND --Compartments 1 = ALL(SELECT &nbs ...Show All