you can't put a select statement there, only a string. you cannot select all columns in a table as a string...you'd have to build a string and use that.

you'll need...

from what i read, you cannot create a clustered index on CE other thant eh PK of the table'http://www.developmentnow.com/g/97_2005_2_0_0_384968/Clustered-Indexes.htm

also, CE can only use one index at any time, but i...

also stating the obvious...maybe in one database, the field is not null, and the database that doesn't show the value it is null...did you query both dbs to check the...

ok i think the per user settings are here:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\Client\PrefServers

for a user that is not logged in, i found a different set of servers here:

HKEY_USERS\S-1-5-21-515967899-1220945662-839522115-500\Software\Microsoft\Microsoft SQL Server\80\Tools\Client\PrefServers

his specific SID...

and building on happycat's list:

how are applications getting data from the views? if the application is doing SELECT * from 100GigView with no WHERE statement, and then filtering the recordset...

Lester on my machine, my 8.0 list of names are in the following key in the registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\LastConnect

i don't know where the passwords are, but you could at least keep ...

forum software ...add a closing parenthesis right before the q...

) q

it took amersand-nbsp-semicolon)

and turned it into this:

😉

nice noel; adding that to my snippet collection.

bad news: I agree with your client. there is no reason to to try and update a column every 30 seconds or one minute or on a specific schedule,...

im assuming your ID column is an identity...using the code below, if you repeat the update several times until no rows are affected, this will work:

[font="Courier New"]

CREATE TABLE EXAMPLE(

ID    INT IDENTITY(1,1)...

if you sp_helptext procedurename, it returns the text of the procedure, including all its comments, in the same format as wehn last created/altered.

if you do this in gridmode in SSMS,...

if openrowset is disabled, then most likely xp_cmdshell and sp_OACreate are disabled as well, which were your other options...

I think in this case, the solution is to NOT do it...

well, the web page itself would run the query, and stick the results in either an ADODB.Recordset, or a .NET DataTable or DataReader, right?

both of those have access to teh...

the same as any other table...after you create it, you'd need to create an index on the table, even if it is in tempdb. that's the only way to improve...

I think what you are talking about is CONTEXT_INFO;

you can store some information in there, and it is specific to the connection; typical examples might be the username from...