Search results for query: *

Hi all, Can someone tell me how to use SQL Mail? I have got a user with NT Domain rights and 'sa' rights. The same domain has an xchange server 5.5. I also have Outlook 2000 on the same machine. The os is w2k as and my sql server is 7 version. Thanx Parasu Parasuraman

Hello all, Im very much new to crystal. All I want to do is call a .rpt file from an .asp page (with parameters). I've got Crystal Enterprise (Evaluation copy) with me. It has Web wizard, publishing wizard, crystal configuration manager etc. What should I use? Someone please help Thanx...

I want to start from the beginning. I want to use crystal report's .rpt file into my asp page to preview and print reports. Where should I start? What all components I need (other than Interdev and RDC8). Ive got the downloaded version of RDC8 from crystal site. Any samples would help me alot...

Dear all, * If my database's initial size is 50 MB, what is the optimal size for the transaction log. * The other question is, how do I remove the logs automatically overwritten? This would reduce the harddisk space utilisation because of the transaction log. Thanx Parasuraman Parasuraman

Hi all, I'm unable to drop a user. I used exec sp_dropuser 'user1' It says that the user doesnt exist in the database. In the EM, i checked for the user in the Security - Logins. His name is there, but he hasnt been assigned any database. But, his default database is master. So, i checked...

I have VB6 and crystal report designer 8 (trial version, downloaded from crystaldecisions.com). Now, how do I create a .RPT file? When I use with VB, a DSR file is getting created, which is of VB's. Someone help me!!! Ozone Parasuraman

Dear all, How do I change the size of a new html page? <a href=&quot;./one.asp&quot; target=&quot;_blank&quot;>???? Kindly help Parasuraman Parasuraman

Hi all, Can I assign a value for an Application variable from inside Java Script? Ex: <language=JavaScript> { <% Application(&quot;var&quot;) = 1 %> } Is this possible? Or, in short, can I run ASP commands within Javascript? Very Urgent Kindly help Thanx in advance Parasuraman Parasuraman

Hi all, I want to pass a Java Script variable's value from Java Script to the ASP code. Is this possible. Example, <script language = &quot;java script&quot;> { var a; a = 100; } <% response.write (a) %> Is this possible. Can I use the java sript variable from...

Hi all, How do I bring in a .RPT file which Ive created using Crystal Report into an .ASP page. The report, should be displayed inside the IE browser window. How do I do it? Thanx in advance Parasuraman Parasuraman

Hi there, How do I use a parameterized report. Suppose, I want to select the Contact_Id at runtime and based on the value I enter, the report should list only records particular to the parameter I give. Ive created a parameter field and Ive included it inside the report design. In the code...

Hi Folks, Im new to Crystal Reports. Ive started working on it only today. Im using VB 6 and Crystal Report 8. I've already created a new report from within VB. I have done the connection stuffs and Ive also added a few fields from the table Ive selected. Now, If I wanted to filter my display...

Hi folks, I've started using Crystal Reports only from today. Im using VB6 and Crystal Report 8.0. I create a new report and create some connectivity and add some fields to the report. When Im trying to save it by using - 'Save to crystal report file' option, it gives me the following...

I create a new database and a new user for it and give him db_datareader, db_datawriter and db_ddladmin roles. Other than this, Im denying permission on select, insert, update, execute and delete on all the system tables in his particular database. Will this denying of access to the system...

Hi there, Which is better in terms of security - EM or Query Analyzer. For remoted usage of my database by my clients, which is secured. One more question, is there anyway to disable EM or Query analyser from the Client's access. If the client has the right connection details, he can connect...

Hi all, Im a newbie SQL DBA. I need the help of you guys. Here is my problem. My company is an Application Service Provider (ASP) which will also do some database hosting. The SQL database will reside in my data center. We'll create a database and a user for each client who registers for...

Hi All, I find one of my databases as SUSPECT when I open my SQL Server 7 using EM. What does this SUSPECT mean. What causes this and how can I rectify my database. Thanx in advance Cheers ozone