Viewing 15 posts - 5,596 through 5,610 (of 6,105 total)
The only reason we use multiple instances is to get an Active/Active cluster. In the case of a fail-over, both instances will be running on one server. But...
February 20, 2002 at 7:24 pm
Are Roaming Profiles in effect? I believe the profile information is going to be stored wherever \Documents and Settings\<User>\Application Data\Microsoft\Outlook\ is. If you've got a roaming profile, it's not...
February 19, 2002 at 8:17 am
quote:
But why then does the following work:SELECT dbo.udfTEST('sdfs')
Just a small bit to add to what...
February 19, 2002 at 8:08 am
If it's not on the domain, this is probably the issue. I'll keep my fingers crossed that it is as simple as this.
K. Brian Kelley
February 19, 2002 at 7:42 am
The SQL Server will need to be "renamed" in order for everything to be in order. However, unless I'm mistaken, the SQL Server service should still start, because the...
February 18, 2002 at 4:44 pm
This works because the default for a FORWARD_ONLY cursor is DYNAMIC which allows updates. If you declare a DYNAMIC cursor (without the FORWARD_ONLY) you'll get the ability to update...
February 18, 2002 at 10:49 am
quote:
I must use the current ending inventory as an anchor and calculate backwords from there
It...
February 18, 2002 at 10:32 am
I believe you're going to have to resort to dynamic SQL. Robert Marda has an article on this:
http://www.sqlservercentral.com/columnists/rmarda/whendynamicsqlisuseful.asp
The problem that you are running into is the ORDER BY will...
February 18, 2002 at 5:05 am
This is perhaps the easiest for the client. However, given some of the database scripts I have seen coming out of vendors, I am not surprised that a couple...
February 18, 2002 at 4:57 am
Dynamic SQL won't work in a UDF. It's against the current set of rules. You always have the option of parsing the string and inserting into a table...
February 18, 2002 at 4:48 am
The problem is SQL Server is doing the IN comparison against the string @Rule. It's not taking it to mean:
SELECT ITEMID FROM ITEMS WHERE itRULE...
February 18, 2002 at 12:50 am
It looks like SQL Mail did its part. The problem is the address that was attempted.
Doing a quick WHOIS, I can't pull up pmrdc.com or pmrdc.com.my so the error...
February 17, 2002 at 11:58 pm
I don't believe SQL2K defaults to READ ONLY unless you are lacking update permissions to the table in question. Is that an issue?
K. Brian Kelley
February 17, 2002 at 9:58 pm
Or building the full sort:
SELECT IPAddress
FROM IP
ORDER BY
-- First Octet
CAST(LEFT(IPAddress, CHARINDEX('.', IPAddress) - 1) AS tinyint),
-- Second Octet
CAST(SUBSTRING(IPAddress,
CHARINDEX('.', IPAddress) + 1,
CHARINDEX('.', IPAddress,...
February 16, 2002 at 9:10 pm
Viewing 15 posts - 5,596 through 5,610 (of 6,105 total)