No I didn't.

 I checked the BOL and while there wasn't an exact example, it did infer that you could do several ALTER COLUMN that...

You can alter several columns at once:

ALTER TABLE mytablename ALTER COLUMN mycolumnname1 INT,

mycolumnname2 VARCHAR(2),

etc....

Check out ALTER TABLE in the BOL. Use the Index tab and enter ALTER TABLE.

-SQLBill

BOL=Books OnLine=Microsoft's SQL...

What are you trying to do?

Do you have a table and are just trying to change the columns in the table?

-SQLBill

Allen,

The poster said the user DOESN'T have permissions on Table 2.

"Nopermissions on 'table2', of course, cause user should not see the table"

And that's the problem. SELECT has to be granted...

Each server (instance) has it's own service, so it's probably showing which ones are still running. There's a tool bar icon for the SQL Services also, and it shows the...

You are probably appending the Transaction Log (TL) backups to the backup file. Correct?

If so, here's what's happening:

1st TL Backup @ 0100 => backup file time of 0100

2nd TL Backup @...

Also, what is considered an EDIT? If I delete a record, usually that's considered editting it. If a database can't be editted, the DBA or anyone else will never be...

What SQL Server version do you have?

Is the red squiggly line only on Server icons that you have expanded?

-SQLBill

Found it!

In the Books OnLine, use the Index tab and enter Create View, scroll down to permissions.

According to the BOL, a View IS a Virtual Table. To EXECUTE a view, the user must...

I'll see if I can find the exact info in BOL, but the issue is that the user still needs permissions to the table.

The view just lets the user see...

It depends on what your database really is. You say it's Access, well then Microsoft SQL Server tutorials won't help.

If you really are going to use MS SQL Server, you...

Is this a typo?

DECLARE @Name

Or did you actually declare @Name as some datatype (ie. VARCHAR(20))?

-SQLBill

Okay. Now what's your question?

-SQLBill

The new 'look' doesn't allow me to properly format this, so bear with me. There's an 'undocumented' procedure called sp_msforeachdb which allows you to execute upto three commands for...

So much for trying to BOLD parts of my message. The parts between and should have been bolded for emphasis. Oh well....