The hard part about seeing value in features is having a place where they can be used. This is where I think the developers and designers of SQL Server need...

First, you shouldn't grant sysadmin privleges. That's a huge security hole and unnecessary.

When replication runs, the account on the distributor logs into SQL Server just like any other user. So...

You should never shrink the data files if you can avoid this.

Shrinking the t-log does not invalidate the backup chain. http://msdn.microsoft.com/en-us/library/ms190749.aspx

The log file does not shrink after a log backup....

Here's another article: http://msdn.microsoft.com/en-us/library/ms190749.aspx

sorry to be late getting back, but I think IN reads better, especially when other people will see the code. Easy to make mistakes with OR.

If someone says OR is...

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.