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 server cannot start

I have MS SQL 2000. I wanted to install SP3a and
encountered the following error :
FRunCM : Process <> generated Fatal exception c0000005.
Exception Access Violation - SQL Server is terminating
this process.
This happens during the running of the script
sp3_server_repl.sql. After that, I couldn't start the SQL
server anymore. I tried the solution given by Microsoft
but it didn't work.
SO, I decided to uninstall MS SQL and install again. But
after installing a fresh copy, I still get the same error
when the SQL Server tries to startup.
Please help, thank you.
PhilipHI Philip.
Check this article
814572 FIX: SQL Server Does Not Start and an Access Violation Occurs After
You
http://support.microsoft.com/?id=814572
If that does not help, download MDAC 2.7 SP1 from
http://www.microsoft.com/downloads/...00f2-cae7-493d-
b0f3-ae36c570ade8&languageid=f49e8428-7071-4979-8a67-3cffcb0c2524&displaylan
g=en
Reinstall MDAC 2.7 SP1 refresh and rerun SP3 installation.
Hope that helps.
Regards,
Gayathri Rau [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.|||As a safety, pls check the dasetup,log to make sure that mdac installed
successfully.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

MS SQL server cannot start

I have MS SQL 2000. I wanted to install SP3a and
encountered the following error :
FRunCM : Process <> generated Fatal exception c0000005.
Exception Access Violation - SQL Server is terminating
this process.
This happens during the running of the script
sp3_server_repl.sql. After that, I couldn't start the SQL
server anymore. I tried the solution given by Microsoft
but it didn't work.
SO, I decided to uninstall MS SQL and install again. But
after installing a fresh copy, I still get the same error
when the SQL Server tries to startup.
Please help, thank you.
PhilipAs a safety, pls check the dasetup,log to make sure that mdac installed
successfully.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.sql

MS SQL Server 2005 Express Edition Installation.

Hi,
I want to install MS SQL Server 2005 Express Edition. can any one
guide me the installation process of SQL Server 2005 Express Edition
and it's Hardware Requirment.
It will be more useful if get any other information on related
topic which i miss to mention.
Thanks & Regards,
MS SQL DBA.
Installation details: http://msdn2.microsoft.com/en-us/library/ms143441.aspx
Hardware requirements:
http://www.microsoft.com/sql/editions/express/sysreqs.mspx
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Hi Paul,
Thanks for your reply.
Thanks & Regards,
Sajid C.
Paul Ibison wrote:
> Installation details: http://msdn2.microsoft.com/en-us/library/ms143441.aspx
> Hardware requirements:
> http://www.microsoft.com/sql/editions/express/sysreqs.mspx
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .

MS SQL Server 2005 Express Edition Installation.

Hi,
I want to install MS SQL Server 2005 Express Edition. can any one
guide me the installation process of SQL Server 2005 Express Edition
and it's hardware Requirment.
It will be more useful if get any other information on related
topic which i miss to mention.
Thanks & Regards,
MS SQL DBA.Installation details: http://msdn2.microsoft.com/en-us/library/ms143441.aspx
Hardware requirements:
http://www.microsoft.com/sql/editio...ss/sysreqs.mspx
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||Hi Paul,
Thanks for your reply.
Thanks & Regards,
Sajid C.
Paul Ibison wrote:
> Installation details: hardware requirements:
> [url]http://www.microsoft.com/sql/editions/express/sysreqs.mspx" target="_blank">http://msdn2.microsoft.com/en-us/li...ss/sysreqs.mspx
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .sql

MS SQL Server 2005 Express Edition Installation.

Hi,
I want to install MS SQL Server 2005 Express Edition. can any one
guide me the installation process of SQL Server 2005 Express Edition
and it's Hardware Requirment.
It will be more useful if get any other information on related
topic which i miss to mention.
Thanks & Regards,
MS SQL DBA.Installation details: http://msdn2.microsoft.com/en-us/library/ms143441.aspx
Hardware requirements:
http://www.microsoft.com/sql/editions/express/sysreqs.mspx
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||Hi Paul,
Thanks for your reply.
Thanks & Regards,
Sajid C.
Paul Ibison wrote:
> Installation details: http://msdn2.microsoft.com/en-us/library/ms143441.aspx
> Hardware requirements:
> http://www.microsoft.com/sql/editions/express/sysreqs.mspx
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .

MS SQL Server - Transfer Database From non-unicode to unicode

Any one know the process of transfering the database from non-unicode to unicode. Coz I like to transfer the data from english to hebrew.

Jebaprakash Johnson wrote:

Any one know the process of transfering the database from non-unicode to unicode.

i'm not sure if this will work, but you can try to convert the column data types to unicode in management studio.

MS SQL Server - sleeping processes that reawaken

We are runnoing SQL server enterprise manager on a Win2K box. In the Process Info view, there are several processes that are in a "sleeping" state whose hostname references a machine that is no longer on our network.

When I try to kill the process, it does go away (verified by both the "Current SQL Server Log" and in the Evenet Manager), but a few minutes later, the process reappears with the same PID and Hostname.

Does anyone know why this might occur?

ThanksThe records are existing in your master..sysprocesses. Killing those SPID's would suffice. In case it is coming back, maybe somebody has changed his machine name to that machine name as that machine no longer exists. And then he is accessing your SQL Server.

MS SQL Parelleism

Hello all,

i have two node cluster, each server has 4 dual core processors (16 virtuals) and 16 GB of RAM.
I have to examine if MS SQL Server process is executed by more than one of processor (SQL batchs ect) because i have message of bad working antivirus software whitch blocs multiprocessor execution.

Have anybody idea how can i proof multiproccesor execution ?

Thank you

Regards

Quote:

Originally Posted by Hermess

Hello all,

i have two node cluster, each server has 4 dual core processors (16 virtuals) and 16 GB of RAM.
I have to examine if MS SQL Server process is executed by more than one of processor (SQL batchs ect) because i have message of bad working antivirus software whitch blocs multiprocessor execution.

Have anybody idea how can i proof multiproccesor execution ?

Thank you

Regards

I don't know of a way to "prove" multiprocessor execution, however, you can check your Processor control settings in Enterprise Manager, and watch the individual CPU usage with Task Manager.