So, if folks are wondering or trying to do the same thing, the RUNAS command does not provide a means to send a password with the command. it was deliberately...

It sounds like you are looking for SQL query help for SQL Server 2012. This forum is for Administrating SQL Server 2005.

Try your question over here at T-SQL

Thanks for the feedback. Good Stuff! I should have been more detailed about the numerics being stored. Firstly, the data in question originates in other systems and is brought into...

I've also seen BI-Lite which claims to be able to do the job. I've not been able to test this since it requires .Net 4 which I'm not able to...

Yes. There are schemas that share the name fo the user. When I look at the properties of the user the 'Owned Schema' is the same as the user....

Great! Thanks Roy. I'm still confused about how I got it to show results last night with a database but maybe that's an Express thing. I appreciate the clarification.

What I ran last night was sp_help 'Sample' and got 2 reulstsets back. The first contained info like db_size, id, owner, status, compatability_level. The second resultset showed infor about the...

oh man...ha ha ha..I really need to work on my troubleshooting skills!

Thanks so much!

SOLVED:

I used only the machinename and left out '\MSSQLSERVER'.

Amateur mistake.

Could there be another process attempting to connect with a bad password and disabling the account? Has anything come up in Event Viewer?

Have you attempted to reinstall the product since? What happened? Are you running this with an account that is an administrator on the machine? After the setup files installed completely...

Yes that does help. These bkp files are part of a sharepoint upgrade so we won't be too many of them and not for long (hopefully).

Thanks!

You guys are amazing! Thanks so much!

Multiple filegroups lets you explicitly specify what filegroup a table or index goes onto.

So a good practice would be to create a secondary filegroup when a database is created...

I guess I missed something because my db ran out of room. The single mdf on the primary was set to Autogrow and had a size cap at 70Gb. The...