How to author reports for Reporting Services?

I have installed and am using Reporting Services.

I can create RDL files using Visual Studio.NET, but like to offload this task to a minion who does not have VS.NET.

Is there a stripped down something-or-other to make reports that and end user or business analyst could use and then upload the reports?

Thanks.You might consider Soft Artisans'OfficeWriter. I personally don't have any experience using Reporting Services with OfficeWriter; I have only used their ExcelWriter product and was very pleased with both it and their customer service.

Terri

how to assign the view to a user?

im using the Northwind database, i use T-SQL commands to create a view that restricts users from seeing the address, city for all employees.
i dont know how to assign the view to a user in the database using Enterprise manager.
pls help me, im really needing a answer.
thanks!

What do you mean by assign a view to a user, do you just want to grant him Select permissions on the view, or do you want the user to be the owner of the view ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||i want the user to be the owner of the view
pls, step by step.
thanks.|||

sp_changeobjectOwner 'dbo.MyTable', 'Scott' -- this will grant ownership of the object to a user named 'Scott'

Check out my SQL Server 2005 Video Tutorials: http://www.learnsqlserver.com/

|||But you should be aware that sp_changeobjectowner is for SQL 2000 only. It is still existing for SQL 2k5 but should not be used anymore in SQL2k5. Use the other options mentioned in the BOL (look in the entry sp_changeobjectowner)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

How to apply complex constraints

Hi all!
I want to create a constraint that uses data from other tables,
specifically i want to make sure that a varchar has exactly the length
specified in an integer-column in a table that I pointed out with a
foreign key.

I would like this to be solved something like this:

create table string_size_limits
(
row_id INTEGER PRIMARY KEY
string_size INTEGER
)

create table strings
(
string_size_limit_row_id INTEGER
REFERENCES string_size_limits(row_id)
string varcher(50)
CONSTRAINT check_string_size CHECK ?
)

Is it possible to solve this problem without SP using above model?
Is it possible to solve this problem with SP using above model?
Must the above problem be solved using triggers?

Any help appreciated"Jon" <jonsjostedt@.hotmail.com> wrote in message
news:9f379edc.0503150952.59caa802@.posting.google.c om...
> Hi all!
> I want to create a constraint that uses data from other tables,
> specifically i want to make sure that a varchar has exactly the length
> specified in an integer-column in a table that I pointed out with a
> foreign key.
> I would like this to be solved something like this:
> create table string_size_limits
> (
> row_id INTEGER PRIMARY KEY
> string_size INTEGER
> )
> create table strings
> (
> string_size_limit_row_id INTEGER
> REFERENCES string_size_limits(row_id)
> string varcher(50)
> CONSTRAINT check_string_size CHECK ?
> )
> Is it possible to solve this problem without SP using above model?
> Is it possible to solve this problem with SP using above model?
> Must the above problem be solved using triggers?
> Any help appreciated

A CHECK constraint can only access data in the table it's created on, but in
your example, what is the purpose of Row_ID as a primary key? In other
words, what is the difference between these two limits:

insert into string_size_limits select 1, 5
insert into string_size_limits select 2, 5

Is the second string size limit somehow different because its row_id is
different? If the primary key of your limits table was just the string size
itself, then the foreign key could be used in the CHECK constraint:

create table dbo.StringSizes (
StringSize int not null,
constraint PK_StringSizes primary key (StringSize)
)

create table dbo.Strings
(
StringSize int not null,
String varchar(50) not null,
constraint PK_Strings primary key (String),
constraint FK_Strings_StringSizes foreign key (StringSize)
references StringSizes (StringSize),
constraint CHK_StringLength check (len(String) = StringSize)
)

insert into dbo.StringSizes select 3
insert into dbo.StringSizes select 5

insert into dbo.Strings select 3, 'Jon'
insert into dbo.Strings select 3, 'John' -- Fails
insert into dbo.Strings select 5, 'Check'
insert into dbo.Strings select 5, 'Cheque' -- Fails

