Data File Remaining Space

I am running SQL 2000. I have a data file set up with restricted growth. Is
there a stored procedure or script available that I can schedule or run
when I want manually that will give me the space remaining in the data file?
Message posted via http://www.sqlmonster.com
Checkout sp_spaceused in BOL.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Richards via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:be0b5b63225d4993937c2075fbb4510f@.SQLMonster.c om...
> I am running SQL 2000. I have a data file set up with restricted growth.
Is
> there a stored procedure or script available that I can schedule or run
> when I want manually that will give me the space remaining in the data
file?
> --
> Message posted via http://www.sqlmonster.com
|||sp_helpdb YourDBNameHere
gives some information regarding database and file size.
Keith
"Robert Richards via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:be0b5b63225d4993937c2075fbb4510f@.SQLMonster.c om...
> I am running SQL 2000. I have a data file set up with restricted growth.
Is
> there a stored procedure or script available that I can schedule or run
> when I want manually that will give me the space remaining in the data
file?
> --
> Message posted via http://www.sqlmonster.com

Data File Remaining Space

I am running SQL 2000. I have a data file set up with restricted growth. Is
there a stored procedure or script available that I can schedule or run
when I want manually that will give me the space remaining in the data file?
Message posted via http://www.droptable.comCheckout sp_spaceused in BOL.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Richards via droptable.com" <forum@.droptable.com> wrote in message
news:be0b5b63225d4993937c2075fbb4510f@.SQ
droptable.com...
> I am running SQL 2000. I have a data file set up with restricted growth.
Is
> there a stored procedure or script available that I can schedule or run
> when I want manually that will give me the space remaining in the data
file?
> --
> Message posted via http://www.droptable.com|||sp_helpdb YourDBNameHere
gives some information regarding database and file size.
Keith
"Robert Richards via droptable.com" <forum@.droptable.com> wrote in message
news:be0b5b63225d4993937c2075fbb4510f@.SQ
droptable.com...
> I am running SQL 2000. I have a data file set up with restricted growth.
Is
> there a stored procedure or script available that I can schedule or run
> when I want manually that will give me the space remaining in the data
file?
> --
> Message posted via http://www.droptable.com

Data Encryption

HI There,
I was wondering how I encrypt the data I have in my SQL sevrer database? is
there some built in tool that will do this? if there is can someone provide
me with a code snippet to get me started?
SeanSean,
Generally you will be required to write extended stored procedures that
calls on CryptoAPIs for this, as SQL Server encrypts at the packet level
when you setup your network libraries with encryption turn on either using
SSL or multiprotocol. I don't know of samples that I can supply you with
but I believe companies such as Protegrity has some sort of solution, you
might like visiting their web site and search on the internet for some
others. I'm not sure if the next release of SQL Server, Yukon, will have
this built in, but because it can call into the Cryptography namespace in
the CLR, it may make your life a little easier. Another solution is to use
Windows encrypted file system (EFS) and encrypt your entire database that
way although this might not be as granular as you want it to be.
I hope this helps.
Regards
James|||Have a look at:
Whamware.Crypt - www.whamware.com
dbEncrypt - www.appsecinc.com
Encryptionizer for SQL Server - www.netlib.com
Tom
"sean" wrote:
> HI There,
> I was wondering how I encrypt the data I have in my SQL sevrer database? i
s
> there some built in tool that will do this? if there is can someone provid
e
> me with a code snippet to get me started?
> ...|||I can also recommend XP_Crypt from www.activecrypt.com cheap, fast and very
easy to use, they also sell a great activeX component so you can easily encr
ypt in your front end app and decrypt in the database etc..
nntp://news.microsoft.com/microsoft.public.sqlserver.security/ >
Have a look at:
Whamware.Crypt - www.whamware.com
dbEncrypt - www.appsecinc.com
Encryptionizer for SQL Server - www.netlib.com
Tom
"sean" wrote:
> HI There,
> I was wondering how I encrypt the data I have in my SQL sevrer database? i
s
> there some built in tool that will do this? if there is can someone provid
e
> me with a code snippet to get me started?
> ...
[microsoft.public.sqlserver.security > ]