This sounds like a permissions issue with your SSMS installation rather than a database error.  You mention that you have dbo rights on the database, but do you have administrative...

Glad you found the problem.  I run into this a lot actually, as I get a good deal of data in text files from foreign systems.  I got so tired...

I want my Supreme Being status back!  Does that qualify as a feature? 😉

I'll add my name to the list of those requesting this feature.  By default if I comment on a thread, I would like to subscribe to that thread.

Ouch.  It's like getting promoted and demoted in the same week.  It was fun while it lasted.

So Steve, I noticed that you have references to Mays and Babe, but no...

In my case, it's just confirmation of something I've known all along.  Now if I can just convince my boss....  😉

Take a look at your permissions on the database.  There should be no reason that SQL Express would arbitrarily disallow non-admins from connecting to the database, unless this is a...

If you have admin rights on the machine, your login account will have admin rights on the SQL Server instance as well.  You can log in using your Windows credentials...

The title of your post reads "Conditional Split query", but your post doesn't mention how you are using this component, if at all.  The problem you describe can be resolved...

I've run into this before, and ended up running it through a script task to standardize the format.

Open SQL Server Management Studio and browse down to SQL Server Agent in the Object Explorer.  Expand Sql Server agent, right click the Jobs folder, and select New Job.  A...

That's the same conclusion I came to, just wanted to make sure I wasn't over looking something subtle.  Thx anyway.

Tim

SQL Server reporting services is available for SQL Server 2000 - I think it's a separate (but free) download on the MS website.  There are a number of vendors that...

Well put, Steve.  Let's take a moment to remember those who died, without politicizing their loss.

To all: This is a technical forum, not a political one.  If you have strong...

During my days as a systems engineer, I went on a service call to repair a server damaged by liquid.  Their data center was in an office building, just below...