If that doesn't help, I suggest you give some more details on Row_Id, and
also working CREATE TABLE and INSERT statements. But if you can't use the
string size limit itself in the foreign key, a trigger is the most likely
alternative.

Simon|||Jon (jonsjostedt@.hotmail.com) writes:
> I want to create a constraint that uses data from other tables,
> specifically i want to make sure that a varchar has exactly the length
> specified in an integer-column in a table that I pointed out with a
> foreign key.
> I would like this to be solved something like this:
> create table string_size_limits
> (
> row_id INTEGER PRIMARY KEY
> string_size INTEGER
> )
> create table strings
> (
> string_size_limit_row_id INTEGER
> REFERENCES string_size_limits(row_id)
> string varcher(50)
> CONSTRAINT check_string_size CHECK ?
> )
> Is it possible to solve this problem without SP using above model?
> Is it possible to solve this problem with SP using above model?
> Must the above problem be solved using triggers?

The problem does not need be solved with triggers, but that's the best
solution.

The alternative is to write a UDF which access the string_size_limits
table, and then you CHECK constraint would read:

CHECK (len(string) = dbo.maxlen(row_id))

The reason you should not do this, is because the performance penalty
can be severe. I remember that I played with this once, and added a
constraint with a UDF to the copy of an existing table. I then inserted
all 24000 rows into that table. Instead of two seconds it took 30!

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||In full SQL-92, you can write such a CHECK() constraint, but not in SQL
Server yet. You would have to use a trigger and get away from
declarative code.

However, why are you putting metadata into the database in violation of
basic design principles? This is sooo wrong.|||"--CELKO--" <jcelko212@.earthlink.net> a crit dans le message de
news:1110989814.440585.47880@.o13g2000cwo.googlegro ups.com...
> In full SQL-92, you can write such a CHECK() constraint, but not in SQL
> Server yet. You would have to use a trigger and get away from
> declarative code.
> However, why are you putting metadata into the database in violation of
> basic design principles? This is sooo wrong.

Why is this so wrong? How about a link to thoes basic design principles?
Where do you think metadata should be stored?

How to append only new records

What would be the steps to create a SSIS job to append records from an ODBC table to a SQL table, adding only the records from the source that do not already exist in the destination?

I have another post on this subject, with a good suggestion for the approach, but I need some more detailed instructions for implementing it:

Have you considered to use a Lookup task in your data flow to check if the row already exists in the destination table and then use the error output (no matches) for inserting only non existing rows? Notice that the error output of the lookup task needs to be set as 'redirect rows' in order to get this behavior

All details here:

Checking if a row exists and if it does, has it changed
(http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx)

(and in the various links from it)

-Jamie

|||

This is excellent. Just what I was looking for, and a little bit more...

Many thanks

|||

Jamie's answer did the trick

All details here:

Checking if a row exists and if it does, has it changed
(http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx)

(and in the various links from it)

-Jamie

Edit: Can't mark this issue solved...

How to append only new records

What would be the steps to create a SSIS job to append records from an ODBC table to a SQL table, adding only the records from the source that do not already exist in the destination?

I have another post on this subject, with a good suggestion for the approach, but I need some more detailed instructions for implementing it:

Have you considered to use a Lookup task in your data flow to check if the row already exists in the destination table and then use the error output (no matches) for inserting only non existing rows? Notice that the error output of the lookup task needs to be set as 'redirect rows' in order to get this behavior

All details here:

Checking if a row exists and if it does, has it changed
(http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx)

(and in the various links from it)

-Jamie

|||

This is excellent. Just what I was looking for, and a little bit more...

Many thanks

|||

Jamie's answer did the trick

All details here:

Checking if a row exists and if it does, has it changed
(http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx)

(and in the various links from it)

-Jamie

Edit: Can't mark this issue solved...

How to Append new rows and update existing rows using dts

