Encrypt Stored Procedure

Hi All
I am looking for a way to encrypt our stored procedures in a SQL Server 2000
database so that the Intellectual Property is not readily accessible. I am
aware of the WITH ENCRYPT option when creating the stored procedure however I
am looking for a solution that is not easily able to be un-encrypted. Is
anyone aware of a solution that will encrypt stored procedures?
Thanks
Try a third party product like :
http://www.ecatenate.com/dblockdown_product_info.html
or
http://www.sql-shield.com/
I have never tried either
"David" wrote:

> Hi All
> I am looking for a way to encrypt our stored procedures in a SQL Server 2000
> database so that the Intellectual Property is not readily accessible. I am
> aware of the WITH ENCRYPT option when creating the stored procedure however I
> am looking for a solution that is not easily able to be un-encrypted. Is
> anyone aware of a solution that will encrypt stored procedures?
> Thanks

Encrypt Stored Procedure

Hi All
I am looking for a way to encrypt our stored procedures in a SQL Server 2000
database so that the Intellectual Property is not readily accessible. I am
aware of the WITH ENCRYPT option when creating the stored procedure however
I
am looking for a solution that is not easily able to be un-encrypted. Is
anyone aware of a solution that will encrypt stored procedures?
ThanksTry a third party product like :
http://www.ecatenate.com/dblockdown_product_info.html
or
http://www.sql-shield.com/
I have never tried either
"David" wrote:

> Hi All
> I am looking for a way to encrypt our stored procedures in a SQL Server 20
00
> database so that the Intellectual Property is not readily accessible. I a
m
> aware of the WITH ENCRYPT option when creating the stored procedure howeve
r I
> am looking for a solution that is not easily able to be un-encrypted. Is
> anyone aware of a solution that will encrypt stored procedures?
> Thanks

Encrypt all

Hi to all
i have A LOT of stored procedures that i have to encrypt. There is any nice way to do it automatically without having to ALTER them with the ENCRYPTION keyword one by one?
Thanx in advanceI don't believe there is another way to do it. BOL makes it very clear the syntax required for altering a SP.

Good luck and I hope you have plenty of time on your hand.|||can i say "oh sh*t" ? :-)

i expected that anyway...just need to be sure of it

thanx|||I think you will be saying on S**t for every one you have to do manually!

Just remember to backup them up safely becaus once encrypted... you know the rest!

Good luck and have fun. Perhaps you could use this weekend to do it?! :)|||Every encrypted procedure can be decrypted, so if you just want to protect the code by doing that, don't waste your time. The code can be easily extracted even if is "encrypted".

Originally posted by Crespo-n00b
I think you will be saying on S**t for every one you have to do manually!

Just remember to backup them up safely becaus once encrypted... you know the rest!

Good luck and have fun. Perhaps you could use this weekend to do it?! :)|||mmm...not so sure of it. the only method to decrypt a sql server encryption should the the brute-force method, since encryption is irreversible.

am i wrong? if yes can you show the proof?|||Well, take a look at
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=505&lngWId=5

Originally posted by manowar
mmm...not so sure of it. the only method to decrypt a sql server encryption should the the brute-force method, since encryption is irreversible.

am i wrong? if yes can you show the proof?

Emptying the primary data file

Greetings all
I have a database where the primary filegroup has been allocated very
fragmented. I have tried to defragment my database by adding a new file
to the primary filegroup, allocation space properly and calling DBCC
SHRINKFILE('File1', EMPTYFILE) to move all the data from one file to the
other.
However, when I try to remove the original file i get an error message
that "The primary data file cannot be removed". After some research, I
discovered that the system tables seem to be allocated din the primary
data file and that EMPTYFILE does not move these.
Is there any way to move system tables to another file in the PRIMARY
filegroup making the other file the new primary datafile?
/Thomas Kejser
Thomas Kejser wrote:
> Greetings all
> I have a database where the primary filegroup has been allocated very
> fragmented. I have tried to defragment my database by adding a new
> file to the primary filegroup, allocation space properly and calling
> DBCC SHRINKFILE('File1', EMPTYFILE) to move all the data from one
> file to the other.
> However, when I try to remove the original file i get an error message
> that "The primary data file cannot be removed". After some research, I
> discovered that the system tables seem to be allocated din the primary
> data file and that EMPTYFILE does not move these.
> Is there any way to move system tables to another file in the PRIMARY
> filegroup making the other file the new primary datafile?
> /Thomas Kejser
I don't think you can remove the primary data file. See this thread as
it mentnions a possible hack. Just test it on a dev server and back up
your database before trying it in production:
http://webservertalk.com/t429554.html
David Gugick
Imceda Software
www.imceda.com
|||if you have extent fragmentation then adding another filegroup will not
necessarilly resolve your problem. you need to
1) drop the additional file (run dbcc shrinkfile with the emptyfile option
and delete secondary file)
2) run dbcc checkdb with repair_rebuild to repair allocation errors and
rebuild indexes.(this will fix extent fragmentation currently experienced)
3) if this is resolved but you still feel that you need to defragment the
MDF file .. .then you can either
- stop sql server
- copy mdf and ldf file off the OS drive
- defragment drive
- copy mdf file back to the OS drive
OR
- use a utility which it's name escapes me at the moment(SQLDefrag?)
- this will allow you to perform task without copying the database files
off the drive(I have not found it as effective as the first option)
HTH
"Thomas Kejser" <thomas@.kejser.org> wrote in message
news:%23bNEQe7IFHA.2640@.TK2MSFTNGP09.phx.gbl...
> Greetings all
> I have a database where the primary filegroup has been allocated very
> fragmented. I have tried to defragment my database by adding a new file
> to the primary filegroup, allocation space properly and calling DBCC
> SHRINKFILE('File1', EMPTYFILE) to move all the data from one file to the
> other.
> However, when I try to remove the original file i get an error message
> that "The primary data file cannot be removed". After some research, I
> discovered that the system tables seem to be allocated din the primary
> data file and that EMPTYFILE does not move these.
> Is there any way to move system tables to another file in the PRIMARY
> filegroup making the other file the new primary datafile?
> /Thomas Kejser
|||You might want to consider moving your data to another filegroup and use
your primary filegroup just for database metadata.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:O48tom7IFHA.656@.TK2MSFTNGP14.phx.gbl...
> Thomas Kejser wrote:
> I don't think you can remove the primary data file. See this thread as it
> mentnions a possible hack. Just test it on a dev server and back up your
> database before trying it in production:
> http://webservertalk.com/t429554.html
>
>
> --
> David Gugick
> Imceda Software
> www.imceda.com

