A neat thing that SQL Server does is also allows you to insert any non-zero value (and non-null) and have it represented as 1. So if you're used to...

Can you post a small sample of your code? Generally there shouldn't be any reason .EOF would fail unless the connection isn't getting opened and/or the recordset isn't getting...

Books Online does the second method that Andy speaks of (hierarchical information under the Index tab), by building a temporary table and interating up the relationship chain. I've done...

You might have your friend try the Fitch & Mathers Stocks project. It was a project that Vertigo Software went through to demonstrate the Windows DNA. Included...

If you've got the space, you could write the backup to disk, move it over, then restore it. Quite a few of us have our SQL Server backups being...

Andy makes a good point. Pages are 8KB in SQL Server 7 to take advantage of the I/O from the OS perspective, an improvement over SQL 6.5's 2K pages....

What was the error you received?

K. Brian Kelley

bk@warpdrivedesign.org

quote:

---

The article on Triggers did not mention that the Trigger is fired only one timer per DML statement - Insert, Update, or...

You've ascertained that the SQL Server seems to be executing the query just fine.

By standing up something like NetMon or some similar network tool, you can tell whether or not...

Steve covered a lot of good stuff, I've only got a little to add.

One of the best things you can do as an undergrad is excel to the point where...

Try http://www.cramsession.com for a good study guide of what you need to know. I think they also have a signup list for a question of the day. There...

Our change control allows developers to build and modify tables in development (if they have the expertise), but once we are ready to move to QA or production, the database...

If you're using a file DSN, you can add the following lines to have it connect automatically using a SQL Server login and avoid the prompt:

UID=<username>

PWD=<password>

If you're using a User...

What Andy posted is what I was thinking about when I first asked the question about standard SQL logins.

Is there some limitation as to why you can't use...

There is a view and table you can use.

For all tables (and views) you as a user has access to:

SELECT * FROM INFORMATION_SCHEMA.Tables

For all user table:

SELECT [name] FROM sysobjects WHERE...