i don't remember the scripts coming out in order, I'm testing it now...the wierd thing is, on a decent size database, with 2000+ objects, it's still running the Script wizard...

if you add a server side trace, then you can use the HOSTNAME column, which resolves to the computername that connected, in the trace to track everything from that PC.

you...

do you mean a temp table on the linked server? like this?

Select * into "server2".dbname.dbo.tablename from tablename

"The object contains more than the maximum number of prefixes. The maximum is 2."

If...

the piece you posted does not have an ORDER BY, without it, the data comes back in whatever order is convenient for SQL server to get the data.

The piece...

a couple of people noticed they registered themselves twice...could that be your issue as well?

if you joined, then joined again, your first "original" account keeps the first name, but all...

Magy i may have read the requirement wrong, but all i did was wrap your query with parenthesis, give it an alias, and add the grouping...is that what you wanted?

SELECT...

if you need the actual count, instead of just checking for orders, try this way:

declare @TheCount int

select @TheCount = count(*) FROM [ReorderS] where Item is not null

if @TheCount> 0

...

yes.

as db_owner, you own every object in the database; you can read/write, as well as create/alter/drop all the objects...

db_owner is a powerful role so it's like having db_datareader,db_datawriter and ddl_admin,...

SQL Server's SOAP does not support table valued functions unfortunately. This is why it's not working. I found this out by talking to one of the testers. ...

looks like you'll need to make a cursor, since the proc only changes one object at a time;

at least with the cursor, you could call it with parameters for all...

i think you'll need to use the stored procedure sp_changeobjectowner, which i think was around for SQl 2000 as well; that's the way to change the owner from say ,dbo,...

it's one of those "GOTCHAS" with the left outer join;

a left outer join should test for a column=null or not null on the joined table;

if it tests for anything else...

ask indirectly about whether they pony up money for conferences/networking events;

ie: "Did your last admin go to the SQL PASS conference for your company?"

ahh... the WHERE statements are turning the left outer join into an inner join.

try this instead:

SELECT DISTINCT NAME

FROM APPLICATION_USER

LEFT JOIN USER_PGM_AUTHORITY

ON APPLICATION_USER.NAME = USER_PGM_AUTHORITY.USER_ID

AND USER_PGM_AUTHORITY.PROGRAM_ID = 'VMINVENT'

WHERE USER_PGM_AUTHORITY.PERMISSION...

bpowers (9/21/2009)

---

If a user has permission to a program there is not a null value. There is no placeholder whatsoever. So, I can not use "permission is null" in a...