Viewing 15 posts - 4,846 through 4,860 (of 7,429 total)
Chris it is DBCC UPDATEUSAGE.
quote:
Specifies that the rows column of sysindexes is updated with the current count of the number of rows...
September 24, 2002 at 4:05 am
jiangs is right, SQL.LOG is a log file for ODBC processing and can be moved to anywhere by opening Data Sources (ODBC) or ODBC Data Sources control panel appleton the...
September 23, 2002 at 5:54 am
You cannot limit their ability to change. However, do they really need DBO rights, can you put them on some other writes option and provide the needed access, which will...
September 23, 2002 at 5:51 am
If the log file is large, what is data file size. You can get some performance gains with moving indexes and large tables to their own filegroups. However how many...
September 23, 2002 at 5:49 am
Greg is exactly right.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
September 23, 2002 at 5:37 am
To understand this properly can you give me what the output should be from your data posted and why?
"Don't roll your eyes at me. I will tape them in place."...
September 23, 2002 at 5:35 am
This will reutrn the required results. As to how to properly perform for your app, depends on your implementation.
SELECT a.*
from table_Advertisers a
INNER JOIN table_AdvertiserCategories ac
ON a.ID = ac.AdvertiserID
WHERE...
September 23, 2002 at 5:32 am
No solution I know of. Has to be a design piece in the two codes that one supports it properly and the other does not.
"Don't roll your eyes at me....
September 23, 2002 at 5:21 am
The table should have failed when the first item was attempted to be done this way. How did the data get out of range. What are you trying to do...
September 23, 2002 at 5:20 am
Can you give details of your situation? WHat type of app, what is happening, when does it happen?
"Don't roll your eyes at me. I will tape them in place." (Teacher...
September 23, 2002 at 5:17 am
Also did you check to make sure the file was copied? And how big is the file and network speed? Have you tested a copy by hand to see the...
September 23, 2002 at 5:11 am
Yes, the same. Usually some folks use the IP address instead of name but it is better to use a name and define that name with IP in SQL Client...
September 23, 2002 at 5:08 am
For Example when I write an app in ASP I will have to use Server.CreateObject and supply the proper com interface which Crstal comes with a reusable page for this....
September 23, 2002 at 5:07 am
No it is not possible to get a modified date and in fact has been suggested to MS but you may want to suggest yourself also for future versions. The...
September 23, 2002 at 4:24 am
Thanks, this is a working piece of code from my first app so your guys should be able to use. The app which I am finishing is far larger and...
September 23, 2002 at 4:19 am
Viewing 15 posts - 4,846 through 4,860 (of 7,429 total)