Workgroup. We run 4 machines in a workgroup here with ss2k5 accessed by all of them (it's on one of them).

Standard edition

A few questions:

- Can you post the schema?

- What did you try? and what was the error?

You need an index and a PK. Probalby more than one index. You should...

Thanks and I doubt my friend is reading, but I'm glad I appeared to reach a few others.

Good ideas above and I'll add my favorite. If someone grabs you and...

It could be permissions or some config with this being created.

If you log in as the user (SQLAgent), can you run this as a DTExec command line? Can you run...

Be sure you know your ANSI_NULLS setting.

In accounting you need to know what to do with every value. There are times that you don't want a zero, so a null...

You need to read in Books Online on creating users and logins. Look up CREATE USER and CREATE LOGIN

You can only have one user per login in each database as...

If you are doing this in a dev world, two ways:

1. Let them create objects and then "mark" them for dbo status. They do this by dropping the object name...

Litespeed does it, since I've had smaller, GB sized dbs, I use sql_er's method. Restore on another server or a new db, copy data over.

In SQL 2000, the "version" field will change on alters. May change on a few other index things, but alters for sure. You can track this

http://www.sqlservercentral.com/columnists/sjones/20010423065956_1.asp

Doesn't give you a date...

No way I know of to set an alert on this.

What I've done is store the object list in a table and then run a job to compare current...

Each time a stored procedure calls another, the nesting level increases. So if I call proc 1, I have a level of 1. If proc 1 updates table A that...

Depends on your update/insert frequency. The more often you do those the more often you might want to defrag/rebuild.

Lots of people do it weekly, some daily, some monthly.

and some never....

tedious code. Or pay for something like Data Compare from Red Gate. Might burn the $300 cost in time very, very quickly.

Can you connect from the web machine to the SQL Server using query analyzer or the data sources in ODBC?

Maybe the SQL 2000 instance is named, which means you'd need...

First, put your ON clause after the join.

from a

join b

on a.x = b.y

join c

on a.x = c.y

etc.

Next, do you want...