Hello,
I'm trying to create a DTS package that allows me to update a new
database for a new site with the rows from the old site's database. I
know how to get the data to the new database, transformed how I want,
and I know how to append rows, but I have not been able to figure out
how to do updates to rows. I want to create a package that inserts new
rows and updates any changes made to old rows.
Ideally if there was a way to somehow link data from the old database
to the new database so that the two were kept syncronous on a real time
basis that woudl be ideal.
Any ideas or suggestions?
Thanks,
Jeff
Hi
If you use Execute SQL Task object you can write T-SQL query to handle those
changes
<jefftim@.gmail.com> wrote in message
news:1162916174.330520.50970@.e3g2000cwe.googlegrou ps.com...
> Hello,
> I'm trying to create a DTS package that allows me to update a new
> database for a new site with the rows from the old site's database. I
> know how to get the data to the new database, transformed how I want,
> and I know how to append rows, but I have not been able to figure out
> how to do updates to rows. I want to create a package that inserts new
> rows and updates any changes made to old rows.
> Ideally if there was a way to somehow link data from the old database
> to the new database so that the two were kept syncronous on a real time
> basis that woudl be ideal.
> Any ideas or suggestions?
> Thanks,
> Jeff
>
sql

How to Append new rows and update existing rows using dts

Hello,
I'm trying to create a DTS package that allows me to update a new
database for a new site with the rows from the old site's database. I
know how to get the data to the new database, transformed how I want,
and I know how to append rows, but I have not been able to figure out
how to do updates to rows. I want to create a package that inserts new
rows and updates any changes made to old rows.
Ideally if there was a way to somehow link data from the old database
to the new database so that the two were kept syncronous on a real time
basis that woudl be ideal.
Any ideas or suggestions?
Thanks,
JeffHi
If you use Execute SQL Task object you can write T-SQL query to handle those
changes
<jefftim@.gmail.com> wrote in message
news:1162916174.330520.50970@.e3g2000cwe.googlegroups.com...
> Hello,
> I'm trying to create a DTS package that allows me to update a new
> database for a new site with the rows from the old site's database. I
> know how to get the data to the new database, transformed how I want,
> and I know how to append rows, but I have not been able to figure out
> how to do updates to rows. I want to create a package that inserts new
> rows and updates any changes made to old rows.
> Ideally if there was a way to somehow link data from the old database
> to the new database so that the two were kept syncronous on a real time
> basis that woudl be ideal.
> Any ideas or suggestions?
> Thanks,
> Jeff
>

How to Append new rows and update existing rows using dts

Hello,
I'm trying to create a DTS package that allows me to update a new
database for a new site with the rows from the old site's database. I
know how to get the data to the new database, transformed how I want,
and I know how to append rows, but I have not been able to figure out
how to do updates to rows. I want to create a package that inserts new
rows and updates any changes made to old rows.
Ideally if there was a way to somehow link data from the old database
to the new database so that the two were kept syncronous on a real time
basis that woudl be ideal.
Any ideas or suggestions?
Thanks,
JeffHi
If you use Execute SQL Task object you can write T-SQL query to handle those
changes
<jefftim@.gmail.com> wrote in message
news:1162916174.330520.50970@.e3g2000cwe.googlegroups.com...
> Hello,
> I'm trying to create a DTS package that allows me to update a new
> database for a new site with the rows from the old site's database. I
> know how to get the data to the new database, transformed how I want,
> and I know how to append rows, but I have not been able to figure out
> how to do updates to rows. I want to create a package that inserts new
> rows and updates any changes made to old rows.
> Ideally if there was a way to somehow link data from the old database
> to the new database so that the two were kept syncronous on a real time
> basis that woudl be ideal.
> Any ideas or suggestions?
> Thanks,
> Jeff
>

How to alter column in Micorsoft SQL

