how to change in SQL 2005 and accept the bin caracter and the langage

Hello

I am newbies with SQL 2005

I want install Windows sharepoint services 3 in french on my SBS 2003 R2 SP2 also in frecnh langage and at the end of the install, a message say to me :

Bin caracter are not accepted in your configuration SQL

Langage is not correct (I have French_CS_AS)

Where is possible to change these parameters ?

I try to find but never find

Thank You in advance for your help

++

Michel

If you have the answer in French it's better for me but not neccessary !

You need to change your collation to French_BIN which means alter database and change collation you can do it in the database properties. You have to know that BIN(binary collation) is the fastest sort but it also require you to use case sensitive data including queries. Run a search for ALTER database, table and columns and binary sort in SQL Server BOL. Check out SQL Server collations below.

http://msdn2.microsoft.com/en-us/library/ms180175.aspx

How to change from Windows to SQL Server Authentication?

Hi

I want to know how can I change Login from Windows Authentication to SQL Server Authentication. I'm using SQL Server Express Edition and SQL Server Management Studio Express to connect to the Sql Server. I selected Windows Authentication during the installation of the SQL Server Express and now i want to cahnge to SQL Server Authentication using sa account.

Your help will be highly appreciated.

1. In Object Explorer choose Properties for your SQL Server instance. Then choose "Security" tab and check "SQL Server and Windows Authentofocation"

2. Enable sa login, because it's disabled by default

|||Thank you Konstantin.

how to change dts import/export windows size

Howdy!
Does any of you good folk know how to change window size of the DTS
Import/Export Wizard window?
Darn thing is very small and inconvinient to work with, no apparent way to
change it's size,
may be there is a registry tweak or something.
Thanks in advance,
I.B.Yes, It's inconvenient. No, there is no way to change the size of it, as
far as I know. Maybe in MS SQL SERVER 2004?
Best regards,
Chuck Conover
www.TechnicalVideos.net

"Ilya Bari" <IBari@.SnappyDsl.net> wrote in message
news:4015c5fd@.news.snappydsl.net...
> Howdy!
> Does any of you good folk know how to change window size of the DTS
> Import/Export Wizard window?
> Darn thing is very small and inconvinient to work with, no apparent way to
> change it's size,
> may be there is a registry tweak or something.
> Thanks in advance,
> I.B.

How to catchup job schedule? Scheduled jobs not running.

Hi,
I try not to schedule jobs during sw/hw maintenance windows, but sometimes
it happens - even more so now with active windows update running. It just
shuts down without regard to what's running.
Unfortunately, when the sql server comes back up, it doesn't run jobs that
are past due. I can't seem to find any setting that would 'catch-up' the
jobs. Would you share your thoughts on how to deal with this situation.
thanks
Doug
I don't think there is a "built-in" function for this type of situation.
However, you can create your own stored procedure that queries
msdb..sysjobhistory and look for run_status = 0, then use sp_start_job to
start those jobs that failed. And then you can set up a scheduled job to run
this SP during every restart.
"Doug Little" wrote:

> Hi,
> I try not to schedule jobs during sw/hw maintenance windows, but sometimes
> it happens - even more so now with active windows update running. It just
> shuts down without regard to what's running.
> Unfortunately, when the sql server comes back up, it doesn't run jobs that
> are past due. I can't seem to find any setting that would 'catch-up' the
> jobs. Would you share your thoughts on how to deal with this situation.
> thanks
> --
> Doug

How to catchup job schedule? Scheduled jobs not running.

Hi,
I try not to schedule jobs during sw/hw maintenance windows, but sometimes
it happens - even more so now with active windows update running. It just
shuts down without regard to what's running.
Unfortunately, when the sql server comes back up, it doesn't run jobs that
are past due. I can't seem to find any setting that would 'catch-up' the
jobs. Would you share your thoughts on how to deal with this situation.
thanks
DougI don't think there is a "built-in" function for this type of situation.
However, you can create your own stored procedure that queries
msdb..sysjobhistory and look for run_status = 0, then use sp_start_job to
start those jobs that failed. And then you can set up a scheduled job to ru
n
this SP during every restart.
"Doug Little" wrote:

