MS SQL Server import/export wizard

Hi everyone,
Plese help me out. I import one database from one server to another. This process able to copy all the tables and functions but it copied only few stored procedures.
so tell me how to copy or import remaining stored procedures?You could always right click on the database, go toall tasks and hit generate script and select the sps you need scripted and then run said script on the new server.|||Or better still

try using the Copy Database Wizard instead of the Import/Export Data Wizard

:-) GW

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