Hi,
I have the following sample code to alter two table columns. But it
did not work. Please help me out. Thanks!
drop table one ;
create table one (
a float NOT NULL,
b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
)
alter table one
alter column a (NULL) ,
alter column b (NULL)
;
Thanks,
Mike
On Feb 1, 2:09 am, "Michael" <michae...@.gmail.com> wrote:
> Hi,
> I have the following sample code to alter two table columns. But it
> did not work. Please help me out. Thanks!
> drop table one ;
> create table one (
> a float NOT NULL,
> b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
> )
> alter table one
> alter column a (NULL) ,
> alter column b (NULL)
> ;
> Thanks,
> Mike
Hi Mike,
Perhaps you are not using Books Online properly.
The following code does what u wann.
ALTER TABLE ONE
ALTER COLUMN A FLOAT NULL
ALTER TABLE ONE
ALTER COLUMN B VARCHAR NULL
Thanks
Dutt...

How to alter column in Micorsoft SQL

Hi,
I have the following sample code to alter two table columns. But it
did not work. Please help me out. Thanks!
drop table one ;
create table one (
a float NOT NULL,
b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
)
alter table one
alter column a (NULL) ,
alter column b (NULL)
;
Thanks,
MikeOn Feb 1, 2:09 am, "Michael" <michae...@.gmail.com> wrote:
> Hi,
> I have the following sample code to alter two table columns. But it
> did not work. Please help me out. Thanks!
> drop table one ;
> create table one (
> a float NOT NULL,
> b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
> )
> alter table one
> alter column a (NULL) ,
> alter column b (NULL)
> ;
> Thanks,
> Mike
Hi Mike,
Perhaps you are not using Books Online properly.
The following code does what u wann.
ALTER TABLE ONE
ALTER COLUMN A FLOAT NULL
ALTER TABLE ONE
ALTER COLUMN B VARCHAR NULL
Thanks
Dutt...

How to alter column in Micorsoft SQL

Hi,
I have the following sample code to alter two table columns. But it
did not work. Please help me out. Thanks!
drop table one ;
create table one (
a float NOT NULL,
b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
)
alter table one
alter column a (NULL) ,
alter column b (NULL)
;
Thanks,
MikeOn Feb 1, 2:09 am, "Michael" <michae...@.gmail.com> wrote:
> Hi,
> I have the following sample code to alter two table columns. But it
> did not work. Please help me out. Thanks!
> drop table one ;
> create table one (
> a float NOT NULL,
> b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
> )
> alter table one
> alter column a (NULL) ,
> alter column b (NULL)
> ;
> Thanks,
> Mike
Hi Mike,
Perhaps you are not using Books Online properly.
The following code does what u wann.
ALTER TABLE ONE
ALTER COLUMN A FLOAT NULL
ALTER TABLE ONE
ALTER COLUMN B VARCHAR NULL
Thanks
Dutt...

How to alter an used alias type?

