Installed SQL Server Management Studio.

Have performed some tasks - Checking user logins and running some SQL commands.

I'm a happy camper.

Thanks again for the help.

Do you think you could suggest an easier solution?

Just kidding. Thanks so much.

P.S. The person who moved the databases over and set up the maintenance said I needed to...

Well that's enough to avoid using it.

All I'm trying to do is retrieve the current (and complete) data - a snapshot....

Sounds like it... WITH (NOLOCK)

Thanks - and thanks for guiding me to documentation rather than just dumping the information.

Fair question - "Why don't I automate ..."

I'm usually working on another...

Thanks for the link. I finally set myself down and read it. Since our SQL Server has been virtually "set it and forget it" since being installed in 2004 I'm...

Well, I now know about sp_who.

The database is our ERP database - "everyone's always in it". :hehe:

I ran sp_who and there are 87 people in the database. All...

In case you missed this note - This database is for an ERP app created by a 3rd party vendor, not us. So, we are stuck with their creation. Outside...

Oh my gosh! The last exchange was because when I checked to see if there was a reply to my reply (the first one asking about 'more selective' and...

I'm not sure what you mean by "which is more selective on its own?"

Most of the time I will execute the following two queries, probably the first one more than...

Not sure what you mean by "more selective on its own"?

There are two queries that I will run, the columns are the same, the order would be different. The first...

Correct. Hence, my original request for assistance.

With about 100 records and a max of 200 to maybe as high as 300, I wasn't concerned about indexes for this table. BUT!...

I want you to post the definition of the table. Yes, CREATE TABLE creates a table, that's why I want to see the CREATE TABLE statement that created the tables...

I don't follow the 'The create tables statements'

What do I need to do?

As far as I know CREATE TABLE creates a table. I don't know of any variation that will...

Thanks for the links to the articles - yours is very good. I'll delve into SQL In The Wild later.

How do I post the schema with data types?

If I understood...

Question about DBCC UPDATEUSAGE and regular database maintenance...

Our ERP Vendor set up SQL Server and maintenance plan. (I know the tasks being performed and the gist of the importance simply...