Answer Questions

• keith_co how can i sequre my db ?

  i am in Account management softwhere to get confirmation from the IRS i need to sequre the App Sql DB in password According to legal the state no one from the App user will have Accses to the App DB the law says that no one can remove record from the DB . how can i put pass into the SqlDb how i pervent the admin from delete records in the DB can i close the DB whit pass like in oledb i need help fast .....please... you will have to execute a command in your SQL server that deny the delete from your table: deny delete on yourtable from youruser tomer There are already threads discussing this. Here are two of them, but you can ...Show All

• karande23 Data encyption using symmetric keys outside SQL Server

  Hello. I have a problem that spans VB.net, SQL Server and SSIS but is rooted in the need to encrypt column data in SQL Server. I would like to encrypt data that I am bringing into SQL Server in the Data transformation script component of an SSIS package. I have achieved this but I can't decrypt the data because the keys don't match. I would like to use symmetric key encryption but I don't see how to get the symmetric key that I created in SQL Server available to the VB.net script component in SSIS. Please advise me if my approach is correct and what steps I need to take. Importing or exporting key material for SYMMETRIC KEYs is not supported in SQL Server 2005. SYMMETRIC KEY material is always e ...Show All

• Igor Nikiforov application failover error

  We currently have a system that uses sql server 2005 mirroring. In testing the application, we fail over the database in the middle of a 2.0 .NET web application. The failover partner is specified in the connection string. The next request to the web server results in an error page popping up with the message "A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)" This message only occurs for the first request to the web server, all subsequent requests sucessfully access the new failed over database. Thanks for any suggestions. I'm having the same problem and have ...Show All

• Yogesh Ranade Handling Dataset in Stored Proc.

  Hi, I want to create and populate a dataset from store procedure with following to querires & return the dataset as a result. Select * from billmain where billno = 12 Select * from billdetails where billno = 12 I am currently performing this task aa a resultset. Now I want to use Dataset. Anybody can send me sample sp which returns dataset as a execution of the sp. Nilkanth Desai A simple select statement would do. Call the stored procedure from your ADO.NET code and store the results of this stored procedure in a DataSet object. CREATE PROCEDURE SelectTable @billNo int AS SELECT columnName FROM Table WHERE billno=@billNo Hi, Thanks fpr your Reply ...Show All