If I created an alias type as followed,
CREATE TYPE SSN
FROM varchar(11) NOT NULL
For some reasons, I would like to modify this alias type to varchar(20) not
null,
How to do it?
--Frank, using SQL2005devYou can to drop it and re-create it. But you cannot drop it as long as it is
being used, so...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Frank Lee" <Reply@.to.newsgroup> wrote in message news:OI8c$X$LGHA.140@.TK2MSFTNGP12.phx.gbl
..
> If I created an alias type as followed,
> CREATE TYPE SSN
> FROM varchar(11) NOT NULL
> For some reasons, I would like to modify this alias type to varchar(20) no
t
> null,
> How to do it?
> --Frank, using SQL2005dev
>|||Frank Lee (Reply@.to.newsgroup) writes:
> If I created an alias type as followed,
> CREATE TYPE SSN
> FROM varchar(11) NOT NULL
> For some reasons, I would like to modify this alias type to varchar(20)
> not null,
> How to do it?
That's a bit of work! Rename the type (sp_rename), create the new
definition. Run ALTER TABLE ALTER COLUMN on all tables that uses
the type, and recreate all procedures that uses the type as a parameter.
Finally you can drop the old definition.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||"Erland Sommarskog" <esquel@.sommarskog.se>
'?:Xns9769A5B38E43Yazorman@.127.0.0.1...
> Frank Lee (Reply@.to.newsgroup) writes:
> That's a bit of work! Rename the type (sp_rename), create the new
> definition. Run ALTER TABLE ALTER COLUMN on all tables that uses
> the type, and recreate all procedures that uses the type as a parameter.
> Finally you can drop the old definition.
>
Oh My god!
I would like to use alias type because I thought that if one day I want to
alter the difinition of alias type, it would be more easy as it has central
difinition. However, it's not really. It's more complex. :-(
Anyway, if it's the only way to alter the used alias type, I accept.
--Frank|||Frank Lee (Reply@.to.newsgroup) writes:
> I would like to use alias type because I thought that if one day I want
> to alter the difinition of alias type, it would be more easy as it has
> central difinition. However, it's not really. It's more complex. :-(
And it's maybe just as well. For a small database with little data in it
a single ALTER TYPE may be harmless. But for a widely used type in a 1TB
database it could send the database offline for a w.
Changing table schema in a large database requires careful planning, and
even more so if you change a type.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||"Erland Sommarskog" <esquel@.sommarskog.se>
'?:Xns97695FE4BC283Yazorman@.127.0.0.1...
> And it's maybe just as well. For a small database with little data in it
> a single ALTER TYPE may be harmless. But for a widely used type in a 1TB
> database it could send the database offline for a w.
> Changing table schema in a large database requires careful planning, and
> even more so if you change a type.
>
Ya, you are right.sql

How to Alter a table in a trigger?

Hi,everyone.

I have a problem with SQL SERVER 2005, described as follows,

(1) To create two tables MASTERINFO and PRODUCT,

--TABLE MASTERINFO--
CREATE TABLE MASTERINFO
(
ID CHAR(2),
FIELDNAME VARCHAR(50),
FIELDTYPE VARCHAR(50),
);

Table MASTERINFO with following records,

MASTERINFO('1','PRODUCTNAME','VARCHAR(50)');
MASTERINFO('2','PRODUCTADD','VARCHAR(50)');
MASTERINFO('3','PRODUCTEXP','VARCHAR(50)');

--TABLE PRODUCT--
CREATE TABLE PRODUCT
(
ID CHAR(5),
PRODUCTNAME VARCHAR(50),
PRODUCTADD VARCHAR(50),
PRODUCTEXP VARCHAR(50),
);

In our project, field name and field data type of fields PRODUCTNAME,PRODUCTADD and PRODUCTEXP in the table PRODUCT are changed with values of fields FIELDNAME and FIELDTYPE in the table MASTERINFO.That is to say, when using the following UPDATE statement,

UPDATE MASTERINFO SET FIELDNAME='PRODUCTNAME1',FIELDTYPE='VARCHAR(60)' WHEN ID='1';

We hope that field name of field PRODUCTNAME is automatically changed into PRODUCTNAME1 and data type of its is changed into 'VARCHAR(60) in the table PRODUCT.

I want to use a trigger to realize, but I failed for ALTER TABLE statement can not be included in the trigger. How can I do?

Please give me some advice. Thank you in advance.The mere fact that you feel the need to alter your table structure in a trigger demonstrates that you need to rethink your entire database design.

I'm not kidding...

Describe the database application you are trying to build, and maybe we can give you some tips.|||self modifying code can be a lot of fun to debug, don't you think?|||Think you!

In oracle DBMS, we can use EXECUTE IMMEDIATE statement to finsih such a task.However, I can not find the right statement in SQL SERVER 2005.|||who cares how to do it or if you can do it in Oracle? dude, the whole point is if it is a good idea or not and any code that modifies the definition of permanent database objects as part of the application is a terribly bad idea. I believe there is a way to do this in sql server, but I am not going to hand you a loaded gun to shoot yourself with.|||I wonder if you can pop a messagebox from a trigger in oracle? like "I am about to modify your schema. Confirm: yes/no"|||You can't do it through a trigger.

You could conceivably do it through a stored procedure, and under a good database design all interaction with tables would be done via sprocs anyway. But then again, we already know we're not talking about a "best practices" database design here.|||Hi,everyone.
Please give me some advice. Thank you in advance.

Sure, no problem.

Don't do it.

Now, for the fun part.

Why do you want to do this?

How to alter a column

Hi,
What's wrong with the following code? Please help. I am using MS SQL
2000.
create table one (
a float NOT NULL,
b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
)
alter table one
alter column a {drop} NOT NULL
alter column b {drop} NOT NULL
;
Thanks,
MikeSyntax usage is incorrect. Please use the below code to modify NOT NULL to NULL
alter table one alter column a Float NULL
alter table one alter column b Varchar(50) NULL
Thanks
Hari
"Michael" wrote:
> Hi,
> What's wrong with the following code? Please help. I am using MS SQL
> 2000.
> create table one (
> a float NOT NULL,
> b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
> )
> alter table one
> alter column a {drop} NOT NULL
> alter column b {drop} NOT NULL
> ;
> Thanks,
> Mike
>

How to alter a column

Hi,
What's wrong with the following code? Please help. I am using MS SQL
2000.
create table one (
a float NOT NULL,
b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
)
alter table one
alter column a {drop} NOT NULL
alter column b {drop} NOT NULL
;
Thanks,
MikeSyntax usage is incorrect. Please use the below code to modify NOT NULL to N
ULL
alter table one alter column a Float NULL
alter table one alter column b Varchar(50) NULL
Thanks
Hari
"Michael" wrote:

> Hi,
> What's wrong with the following code? Please help. I am using MS SQL
> 2000.
> create table one (
> a float NOT NULL,
> b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
> )
> alter table one
> alter column a {drop} NOT NULL
> alter column b {drop} NOT NULL
> ;
> Thanks,
> Mike
>

How to allow normal user (not Administrator) deployment of SSAS Cube?

Hello,

how to allow normal user (not Administrator) deployment of SSAS Cube? It says always that normal user cannot create new objects.

Andrey.

In order to create a database you need to be an Analysis Server admin.

In order to create cubes, dimensions, partitions you need to be database administrator.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

If you want your user to work with a BI project (that he will edit in Visual Studio and then deploy), these are the things to do:

- you need to create the database yourself (empty database) as server admin

- you need to give user admin rights for the database (using SQL Management Studio, create a Role)

- then user can deploy the BI project. Important: his project needs to contain the Role definition specifying him as admin (otherwise when he deploys the project, he will cut his access). To ensure you have the Role definition, you could initially create the BI project out of the live empty database (from VS, chose New Project, Import Analysis Services 9.0 Database wizard; then make sure that the newly create BI project specifies in its properties your database name).

Adrian Dumitrascu.

|||

I created a Cube from my DataWarehouse.
Under Administrator account I can deploy the Cube and everything is fine.
Then I want to allow normal user (programmer) to develop and deploy it in Business Intelligence Development Studio. This user has no Administrator rights.
So, I receive something like "User _xxx_ has no rights to change _yyy_-objects or an object does not exist" (my translation from German).

Granting user all rights to the DataWarehouse, creating Role in SQL Management Studio for DataWarehouse does not help. What really helps: creating Administrator Role for user in SSAS project and deploying project to Analysis Service under Administrator! So, this role will be uploaded to the service. After this, service recognizes user as an Administrator!
If you try to deploy project for the first time under user, then the role will not be uploaded (no rights). If you try to create role in SQL Management Studio instead of in BI project, then user will update service, remove role from service (since there is no role in project) and after this will be non-recognizeable.
It is possible also to create role in SQL Management Studio and then identical role in BI project. And then user can deploy.

Thanks for help! It gave a clue :)

How to allow FULLTEXT SEARCH INDEXING to non-admin user?

I've tried searching alot on the net but am not able to find how to allow a user (not admin/owner) to be able to create & populate the FullText Indexing Catalogs on the tables he creates.
Currently although with admin account, I can create FullText Catalogs but I have to provide the permissions to build & populate catalogs to some user, so that he can use FullText Search on his tables.
Please Help

Cheers
LuckyHelllooooo.....does anyone know abt it?sql

How to allow FULLTEXT SEARCH INDEXING to non-admin user (in MSSQL 2000)?

I've tried searching a lot on the net but am not able to find out how to allow a user (not admin/owner) to be able to create & populate the FullText Indexing Catalogs on the tables he creates (in MSSQL 2000) .
Currently although with admin account, I can create FullText Catalogs but I have to provide the permissions to build & populate catalogs to some user, so that he can use FullText Search on his tables.
Please Help.
I'm not very experienced in using SQL, so if you can give a bit of explaination also then it would be really helpfull :-)
Cheers :-)

