Database Discussion Boards

StianSandberg21-Jan-08 10:19

21-Jan-08 10:19

The procedure encryption is actually referred to as obfuscation in Books Online. Also, there is no SQL Server command for decrypting it back. You could use third party components to accomplish this, there sure can be found some by searching in google for them.

The only feature for protecting code in SQL Server is the WITH ENCRYPTION clause (http://databases.aspfaq.com/database/how-do-i-protect-my-stored-procedure-code.html[^]). It is weak not necessarily because the encryption is weak (it uses RC4), but because the encryption key can be easily found. An attacker will focus on finding the encryption key rather than breaking the encryption algorithm in such a solution.

---------------
www.serverside.no

How to Schedule a Job in sqlserver 2005

Satish - Developer21-Jan-08 0:49

Satish - Developer

21-Jan-08 0:49

Hi, i want a procedure to schedule a job in sqlserver 2005.

How to create a job in sqlserver 2005?

G. Satish

Re: How to Schedule a Job in sqlserver 2005

pmarfleet21-Jan-08 2:03

pmarfleet

21-Jan-08 2:03

This information is available in SQL Server BOL. Did it occur to you to read the documentation?

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: How to Schedule a Job in sqlserver 2005

Satish - Developer21-Jan-08 2:25

Satish - Developer

21-Jan-08 2:25

I cant understand your answer. I dont know anything regarding schdeuling and sqlserver agent also. I dont know BOL. what is this? can u give link rgarding this concept?

G. Satish

Re: How to Schedule a Job in sqlserver 2005

pmarfleet21-Jan-08 2:38

pmarfleet

21-Jan-08 2:38

Satish - Developer wrote:
I dont know BOL. what is this?

SQL Server Books Online. It's the online documentation for SQL Server. Reading documentation is what people usually do when they want to learn how something works. I suggest you follow their example.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

sending mails in sqll

mrcsn20-Jan-08 22:26

mrcsn

20-Jan-08 22:26

hi
can any body explain me how to send mails from sql server 2000

thanks

Suman

Re: sending mails in sqll

Vasudevan Deepak Kumar20-Jan-08 23:49

Vasudevan Deepak Kumar

20-Jan-08 23:49

http://support.microsoft.com/kb/263556[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

Re: sending mails in sqll

SVb.net21-Jan-08 21:47

SVb.net

21-Jan-08 21:47

you must join your computer of sql server to domain and make profile for your email Exchange on Sql server 2000.
then used it.

123

Stored Procedure not returning any rows -- Pls Ignore[modified]

meeram39520-Jan-08 21:32

meeram395

20-Jan-08 21:32

Hi,

I have written a stored procedure for displaying data page-wise in ASP.Net 1.1 version. Even though data is present in database, when I tried to execute the following stored procedure, nothing is executing. I'm also not getting any errors. Could anybody please help me in finding out what's I'm doing wrong in these Stored Procedure?

ALTER PROCEDURE GETRICSBYPAGE
(
@Page int,
@RecsPerPage int
)
AS
SET NOCOUNT ON
CREATE TABLE #TEMPRICSBYPAGE
(
SLNO INT,
PK_VALUE INT,
RIC_NAME VARCHAR(50),
NO_OF_DAYS INT,
LAST_UPDATE_DATE DATETIME,
PE_FID1 BIGINT,
HEADEND_FID1383 VARCHAR(30),
LOCATION_FID836 VARCHAR(30),
CTBTR_BKDG VARCHAR(50)
)
INSERT INTO #TEMPRICSBYPAGE (SLNO,PK_VALUE,RIC_NAME, NO_OF_DAYS, LAST_UPDATE_DATE,
PE_FID1, HEADEND_FID1383,LOCATION_FID836, CTBTR_BKDG)
SELECT '' SLNO,PK_VALUE,RIC_NAME RIC, NO_OF_DAYS Days, LAST_UPDATE_DATE,
PE_FID1, HEADEND_FID1383,LOCATION_FID836, CTBTR_BKDG
FROM STALERICSTEMP2 WHERE PK_VALUE IS NOT NULL ORDER BY RIC_NAME

DECLARE @FirstRec int, @LastRec int
SELECT @FirstRec = (@Page - 1)* @RecsPerPage
SELECT @LastRec = (@Page * @RecsPerPage + 1)

