[testuser] can't GRANT EXECUTE on the proc, because he hasn't been granted the authority to do so. In order for a user to grant privileges to another on an...

Is the MSSQLSERVER service running?

If not, check the Services (services.msc) applet. Is it set to autostart? Also check the Log On settings. If your machine...

Are they running integrated security?

Do they all have the same level of db access?

Does the team have a domain group that they all belong to? ...

How is this to be used: Is this a one-time task or something you'll run regularly? Will it always be a fixed number of files, ie: the past...

It's crude, but it serves the purpose for which it's intended. It shows users, databases and roles for each user, and permissions granted directly to each user.

It...

The biggest problem is that most DDL statements don't like variables, and require explicit specifications. You'll have to build & execute the create table statement dynamically. The other...

INSERT INTO #PT61_PREFIX_ACTOR

SELECT

...

[BUYER_LAST_NAME] = case actor_role when 'B' then SUBSTRING(PT61_RECORD, 25,100) end ,

...

[SELLER_LAST_NAME] = case actor_role when 'S' then SUBSTRING(PT61_RECORD, 25,100) end,

...

[ADDITIONAL_BUYER_LAST_NAME] = case actor_role when 'BA' then SUBSTRING(PT61_RECORD, 25,100)...

exec tempdb..sp_help #tablename

SQLSecurity.com's version database is useful. Let's you know which hotfixes are installed as well.

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

Can you script your job & post it?

Scalar? No.

Table-valued? Sure...

CREATE FUNCTION SalesByStore (@storeid varchar(30))

RETURNS TABLE

AS

RETURN (SELECT title, qty

FROM sales s, titles t

WHERE s.stor_id = @storeid...

Here's something that may work for you.

I took some liberties in the code due to my lack of understanding of the data. Where you've got periods of...

All I've got for now are more questions. This is being launched from SQLAgent, right?

Open the DTS. Select Package->Disconnected Edit. Expand the Tasks collection and...

Let's take 'em one at a time.

First the SQLEM error. A UNION construct can only have one ORDER BY clause. If you try to run the...

A few comments...

I noticed in the ID/ParentID hierarchy that the first record's ParentID = 1. Is this column nullable? If so, set the first ParentID =...