Hey
So no one knows abt it?

|||You have to be members of sysadmin or db_owner to create sp_fulltext_catalog. The reason is that SQL 2000 catalog resides in file system (that is, outside of sql server). From the securiety's point of view, sql 2000 cannot let a user to create catalog.|||

Although the user has been given db_owner but in Sql Server Enterprise Manager it shows FullText Service with a red Flag (Stopped) & when i try to start it, then it shows the following error --

"An error 1722- (The RPC server is unavailable) occurred while performing this service operation on the MSSearch service."

But logging with admin a/c it shows green Flag (started FullText Service)

Also does activating RPC service have any security issues.

Thanks :-)

How to allow FULLTEXT SEARCH INDEXING to non-admin user (in MSSQL 2000)?

I've tried searching a lot on the net but am not able to find out how to allow a user (not admin/owner) to be able to create & populate the FullText Indexing Catalogs on the tables he creates (in MSSQL 2000) .
Currently although with admin account, I can create FullText Catalogs but I have to provide the permissions to build & populate catalogs to some user, so that he can use FullText Search on his tables.
Please Help.
I'm not very experienced in using SQL, so if you can give a bit of explaination also then it would be really helpfull :-)
Cheers :-)

Hey
So no one knows abt it?

|||You have to be members of sysadmin or db_owner to create sp_fulltext_catalog. The reason is that SQL 2000 catalog resides in file system (that is, outside of sql server). From the securiety's point of view, sql 2000 cannot let a user to create catalog.|||

