Use the loginame column instead. The nt_username column is only populated when the user id is a Windows user. For SQL Server login id's, the column will be blank.

select CONVERT(varchar(25),d.name)...

Rhonda,

Review what Frank and Jonathan said initially. The fact is, there is no way to guarantee the results that you want without using an ORDER BY on the final SELECT.  For...

Teague brings up a good point. FoPro 2.6 dates range from 1/1/100 to 12/31/9999, which far exceeds the range of valid dates for SQL Server.

Flextech is correct. In my experience, date fields were the biggest problem. We had a FoxPro 2.6a application until 2001 (when it was converted to SQL Server and Powerbuilder).

The two...

This version starts with A0001, then procedes to A9999, B0001, B0002,...,B9999, C0001, etc.  The loop at the end is just for testing purposes. It will insert 10005 rows to show...

The loop was just to show that the code worked correctly. I would not use a trigger if the ID is the primary key for the table. A primary key...

Is the id limited to A0001, A0002, ..., A9999? Or does A9999 get incremented to B0000 or B0001? If the A is fixed, you can obtain the next value using:

(SELECT...

You will need another column (I called it 'rid' ) in the residents table that will be incremented from 1 by one for each household. Each time a new household...

The domain admin probably just renamed her account, so the SID is unchanged.  That SID is stored in master..sysxlogins, which also remains unchanged. That's why the "new" user id has...

Normally, "SuperSocket info:SpnRegister Error" errors occur when SQL Server is started. "SpnRegister Error" means that SQL Server was unable to register a Service Principal Name (SPN) with Active Directory. This...

Have you changed a server or workstation name recently?

Frequently, DNS or Active Directory problems cause the error you are receiving.

From a command prompt, type: ping -a <yourServerName> and verify...

In Windows 2000, go to Control Panel, then Administrative Tools, then Local Security Policy.

Then click on Account Policies, then Password Policies.

You'll see the item "Passwords must meet complexity requirements".

Doubleclick it and...

If you only want one row per description in the result set, regardless of the number of keywords found, something like the following might work:

SELECT mt.description

  FROM MainTable mt

 WHERE EXISTS...

Unfortunately, ALTER TABLE runs into the same problem you experienced trying to declare the same table with two different schemas. Since the "ALTER TABLE DROP COLUMN" statement would follow the "CREATE...

You need to use the following generic format if, as in this example, col3 allows null values:

SELECT col1, col2, col3

FROM myTable

WHERE col3 <> 'X' AND col3 IS NOT NULL

Mike