Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Session Variables

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-06-02 : 07:42:13
Glenn writes "Hi,

Is it possible in SQL Server 2000 to read a 'site definitions' table once when a user logs. Then later in the same user session use these values within stored procedures without having to re-read the table?

Best,
Glenn"

rrb
SQLTeam Poet Laureate

1479 Posts

Posted - 2003-06-02 : 19:41:33
Not sure what you mean by 'site definitions' table?

Could you explain a little more what you're trying to do, and why it's such a problem to re-read the table (SQL Server is very fast at reading tables)...

--
I hope that when I die someone will say of me "That guy sure owed me a lot of money"
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-06-02 : 19:55:16
I do not know what you mean by 'site definitions' table either. Of course it is possible. You just have to store the values somewhere.

Tara
Go to Top of Page

jackstow
Posting Yak Master

160 Posts

Posted - 2003-06-03 : 11:52:44
You might want to take a look at Microsoft's IBuySpy Portal - http://www.asp.net/Default.aspx?tabindex=7&tabid=41 - that does just this kind of thing.

Go to Top of Page
   

- Advertisement -