SELECT '' SLNO,PK_VALUE,RIC_NAME,NO_OF_DAYS,LAST_UPDATE_DATE,PE_FID1,
HEADEND_FID1383,LOCATION_FID836, CTBTR_BKDG
FROM #TEMPRICSBYPAGE AS STLRICNEW WHERE PK_VALUE > @FirstRec
AND PK_VALUE < @LastRec

Is there anything wrong with the above? When I tried to execute in the query analyzer, EXEC GETRICSBYPAGE 1, 10, it is not giving me anything. Only blank headings. Please help.

Thanks,

Meeram395

modified on Monday, January 21, 2008 3:40:43 AM

Re: Stored Procedure not returning any rows

meeram39520-Jan-08 21:40

meeram395

20-Jan-08 21:40

Hi,

Sorry... Please ignore. It got resovled. It is checking with the PK_Value which is starting with 700. So I reset the PK_value. Issue is resolved now.

Sorry for the inconvenience caused.

Thanks,

Meeram395

DataReader, detecting type of SQL command

PIEBALDconsult19-Jan-08 17:07

PIEBALDconsult

19-Jan-08 17:07

I've always counted on a DataReader's RecordsAffected and FieldCount properties to tell me whether or not the command was a SELECT statement:
While the DataReader is open, use FieldCount; when the DataReader is closed, use RecordsAffected.

But I just ran into a snag... DDL statements, I hadn't tested my code with them until tonight.
While the DataReader is open, FieldCount properly indicates that it's not a SELECT statement; but when the DataReader is closed RecordsAffected == -1 so it tests as a SELECT statement!

Has anyone else run up against this and have a solution?
I don't think it'll really cause any trouble because by the time it's a problem the DataReader is closed anyway.

"
IDataReader.RecordsAffected Property

The number of rows changed, inserted, or deleted; 0 if no rows were affected or the statement failed; and -1 for SELECT statements.

The RecordsAffected property is not set until all rows are read and you close the IDataReader.

IsClosed and RecordsAffected are the only properties that you can call after the IDataReader is closed.
"

"
IDataRecord.FieldCount Property

When not positioned in a valid recordset, 0; otherwise the number of columns in the current record. The default is -1.

After executing a query that does not return rows (for example, using the ExecuteNonQuery method), FieldCount returns -1.
"

Double Quote Issue Data Set

mpavas18-Jan-08 0:27

mpavas

18-Jan-08 0:27

Hello I have a column in a datatable which has value

Title Book [Note values are in double quotes only]
"Does 'Grease Money' Speed Up the Wheels of Commerce?"

When I iterate the dataset I get the value as :
"\"Does 'Grease Money' Speed Up the Wheels of Commerce?\""

Hence I am not able to create an valid XML. Any idea how can I remove this \" from string

Regards,
Pavas

Re: Double Quote Issue Data Set

Paul Conrad19-Jan-08 6:57

Paul Conrad

19-Jan-08 6:57

Sounds like code somewheres is adding the \ before you insert into the database.

"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

Re: Double Quote Issue Data Set

Mike Dimmick19-Jan-08 7:46

Mike Dimmick

19-Jan-08 7:46

Is that what you're seeing in the debugger tooltip or watch window in C#? For reasons best known to themselves, they show the string as you would have to write a string literal in the code. The outer quotes and backslashes aren't present, which you can confirm by sending it to Console.WriteLine.

I believe VB.NET shows doubled quote marks for the same reason.

DoEvents: Generating unexpected recursion since 1991

Re: Double Quote Issue Data Set

PIEBALDconsult19-Jan-08 17:17

PIEBALDconsult

19-Jan-08 17:17

What the others said, plus that shouldn't keep you from producing well-formed XML unless you're doing something wrong.

I recently changed how I produce XML files, I used to do things like

string xml = string.Format
(
    "<Book><Title>{0}</Title></Book>"
,
    (string) datarow [ "Title" ]
) ;

Which will produce non-well-formed XML in many cases.

If that's what you're doing, look at System.Xml.XmlDocument.

ADO.NET Entity Framework and create entities at runntime

realmontanakid17-Jan-08 23:09

realmontanakid

17-Jan-08 23:09

Hi,

I'm currently working with the ADO.NET Entity Framework. The database design gots a anomaly with its tables.
The application design is a little bit awful. The user can login with different companies. So, USER1 logged in on company one, USER2 on company two and so on. For each company exists a copy of each table which can be identified via a prefix. If USER1 is logged in on company one his working tables got the prefix XXA_TableName. If USER2 is logged in on company two his working tables got the prefix XXB_TableName and so on. You don't have to tell me that this is a very dirty database design because i know that (it was not my brainchild).

