.NET

Technical Article

SQL Mail...

  • Topic

Hi all, I had posted this in the 'Programming-General' by mistake. Sorry for that. Im new to SQL Mail. When I say xp_startmail, i get a message 'Server: Msg 17952, Level 18, State 1, Line 0 Failed to start SQL Mail session. Check the errorlog file in the SQL Server directory for details.' Can someone […]

You rated this post out of 5. Change rating

2001-09-02

2 reads

Technical Article

Stored Procedure Syntax

  • Topic

I'm new to SQL and Stored procedures. I'm trying to write a stored procedure and I'm having difficulty with the syntax. Ultimately what needs to happen is that if a certain condiion is met, then a variable will add one to it's initial value of 0 until the procedure has gone through the table basically […]

You rated this post out of 5. Change rating

2001-08-23

1 reads

Technical Article

SQL tools

  • Topic

I am trying to find a report writing tool (like BRIO), that also allows users to update lookup tables. Is there any products that allow this? Thanks Joe

You rated this post out of 5. Change rating

2001-08-23

3 reads

Technical Article

data display in table

  • Topic

hello, i am having a table in which the value of one field is too long, and it isnot being displayed i tried nvarchar, ntext eveything but its not working any new ideas?? thanks in advance

2001-08-13

2 reads

Technical Article

deny alter table priv - how?

  • Topic

Hi all Im trying to deny the "alter table" command for a schema user. Basically I dont use DBO, the applications in the database get their own userid and create object using it. Ive created the following role to deny schema access but can add to it the "alter table" command to stop developers from […]

2001-07-25

196 reads

Technical Article

Memory

  • Topic

Hello, I've created the alert for Memory-Pages/sec Alert Over 2 in Performance Monitor, I'm getting net send message as Pages\sec is being over 2. I'm confused and what should I do to overcome it. My production server has 523 MB Ram and I've specified SQL Server to use memory dynamically setting max as 440 MB. […]

2001-07-19

8 reads

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers