Search results for query: *

Hi, I have a requirement, where the database data should be encrypted during storing and decrypted during retrieving. What are the ways or tools available for this. Also, kindly let me know of the ways to improve performance in this case. I urgently need these information. Thanks in...

Installation of Analysis Services 2000 on Windows 2003 standard edition fails. Whereas, it installs correctly on Windows 2003 Enterprise Edition. Is there any workaround for installing analysis services on Windows 2003 standard edition. Thanks in Advance, Manohar

In the production floor, database server dumped. When we put a big transaction, it didn't complete, though it was tried repeatedly. After a while, when SQL Server service is restarted, the same transaction worked perfectly. What could be reason for this. Thanks in Advance, Manohar

How to replace a an invalid character(as per business rules) in the column data using a query? For example, in our application, the following characters are valid. '[^-\^_<>`~{} :[",#$%&!?;+0-9a-zA-Z@/*().]' I want to replace all the characters, which don't belong to this character set...

How to use DTSTransformStat_DeleteQuery to delete rows from a table? Thanks, Manohar

Is it possible to pass the select statement with FOR XML as parameter to sp_xml_preparedocument? I tried this but couldn't execute the SQL Statement? Thanks, Manohar

Since the row size will not go more that 8 K, we shall assume that it is less than 8 K. What is the syntax for this? Thanks, Manohar

Is there any other free third party stored procedures available to send mails thru SQL Server. Thanks, Manohar

How to get the stored proc, xp_smtpsendmail, installed? Thanks in Advance, Manohar

I want to declare a variable in stored procedure and assign the XML to this variable. Thanks, Manohar

Is it possible to get the table's data in the XML format, using FOR XML, and store it in a variable. How can this be done. Thanks in Advance, Manohar

Yes, I understand this. But can I give a time, which is before the last transaction time, before crash. Thanks, Manohar

In that case, is it possible to create a new log file and make this database point to that log file. Thanks, Manohar

I just want to make sure of this one. Is it possible to take log backup at that time, when data files are crashed. Because, database may not be accessible. Thanks, Manohar

Data files and log files are kept in separate disks of my database. If the disk which contains log files crashes, will it stop the database. What can be done in this situation to continue using the database. Thanks in Advance, Manohar

Data files and log files are kept in separate disks of my database. If the disk which contains data files crashes, is it possible to take the log backup and then recover the database to the point of failure. Thanks in Advance, Manohar

In case server crashes, is it possible to recover the database to the point of failure with the help of log files? In that case, if the last transaction caused the db crash, is it possible to recover the db till the previous transaction(or the time upto that). Thanks in Advance, Manohar

What about pubs and northwind databases. Does this user has permission on these databases, as soon as the logins are created. Manohar

No, I am using mixed mode authentication. But still I get pubs and northwind databases. Thanks, Manohar

But it is not so, when you create a new login. Pl check it. Thanks, Manohar