Answer Questions

• DtwSailor SP1 Installation Failure for Reporting Services Instances

  The upgrade was alright for my first/default instance of reporting services but failed for the other 3 non-default instances. I was running SP1 using remote desktop connection. I got the following error at the report manager and the reporting services configuration's initialization. Is there any way to get around this The version of the report server database is either in a format that is not valid, or ...Show All

• PTA How to install Express Manager tool?

  After wasting several days trying to get SQL 2005 installed on my test server & to connect to a virgin database (DotNetNuke), I'm reverting to simply using Express. That should be simple, right ! It's even installed with Visual Studio 2005 (June CPT)!   Lookoing, the only thing under Start|All Programs are Microsoft SQL Server 2005 CTP|Configuration Tools with threee entries: SQL Server Configuration Manager.lnk, SQL Server Error and Us ...Show All

• Tallydeals Store Procedure Performance

  I want to know what are the advantages and the desventajes to use stored  procedures in applications Two of the biggest advantages are: Performance: stored procedures are precompiled, thus they are faster than inline SQL Security: Stored Procedures if created wisely can protect your application from SQL Injection Regards Deepak ...Show All

• Lorenzo778 Bug: "ALTER TABLE *** WITH NOCHECK" does not work for SQL Server 2005

  I wanted to turn off 'Enforce Foreign Key Constrain' using SQL. However, it did not work on the SQL Server 2005 database. For example, running following SQL in Management Studio, and the result showed that 'Enforce Foreign Key Constrain' property for the newly created constraint was still enabled. ALTER TABLE [dbo] . [Tags] WITH NO CHECK ADD CONSTRAINT [FK_Tags_C hannelID] FOREIGN KEY ( [ChannelID] ) REFERENCES [dbo] . ...Show All

• mikestc Report designer - turning off the query generator

  Is there a way to stop the report designer from 'fixing' my query I tried to modify the where clause with an OR statement and when I ran the report it totally messes it up. Any ideas It sounds like you are using the visual query designer (4 display panes). You can just switch to the generic query designer (2 display panes). More information is available here: http://msdn2.microsoft.com/en-us/library/ms365414 ...Show All

• Rajonline_82 Merge Replication - native exception

  Hi! Here are the details: - Merge replication is set up between SQL Server 2000 SP3 <-> SQL CE clients - It is expected for the system to have 100-150 PDA users - About 80-90 tables are being replicated. About half of the tables are for documents  that PDA users create. These tables have to be filtered by SUSER_SNAME() to minimize data transfered and not to allow users to see each others documents. For filtering we us ...Show All

• mgsk Encryption Performance

  Hi I am trying to encrypt data using a symmetric key which is encrypted by certificate. I do not want grant control on these objects to the users who wants to decrypt this data. Instead I have created a udf with execute context as "dbo" and used DecryptByKeyAutoCert built-in function. Now this works fine but large data operations this is extremely slow. It takes around 10 minutes to select decrypted data whic in comparision takes ...Show All

• Craig Mackles The 'IBMDADB2.1' provider is not registered on the local machine

  I am receiving this error when I try to run a report I have deployed to the report server (SQL Server 2005 Standard on a maschine with Windows XP Professional) An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'DataSource2'. (rsErrorOpeningConnection) The 'IBMDADB2.1' provider is not registered on the local machine. The DB Provider I am using is OLE DB and the connection string ...Show All

• Dev Chris How can default schema change in stored procedure ?

  Hello, How can default schema change in stored procedure For Example: There are two user 'User1', 'User2' in TestDb Database. These users default schema is same name, like 'User1's default schema is 'User1', and 'User2's default schme is 'User2'. And each users have 'Table1' table, like [User1].[Table1], [User2].[Table1] In this enviroment, query 'SELECT * FROM [Table1]' refer default schema of execute user. like 'User1' execute 'SE ...Show All

• pradeep_TP quick transaction inside a stored procedure question

  a transaction block inside a sproc if after one of the tran statements, I bust out of the sproc with a return statement do I have to rollback explicitly first or does the tran rollback automatically appreciate the tip Could you please rate the thread as solved or helpful or whatever, that its no longer present as unanswerd Thanks, Jens. thanks jens ...Show All

• Tom Meschter Report Paramaters and WildCards

  I've created a report parameter which i've had to concatenate and modify because of the way in which the information is entered into the database - consequently I need my query parameter (in my database query) to only match the beginning of of each report parameter.  For instance - my parameters (in my drop down list) state "Pentium 4 CPU" whereas within the database this entry is stored as "Pentium 4 CPU 2.23GHz" or "Pentium ...Show All

• Amar_k_solai How to use sum and count aggregate functions with xml data type in SQL Server 2005

  Hi: I have xml in sql server 2005 beta2 that is stored as an xml data type and I'm trying to run some aggregate functions like count and sum, but I don't know how to do it.  The elements are numeric values, but 'sum' and also 'count' return errors.  I have included the error message and the sp below.  Any ideas how to use sum and count correctly Thanks, Paul -------------------------------------------------------------------- ...Show All

• FigBug Is there an IN( ) function?

  Is there and IN or and InList function in Reporting services I'm trying to do some conditional formatting and it would be really handy to be able to write an expression such as =iif(Fields!blah.Value In(X,Y,Z),"Red","White") Hi, If your using RS 2005 then there is an IN function in Report Builder, just not in BIDS. I've used nested if statements to get around this problem when ...Show All

• cristianv XML Source error on a complicated schema. "struggling"

  Thanks for taking the time to read my post.  For 3 months now I have been trying to get SSI XML Source to recognize my Schema and Instance file.  I have commited my self to using this tool and have been struggling tremendously.  The error that I'm getting is this: Error at SovrenXML Full Schema Resume Import[XML Source[1]]:  The component "XML Source" (1) was unable to process the XML data.  Ambiguous completType definit ...Show All

• Kingsonal Restore a Database with Differential

  Hello All, I'm new to this forum after read a few question error it given me little bit more understanding. But here's my problem I was create a database implement some tables than make a 'Full Backup' and input information on the table before make a 'Differential Backup'. I don't want restore a full database and just want to recovery specific table were deleted or removed. Please help........ Message show error: Restore failed for Serv ...Show All