MS SQL Server 2005 Database Documenter

I have started a Reporting Service project called "SQLDB.Documenter" that can be used to document databases hosted on MS SQL Server 2005. Now, the project is in its alpha phase. I am willing to give it out to people who might be interested to give it a try. It can only document MS SQL Server 2005 databases and requires SQL Server Reporting Services to run it.

Please contact me directly if you are interested and want to give it a try. Any suggestions and/or feedbacks will be highly appreciated.

My e-mail address is <George.Liu@.iko.com>.

Good to hear. You may also want to post this in the Reporting Services area, since this one deals primarily with documentation.

sql

MS SQL Server 2005 Database Documenter

I have started a Reporting Service project called "SQLDB.Documenter" that can be used to document databases hosted on MS SQL Server 2005. Now, the project is in its alpha phase. I am willing to give it out to people who might be interested to give it a try. It can only document MS SQL Server 2005 databases and requires SQL Server Reporting Services to run it.

Please contact me directly if you are interested and want to give it a try. Any suggestions and/or feedbacks will be highly appreciated.

My e-mail address is <George.Liu@.iko.com>.

Good to hear. You may also want to post this in the Reporting Services area, since this one deals primarily with documentation.

MS SQL security best practices?

Hi all,
Is there a document exists that identifies/discusses/lists security best
practices for MS SQL Server?
Any info. will be appreciated.
Plese, post reply to this msg.
Thanks in Advance.
-MsdTry SQLSecurity.com
I do have an article on my site:
http://vyaskn.tripod.com/sql_server_security_best_practices.htm but I
haven't updated it recently.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"MSD" <no@.spam> wrote in message
news:Xns9499B11D0EF8Anospam@.207.46.248.16...
Hi all,
Is there a document exists that identifies/discusses/lists security best
practices for MS SQL Server?
Any info. will be appreciated.
Plese, post reply to this msg.
Thanks in Advance.
-Msd|||Hi,
Look into this article as well on "Implementation of Server Level Security
and Object Level Security"
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechn
ol/sql/maintain/security/sp3sec/SP3SEC02.ASP
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:OVq$v2y#DHA.3500@.tk2msftngp13.phx.gbl...
> Try SQLSecurity.com
> I do have an article on my site:
> http://vyaskn.tripod.com/sql_server_security_best_practices.htm but I
> haven't updated it recently.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
>
> "MSD" <no@.spam> wrote in message
> news:Xns9499B11D0EF8Anospam@.207.46.248.16...
> Hi all,
> Is there a document exists that identifies/discusses/lists security best
> practices for MS SQL Server?
> Any info. will be appreciated.
> Plese, post reply to this msg.
> Thanks in Advance.
> -Msd
>|||Lots of stuff on the SQL site
http://www.microsoft.com/sql/techinfo/administration/2000/security/default.asp
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"MSD" <no@.spam> wrote in message
news:Xns9499B11D0EF8Anospam@.207.46.248.16...
> Hi all,
> Is there a document exists that identifies/discusses/lists security best
> practices for MS SQL Server?
> Any info. will be appreciated.
> Plese, post reply to this msg.
> Thanks in Advance.
> -Msd

MS SQL security best practices?

Hi all,
Is there a document exists that identifies/discusses/lists security best
practices for MS SQL Server?
Any info. will be appreciated.
Plese, post reply to this msg.
Thanks in Advance.
-MsdTry SQLSecurity.com
I do have an article on my site:
http://vyaskn.tripod.com/sql_server...t_practices.htm but I
haven't updated it recently.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"MSD" <no@.spam> wrote in message
news:Xns9499B11D0EF8Anospam@.207.46.248.16...
Hi all,
Is there a document exists that identifies/discusses/lists security best
practices for MS SQL Server?
Any info. will be appreciated.
Plese, post reply to this msg.
Thanks in Advance.
-Msd|||Hi,
Look into this article as well on "Implementation of Server Level Security
and Object Level Security"
http://www.microsoft.com/technet/tr...chnet/prodtechn
ol/sql/maintain/security/sp3sec/SP3SEC02.ASP
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:OVq$v2y#DHA.3500@.tk2msftngp13.phx.gbl...
> Try SQLSecurity.com
> I do have an article on my site:
> http://vyaskn.tripod.com/sql_server...t_practices.htm but I
> haven't updated it recently.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
>
> "MSD" <no@.spam> wrote in message
> news:Xns9499B11D0EF8Anospam@.207.46.248.16...
> Hi all,
> Is there a document exists that identifies/discusses/lists security best
> practices for MS SQL Server?
> Any info. will be appreciated.
> Plese, post reply to this msg.
> Thanks in Advance.
> -Msd
>|||Lots of stuff on the SQL site
http://www.microsoft.com/sql/techin...www.sqlpass.org
"MSD" <no@.spam> wrote in message
news:Xns9499B11D0EF8Anospam@.207.46.248.16...
> Hi all,
> Is there a document exists that identifies/discusses/lists security best
> practices for MS SQL Server?
> Any info. will be appreciated.
> Plese, post reply to this msg.
> Thanks in Advance.
> -Msd

