Viewing 15 posts - 2,461 through 2,475 (of 7,429 total)
Oh 1 more not I would suggest if you have alots of repeating values or if the NULLable column will be NULL often then consider splitting the table and using...
October 21, 2003 at 8:34 am
Fortunately it does not stubob. From SQL BOL
quote:
@@ERROR returns the number of the error message until another Transact-SQL statement is executed.
October 21, 2003 at 8:30 am
First off I will state I disagree with CJ Date and the others who think NULL is a waste in SQL. NULL does not apply only to SQL but to...
October 21, 2003 at 7:19 am
When you say "poll" what exactly are you looking for? I can poll for connections, I can poll for service running (thru DMO best). What are you after?
October 21, 2003 at 5:29 am
Of the rows you know of the local copy have data in them use the key field and query the other DB to validate the data. Could be something wrong...
October 21, 2003 at 5:28 am
Unless the date is stored in a character type field I was not aware Informix supported anything older than 12/31/1899. The fact they didn't use NULLS bugs me as well...
October 21, 2003 at 5:24 am
Actually the answer is better expressed in BOL
quote:
This variable is set to 0 by any statement that does not return rows, such...
October 21, 2003 at 5:22 am
Use the ISO format in the char field but you are sorta gonna be screwed on the datetime functions. Dates that far back are subject to errors as the calendar...
October 17, 2003 at 4:25 am
You shouldn't end up with more than one resultset of actual data depedning on how you are doing this but you may be getting the messages back. Do you have...
October 16, 2003 at 4:58 am
Ok let's step back just for testing to see what I may be missing. Sorry I have not used the trusted accounted method myself so not sure what applies but...
October 15, 2003 at 1:22 pm
quote:
When we upgraded from 7.0 to 2000 we had a couple of queries that exibited the same problem. We have a...
October 15, 2003 at 10:39 am
Actually how are you determining it is SQL pegging the CPU? Make sure you are looking at CPU under Windows Task Manager on the Processes tab. Watch sqlservr.exe to see...
October 15, 2003 at 9:27 am
I woul watch it with profiler. Also if this is a multiple instance situation where 7 and 2000 are on there 2000 may not have taken over the needed resources....
October 15, 2003 at 5:05 am
If you will open the linked server properties on the local SQL server you will see a tab labeled "Security", on this tab you will find multiple options of which...
October 15, 2003 at 5:03 am
Viewing 15 posts - 2,461 through 2,475 (of 7,429 total)