ID Column has backed down !

hi
honestly, i can't understand
why the pointer has backed down...
in design view, i see the value 147.720
while the last id-key is 147.772
what happens ?
thanks
atte, Hernn
You need to post your DDL so we can better understand the question. Are you
working with the identity property or is this a home-grown id?
--Brian
(Please reply to the newsgroups only.)
"bajopalabra" <bajopalabra@.hotmail.com> wrote in message
news:essjRIIuFHA.204@.TK2MSFTNGP10.phx.gbl...
> hi
> honestly, i can't understand
> why the pointer has backed down...
> in design view, i see the value 147.720
> while the last id-key is 147.772
> what happens ?
> thanks
> --
> atte, Hernn
>

ID Column has backed down !

hi
honestly, i can't understand
why the pointer has backed down...
in design view, i see the value 147.720
while the last id-key is 147.772
what happens ?
thanks
atte, HernnYou need to post your DDL so we can better understand the question. Are you
working with the identity property or is this a home-grown id?
--Brian
(Please reply to the newsgroups only.)
"bajopalabra" <bajopalabra@.hotmail.com> wrote in message
news:essjRIIuFHA.204@.TK2MSFTNGP10.phx.gbl...
> hi
> honestly, i can't understand
> why the pointer has backed down...
> in design view, i see the value 147.720
> while the last id-key is 147.772
> what happens ?
> thanks
> --
> atte, Hernn
>

ID Column has backed down !

hi
honestly, i can't understand
why the pointer has backed down...
in design view, i see the value 147.720
while the last id-key is 147.772
what happens ?
thanks
--
atte, HernánYou need to post your DDL so we can better understand the question. Are you
working with the identity property or is this a home-grown id?
--
--Brian
(Please reply to the newsgroups only.)
"bajopalabra" <bajopalabra@.hotmail.com> wrote in message
news:essjRIIuFHA.204@.TK2MSFTNGP10.phx.gbl...
> hi
> honestly, i can't understand
> why the pointer has backed down...
> in design view, i see the value 147.720
> while the last id-key is 147.772
> what happens ?
> thanks
> --
> atte, Hernán
>

I want to restrict the my clients to access database through EnterPrise Manger Or Quer ana

Hello All
I am using SQL server 2000 as the backend of my application but don't
want my clients tobe able to view or edit the database tables, stored
procedures , view etc using enterprise manager or query analyser (or
similar tools)How can this be done ?
I searched a lot for this but unable to get the correct answer is
there anybody to give full solution regarding this.
Please relpy me as early as possibleCheck 'Application roles' topic in BOL.

Igor

"Kavita" <kavitajt@.yahoo.com> wrote in message
news:b1112113.0403020411.7eb19264@.posting.google.c om...
> Hello All
> I am using SQL server 2000 as the backend of my application but don't
> want my clients tobe able to view or edit the database tables, stored
> procedures , view etc using enterprise manager or query analyser (or
> similar tools)How can this be done ?
> I searched a lot for this but unable to get the correct answer is
> there anybody to give full solution regarding this.
> Please relpy me as early as possible|||"Kavita" <kavitajt@.yahoo.com> wrote in message
news:b1112113.0403020411.7eb19264@.posting.google.c om...
> Hello All
> I am using SQL server 2000 as the backend of my application but don't
> want my clients tobe able to view or edit the database tables, stored
> procedures , view etc using enterprise manager or query analyser (or
> similar tools)How can this be done ?
> I searched a lot for this but unable to get the correct answer is
> there anybody to give full solution regarding this.
> Please relpy me as early as possible

Here are several things you can look at:

1. Do not give the users permission to create procedures, views etc.

2. Use application roles (see sp_setapprole in Books Online)

3. Only allow access to data through stored procedures, and only grant
EXECUTE permissions on the procedures instead of granting permissions on the
tables (this may not be 100% possible if you require dynamic SQL, however)

