Ed

It sounds like the table doesn't exist at all under any owner, then.  Have you refreshed the window in Enterprise Manager?

Try this query:

SELECT TABLE_SCHEMA, TABLE_NAME

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE =...

Here are some things you can try:

(1) Create your stored procedure with encryption so nobody can read it

(2) Use DTS instead of bcp

(3) Use Windows authentication instead of SQL

John

Ed

OK - so the object in question is definitely a table and not a view or stored procedure or function?  What is the result of this query:

SELECT TABLE_SCHEMA,...

Ed

Who does Enterprise Manager show as being the owner of the table?

John

Ed

If the new owner isn't your username or dbo then you need to qualify the object name with its new owner.

SELECT * FROM newowner.MyTable

John

Probably the best way is to insert the result set of sp_helprotect @username='olduser' into a temp table and use that to build a script to grant or deny permissions as...

Ankur

I'm guessing you're looking at the result in grid format?  That will always be displayed on one row.  Try using Text format and see if that makes a difference.

If you...

This takes advantage of the fact that when you perform an operation involving two integers, the result is also an integer

UPDATE MyTable

SET IID = (ID - 1)/3 +...

The easiest way is to create roles and assign permissions to them.  Then, all users that need the same permissions can be made members of the same role(s).

John

Adam

No.  Books Online tells us that for the SELECT statement, the select list is as follows:

< select_list > ::=

    {    *

        | { table_name | view_name | table_alias }.*

        |     {...

DELETE FROM MyTable

WHERE col1 BETWEEN @a AND @b-2

AND col2 BETWEEN @c AND @d

Read about BETWEEN in Books Online before you use this so that you understand how it...

Ankur

Try this:

SELECT REPLACE ('I Love India', ' ', CHAR(13) + CHAR(10))

John

Tony

Check out GETDATE(), DATEDIFF and CAST in Books Online.

John

Adam

You can create a table with the same columns as the output of the stored procedure, then insert the results into it like this:

INSERT INTO MyTable ( <column...

Fredrik

NT AUTHORITY\SYSTEM only has access to the local computer.  You should start the SQL Server Agent service with a domain account that has permissions on the share you want to...