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.
| Author |
Topic |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2009-04-24 : 05:35:39
|
| Dear allplease tell how can i store table in sql memory.in my asp.net applicaton some table is use a large time and this table is very few record. and it is not changed so how can i posible store this table in memory thanks is advance |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-24 : 05:46:34
|
Which version of SQL Server are you using?With SQL Server 2000 yo ucan use DBCC PINTABLE, but not longer in SQL Server 2005 and later.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-04-24 : 05:47:42
|
| You can create temporary table using sql Stored procedure..Then you call the procedure from asp.net and where ever u want!Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceled |
|
|
|
amirs
Constraint Violating Yak Guru
260 Posts |
Posted - 2009-04-25 : 02:51:32
|
| thanks for replaydear pesoi am using sql server2000 version 8.00.760but how can use pintable |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-25 : 04:36:02
|
Read about DBCC PINTABLE in Books Online, the SQL Server help file.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
store table in sql memory