Forum Replies Created
Viewing 15 posts - 16 through 30 (of 183 total)
-
RE: The Pitfalls of Foreign Keys
You enforce referential integrity using FKs, not relations. Relations are tables.
-
RE: Random "Could not find stored procedure" error
That's exactly the issue. I can only assume it's a bug as it doesn't make any sense otherwise. It's annoying that I have to use more than one login but...
-
RE: Data warehouse load job hangs
Thanks. I found the problem: I'd changed a UDF which caused serious performance problems. Quickly changed back.
-
RE: Procedure ''''xyz'''' expects parameter ''''@abc'''', which was not supplied
Oh, it's always so stupid and obvious isn't it? What a silly little boy I am...
Compare the code that didn't work to...
-
RE: Procedure ''''xyz'''' expects parameter ''''@abc'''', which was not supplied
BTW I'm off in an hour and not back at work till next Wednesday, so if there are any more developments, I'm not hiding - I'll pick it up then!
Something...
-
RE: Procedure ''''xyz'''' expects parameter ''''@abc'''', which was not supplied
>> Can you fire out profiler and execute both calls. That'll give you the command send to the server by both statements and that should tell you (and all of...
-
RE: Procedure ''''xyz'''' expects parameter ''''@abc'''', which was not supplied
It worked - thanks!
I had to modify it slightly to fit the syntax it was looking for but virtually the same:
November 16, 2006 at 8:57 am
-
RE: Procedure ''''xyz'''' expects parameter ''''@abc'''', which was not supplied
Didn't work - same error. Thanks anyway.
SOP has db_owner rights but I've tried giving it explicit EXEC permissions anyway, just in case, and it throws the same error.
-
RE: Random "Could not find stored procedure" error
This is my connection string:
"Provider=SQLOLEDB;Data Source=SHED\FINANCE;initial catalog=SOP;User ID=SOP;Password="
If I change "initial catalog=SOP" to any other db it can't see the procedures within that DB. Not sure if it's a...
-
RE: Random "Could not find stored procedure" error
Thanks for that - solved the same problem I was having from an ASP.NET 2.0 application connecting to SQL Server 2000.
Despite the connection string specifying the correct database, it could...
-
RE: How To Mess Up An Interview
Beat me to it!
Genius does not imply knowledge of grammar. Besides, who's to know it wasn't grammatically perfect when submitted and subsequently doctored...
-
RE: Closing on One Year
Probably not until support of 2K is withdrawn, unless I find some compelling reason otherwise (though I doubt I will).
As others have said, our SQL 2K environments are running quite nicely...
-
RE: The Support Joke
I had a similar scenario ealier in the week with my dad; I was talking him through getting his Windows 98 installation CD to run from the DOS prompt (long...
-
RE: The Data Bill of Rights
Very true. I think the added advantage we have too is that it was introduced back in 1984 when there were nowhere near as much data, and the large volumes...
-
RE: The Data Bill of Rights
In the UK we've had the Data Protection Act since 1984. A replacement Act was passed in 1998, coming into force a few years later in around 2002/03, which mainly...
Viewing 15 posts - 16 through 30 (of 183 total)