Cluster Server installation other than default directory

Is anyone aware of any issues that can arise from installing MS SQL Server
2000 on the root of a drive - x:\\MSSQL\Data - instead of using the using
the default structure - x:\Program Files\Microsoft SQL Server\MSSQL\Data?
I have always installed to the root directory be it stand-alone or clustered
installs without any issues but I need to know whether there might be
issues especially regarding virtual sql servers installs.
Thanks
I have not seen any differences with clustering, you should be fine with any
path, as long as all possible owners have the same paths.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Gboyega Adepegba" <muyid@.hotmail.com> wrote in message
news:u5IVSaOZEHA.3752@.TK2MSFTNGP12.phx.gbl...
> Is anyone aware of any issues that can arise from installing MS SQL Server
> 2000 on the root of a drive - x:\\MSSQL\Data - instead of using the using
> the default structure - x:\Program Files\Microsoft SQL Server\MSSQL\Data?
> I have always installed to the root directory be it stand-alone or
clustered
> installs without any issues but I need to know whether there might be
> issues especially regarding virtual sql servers installs.
> Thanks
>
|||No issues. I have installed clustered instances of SQL Server 2000 on non-default locations without any problems.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
sqlsql

CLR Trigger -> Send Insert/Update/Delete Message to Windows Service

Hi,

I have an c# windows service, which is running on the same machine where my mssql server is installed. This service must be informed for each insert/update/delete event on one specific table.

My idea was to create an CLR Trigger for this table which can communicate with this service via .NET remoting. But the problem is, that the system.runtime.remoting assembly is not integrated within the mssql clr enviroment => i can't use remoting.

Are there any other idea's how can i solve this?

Best regards,
Thomas

Hi,

what about using Query Notification ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||I had the same problem as you and I have used two different tecniques: both of them uses CLR stored procs.

1. An OS event set by SqlServer: useful when to have to notify that an event occurred without any param. Each different event must be attached to a different event name.

[SqlProcedure]
public static void SetOsEvent(SqlString eventName) {
try {
EventWaitHandle.OpenExisting((string)eventName).Set();
}
catch (WaitHandleCannotBeOpenedException) {
}
}

2. An UDP Message. Useful for non-reliable and fast messaging system, such as broadcasting the internal net that an event has occurred.

[SqlProcedure]
public static void UdpSend(SqlString address, SqlInt32 port, SqlString message) {
try {
System.Net.Sockets.UdpClient client = new System.Net.Sockets.UdpClient();
byte[] datagram = message.GetUnicodeBytes();
client.Send(datagram, datagram.Length, (string)address, (int)port);
}
catch{
}
}

[SqlProcedure]
public static void UdpBroadcast(SqlInt32 port, SqlString message) {
try {
System.Net.Sockets.UdpClient client = new System.Net.Sockets.UdpClient();
byte[] datagram = message.GetUnicodeBytes();
System.Net.IPEndPoint ep = new System.Net.IPEndPoint(System.Net.IPAddress.Broadcast, (int)port);
client.Send(datagram, datagram.Length, ep);
}
catch {
}
}

Hope that helps.

Client user timeout

Hi,
Used Mssql 5 exp. On win 2003 server
my problem,
client user time out 15 minute by sql server,
Client user inside my program, connection closed,
logout program and relogin program work again,
no network problem, no closed network connection
How can i do,There are several reasons depending upon how the connection process is set
up. For a brief review see: http://vyaskn.tripod.com/watch_your_timeouts.htm
Anith

cli for MSSQL server?

I need to put a series of records in two columns of an
Excel file into an MSSQL database on a server I am
connected to over a LAN. On my computer I am running SQL
Server service manager. I do not appear to have the
software to insert. I see there are a bunch of
executables in the MSSQL directory, but they do not appear
to accept SQL commands. Please Help!
UsarianWhat happens if you try to run DTSWiz.exe from Start -> Run
?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Usarian" <usariankristine@.juno.com> wrote in message
news:0f2b01c3dfa7$9cf9b990$a101280a@.phx.gbl...
I need to put a series of records in two columns of an
Excel file into an MSSQL database on a server I am
connected to over a LAN. On my computer I am running SQL
Server service manager. I do not appear to have the
software to insert. I see there are a bunch of
executables in the MSSQL directory, but they do not appear
to accept SQL commands. Please Help!
Usarian|||File not found. It does not show in my searches on local
and networked drives either.
thank you for your prompt reply tho!
Usarian

quote:

---

>--Original Message--
>What happens if you try to run DTSWiz.exe from Start ->

---

Run

quote:

---

>?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>
>"Usarian" <usariankristine@.juno.com> wrote in message
>news:0f2b01c3dfa7$9cf9b990$a101280a@.phx.gbl...
>I need to put a series of records in two columns of an
>Excel file into an MSSQL database on a server I am
>connected to over a LAN. On my computer I am running SQL
>Server service manager. I do not appear to have the
>software to insert. I see there are a bunch of
>executables in the MSSQL directory, but they do not appear
>to accept SQL commands. Please Help!
>Usarian
>
>.
>

---

|||Then consider installing SQL Server client utilities on this machine.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
<anonymous@.discussions.microsoft.com> wrote in message
news:176101c3dfad$1e3e1ff0$a401280a@.phx.gbl...
File not found. It does not show in my searches on local
and networked drives either.
thank you for your prompt reply tho!
Usarian

