SOAP Endpoint: How to Receive RAISERROR as Exception?
Tue, 29 Apr 2008 11:34:19 +0200
Hi,
I've created a SOAP Endpoint but I don't know how to define it in a way that RAISERROR is returned as a "self-speaking" exception.
If I declare a WEBMETHOD with FORMAT = ROWS_ONLY, I get an exception but its text is just something general. The text I've provided with RAISERROR doesn't seem to get through.
...
|
accessing sql server via IP is very slow
Mon, 28 Apr 2008 05:09:00 -0700
Hello,
we got a situation with sql 2005 server that configured to be access with
both name pipes and tcp/ip.
while accessing the server via name pipes is very fast other method ip is
very slow
someone could put a light on this issue
Thanks
...
|
SOAP endpoint: Doesn't publish user defined table functions - why?
Sun, 27 Apr 2008 13:27:42 +0200
Hi,
I can't export user defined table functions. Can someone please help me out on how to export this kind of function? I can publish stored procedures and user defined scalar functions, but when I change the function type to table (either inline or multiline) the function is not available from the WSDL anymore.
...
|
Can't connect to SSL SOAP endpoint
Sun, 27 Apr 2008 03:54:28 +0200
Hi,
I've been trying to set-up an SSL secured SOAP endpoint to my development SQL Server. But I just can't get this to work...
If I set the PORTS parameter to CLEAR and the LOGIN_TYPE to Windows everything works fine using http://localhost/MyDB/SQL?wsdl.
But if I set PORTS=(SSL) and LOGIN_TYPE = MIXED, IE s ...
|
Re: Visual Web Developer 2005 To SQL Server Express
Fri, 25 Apr 2008 21:42:46 -0700
---
*** Sent via Developersdex http://www.developersdex.com *** ...
|
Backup across domain
Fri, 25 Apr 2008 05:39:01 -0700
Hey all,
I am in a domain A and want to make a database backup from domain B (dmz)
which I have sa password for. The backup is performed with a maintenance plan.
The backupped files is going to be saved on a file share on domain A.
I have some problems with the credentials:
Executing the query "BACKUP DATA ...
|
Transport-level errors occur after adding new IP address
Thu, 24 Apr 2008 11:09:00 -0700
We get this when we add IP addresses to the Windows system when SQL 2005
database activity is on-going:
"Database error: A transport-level error has occurred when receiving results
from the server. (provider: TCP Provider, error: 0 - The semaphore timeout
period has expired.)"
.NET application can be run ...
|
|
|
VS2008 Server Explorer takes 45 seconds to connect to SQL2005 Data
Tue, 22 Apr 2008 13:03:01 -0700
I have a good spec box running Windows Server 2008 with SQL2005 SP2.
I have a few machines running Vista SP1 that run Visual Studio 2008.
When I try and connect to a database via VS2008 Server explorer I initially
get time out errors. After setting the timeout (via Advance Properties) to
120 I manage to connec ...
|
SPID value of -4
Mon, 21 Apr 2008 13:33:21 -0700
Hello...
I am currently seeing a spid value of -4 in my production SQL Server 2005
environment. There is alot of blocking and I came across this number. I did
some research and could only find information about a spid value of -2 which
is related to orphaned transactions. This spid appears to be doing al ...
|
Hacking MSSQL?
Sat, 19 Apr 2008 00:04:59 -0700 (PDT)
Hey guys! Good News. Secure Auditor is new software that identifies
vulnerabilities in Windows, Oracle, MSSQL and Cisco Routers. So
exploit vulnerabilities and enjoy additional 30 tools along with
scanning, auditing, forensics and penetration test. Crack passwords of
any windows or Oracle machine. Here is the li ...
|
