Lynn Pettis (10/13/2011)

And IMNSHO, the right decision would actually be to move the...

That's what I needed. Thanks 🙂

I understand that the files are use serially and that the ideal situation would be to increase disk space, however I need other options to present to the decision makers....

The reality that seems to exist at my work is that the DBA is often directly responsible for only a small subset of activity. Often the issue we have is...

Thanks Tom, tend to get caught up in using the sys.* catalog views and forget there are other ways to skin that cat 🙂

The connection string is the string used to connect to SQL server. It will be in the C# project and should contain servername, username, security info etc...

It would be also...

This could be a problem with the connection string - check it carefully for typos 🙂

Hmm, okay, need to get the context nailed down:

Is the SQL Server using mixed mode, or Windows authentication?

Is the SQL Service running?

What are you attempting to do when you get...

Right click this login in SQL Server Management Studio, select properties and at the bottom of the dialog and tell me what the default database is.

Thanks for that - some interesting points. I suspect that this is the modus operandii for a lot of people. It is when the problem space gets too large and...

Are you able to log on to SQL Server using the sa account and verify that NT AUTHORITY\SYSTEM has an associated login and what is the default database for the...

Thank you - good to review the basics.

I hear that! I have a handfull of scripts that I use every day, and folder upon folders of 'one day I'll sit down and sort thorugh this' scripts 🙂

Please give an example output of the query you are wanting given the sample data you have provided. (If you can provide sample data in the form of ddl statements...

The space is the problem. Another option is to use the 8.3 path name:

C:\PROGRA~1\...