can you post the output of

SELECT * FROM sys.database_files

so that we can all see the file settings for the database?

I've only ever seen that error message when the file...

I have also seen this when the sql agent account is locked out.

you can also try to use a sql authenticated account to run the job instead of a domain...

Seems like the code did not work for me at first either. as the earlier posts suggested, i enabled the service broker, and then created a master DB key...

Correction: With what I said about the login being remembered, it only remembers sql vs windows authentication in that scenario. I chose SQL auth, connected with sqluser1, then close...

the one i've used is to create a policy based on the server facet to take a snapshot of the settings of the server after installation to go back and...

it looks like it uses the last name that was used for that particular instance. if you connect with sqluser1, then sqluser 2, then close all query windows, disconnect...

I would check the SQL cluster name resource. When I did a sql 2008 clustered install, it created the sql network name with kerberos authentication enabled. I'm not...

Was worth a shot. Thought maybe it would show you a table or something in the primary filegroup that was being overlooked.

Sorry couldn't be of more help.

Steve

You can try a combination of these two scripts to look at the tables, sizes, and affiliated filegroups.

Don't know if it will necessarily give you a solid answer, but another...

There is a 2005 version which should work the same in 2008.

This URL takes you to that article:

http://support.microsoft.com/kb/918992

I haven't tested this out on 2008 yet, but the syntax...

You should be able to go to View > Object explorer Details to get to what you are looking for.

Hope that helps,

Steve

One other issue that I had related to this was that the SQL Server Network name set up with Kerberos enabled wouldn't start after the install completed. If you...

Thanks Gail. That's what I thought. I will have our sys admins look into the storage on the machine. Weird that its only this one DB out...

Another option that I've been looking at is the Lookup transformation component within the data flow task toolbox.

I was able to get this configured to do what you need to...

Ok- now it makes sense. The way my example would work is that you would need to generate a select statement based on all of the values in the...