> Hi,
> I try not to schedule jobs during sw/hw maintenance windows, but sometimes
> it happens - even more so now with active windows update running. It just
> shuts down without regard to what's running.
> Unfortunately, when the sql server comes back up, it doesn't run jobs that
> are past due. I can't seem to find any setting that would 'catch-up' the
> jobs. Would you share your thoughts on how to deal with this situation.
> thanks
> --
> Doug

How to catchup job schedule? Scheduled jobs not running.

Hi,
I try not to schedule jobs during sw/hw maintenance windows, but sometimes
it happens - even more so now with active windows update running. It just
shuts down without regard to what's running.
Unfortunately, when the sql server comes back up, it doesn't run jobs that
are past due. I can't seem to find any setting that would 'catch-up' the
jobs. Would you share your thoughts on how to deal with this situation.
thanks
--
DougI don't think there is a "built-in" function for this type of situation.
However, you can create your own stored procedure that queries
msdb..sysjobhistory and look for run_status = 0, then use sp_start_job to
start those jobs that failed. And then you can set up a scheduled job to run
this SP during every restart.
"Doug Little" wrote:
> Hi,
> I try not to schedule jobs during sw/hw maintenance windows, but sometimes
> it happens - even more so now with active windows update running. It just
> shuts down without regard to what's running.
> Unfortunately, when the sql server comes back up, it doesn't run jobs that
> are past due. I can't seem to find any setting that would 'catch-up' the
> jobs. Would you share your thoughts on how to deal with this situation.
> thanks
> --
> Doug

How to call remote object using C# Stored procedure

I want to call a windows based service running with remote objects listner from a C# Stored procedure. Any idea how to do that?

Hi-

I'm actually not quite sure what you would like to do, but if you could clarify, I can try to help.

I think your question may be how to do this within C#. 99.9% of the time, if it’s possible to do in C#, then it’s possible to do in SQLCLR (under atleast the UNSAFE permission set).

I'd recommend using MSDN or clarifying what you need to do to make your scenario work within a console application. Once you have your scenario working in a console application, you could port your code to map a stored procedure to an entry point.

Thanks!
Jason

|||

I am running a windows service with one exposed object using remoting.

I want to call that from stored procedure/function created in SQL Server using C#.

How to call remote object using C# Stored procedure

I want to call a windows based service running with remote objects listner from a C# Stored procedure. Any idea how to do that?

Hi-

I'm actually not quite sure what you would like to do, but if you could clarify, I can try to help.

I think your question may be how to do this within C#. 99.9% of the time, if it’s possible to do in C#, then it’s possible to do in SQLCLR (under atleast the UNSAFE permission set).

I'd recommend using MSDN or clarifying what you need to do to make your scenario work within a console application. Once you have your scenario working in a console application, you could port your code to map a stored procedure to an entry point.

Thanks!
Jason

|||

I am running a windows service with one exposed object using remoting.

I want to call that from stored procedure/function created in SQL Server using C#.

How to call remote object using C# Stored procedure

I want to call a windows based service running with remote objects listner from a C# Stored procedure. Any idea how to do that?

Hi-

I'm actually not quite sure what you would like to do, but if you could clarify, I can try to help.

I think your question may be how to do this within C#. 99.9% of the time, if it’s possible to do in C#, then it’s possible to do in SQLCLR (under atleast the UNSAFE permission set).

I'd recommend using MSDN or clarifying what you need to do to make your scenario work within a console application. Once you have your scenario working in a console application, you could port your code to map a stored procedure to an entry point.

Thanks!
Jason

|||

I am running a windows service with one exposed object using remoting.

I want to call that from stored procedure/function created in SQL Server using C#.