• Rakosnicek Timeout and Audit Logout and sp_reset_connection?

  Hello, We've been getting some intermittent timeouts from our live website (the timeouts normally, but not always, occur when getting the user details - but that could be just because that task is happening the most often). However the strange thing is that this happens intermittently - but often enough to be annoying! I started a trace to see what was happening. I thought maybe it was a transaction/ or some sort of blocking SQL statement - however I'm not seeing anything that clearly indicates this.(I suppose the timeouts would only occur when another SQL was blocking the same db object, right And I don't think the updating of the user details are performed regularly.) However I did find some oddities that could maybe help: When we receiv ...Show All

• MadGerbil need to convert this SQL2000 DTS validation code to SQL2005 SSIS

  Hello, How do I convert VBSCRIPT code in a DTS package which is used for data validation to SQL 2005 SSIS Thanks, Michael Michael, There isn't really a tool to do that for you. Its a manual process I'm afraid. If you explain what sort of data validation you want to do then you may find people on here will be able to help you achieve the same in SSIS. -Jamie Hello, I have a source table which contains some invalid dates (can be null, letters, etc). I want to check to see if the date is valid. If the date is valid then I want to use it. If the date is not valid then I went to set the destination field to null. In the past I used vbscript code like Dim dtStart Dim d ...Show All

• Robert3234 Inserting with XML files - VERY URGENT!!!

  Hello everybody, I have a problem. I need to insert an unknown number of xml files in a database (all files are always in the same folder), in different tables, each file has the same name that the corresponding table. For example: Files Tables user.xml user purchase.xml purchase ...and so but the number of files is not always the same, I mean, it can be 6 one day and only 4 the next day. Can I insert the data in the xml files into the tables with a Foreach Loop Container or any other way If it's possible, how Thanks in advance for your help, Radamante71 Create a ForEach Loop task to read the files from the directory and assign the name to a variable. Then add a dataflow task to ...Show All

• Markus Rose SQL CE Installation Location

  Hi, When the battery dies the SQL Ce installation vanishes. Especially the following dlls which were copied into the \Windows directory during installation are getting vanished when the battery dies. sqlCese30.dll sqlCepqp30.dll sqlcemme30.dll sqlceer30EN.dll I guess this is because of the fact that RAM content vanishes when the power goes off. Is there a way i could install the SQL CE in the Storage Card I can install the Compact Framework in the Storage Card but not the SQL CE. I have installed the CF, My application in the Storage Card. Just because of this SQL CE does not allow me to choose the installation directory, i have to install the SQL CE everytime the battery dies out. Y ...Show All

• PedroCGD Dedicated Administrator Connection

  Hi: I am trying to connect to my local instance of SQL Server 2005 using Dedicated Administrator Connection by using Admin:Servername\Instancename and I end up with the following error. Dedicated administrator connections are not supported. I enabled the connection in the SQL Configuration Manager and still get the error. Any ideas on how to resolve this error . Note: SQL Browser service is running. Thanks Ak Thanks Ashvin. That did exactly confirm that I was connected using DAC. It returned one row. So my million dollar question is why cant I connect to DAC using ADMIN keyword. I tried all that have been suggested in this thread and still it says DAC connections ar ...Show All

• Pooja Katiyar Errors using multiple parameters in a SQL Statement

  In an OLE DB Source in an SSIS package, we are having difficulties using multiple parameters in a SQL statement. Using a single ' ' works fine, but I've read that when you want to map more than 1 parameter you should use 'Parameter0, Parameter1, etc'. The problem is that when we use Parameter0 and Parameter1 and then try to map it, it says that the query contains no parameters. Can anyone help with the correct way to use multiple parameters in a SQL query that's part of an OLE DB Source task Thanks, Mike Mike Batton wrote: Neither Parameter0 or just 0 is working This is the SQL in an OLE DB Source. At one point, 0 and 1 caused the parameter mapping dialog to appear, but ...Show All

• av_ster Analysis Services 2005 Lock-up on Calculated Measures

  AS 2005/VS 2005 is locking-up when I try to go to the calculated measures tab. It uses some CPU and I think a lot of I/O. My only way out is to close VS. Everything else is working. I looked at the XML and it looked OK to me (naive me). I have written out the xml and created another db/cube and the problem came along with the xml. I'm stuck. Tom The calculation tab in BIDS (VS) has to do a parse of the script to display it in the UI, so this would suggest that there is something in the script that is giving it issues. Try creating another database/cube using the xmla as you did before, but also do the following: search for the <MDXScript></MDXScript> tags and copy ...Show All

• nlarkjason Referencing the return value of a Subreport

  I have a subreport inside my main report and it is working just fine. The subreport is called sbrCaseSummary. In an expression of another txtbox in the main report I want to reference the value returned from the subreport. How do you reference it I can't find out how that's done. Help. I am having the exact same problem. Anybody have any ideas BJ ...Show All

• Biodegradable Equivalent of DTSStepExecStatus in SSIS

  Hi, I am migrating a dts package into SSIS.The dts package has a dynamic property to set the execution status of a data pump task in the package. the dts paskage is setting the DTSstepexecstatus of the datapumptask to 1 or 3 ie waiting and inactive. The dynamic property cannot be migrated to SSIS. May i know any equivalent property in SSIS to DtsStepExecStatus property of Dts. Thanks in advance Neethu You can use expressions on precedence constraints: set some variable in the script task to true/false, connect the script task with the data flow task with precedence constraint, double click the precedence constraint, select expression and enter the @varName ...Show All

• lezi SQL 2000 database upgraded to SQL 2005

  Hello, We are currently testing the migration fo a SQL2000 database to SQL2005 and we seem to be having difficulties with the security. Permissions for database objects are not coming across, loginids all have their own schema (which maybe this is expected ) The database server loginids do not seem to be in sync with the individual database logins because if you pull up the security for a loginid at the server level and click mappings, none of the databases are checked that the id had mappings for. If you click the databases and then "OK" an error pops up saying the loginid exists in the databases - which they do. The only way we can get the ids to map correctly is to totally delete the loginid from every database ...Show All

• moveit Add space between matrix row group

  I have a 2 row groups in a matrix and I need to add some space between the top one so that all the columns don't run together. Is there a way to do this Click on the last column in the matrix, and in the properties window, increase the Padding-Right value. You might want to increase the Width of that column to handle the additional padding. Does this do what you are trying to accomplish Hope this helps. Jarret That adds a second column of data that will repeat. So instead of one column under advanced I have two. Click on the row that you want to add the space below, go to the properties window and increase your 'Height' value. Al ...Show All