4. Code your application to set the application name when it connects, then
use APP_NAME() in stored procedures to check the user is using an
'authorized' application (this is easy to fake, though, so it will only stop
an accidental or 'casual' attempt to connect)

5. Use a middle tier to authenticate users and manage connections instead of
allowing them to connect directly to the database server

Simon

I really need help here

Hi,
My site is currently down. When users try to view a report they get
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
Could not allocate space for object 'ChunkData' in database
'ReportServerTempDB' because the 'PRIMARY' filegroup is full.
It was working fine until I loaded a new report a few days ago the
ReportServerTempDB when from a mere 400MB to 2.5GB. How can I fix this
please? I can't seem to find any info on this.
ThanksThis is a multi-part message in MIME format.
--=_NextPart_000_000B_01C71267.EA8848C0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
Seems like your temp db is full. Try doing a transaction log backup with =truncate to shrink it.
Not quite sure what would cause the temp db to fill up like that, =though. Shrink it first, then you could run SQL Profiler against that db =do see what sort of statements that increases it so much over time.
Some of these articles might be usefull to you:
How to stop the transaction log of a SQL Server database from growing =unexpectedly
http://support.microsoft.com/kb/873235
Planning for Scalability and Performance with Reporting Services
http://www.microsoft.com/technet/prodtechnol/sql/2005/pspsqlrs.mspx
How to Performance Tune the Microsoft SQL Server tempdb Database
http://www.sql-server-performance.com/tempdb.asp
Kaisa M. Lindahl Lervik
"Chris" <Chris@.discussions.microsoft.com> wrote in message =news:9A24D6A4-E0E3-4540-8906-94C26EB7E6A2@.microsoft.com...
> Hi,
> My site is currently down. When users try to view a report they get
> > An internal error occurred on the report server. See the error log for =more > details. (rsInternalError) Get Online Help
> Could not allocate space for object 'ChunkData' in database > 'ReportServerTempDB' because the 'PRIMARY' filegroup is full. > > It was working fine until I loaded a new report a few days ago the > ReportServerTempDB when from a mere 400MB to 2.5GB. How can I fix this =
> please? I can't seem to find any info on this.
> > Thanks
--=_NextPart_000_000B_01C71267.EA8848C0
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Seems like your temp db is full. Try =doing a transaction log backup with truncate to shrink it.
Not quite sure what would cause the =temp db to fill up like that, though. Shrink it first, then you could run SQL Profiler =against that db do see what sort of statements that increases it so much over time.
Some of these articles might be usefull =to you:
How to stop the =transaction log of a SQL Server database from growing unexpectedly
http://support.microsoft.com/kb/873235
Planning for Scalability and Performance =with Reporting Services
http://www.microsoft.com/technet/prodtechnol/sql/2005/pspsqlrs.m=spx
How to =Performance Tune the Microsoft SQL Server tempdb Database

Kaisa M. Lindahl Lervik
"Chris" wrote in message news:9A24D6A4-E0E3-4540-8906-94C26EB7E6A2@.microsoft.com...> =Hi,> My site is currently down. When users try to view a report they get> => An internal error occurred on the report server. See the error =log for more > details. (rsInternalError) Get Online Help> Could =not allocate space for object 'ChunkData' in database > ='ReportServerTempDB' because the 'PRIMARY' filegroup is full. > > It was =working fine until I loaded a new report a few days ago the > =ReportServerTempDB when from a mere 400MB to 2.5GB. How can I fix this > please? I can't =seem to find any info on this.> > Thanks

---

--=_NextPart_000_000B_01C71267.EA8848C0--

I need the istance name in my SQL 2000

Hi guys,
how to view the default instance name in my sql server?Hi

Have you tried something like:

SELECT ISNULL(SERVERPROPERTY('InstanceName'), SERVERPROPERTY('MachineName'))

The default instance returns NULL. More information in Books Online.

John

"amnsia" <secondotetidoilmioindirizzocosilospammi@.nondirecaz zate.it> wrote
in message news:camuap$96g$1@.domitilla.aioe.org...
> Hi guys,
> how to view the default instance name in my sql server?

