Only Title

Answer Questions

• Eric from Plainwrap Encryption and database restore

  Hi Can anyone help I have a database using encryption with symmetric keys created using asymmetric keys. I backed up this database and restored it on another machine along with the service master key. I can read the encrypted data fine. But all the encrypted stored procs that are associated with the application that uses the data cannot read the data, they just return Nulls. If I regenerate all the encrypted stored procs from scri ...Show All

• JeevesIndia jdbc driver getTables(String , String ,Sring ,String[] )can't get tables whose catalog is pure number

  i have a database named "1", then i want to get the tables which type is "TABLE" under this catalog but it can't be done. Check the kode: conn.setCatalog("\"1\""); DatabaseMetaData meta = conn.getMetaData(); ResultSet tables = meta.getTables( "\"1\"" , "dbo","ttt" , new String [] {"TABLE"}); if i change the last sentence to : ResultSet tables = ...Show All

• Dionne Retrieving a piece of datalogged equipment by most recent time

  The TSQL below all works except the bolded part at the end. I'm want to grab only the most recently logged piece of equipment not the most recent and all past ones as well which is what I've got doing minus the bolded part below. But I don't know how to say get this Equipment ID etc and only the most recently logged one to find its present location. The bolded part below is just there to show what I want it to do I know you can use an aggregat ...Show All

• Maruthi Ravuri Foreach Loop Container causes package to crash

  We have a problem with a SSIS package containing a Foreach Loop Container that causes the package to fail unpredictably. We are using a Foreach Loop Container to process records in a source table one by one. We do this by executing a SQL statement on the source table, putting the resultset in a package variable and using that variable as an ADO object source variable in a Foreach Loop Container. In that container, we do four things: 1) ...Show All

• millerfjtp Analysis 2005 Dimension Max members

  Dear Anyone, Does the dimensions for Analysis Services 2005 have any member limitations Say a parent can only have so many members Thanks, Joseph Is there a possibility that when processing a dimension (not parent and child) a memory error an happen even though the dimension is quite large The reason I asked is that we encountered a memory error problem when processing a large dimension. Understandably our dimension is la ...Show All

• Orkoon SSIS custom component will only partially update in VS causing debugging to fail

  When I try to debug the break points will always say the source code is different from the current version, but the custom component in the GAC has the new version number. The other strange thing is the toolbox will not reset to the original version meaning it will not remove the custom components. The funny thing is after I compile the custom components and restart VS the custom component runs with the new code changes. I can see the new fea ...Show All

• NewHacker not fully qualified files

  Hi all, I need to create flat file connection managers. The connection Manager editor forces me to use fully qualified file names. Is there a possibility to use unqualified file names, because I need to reference to files in different directories with the identical file strcture. Any Ideas Guido Unfortunately not. It doesn't support relative file names. What you could do is use a common folder ...Show All

• KenRumble How to get programatic access to SSIS Service run time pkg monitoring info...?

  If running pkg from file system ( not deployed to SQL ), how do you interrogate the DTExec process to get pkg info, similar to the info the SSIS service shows...is this exposed somewhere in the API, to get runtime info for a pkg... Want to expand on what SSIS Service monitoring provides... Thanks in advance... RC You can control what is reported to the console, /REPORTING, and you can set loggers, /LOGGING, bu ...Show All

• GShaw Merge Join

  All, I need to use Merge Join transformation to join two sources. One is from a PIVOT transformation and one of the output columns is ISSORTED, the other is from an OLE DB Source using a query. The Merge Join transformation requires both input source have to be sorted. I cannot find the ISSORTED property on the OLE DB Source!! I tried to use Derived/ copy transformations but cannot find the property also. How can set the OLE query so ...Show All

• TheSoddy How Can I Change the data type of the parameter for the Deployed Stored Procedure ??

  Hi   I have Try to Create Stored Procedure in C# with the following structure   [Microsoft.SqlServer.Server. SqlProcedure ] public static void sp_AddImage( Guid ImageID, string ImageFileName, byte [] Image) {         }   But   when I try to deploy that SP to SQL Server Express   , The SP Parameters become in the following Stature   ...Show All

• Jay Hickerson my store procedure that call back itself doesn't seems to work.

  I have written a store procedure that will delete the record and any children record of it. That store procedure is suppose to call back itself to for every children record, but it only seems to delete the first record (the parent record). Below is my store procedure, pls help. CREATE PROCEDURE [deleteCMSPage] (@PROJ_CMS_PAGE_ID [int]) AS /* do not delete page id 1 */ if @PROJ_CMS_PAGE_ID <> 1 begin -- For storing the list o ...Show All

• PatLaplante12345 aggregate functions vs. non-numeric data

  RS doesn't like this expression that's supposed to total up all the debit values in my ledger: =RunningValue( iif(Fields!Amount.Value < 1, 0, Fields!Amount.Value), Sum, Nothing) I'm getting this error : The value expression for the textbox ‘APTotal’ uses a numeric aggregate function on data that is not numeric .  Numeric aggregate functions (Sum, Avg, StDev, Var, StDevP, and VarP) can only aggregate numeric data. I t ...Show All

• Jean-Francois Peyroux server name PROBLEM....

  Hi all, I have installed SQL SERVER 2005 CTP,Version 9.00.1314 but the problem is...as soon as i m trying to connect..i gave the local server name as SHUCHI during the installation and now i m trying to connect to it... then it gives me error as : cannot connect to SHUCHI additional information: An error has occured while establishing a connection to the server . When connecting to SQL Server 2005,this failure may be caused by the fact that ...Show All

• zinc Exporting data with SMO?

  I have searched low and high for some information on how to export data with SMO. My old build scripts were using SQLDMO.BulkCopy which was using BCP and it worked fast on entire database. I can't find a way to do the same with SMO. As alternative, I tried using bcp.exe on each table but it's awefully slow because initial process startup overhead. Please don't recommend Transfer class as I'm not looking to transfer server-to-serve ...Show All

• Nevil SQL Express Reporting Services

  Wow! We get reporting services in SQL Express. Excellent! Now, how do I save/deploy a report. Can we set up a report server locally. I feel a bit cheeky seeing as how this is all free, but where are we supposed to store the reports we create in the (free! thanks!) Business intelligence tool. Cheers Mick The reports are stored as standard .RDL files that are deployed and run on a local report server ...Show All