Natalie,

Few things:

1. You forgot to declare @cmd in the beginning

2. When I tried your code I got only 1 result and mine returns all objects in all DBs

3. Don't forget...

Are they running stored procedures? Are you runnning ad hoc query?

If the answer is yes for both try to recompile.

If not please post more details (like if it's sp...

Can you please add an example.

 

My idea is that you need to do some actions in Excel and that is not relevnt to SQL, i.e:

1. in new column set [column...

Can you post an example to see the way you store it.

dd-mm-yy / mm-dd-yy etc...

This one will give you the result you asked for.

You should change the query to return whatever you need.

 

 

 

 

SET

NOCOUNT ON

CREATE

TABLE

As you can see, my example will give you the exact answer you want ("GROUP BY A.AccountNumber")

You should try this one or at least understand the logic and try to implement your own changes. Few things:

1. I answered only on the first one, but I...

Can you be more specific?

Using sp_helprotect is enough? For example:

 

1. List the permissions for a specific user with sp_helprotect:

EXEC sp_helprotect NULL, NULL, 'User_Name'

2. You can list permissions for Statements (=S) and...

Natalie hi,

 

Do you mean something like that:

 

--------------------------------------------------------------

CREATE TABLE #User_Objects (

 DB sysname,

 Obj_name sysname,

 Type sysname&nbsp

INSERT #User_Objects

Exec sp_MSforeachdb

 'SELECT ''?'' AS DB, SO.NAME, SO.TYPE

 FROM ?..SYSOBJECTS SO

 JOIN...

I wrote something quickly, let me know if you need more than that.

 

-- Simulate data

CREATE

TABLE #Report (

ID INT ,

PL_category INT ,

booking_date...

Can you add an example of current situation and desired results?

 

Roi Assa

sp_helprotect null, 'User_Name'

Roi Assa