I need identity on updatable partitioned view

Ok, already read that is not allowed to have identity column in any member table of a updateable partitioned view.

But I need an identity column. Is there any other way or ide how to solve this problem?

This is one of the situation where using a column with a uniqueidentifier datatype, set to a default of newid() is the 'right' solution.|||It does not work...|||

I have to disagree with you on that!

What are you attempting to accomplish, and what steps have you taken so far.

Please include the TABLE and VIEW DDL.

|||

create table bileta_te_lozura_2007_01

(id int not null,

databiletes datetime not null check (databiletes>=cast('20070101' as datetime) and databiletes<cast('20070201' as datetime)),

constraint [pkjan2007] primary key clustered ([id],[databiletes]) with fillfactor=50 on [primary]

)

create table bileta_te_lozura_2007_02

(id int not null,

databiletes datetime not null check (databiletes>=cast('20070201' as datetime) and databiletes<cast('20070301' as datetime)),

constraint [pkshk2007] primary key clustered ([id],[databiletes]) with fillfactor=50 on [primary]

)

create view bileta_te_lozura

as

select * from bileta_te_lozura_2007_01

union all

select * from bileta_te_lozura_2007_02

I need ID to be an unique ID

For the whole view not only for one table!

|||

Try this:

CREATE TABLE bileta_te_lozura_2007_01
( ID uniqueidentifier DEFAULT newid() NOT NULL,
DataBiletes datetime NOT NULL CHECK ( DataBiletes >= cast( '20070101' AS datetime ) AND DataBiletes < cast( '20070201' as datetime )),
CONSTRAINT [pkjan2007] PRIMARY KEY CLUSTERED ([ID],[DataBiletes]) WITH FILLFACTOR = 50 ON [primary]
)

CREATE TABLE bileta_te_lozura_2007_02
( ID uniqueidentifier DEFAULT newid() NOT NULL,
DataBiletes datetime NOT NULL CHECK ( DataBiletes >= cast( '20070201' AS datetime ) AND DataBiletes < cast( '20070301' as datetime )),
CONSTRAINT [pkshk2007] PRIMARY KEY CLUSTERED ([ID],[DataBiletes]) WITH FILLFACTOR = 50 ON [primary]
)

CREATE VIEW dbo.bileta_te_lozura
AS
SELECT * FROM bileta_te_lozura_2007_01
UNION ALL
SELECT * FROM bileta_te_lozura_2007_02

|||

That will create an unique identifier column, not an integer column. Looking that all this is done because table can be be very large i'm affraid for performance issues using rowguid things...

I mean, if i query as follows:

select aa,bb,cc from bileta_te_lozura where id='233acf-sdffd-sdfsdfs-sdfsf-sdfssss'

have the same performance with:

select aa,bb,cc from bileta_te_lozura where id=1167876

Every table has some million rows.

Anyway... this also does not work. It report error during insert

Partitioned view 'renis.dbo.bileta_te_lozura' is not updatable because table '[renis].[dbo].[bileta_te_lozura_2007_01]' has a DEFAULT constraint.

|||

Ok Regis,

I'm starting to get a better idea about your situation. I think that if you do not have a primary key for the data, and that if you need to create a surrogate key, and since IDENTITY is not available in this situation, you may have to create a 'Table of Numbers' and get/increment the new value before each INSERT. One option would be having a Staging table, where the IDENTITY column does exist, and then immediately (after the IDENTITY value is assigned) move the data to your partitioned tables.

I also caution you that having a new table for every month will rapidly become burdensome. If you are using SQL 2005, you may wish to investigate table partitioning -and if you are not using SQL 2005, table partitioning may be the reason to upgrade. See Books Online, topic: [Partitioned Tables]

Distributed Partitioned Views (DPV) are best suited for multiple servers.

|||I tried and resolved this problem using partition tables... With partition views this was impossible, (not impossible, but just too long and complicated, which in generall means a lot of bugs)