Viewing 15 posts - 3,571 through 3,585 (of 7,429 total)
David is right. The reason is that your uniqueidentifier the way you are doing it is not in the same scope as the query and thus the query cannot see...
January 16, 2003 at 11:07 am
I have thought about this and the only thing I see is that you get about twice as many values, however unless you move the current values down it you...
January 16, 2003 at 11:03 am
Here is the link http://www.sqlservercentral.com/scripts/contributions/204.asp
January 16, 2003 at 10:41 am
Tried it in SQL 7 and does seem to be an issue there when using # for the name of an index. It looks for it in the table as...
January 16, 2003 at 10:25 am
Unless you have a specific tool then put the SQl 2000 CD in the drive and choose to install sql components then client tools only. This will install Enterprise Manger...
January 16, 2003 at 4:19 am
Actually some can store the history on the server but I am not sure of all that can do this. I know Sametime (a lotus app and akin to AOL...
January 15, 2003 at 3:47 pm
Do have a maximum growth size set for the Log. If it reaches that the file will no longer grow and transaction will continue until it is full. If not...
January 15, 2003 at 3:41 pm
Hoepfully this will help. See additional info for FileSystemObject on msdn website here http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/fsooriscriptingrun-timereference.asp.
In the DTS package create an ActiveScipt object on the design sheet.
Open it and set to VBScript...
January 15, 2003 at 3:37 pm
Also, there are other issues you may run into. Since we are talking Oracle here, what version and what driver are you trying to use?
January 15, 2003 at 3:19 pm
Also, did you add the /3GB switch to the OS boot.ini to make the memory available to SQL? There are dozens of threads on this here and see BOL "Managing...
January 15, 2003 at 3:16 pm
I don't believe you will have any issues either, just make sure you make a backup before the upgrade for safety as always. I assume you are using Win 2K...
January 15, 2003 at 3:14 pm
quote:
Can we restore the database without the Log file? What is the process to do this?
January 15, 2003 at 12:33 pm
Ok consider this.
Storing in a varchar.
VARCHAR or any char datatype stores numbers with their ascii value. Which for 0 is 48 and 1 is 49 (you would think someone would...
January 15, 2003 at 12:23 pm
It would help you to add an INDENTITY column to the table then you can query like so.
SELECT COUNT(*), UNIT, [DATE] FROm tblX oqX WHERE [identcol] = (SELECT MIN(iqX.[identcol]) FROM...
January 15, 2003 at 5:22 am
This is the table setup we use. It allows for adding questions to questionaries and knowing which questionaire a user took. In addition it stores all their answers. We also...
January 15, 2003 at 5:08 am
Viewing 15 posts - 3,571 through 3,585 (of 7,429 total)