Viewing 15 posts - 4,531 through 4,545 (of 7,429 total)
Try changing it back to SystemAccount in Services then rechange in EM.
November 1, 2002 at 11:06 am
Also on the second point, if it is SQL 7 the point is marked but the virtual logs sometimes do not free until transactions take place then it may fre...
November 1, 2002 at 11:04 am
What is the error when failing and have you check the EventViewer in Windows to check for messages from the Service. Always start with looking there.
November 1, 2002 at 8:13 am
No, I don't think a table design change or index will fix it. The problem I believe comes from the fact TableB must be ACTIVE and TableA must alos be....
November 1, 2002 at 7:33 am
If you FECTH them into a cursor, variable or temp table object the rows should not output just the number of rows affected. Can you post an example of the...
November 1, 2002 at 6:20 am
What exactly are you getting is it the results of a select statement or the number of rows affected? If number of rows place SET NOCOUNT ON at the begining...
November 1, 2002 at 5:38 am
Yes 37 seconds of CPU time used. And yes it would be nice but for now the best you can get is thru PerfMon or Task Manager on SQL as...
November 1, 2002 at 5:26 am
Or you can setup traces on the server to ouptu to a Profiler file. Nothing to show live except Profiler itself.
November 1, 2002 at 5:20 am
As far as I know this is current
To find out the current level of Windows 2000 Analysis Services, start the Analysis Manager, right-click on the Analysis Servers node, and select...
November 1, 2002 at 5:13 am
The only way I know is using ADO to make the connection and get the driver versions back.
From MSDN
quote:
Version Property...
November 1, 2002 at 5:06 am
SQL Server can be run on any machine of your choice for really any reason. The licensing is now based on number of CPU's so if the box has 2...
November 1, 2002 at 4:49 am
From SQL BOL
quote:
sp_resetstatus turns off the suspect flag on a database. This procedure updates the mode and status columns of the...
November 1, 2002 at 4:44 am
Greg is right, thr ROUND function only rounds the value out to that length but the output length of the data remains intact. Thus 1.00000000001 round out to a length...
November 1, 2002 at 4:42 am
You should look at your execution plan to see what it is doing during that step.
Try this and see what happens.
SELECT TableA.LINE_ID
FROM
TableA
LEFT OUTER JOIN
(SELECT
RecName,
RecType,
Price,
Line_ID
FROM TableB
WHERE TableB.Status = 'ACTIVE')...
November 1, 2002 at 4:33 am
Viewing 15 posts - 4,531 through 4,545 (of 7,429 total)