Viewing 15 posts - 4,741 through 4,755 (of 7,429 total)
Sorry, do not know everything. But a number of system tables are added to each DB for such thing as column and tables descriptions. Also new function ::fn... items are...
October 7, 2002 at 8:07 pm
Determine the SQL Server instance port number.
To find the SQL Server instance port number:
On the Microsoft SQL Server 2000 server, start the SQL Server Network Utility.
Click the General tab, and...
October 7, 2002 at 6:17 pm
No but take a look here http://webferret.search.com/click?wf,Server+could+not+spawn+process_loginread+thread.,,support.microsoft.com%2Fsupport%2Fkb%2Farticles%2Fq282%2F2%2F29.ASP,,fastsearch . This sounds like the issue especially since you point out the sp_OA-procs relation.
"Don't roll your eyes at me. I will tape them...
October 7, 2002 at 5:48 pm
sysdatatypes which I believe is located in all dbs and does include any user defined datatypes in it as well.
"Don't roll your eyes at me. I will tape them in...
October 7, 2002 at 3:40 pm
7 is fine without it. In fact we had to get rid of it on the connection between our Web and SQL Server as they kept running into issues trying...
October 7, 2002 at 2:50 pm
Yes set to Background.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
October 7, 2002 at 12:25 pm
N is an explicit hint to cast the string data to NVARCHAR when defining a quoted string value.
"Don't roll your eyes at me. I will tape them in place." (Teacher...
October 7, 2002 at 12:21 pm
The problem is that you have one variable for the values which when submit will interpret as
IN ('ALLTHEVALUESASONESTRNG')
To get around this you have at least two options.
1) Build the...
October 7, 2002 at 11:03 am
Ooops sorry about that, change
EXECUTE sp_executesql @FindMember, '@FindMemberVal int OUTPUT', @FindMemberVal OUTPUT
EXECUTE sp_executesql @FindAnswer, '@FindAnserVal int OUTPUT', @FindAnserVal OUTPUT
to
EXECUTE sp_executesql @FindMember, N'@FindMemberVal int OUTPUT', @FindMemberVal OUTPUT
EXECUTE sp_executesql @FindAnswer, N'@FindAnserVal int...
October 7, 2002 at 10:50 am
Usually does not happen but compatibility issue can arise. However, these usually show up in the first dozen or so custoemr and MS will pull the fix and repost a...
October 7, 2002 at 10:46 am
It returns into the error collection. If using VB then do
IF ERROR RESUME NEXT or GOTO line
and if Err <> 0 then
Err.Description should contain you value.
If using C++ then...
October 7, 2002 at 4:55 am
No you cannot, only in SPs and sets of code. Views can be used in SPs with parameters but views can only be whole query statments.
"Don't roll your eyes at...
October 7, 2002 at 4:52 am
It is Latin1_General. I believe the value you see shows up when you upgrade a DB from SQL 7 or may be something to do with SP level, I foget....
October 7, 2002 at 4:05 am
You can also do thru EM by right clicking the database choosing proerties and check the value on the option tab related to this.
"Don't roll your eyes at me. I...
October 7, 2002 at 3:59 am
Answer 1: Yes there are some internal changes and ou will not be able to move the files back to a 7 server. But mostly it is related to system...
October 7, 2002 at 3:58 am
Viewing 15 posts - 4,741 through 4,755 (of 7,429 total)