quote:

---

>--Original Message--
>What happens if you try to run DTSWiz.exe from Start ->

---

Run

quote:

---

>?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>
>"Usarian" <usariankristine@.juno.com> wrote in message
>news:0f2b01c3dfa7$9cf9b990$a101280a@.phx.gbl...
>I need to put a series of records in two columns of an
>Excel file into an MSSQL database on a server I am
>connected to over a LAN. On my computer I am running SQL
>Server service manager. I do not appear to have the
>software to insert. I see there are a bunch of
>executables in the MSSQL directory, but they do not appear
>to accept SQL commands. Please Help!
>Usarian
>
>.
>

---

cli for MSSQL server?

I need to put a series of records in two columns of an
Excel file into an MSSQL database on a server I am
connected to over a LAN. On my computer I am running SQL
Server service manager. I do not appear to have the
software to insert. I see there are a bunch of
executables in the MSSQL directory, but they do not appear
to accept SQL commands. Please Help!
UsarianWhat happens if you try to run DTSWiz.exe from Start -> Run
?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Usarian" <usariankristine@.juno.com> wrote in message
news:0f2b01c3dfa7$9cf9b990$a101280a@.phx.gbl...
I need to put a series of records in two columns of an
Excel file into an MSSQL database on a server I am
connected to over a LAN. On my computer I am running SQL
Server service manager. I do not appear to have the
software to insert. I see there are a bunch of
executables in the MSSQL directory, but they do not appear
to accept SQL commands. Please Help!
Usarian|||File not found. It does not show in my searches on local
and networked drives either.
thank you for your prompt reply tho!
Usarian
>--Original Message--
>What happens if you try to run DTSWiz.exe from Start ->
Run
>?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>
>"Usarian" <usariankristine@.juno.com> wrote in message
>news:0f2b01c3dfa7$9cf9b990$a101280a@.phx.gbl...
>I need to put a series of records in two columns of an
>Excel file into an MSSQL database on a server I am
>connected to over a LAN. On my computer I am running SQL
>Server service manager. I do not appear to have the
>software to insert. I see there are a bunch of
>executables in the MSSQL directory, but they do not appear
>to accept SQL commands. Please Help!
>Usarian
>
>.
>|||Then consider installing SQL Server client utilities on this machine.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
<anonymous@.discussions.microsoft.com> wrote in message
news:176101c3dfad$1e3e1ff0$a401280a@.phx.gbl...
File not found. It does not show in my searches on local
and networked drives either.
thank you for your prompt reply tho!
Usarian
>--Original Message--
>What happens if you try to run DTSWiz.exe from Start ->
Run
>?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>
>"Usarian" <usariankristine@.juno.com> wrote in message
>news:0f2b01c3dfa7$9cf9b990$a101280a@.phx.gbl...
>I need to put a series of records in two columns of an
>Excel file into an MSSQL database on a server I am
>connected to over a LAN. On my computer I am running SQL
>Server service manager. I do not appear to have the
>software to insert. I see there are a bunch of
>executables in the MSSQL directory, but they do not appear
>to accept SQL commands. Please Help!
>Usarian
>
>.
>

clearing log

As a relative newcomer to MSSQL, I've been playing around with a database,
adding and removing tables and tons of data. Now I'm ready to get down to
business.
I notice that the log (LDF file) is now three times the size of the database
itself. I'm pretty sure there's nothing in there that is of any use. Is
there a way to clear it? Is that desirable? Am I better off starting over
with a new database? This one does have some, not a lot, data in it that I'd
like to keep.Try in Query Analyser
BACKUP LOG WITH TRUNCATE_ONLY
Then
DBCC SHRINKFILE( look in BOL for more detail)
If you don't want to do this repeatedly, you can modify the Recovery
Model of the database !
Go to your Database Property, on the last tab, you'll se the recovery
model is at Full or Bulked-Logged, change it to Simple ! Your log will
stop accumulating !
You can also change the recovery model of Model database so the next
database you create will use simple recovery !
For more information on Recovery Model, search BOL
Pollus Brodeur|||If you don't do regular transaction log backups, set the database to simple
recovery mode. Shrinking
considerations: http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Pedersen" <no-reply@.swen.com> wrote in message news:eoMfbUaXFHA.616@.TK2MSFTNGP12.phx.
gbl...
> As a relative newcomer to MSSQL, I've been playing around with a database,
adding and removing
> tables and tons of data. Now I'm ready to get down to business.
> I notice that the log (LDF file) is now three times the size of the databa
se itself. I'm pretty
> sure there's nothing in there that is of any use. Is there a way to clear
it? Is that desirable?
> Am I better off starting over with a new database? This one does have some
, not a lot, data in it
> that I'd like to keep.
>
>
>
>|||Thanks to all.
"Paul Pedersen" <no-reply@.swen.com> wrote in message
news:eoMfbUaXFHA.616@.TK2MSFTNGP12.phx.gbl...
> As a relative newcomer to MSSQL, I've been playing around with a database,
> adding and removing tables and tons of data. Now I'm ready to get down to
> business.
> I notice that the log (LDF file) is now three times the size of the
> database itself. I'm pretty sure there's nothing in there that is of any
> use. Is there a way to clear it? Is that desirable? Am I better off
> starting over with a new database? This one does have some, not a lot,
> data in it that I'd like to keep.
>
>
>
>