again, I call BS.

what possible business process needs to scan the table every 30 seconds? how often is the table queried against per second? you've explained just fine what you...

When it comes to beating a dead horse with management, I've been there as well....sometimes they don't want to listen.

What is the real issue by the way? cursors? we might...

steveb's suggestion is the best, bar none. copy database wizard is not reliable compared to the built in ability of a SQL 2005 server to update an existing 2000 MDF...

for a trigger to be handled correctly, you cannot declare variables....

you have to keep everything SET based.

once you declare a variable, you are telling me you are thinking of one...

you can do it in 8000 char bites. the NULL parameter in your original statement below is WHERE to insert more text in the text field, and thenext parameter...

a table scan isn't necessarily evil....is the select very slow or anything?

how many rows are in the temp table?

what is the CREATE TABLE statement for the table?

is there...

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,...