I know that this makes absolutely no sense since you already defined the operator as "=" but you need to set your value to "=Unassigned"

GilaMonster (7/16/2008)

---

No. In 2000 finding the cause of log filling was more trial and...

nicole.willis (7/16/2008)

---

The recovery mode is Full and I have a tran log backup running nightly so it will truncate the log. I would put it in Simple mode and...

Even with Windows Authentication they have to be granted rights to the server. In SSMS under Security -> Logins the Windows Logins would look like domain\user_name. You then...

I obviously need to read a lot more.

Was a similar query available pre-2005?

What recovery model is the database in? If you do not need to recover to point in time you should use simple mode which will remove committed transactions on...

Is there a clustered index on the source table? If the table is a heap then SQL server will use the fastest access path. You can use order by...

If I understand correctly the users in question are already connecting to the server using windows authentication and you need to change or add permissions to the database. The best...

Good thread everyone. I learned a lot.

Thanks,

Are you using the same table elsewhere in the package? It could be the table is locked by another process and SSIS is being denied access.

Use BOL to learn how to use SQL 2005's built in encryption functions. If you are using SQL 2000 you need to do the encryption/decryption in the business layer....

My first guess would be that on all the other client PC's an ALIAS has been setup for the SQL Server instance leaving out \SQLExpress. YOu would do this...

What do you want the total hours to be for? If you want it to be for teacher, your top level group should be teacher then you can do...

If you are inserting into an existing table you want this:

Insert INTO NewDatabase.Customers.tbl_Table

SELECT AcctID

, Name

, Payer

, Payer_Name

, Account

FROM tbl_Customers

WHERE Account IN (113, 372, 135, 021)

If you are creating the table...

You enable database mail using the SQL Server Surface Area Configuration tool for Features. Then in SSMS you configure Database Mail Under the Management section of the server you...