How you tried Profiler?

Could this KB article answer your question?

http://support.microsoft.com/default.aspx?scid=kb;en-us;306649

quote:

---

Can you have a Linked Server and a Remote Server with the same name pointing to the same server.

---

You can't use Backup command to backup MDF/LDF alone. You have to backup the database as following.

backup database pubs to disk = 'g:\share\pubs.bak'.

If you really want to backup MDF and...

Make sure this domain account is in your SQL Server logins with 'sa' right.

What type service account your Agent runs? Local system account or domain account? Did you remove BUILTIN\Administrators login from SQL Server?

Right click SQL Server Agent in EM --> Display Error...

Use four-part name to access linked server, ie linkedserver.catalog.schema.tablename. For example.

select * from EA..EXAV.GROUPS

insert into EA..EXAV.GROUPS values ('Test', 'Test', 9, 381273546)

INSERT statements should supply values for all columns in a...

From BOL.

"Because @@FETCH_STATUS is global to all cursors on a connection, use @@FETCH_STATUS carefully. After a FETCH statement is executed, the test for @@FETCH_STATUS must occur before any other FETCH...

Use greater than (>) comparison operator to direct output to a file from osql.

Edited by - Allen_Cui on 05/08/2003 12:25:19 PM

Yes, you can. Remember to update statistics.

Yes, you can if your want to restore user database. Service Pack touchs only system databases.

quote:

---

I need the syntax to create a table and within the create table statement to include a primary key on 3 columns....

Try to increase the time-out value from Tools --> Options --> Advanced --> Query Time-out.

quote:

---

Device activation error. The physical file name 'D:\MSSQL7\data\DSM_CPKFinishing_be_Log.LDF' may be incorrect.

---

It seems log file...

Just wondering why you don't want to use the convert function?

With the 'style' set to '101' in convert function, you will see what you like.