Emptying the primary data file

Greetings all
I have a database where the primary filegroup has been allocated very
fragmented. I have tried to defragment my database by adding a new file
to the primary filegroup, allocation space properly and calling DBCC
SHRINKFILE('File1', EMPTYFILE) to move all the data from one file to the
other.
However, when I try to remove the original file i get an error message
that "The primary data file cannot be removed". After some research, I
discovered that the system tables seem to be allocated din the primary
data file and that EMPTYFILE does not move these.
Is there any way to move system tables to another file in the PRIMARY
filegroup making the other file the new primary datafile?
/Thomas KejserThomas Kejser wrote:
> Greetings all
> I have a database where the primary filegroup has been allocated very
> fragmented. I have tried to defragment my database by adding a new
> file to the primary filegroup, allocation space properly and calling
> DBCC SHRINKFILE('File1', EMPTYFILE) to move all the data from one
> file to the other.
> However, when I try to remove the original file i get an error message
> that "The primary data file cannot be removed". After some research, I
> discovered that the system tables seem to be allocated din the primary
> data file and that EMPTYFILE does not move these.
> Is there any way to move system tables to another file in the PRIMARY
> filegroup making the other file the new primary datafile?
> /Thomas Kejser
I don't think you can remove the primary data file. See this thread as
it mentnions a possible hack. Just test it on a dev server and back up
your database before trying it in production:
http://webservertalk.com/t429554.html
David Gugick
Imceda Software
www.imceda.com|||if you have extent fragmentation then adding another filegroup will not
necessarilly resolve your problem. you need to
1) drop the additional file (run dbcc shrinkfile with the emptyfile option
and delete secondary file)
2) run dbcc checkdb with repair_rebuild to repair allocation errors and
rebuild indexes.(this will fix extent fragmentation currently experienced)
3) if this is resolved but you still feel that you need to defragment the
MDF file .. .then you can either
- stop sql server
- copy mdf and ldf file off the OS drive
- defragment drive
- copy mdf file back to the OS drive
OR
- use a utility which it's name escapes me at the moment(SQLDefrag?)
- this will allow you to perform task without copying the database files
off the drive(I have not found it as effective as the first option)
HTH
"Thomas Kejser" <thomas@.kejser.org> wrote in message
news:%23bNEQe7IFHA.2640@.TK2MSFTNGP09.phx.gbl...
> Greetings all
> I have a database where the primary filegroup has been allocated very
> fragmented. I have tried to defragment my database by adding a new file
> to the primary filegroup, allocation space properly and calling DBCC
> SHRINKFILE('File1', EMPTYFILE) to move all the data from one file to the
> other.
> However, when I try to remove the original file i get an error message
> that "The primary data file cannot be removed". After some research, I
> discovered that the system tables seem to be allocated din the primary
> data file and that EMPTYFILE does not move these.
> Is there any way to move system tables to another file in the PRIMARY
> filegroup making the other file the new primary datafile?
> /Thomas Kejser|||You might want to consider moving your data to another filegroup and use
your primary filegroup just for database metadata.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:O48tom7IFHA.656@.TK2MSFTNGP14.phx.gbl...
> Thomas Kejser wrote:
> I don't think you can remove the primary data file. See this thread as it
> mentnions a possible hack. Just test it on a dev server and back up your
> database before trying it in production:
> http://webservertalk.com/t429554.html
>
>
> --
> David Gugick
> Imceda Software
> www.imceda.com

Emps working Hrs. <CrossTab> ..

hello all

i'm really confused .. i use VS 2005, VB.NET, Crystal Reports and SQL Server Studio Managment as my DB..

My problem is i dont know where do i have to implement this report i want to produce .. its working hours for all employees showing by month ...

ex:

Jan-07 Feb-07 March-07 ......HrsSUM

joe 54 50 88 sum(hrs)

Sam 20 20 50 sum(hrs)

note : it doesnt always starts at jan-07 ... we have a "cut off date" which is the calculations start date till the end of the project (2010)

so its a crosstab query ... should i do that using crystal report , writing a function there to generate the months and create a crosstable ?(no idea how to do that).... or writing a VB code and pass it to the report ?

or just create a stored procedure in the DB to do that ?

i think the last one is wt should do it ... but i still dont know how

any help plz ,,,,,,,,

I would create a query to sum all the hours for each employee by month.

Then use crystal reports to generate the crosstab report and summation.