Yes, but you'll have to issue it in Query Analyzer not Enterprise Manager. Make certain that any insert queries running while you have it turned off are inserting an identity...

Joins are always executed before the where criteria.

In queries with more than 1 join, you can sometimes make the query more efficient by moving some of the criteria to the...

Interesting way to do it. I don't think it's ideal for this particular instance, but I can think of some instances where it would be ideal. For example, if a...

No they sort the same way. However, if the sort seems different, I would check the data types of the fields. Perhaps one field is a number in Access and a...

Don't use the table names in the select list:

CREATE VIEW IMEXtrlrUtilUNIONasapSM_VW as

SELECT top 100 percent OrderNbr, City, Shipper, Weight

from IMEXtrlrUtilShipMat_VW

Union

select top 100 percent OrderNbr, City, Shipper,...

Perhaps I would understand better if you told me what the error is. I'm good, but I'm not psychic.

What is the error? On what are you joining?

An inline table function doesn't return field names or field information. You may need to do a Multi-statement table-valued function so that...

Off-hand, I can't think of anything that you can format with Format$() that you can't format in T-SQL using the built-in functions. Maybe if you were more specific about what...

Yes, that's true. Changing it is a major thing. Setting it up that way to start with is very simple.

We use merge replication too, but we do not replicate stored procedures. It's just a matter of unchecking the appropriate boxes. You don't have to change replciation type.

Also, I hope he's...

I agree. Drop and create.

Try using sp_password to change the sa account's password by using NULL for the old password. If that doesn't work, try changing yours that way.

Otherwise, the MS solution for changing...

Mine too. And all of my remote servers have an IsRemote of 0.

Yep, just do it the same way. As long as your login has permissions to do it.

Exec SQL021.SomeDB.dbo.MyProc @Param1 = 'Somedata'

First off, you can't simply select text data into a varchar variable (or field). Text data is in binary format. Selecting the text field will only return the amount of...