Sorting is the manipluation of data to represent it in a specific order based on a set condition (fields or functions are the conditions in either a gorup by or...

Best place of course is to start in BOL.

Have to laugh here, but too funny. I was just reading this last night.

I was going based on some old info and what was in those that actually had data in them from a database I recently moved via DTS. Thanks for the...

Dateadd does not work like in vb where the first paramtere is a string input. It actually now is a constant, so you have to use s not 's' to...

Sounds like 1 to me also but I am not sure I fully understand your final need. Can you give an overview of what you are dealing specific to the...

I have seen a few but cannot remember the address. However MS just released something I haven't had time to look at here http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en

First off they will not be able to backup to a local location it has to be a location on the server or a unc path as long as your...

I suggest just installing the client tools on the WinXP PC so you can validate things are setup right.

Have you tried dropping the check constriant and adding back.

They are temporary script files for creating certain objects. You may find several extenstions and they are usually under the tools directory in your SQL Server path.

For instance I see...

Can you post your current sql statement so we can address what you need better?

What most likely happend is this

In MET you have an item where DESCRIPTION='AAA' but the MET.EQNO does not have a partner value in the EQ

These are the things I know from testing before.

1) If you make the user a standard user with access to the DB but give db_owner or db_ddladmin fixed role in...

You can always use a DNS URL but you cannot redirect the SQL connector as it does not process redirect messages aimed back at it as far as I am...