Disallow connection for a second or two

Hi
Is it possible to prevent users of a database in SQL Server 2005 from
doing anything for a second or two.
Can this be done using a stored procedure.
thanks
Newish
You can put the database into readonly mode. In the proc do a
ALTER DATABASE AdventureWorks SET READ_ONLY
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Newish" <ahussain3@.gmail.com> wrote in message
news:1160218524.169852.196200@.i3g2000cwc.googlegro ups.com...
> Hi
> Is it possible to prevent users of a database in SQL Server 2005 from
> doing anything for a second or two.
> Can this be done using a stored procedure.
> thanks
> Newish
>
|||Thanks Hilary.
Would this scenario work. Use a stored procedure to issue this
command. Then the same procedure writes a couple of pieces of info to
a table and then revoke this statement.
Hence, during the readonly state will the stored procedure be able to
write.
How do you revert back to read and write status.
thanks once again.
Newish
Hilary Cotter wrote:[vbcol=seagreen]
> You can put the database into readonly mode. In the proc do a
> ALTER DATABASE AdventureWorks SET READ_ONLY
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Newish" <ahussain3@.gmail.com> wrote in message
> news:1160218524.169852.196200@.i3g2000cwc.googlegro ups.com...

Disallow connection for a second or two

Hi
Is it possible to prevent users of a database in SQL Server 2005 from
doing anything for a second or two.
Can this be done using a stored procedure.
thanks
NewishYou can put the database into readonly mode. In the proc do a
ALTER DATABASE AdventureWorks SET READ_ONLY
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Newish" <ahussain3@.gmail.com> wrote in message
news:1160218524.169852.196200@.i3g2000cwc.googlegroups.com...
> Hi
> Is it possible to prevent users of a database in SQL Server 2005 from
> doing anything for a second or two.
> Can this be done using a stored procedure.
> thanks
> Newish
>|||Thanks Hilary.
Would this scenario work. Use a stored procedure to issue this
command. Then the same procedure writes a couple of pieces of info to
a table and then revoke this statement.
Hence, during the readonly state will the stored procedure be able to
write.
How do you revert back to read and write status.
thanks once again.
Newish
Hilary Cotter wrote:[vbcol=seagreen]
> You can put the database into readonly mode. In the proc do a
> ALTER DATABASE AdventureWorks SET READ_ONLY
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Newish" <ahussain3@.gmail.com> wrote in message
> news:1160218524.169852.196200@.i3g2000cwc.googlegroups.com...

Disable Paging

Hi

Is there any way I can disable paging and show all record on one page?

Regards

Amit

You can set the report's InteractiveHeight to 0 to disable paging.

-Chris

|||

Sweet.. Thank you for your help Chris.

Regards

Amit