Is it possible to limit resources by login?

Is it possible in SQL 2005 to set a limit on resources to certain logins. In other words throttle down some users and therefore increase the priority of others?

SQL 2005 does not have the ability to limit resources based on logins.

Is it possible to import users logins when u restore a DB?

Im abit puzzled here and im looking to see if there is any easy solution

Case:

Have Backed up an DP, then Restored it on another computer.

Then all users will be in the system (Not visible to users, but in sys info)

OK!

Then I set up all LOGINS...

After all this procedure is completed I use the sp_change_users_login Update_One function...

Question:

Cant I just import or other way use old logins/users

(I know this msg might sound weird, but hehe I hope someone knows what I mean..)

Thx!As far as I know there isn't since the logins are stored in the master database. Unless in your scenario you can backup the master database and restore it on the other computer after doing the same for your database.

This worked for me when upgrading from SQL 7 to SQL 2K.|||oh! :eek:

Many thanks, I will try that one :p|||You can use command line utility bcp to copy the master..syslogins table
out of server1 and then bcp it back in to server2. Make sure you use
-c option as this will allow you to edit the output since you will need to
remove any entries which already exist in server2 (eg. "sa") in order
to prevent it falling over with duplicate key errors.

Type bcp on command line to get full list of options.|||2Scre@.m
Sorry, but I think that guys were wrong.
Read this
http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q298897
and other links from it.

Is it possible to have a website remotely hosted, which would access local database?

Hi everybody,

Currently we have a MIS application, developed in VB 6.0 - SQL Server 2000 platform, which is used by around 60 users in our office.

We are planning to host a website remotely, which would allow clients to place orders, track order status etc. on it.

Would it be possible to access our local SQL database from the remote website?

utpal_nandi:

Would it be possible to access our local SQL database from the remote website?

I'm afraid, it won't be possible. You should host the database also.

|||

Well I guess in theory that's not impossible. It might be impracticle though...

When you say "our local SQL database", is that hosted on a dedicated box? You could open that up for remote (read: internet) connections. That would allow your web server to access it.

However, that probably won't save you any time and will deprive you of an in house server that could be used for testing, etc. Also, it'll probably be slower for the webserver to query your sql server over the internet than it would be to query another server on its own network (if you hosted the database at the same place you host the website).

So you asked if it would be possible, and the answer is yes, but I wouldn't actually recommend it.

|||

What do you mean by "dedicated box"? Do you mean dedicated server? We will be having a dedicated server on Windows 2000 Datacenter edition on which the database as well as the web server (IIS) would be installed. The web server would be opened up for remote connections through a static IP.

Regarding the time factor, 90% of our data entry and database access would be done by our office staff on our local database, which would be faster than doing the same on a remote database. Moreover in case of a remote database, if our internet connection fails, our work would get held up. Only 10% of data entry and database access would be done by our clients in case of a local database, which would be slow and could be alternatively done by our local staff in case the internet connection fails.

|||

Hi,

Regarding the time factor, 90% of our data entry and database access would be done by our office staff on our local database, which would be faster than doing the same on a remote database.

From your description, I think that you can make your MIS system connect to the local database first, and then update the data to the live server in a schedule plan. To achieve this, one of the ways is to create a step job in SQLServer Agent, and make your remote database be synchronized with your local database server.

Besides, if you are using Visual Studio Team Suite, you can start a Database project, in that project, you can deploy your local database to your remote server in an easy way, meantime, schema comparison and data comparison between databases on different servers are enabled, you can make different databases be synchronized more easier than before.

Thanks.

Is it possible ?

Hi
I have users in domain group who use application which uses sqlserve, they
have rights to insert, update, delete. I want some of the members of this
domain group to connect directly to the database using query analyzer but
with right only to read and they still of course can use application and
have full rights.
I can't change application, i don't want to crate another users with
different rights.
I want the same user to have different rights using application and query
analyzer.
Is it possible ? Maybe something similar...
regards
m."marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnmq$32b$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
>
Don't multi-post. See response in .server.
David|||If you are using user rights with an application and not an application
role, then there is no way for the server to differentiate between a
user using product x or product y; it simply sees a request for data
from a user.
However, if your application can be re-tooled to use an application
role instead, then that changes things drastically. Of course, that
limits your applications ability to inherit from Active Directory, so
it may not be a viable solution.
Stu

Is it possible ...?

