XML

SP_send_mail

• by winslowlad

• SQLServerCentral.com

• Topic

Anyone getting an error when calling sp_send_mail from a stored procedure?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2001-10-01

4 reads

Rounding Question???

• by Keith-Edwards

• SQLServerCentral.com

• Topic

I am working on a rounding issue with a MSQL 2000 database. The problem is I have a few thousands records that get processed through some stored procedures and after the calculation process we end up with partial cents. We then have to transfer our data to an accounting system and it of course only […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2001-09-18

1 reads

SQLMail and Lotus

• by parasu

• SQLServerCentral.com

• Topic

Hi all, I've made SQLMail send mails to my Exchange server and Outlook2000. But, my corporate is using Lotus. How do I send mails to my corporate mailboxes. Thanx in advance Parasu Parasu Raman

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2001-09-05

2 reads

Changin port 1433

• by parasu

• SQLServerCentral.com

• Topic

Hi all, I'm a newbie SQL admin. I understand that the 1433 port is vulnerable. So, I plan to change it. What should be done for me to make sqlserver work fine with another port? What should be done in theproxy server side and the SQL Server side. There is another guy to take care […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2001-07-30

Format of Backup file

• by parasu

• Microsoft SQL Home

• Topic

Hi all, What is the backup file format for a full-backup. When I give a filename for backing up using the backup wizard, should I give an extension like .bak etc. Because, I found that the backup which I make, has no extension. Kindly clarify Cheers Parasu Parasu Raman

2001-07-27

3 reads

unable to view list of tables/objects

• by jarkley

• SQLServerCentral.com

• Topic

Before I start Im a novice SQL user. I have instlled MSDE which is a cut down version of SQL 7.0 I have installed SP3. I have created a DB Projectsql, I have created a role called "Project" I have added two NT users DOMAIN\Barbie and DOMAIN\Ken to the role 'Project'. I have granted the […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2001-07-17

2 reads

Group By Column Count limitation

• by gprasad

• Microsoft MSDN

• Topic

What is the optimum number of columns that can be grouped by in SQL Server 2000 ?

2001-07-13

2 reads

query problem...

• by emax

• Microsoft MSDN

• Topic

hi, i have the following query problem: let's assume that there are two tables (a and b). table a contains two fields (f1 and f2) which contain unique ids pointing to table b. table b contains the details to a.f1 and a.f2. is there a possiblility to retrieve the detailed data from table b with […]

2001-07-13

5 reads

Where is the SQL 7 knowledge base and Info gone?

• by whubbard

• ASPToday

• Topic

We are going to be migrating our web application to an external hosting partner. All access to our SQL server will be done remotely. I am trying to find information pertaining to the security concerns and how to address them when accessing SQL 7 data via the web from a remote location. Specifically, what set […]

2001-07-11

4 reads

Stored Procedure within a stored procedure

• by ddamalas

• ASPToday

• Topic

Hello.. I was trying to write a stored procedure that could execute another row-returning stored procedure and apply a where and order by clause to be used with some components I wrote. I'm probably not explaining myself properly, but I imagine that the stored procedure would look something like: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ CREATE procedure sp_execute_sp ( @procedure_name […]

2001-07-09

3 reads