SQL 2000 (personal edition)
Tue, 8 Jul 2008 17:17:00 -0700
I need to obtain sql 2000 personal edition but I only have the standard and
enterprise editions on cd. Do I still need to purchase this edition since
it's old or can I obtain any other way? Thanks
--
Breaks ...
|
tcp/ip vs named pipes
Tue, 8 Jul 2008 11:58:39 -0300
Hi Guys... I have 2 aplications App1 and App2.
App1 access Server1 (Sqlserver ent 2000 SP4) through tcp/ip OK!
App1 access Server1 (Sqlserver ent 2000 SP4) through named pipes OK!
App2 access Server2 (Sqlserver std 2000 SP3) can't access through tcp/ip :(
App2 access Server2 (Sqlserver std 2000 SP3) through ...
|
uninstall SQL Server Enterprise Manager Client
Mon, 7 Jul 2008 12:40:00 -0700
I have PC that, when I migrated from an older PC, the SQL Enterprise
Manager client "came along" during the standard MS migration process. Now,
however, it does not function.
I am attempting to remove it, so I can start over, but apparently, there is
no UNINSTALL option, nor is it listed in Control Pa ...
|
Error hanlding in Stored procedure or .Net Application
Fri, 4 Jul 2008 20:01:01 -0700
Dear Professional,
I had serious debate in my organization and I told to my developers to use
Error Handling in Stored procedure BEGIN TRY END TRY BEGIN CATCH END CATCH
but they are saying error handling is better in .Net code instead of stored
procedure,
Please advice me which way is better and give me ...
|
Accessing SQL from an internet page
Fri, 4 Jul 2008 11:53:02 -0700
Hi there:
I'm trying to code a page (ASP .NET) that accesses SQL Server 2005 Express
installed in my own machine.
When vewing it on a browser, SQL Server blocks all attempt to access any
table.
Can anybody help me here?
Thanks in advance.
--
Rafael Soteldo ...
|
Updating SQL-server
Wed, 2 Jul 2008 11:12:54 +0200
How can I update my SQL-server - not the Windows on the server it's
installed but the SQL-server software itself ?
Can I just turn to the usual "Windows update site" and there run the "test
for updates" ?
Best regards
KSor, Denmark
...
|
LIKE search statement for a '%@%'
Sat, 28 Jun 2008 21:20:55 -0400
Does anybody know why searching for a string '@' with LIKE does not work
even when you use ESCAPE
Very strange......
Say the field has ..... I love my @*&!& friend
And I want to SELECT this row when I search for @ with LIKE
Select * from myTable where myField like '%@%' does not work
Select * from m ...
|
|
|
SQL Server 2005 connection issues.
Wed, 25 Jun 2008 12:43:32 -0500
I have a problem that has caused whatever hairs on my head that I had left
to disappear. I distributed an application in a pilot program to over 100
users on a corporate network using an OLEDB connection string to connect to
a SQL Server 2005 database. Of the 100 plus installs, 10 were not able to
connect, even ...
|
Sifobo Enterprise Manager for SQL Server - Free Download
Tue, 17 Jun 2008 21:47:17 -0700 (PDT)
Dear all,
Sifobo Enterprise Manager for Oracle And SQL Server is an MMC based
Oracle and SQL database backup manager for Windows and available for
free download on
http://www.sifobo.com
Please feel free to download and use it or pass it onto anyone who
might be interested..Remember it is FREE ;-) ...
|
Expert Advice
Sun, 15 Jun 2008 21:12:03 -0400
Dear Professional,
I would like to ask couple of question in terms of Load Balancing,
Replication, Database Mirroring.
1. Our organization has two production servers, one is on Toronto and other
one is on New York. In New York I have five databases and Toronto I have
nine databases.
Now the requiremen ...
|