Hi
I have users in domain group who use application which uses sqlserve, they
have rights to insert, update, delete. I want some of the members of this
domain group to connect directly to the database using query analyzer but
with right only to read and they still of course can use application and
have full rights.
I can't change application, i don't want to crate another users with
different rights.
I want the same user to have different rights using application and query
analyzer.
Is it possible ? Maybe something similar...
regards
m.
"marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
>
In this situation users should be granted Read permissions only, and in the
application, they can acquire different permissions by running
sp_setapprole.
David
|||David Browne napisal(a):
> "marta" <marta20wawa@.go2.pl> wrote in message
> news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> In this situation users should be granted Read permissions only, and in the
> application, they can acquire different permissions by running
> sp_setapprole.
> David
I can't change permissions asigned to domain group to which they
belong.
I can't change application in any way, i don't have acess to use
application role. I can't touch application. For me the best solution
would be if in query analyzer is check button "read only", and i could
use it ;)
I need to give users read only access using isql.
M.
|||I believe that the closest you can come is to create triggers on your tables from which you check
the application name (APP_NAME()) and if not expected, you rollback inside the trigger. This will
not prevent a bad seed from writing an app, setting the expected application name and do the bad
operations, though.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sqlserver" <grupy_d@.go2.pl> wrote in message
news:1122622386.882273.249700@.g43g2000cwa.googlegr oups.com...
> David Browne napisal(a):
> I can't change permissions asigned to domain group to which they
> belong.
> I can't change application in any way, i don't have acess to use
> application role. I can't touch application. For me the best solution
> would be if in query analyzer is check button "read only", and i could
> use it ;)
> I need to give users read only access using isql.
> M.
>
|||Think of writing an app that lets users enter select SQL statements only and
shows the results in a grid control.
Don't set the grid to allow updates. You can probably find some code for
something like that in the samples.
HTH
"marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
> regards
> m.
>

Is it possible ...?

Hi
I have users in domain group who use application which uses sqlserve, they
have rights to insert, update, delete. I want some of the members of this
domain group to connect directly to the database using query analyzer but
with right only to read and they still of course can use application and
have full rights.
I can't change application, i don't want to crate another users with
different rights.
I want the same user to have different rights using application and query
analyzer.
Is it possible ? Maybe something similar...
regards
m."marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
>
In this situation users should be granted Read permissions only, and in the
application, they can acquire different permissions by running
sp_setapprole.
David|||David Browne napisal(a):
> "marta" <marta20wawa@.go2.pl> wrote in message
> news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> In this situation users should be granted Read permissions only, and in th
e
> application, they can acquire different permissions by running
> sp_setapprole.
> David
I can't change permissions asigned to domain group to which they
belong.
I can't change application in any way, i don't have acess to use
application role. I can't touch application. For me the best solution
would be if in query analyzer is check button "read only", and i could
use it ;)
I need to give users read only access using isql.
M.|||I believe that the closest you can come is to create triggers on your tables
from which you check
the application name (APP_NAME()) and if not expected, you rollback inside t
he trigger. This will
not prevent a bad seed from writing an app, setting the expected application
name and do the bad
operations, though.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sqlserver" <grupy_d@.go2.pl> wrote in message
news:1122622386.882273.249700@.g43g2000cwa.googlegroups.com...
> David Browne napisal(a):
> I can't change permissions asigned to domain group to which they
> belong.
> I can't change application in any way, i don't have acess to use
> application role. I can't touch application. For me the best solution
> would be if in query analyzer is check button "read only", and i could
> use it ;)
> I need to give users read only access using isql.
> M.
>|||Think of writing an app that lets users enter select SQL statements only and
shows the results in a grid control.
Don't set the grid to allow updates. You can probably find some code for
something like that in the samples.
HTH
"marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
> regards
> m.
>

Is it possible ...?