What i need is to create entities at runtime because on design time i don't know on which company the user will log in. If the user log in on company one i have to create an entity for the table XXA_TableName. I hope this is coherent...

So, how can i create entities on runtime with the ADO.NET Entity Framework?

Kind regards

realmontanakid

Re: ADO.NET Entity Framework and create entities at runntime

Paul Conrad19-Jan-08 6:58

Paul Conrad

19-Jan-08 6:58

Sounds like the person who created the database does not know how to normalize it. You might want to suggest they do that.

"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

Re: ADO.NET Entity Framework and create entities at runntime

realmontanakid20-Jan-08 20:36

realmontanakid

20-Jan-08 20:36

Hi,

thank u for your reply. Some things can't be changed at this time. However, is there an answer to my question?

Kind regards

Set up relation [modified]

mpavas17-Jan-08 20:18

mpavas

17-Jan-08 20:18

I have 3 tables with below examples

dataTable

ID | DATA | ISBN
1 BOOK11 12312389123
2 BOOK22 12312389123

relationTable
AUTHOR_ID | ID
1 1
2 2

authorTable
AUTHOR_FIRST_NAME | Author_LAST_NAME | AUTHOR_ID
NAME NAME1 1
NAME NAME1 2

The relationTable acts as a relation datatable between "dataTable" and "authorTable".
I want to create relation between them in side a dataset. They all belong to a dataset named "MainDataSet"

Regards,
Pavas

<div class="ForumMod">modified on Friday, January 18, 2008 2:35:21 AM</div>

Re: Set up relation

imsathy17-Jan-08 23:26

imsathy

17-Jan-08 23:26

Considering ds as the dataset which contain all the three tables

ds.Tables["dataTable"].Constraints.Add("datpk", ds.Tables["dataTable"].Columns["id"], true);<br />
ds.Tables["authorTable"].Constraints.Add("authpk", ds.Tables["authorTable"].Columns["authorid"], true);<br />
<br />
<br />
ds.Tables["relationTable"].Constraints.Add("rtfk", ds.Tables["dataTable"].Columns["id"], ds.Tables["relationTable"].Columns["id"]);<br />
<br />
ds.Tables["relationTable"].Constraints.Add("rtfk2", ds.Tables["authorTable"].Columns["authorid"], ds.Tables["relationTable"].Columns["authorid"]);

Hope this helps!!!

Sathy

Re: Set up relation

mpavas18-Jan-08 0:24

mpavas

18-Jan-08 0:24

YES THIS helps !

Thanks!

Regards,
Pavas

Re: Set up relation

imsathy18-Jan-08 5:43

imsathy

18-Jan-08 5:43

its a pleasure Smile | :)

Sathy

Convert in Informix SQL

Bad Programmer17-Jan-08 13:53

Bad Programmer

17-Jan-08 13:53

Hi All,

Here's the Query from SQL 2000:

Select * from table1 <br />
  Where Convert(DateTime,dtStTime,103) > = '17/01/2008'<br />
  And Convert(DateTime,dtStTime,103)  <= '19/01/2008'

????I want to have same kind of functionality query for Informix between ranges............

Please help as im new to Informix and im in midway of my project...

Bala

Re: Convert in Informix SQL

John_Adams17-Jan-08 22:21

John_Adams

17-Jan-08 22:21

Hi,

Please try the following query:

SELECT * from Table1
WHERE DATE(dtstTime) > = '17/01/2008'
And DATE(dtstTime)<= '19/01/2008'

For more information on Informix SQL please visit the following web links:

http://www.dbcenter.cise.ufl.edu/triggerman/infoshelf/sqlt/02.toc.html#540217

http://www.dbcenter.cise.ufl.edu/triggerman/infoshelf/sqlt/02.fm2.html#104594

I hope this helps.

Regards,
John Adams
ComponentOne LLC

Re: Convert in Informix SQL

andyharman17-Jan-08 23:09

andyharman

17-Jan-08 23:09

Hi Bala

I haven't used Informix for a long time, but you should be able to use:

Select * from table1 <br />
Where dtStTime between '17/01/2008' and '19/01/2008'

Informix uses environmental variables to determine the date format. From memory, DBDATE should be set to "DMY4/" for your example.

Regards
Andy

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.