Please post the code and errors or results here. I don't really want to download and open a .doc from the forums.

You can use CHARINDEX/PATINDEX to find the $ signs....

Be sure you are connecting to the servername/instancename.

so if your computer is "Bob", and you have a default and named instance of "Sales", you connect to "Bob" to connect to...

Does Sybase have a remove? Alter database xxx remove device yyy?

Or an emptyfile option?

In the v6.5 days, I thought you could remove a device if it didn't (and never had)...

If you think this should be changed, file this on Connect (connect.microsoft.com) and get people to vote for it.

You would need to provide some more details, like examples of what's needed and also make an attempt to do this in a query.

It sounds like a test question or...

Is there some reason you need this?

I'm not sure this is stored as it's not really needed like it was in SQL 6.5 and previous.

Now if you restore, the backup...

How did you log onto the server? In SSMS, opening a query window opens a separate connection to the server. The main "Object Explorer" or "Registered Servers" are connected with...

SQL is supposed to release memory if other applications request it, but I don't think it does it very quickly. However I agree with John that you should limit the...

I skipped some posts, but I can see calling a web service if you want to move data into SQL Server.

But not as part of a query. If you need...

What is the errorr your getting?

Your login needs to have rights to some database to connect.

Red Gate's Log Rescue is SS2K only. ApexSQL and Lumigent have 2005 tools.

Could it be reindexing? Those are moved across and could cause the logs to grow.

I bet that once a named instance exists, the setup program detects it and prevents the install. It's possible that a scripted install might work, but I've not tried it.

The user owns an object, in this case, a schema.

Move the schema to a new user and then drop this one.

I've debated this a bit and there doesn't seem to be a reason to do this. It's likely poor evaluation of the indexes in place and just adding another one.

My...

First I think you need

... sp_executeSQL N' alter table ...'

And it works for me, SS2K5, dev, SP2.

Columns added to table.

Do you have permissions to add columns?