Hi
I have users in domain group who use application which uses sqlserve, they
have rights to insert, update, delete. I want some of the members of this
domain group to connect directly to the database using query analyzer but
with right only to read and they still of course can use application and
have full rights.
I can't change application, i don't want to crate another users with
different rights.
I want the same user to have different rights using application and query
analyzer.
Is it possible ? Maybe something similar...
regards
m."marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
>
In this situation users should be granted Read permissions only, and in the
application, they can acquire different permissions by running
sp_setapprole.
David|||David Browne napisal(a):
> "marta" <marta20wawa@.go2.pl> wrote in message
> news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> > Hi
> >
> > I have users in domain group who use application which uses sqlserve, they
> > have rights to insert, update, delete. I want some of the members of this
> > domain group to connect directly to the database using query analyzer but
> > with right only to read and they still of course can use application and
> > have full rights.
> >
> > I can't change application, i don't want to crate another users with
> > different rights.
> >
> > I want the same user to have different rights using application and query
> > analyzer.
> > Is it possible ? Maybe something similar...
> >
> In this situation users should be granted Read permissions only, and in the
> application, they can acquire different permissions by running
> sp_setapprole.
> David
I can't change permissions asigned to domain group to which they
belong.
I can't change application in any way, i don't have acess to use
application role. I can't touch application. For me the best solution
would be if in query analyzer is check button "read only", and i could
use it ;)
I need to give users read only access using isql.
M.|||I believe that the closest you can come is to create triggers on your tables from which you check
the application name (APP_NAME()) and if not expected, you rollback inside the trigger. This will
not prevent a bad seed from writing an app, setting the expected application name and do the bad
operations, though.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sqlserver" <grupy_d@.go2.pl> wrote in message
news:1122622386.882273.249700@.g43g2000cwa.googlegroups.com...
> David Browne napisal(a):
>> "marta" <marta20wawa@.go2.pl> wrote in message
>> news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
>> > Hi
>> >
>> > I have users in domain group who use application which uses sqlserve, they
>> > have rights to insert, update, delete. I want some of the members of this
>> > domain group to connect directly to the database using query analyzer but
>> > with right only to read and they still of course can use application and
>> > have full rights.
>> >
>> > I can't change application, i don't want to crate another users with
>> > different rights.
>> >
>> > I want the same user to have different rights using application and query
>> > analyzer.
>> > Is it possible ? Maybe something similar...
>> >
>> In this situation users should be granted Read permissions only, and in the
>> application, they can acquire different permissions by running
>> sp_setapprole.
>> David
> I can't change permissions asigned to domain group to which they
> belong.
> I can't change application in any way, i don't have acess to use
> application role. I can't touch application. For me the best solution
> would be if in query analyzer is check button "read only", and i could
> use it ;)
> I need to give users read only access using isql.
> M.
>|||Think of writing an app that lets users enter select SQL statements only and
shows the results in a grid control.
Don't set the grid to allow updates. You can probably find some code for
something like that in the samples.
HTH
"marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
> regards
> m.
>

Is cube browser available as seperate control for use in winforms app?

I love the cube browser in SQL Server management studio and would like to use it in a client app. But I don't want to give end users the SQL Server management studio.

Is it available as a seperate control or is there another one that would be available to me? I have tried the Excel addin for cube analysis but it is not as flexible and a Pivot Table report is pretty static.

Ta

Dirc

It's actually just a slightly modified OWC pivot table.|||

I installed OWC 11 and added a axPivotTable control to my winform. There were so many problems getting it to do anything I gave up.

Using COM controls designed for the web in a winform app seems a bit dodgy anyway....

|||I agree, it's a little odd to work with. And the properties aren't documented that well. But it's a lot better than having to code it yourself :)|||

Hi,

I am also trying to use the OWC control, but I am using it for a web based olap browser that needs to be integrated. If you have some links, material, information regarding the use of OWC, please do forward me the same.

Also, if you are succesful in implementing the OWC, give me some pointers.

thanks

Regards

|||

Found RadarCube NET Windows Forms for MS AS: http://www.radar-soft.com/products/radarwin_msas.aspx

Has similar functionality.

Is Cross-Validation (or Rotation Estimation) available in SQL Server?

Dear forum users,

I am a newbie in using MS SQL server with analysis services.
There seems to be no 'cross-validation' tool in MS SQL
which is frequently used in data mining and even statistics.
Is there anyone having similar difficulties?
Is there any solution like a small scripts to divide
the given dataset with multiple folds?
Your valuable comments and feedbacks would be appreciated.

Minnetongka

We have implemented cross-validation as part of a larger "model evaluation" module on top of the data mining algorithm implementations in SQL-Server 2005 Analysis Services. This is done by implementing sampling on top of the source case/nested tables and then utilizing the Analysis Services APIs (in C#) to train predictive models over training sets and then execute the appropriate prediction join over the testing sets to collect model performance metrics.

We commonly use this "model evaluation" model to automate the process of finding the most accurate predictive models for a given application.

Although we can't make our module publicly available at this time, let me know if you're interested in more information.

Thanks,

- Paul Bradley