Although the user has been given db_owner but in Sql Server Enterprise Manager it shows FullText Service with a red Flag (Stopped) & when i try to start it, then it shows the following error --

"An error 1722- (The RPC server is unavailable) occurred while performing this service operation on the MSSearch service."

But logging with admin a/c it shows green Flag (started FullText Service)

Also does activating RPC service have any security issues.

Thanks :-)

How to allow FULLTEXT SEARCH INDEXING to non-admin user (in MSSQL 2000)?

I've tried searching a lot on the net but am not able to find out how to allow a user (not admin/owner) to be able to create & populate the FullText Indexing Catalogs on the tables he creates (in MSSQL 2000) .
Currently although with admin account, I can create FullText Catalogs but I have to provide the permissions to build & populate catalogs to some user, so that he can use FullText Search on his tables.
Please Help.
I'm not very experienced in using SQL, so if you can give a bit of explaination also then it would be really helpfull :-)
Cheers :-)

Hey
So no one knows abt it?

|||You have to be members of sysadmin or db_owner to create sp_fulltext_catalog. The reason is that SQL 2000 catalog resides in file system (that is, outside of sql server). From the securiety's point of view, sql 2000 cannot let a user to create catalog.|||

Although the user has been given db_owner but in Sql Server Enterprise Manager it shows FullText Service with a red Flag (Stopped) & when i try to start it, then it shows the following error --

"An error 1722- (The RPC server is unavailable) occurred while performing this service operation on the MSSearch service."

But logging with admin a/c it shows green Flag (started FullText Service)

Also does activating RPC service have any security issues.

Thanks :-)