MS SQL Cluster w/ Clariion SAN

Okay, assume that I have read every technical document from MS and Dell about installing SQL into a cluster on a Clariion SAN (I haven't actually read them all yet, but I'm getting there).

What gotcha's are waiting to bite me? I am using:

1. An Active/Passive 2-node cluster
2. Windows 2000 Advanced Server
3. SQL 2000 Enterprise Server
4. EMC Clariion CX400 15-drive array

I have never before configured a cluster server. I got dropped into this project. No one else in the project has any real experience with clusters either.

I have the step-by-step instructions from both Dell and MS: I plan to follow these very carefully. I'm not looking for step-by-step instructions here, I'm hoping for some, "when I tried this, it did that..." or "watch out, the instruction says to do x, but you should really do y..." sort of thing. Also, if you have any additional documentation outside of the vendor required reading, I wuld be grateful for a link.

I understand that there are issues around:
1. Snapview backup from EMC (doesn't work on multi-volume DBs)
2. SQL Mail and SQL Agent Mail (Outlook is not cluster-aware)

I realize this is kind of open-ended; but I really would like to get this right the first time around since it appears that I will be supporting this installation long term.

Regards,

hmscott- http://support.microsoft.com/default.aspx?scid=kb;EN-US;254321 - cluster do's and dont's.
- http://www.sql-server-performance.com/sqlserver2000_clustering_install_part1.asp to stop unnecessary services during setup.

- http://support.microsoft.com/default.aspx?scid=/support/sql/content/70papers/70clstr.asp from the step by step guide pay attention on post installation topics.

- http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/clustering/scconbp.mspx though this refers to cluster on windows2003 best practices, for information.

HTH

MS SQL 2000 and MS Word Document

I need one information. Is any possible to import word document into table
field ?
thnx
borisDo you want to insert the whole document into SQL Server or do you want to
extract information from the document and insert into SQL Server.
If you want to insert the document as a binary object I would recommend that
you look at the following section in Books Online:
http://msdn.microsoft.com/library/d...r />
_07zo.asp
Simon
This posting is provided "as is" with no warranties and confers no rights.
"Boris" <boris@.osijek.hr> wrote in message
news:ehKokfXJFHA.2640@.TK2MSFTNGP09.phx.gbl...
>I need one information. Is any possible to import word document into table
>field ?
> thnx
> boris
>

MS SQL 2000 and MS Word Document

I need one information. Is any possible to import word document into table
field ?
thnx
borisDo you want to insert the whole document into SQL Server or do you want to
extract information from the document and insert into SQL Server.
If you want to insert the document as a binary object I would recommend that
you look at the following section in Books Online:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_md_03_07zo.asp
Simon
This posting is provided "as is" with no warranties and confers no rights.
"Boris" <boris@.osijek.hr> wrote in message
news:ehKokfXJFHA.2640@.TK2MSFTNGP09.phx.gbl...
>I need one information. Is any possible to import word document into table
>field ?
> thnx
> boris
>

MS SQL 2000 and MS Word Document

I need one information. Is any possible to import word document into table
field ?
thnx
boris
Do you want to insert the whole document into SQL Server or do you want to
extract information from the document and insert into SQL Server.
If you want to insert the document as a binary object I would recommend that
you look at the following section in Books Online:
http://msdn.microsoft.com/library/de...md_03_07zo.asp
Simon
This posting is provided "as is" with no warranties and confers no rights.
"Boris" <boris@.osijek.hr> wrote in message
news:ehKokfXJFHA.2640@.TK2MSFTNGP09.phx.gbl...
>I need one information. Is any possible to import word document into table
>field ?
> thnx
> boris
>