ook at DYNAMIC cursor and SCROLL_LOCKS and FOR UPDATE clause.

From BOL

quote:

---

DECLARE CURSOR (T-SQL)

Defines the attributes of a Transact-SQL server cursor, such...

I think you best bet would be to use Active Script to be able to refinfe the export dynamically. You can create an excel object and build the new structure...

I am a bit confused here. Can you walk thru your query. It looks like you try to reference a new item in the same select S is defined as...

I have only seen this type of message when trying to restore a 2000 backup to 7. I have done serveral restores from SQL Standard to Dev, and Enterprise with...

Common statement but a bad idea in a high transaction environment, especially if you want only committed data. When nolock is specified then dirty reads can occurr (reading of uncommitted...

Found it.

The keyword is SAMPLE

quote:

---

SAMPLE n displays only n records (default is 10).

---

So example

SELECT *...

True but for some folks don't have this luxury or they allow there users way too much access which is bad.

"Don't roll your eyes at me. I will tape them...

Steves right, I was have gotten this enough that I should have seen that. Several issue can exist. Make sure the component has been registered. Also may have needs to...

Wrong track. Consider why sa only needs 3k rows when a user has far more. What specifically happens and what are you expecting from this query. Maybe you need to...

If you are using SQL 2000 then you will need to run BACKUP LOG dbname WITH TRUNCATE_ONLY to mark logs emptiable. I believe SHIRNKFILE has a parameter as well. If...

I will get my function list off my machine at work and pass along. Email me directly though or I will forget. Also you can add a timer in you...

It is funny, but how else do you think they become familiar with the competitions products. Looks bad on Microsoft to some folks but when you consider who failed looks...

Nothing that allows it to work this way dirrectly. The way I handle is to create a trigger for UPDATE and INSERT, then when a change or insert occurrs I...

dbcc sqlperf (logspace) -- Shows all log files for the server.

dbcc showfilestats -- shows all the data files for the current database.

sysfiles -- shows all log and data files for...

How do you define the connection to the SQL server with regards to the ActiveX control. If it is hard coded you may have pointed at the web box. If...