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 ...
|
|
|
Quick question.
Sun, 15 Jun 2008 20:50:58 -0400
I am not sure where I have to place this question.
My question is how I can integrate Ms Great Plain with Reporting Services. I
want to create couple of reports based on Ms Great Plains, Please advice how
I can fulfill that?
Thanks
...
|
Indexing my db
Thu, 12 Jun 2008 11:53:33 +0200
I have indexed my db and I don't think it has speeded it up at all !
Do I have to "build" the indexes or anything else ?
Best regards
KSO, Denmark
...
|
What !!!!
Thu, 12 Jun 2008 10:01:44 +0200
TITLE: DTAEngine
------------------------------
Tuning this edition of SQL Server 2005 is not permitted.
------------------------------
BUTTONS:
OK
------------------------------
What is wrong when I get this massage when I try to use the tuning advisor ?
Here is my versions:
Database Engine Tun ...
|
