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

How to get the stored proc, xp_smtpsendmail, installed? Thanks in Advance, 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

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

When a new login is created, what databases, it has access to? When I created a new login(without adding it to any db), it had access to pubs and northwind databases, apart from master, msdb and tempdb databases. But it didn't have access to any other databases. Even if public role has access...

Is it possible to show both attributes and elements using OPENXML? How can this be done? Thanks, Manohar

What is the difference between different flag values in OPENXML, 0, 1, 2, 8. Thanks, Manohar

What's the difference between ALL and ANY? Thanks in Advance, Manohar

What is the use of replaying the trace, if I connect to a different server and database, during replaying. How can I debug a stored procedure or function, during replay? Thanks in Advance, Manohar

I have written the following query to list the rows which have invalid characters in that column SELECT * from titles where convert(varchar(255), [title]) like '%[^-\^_<>`~{} :[",#$%&!?;+0-9a-zA-Z@/*().]%' AND convert(varchar(255), [title]) NOT LIKE '%]%' List of valid characters are...

Suppose, I write a single trigger for all the transactions, INSERT, UPDATE, DELETE. Is it possible to identify, which trigger(INSERT, UPDATE or DELETE) fires this trigger code? Thanks in Advance, Manohar

What is a firehose cursor? When 2 rows in a table have the same set of values and when we try to delete one of the rows, why it says "Cursor is in firehose mode". Thanks, Manohar

Is it possible to call a user-defined function from a front end or middle-tier component written in vb.net or c#.net. If so, is it possible get the return value, which is either scalar or a table? Thanks in advance, Manohar

I have to declare a cursor to get list of rows, which don't contain the following characters in a column. exec('DECLARE curData CURSOR for SELECT count(*) from ' + @TableName + ' where convert(varchar(255), [' + @ColName + ']) like ''%[^\\-\\^_<>`~:{}\",#$%&!?;+0-9a-zA-Z@/*()\\.\\-\\b\\\\...