Viewing 15 posts - 1,561 through 1,575 (of 2,387 total)
Don't think SQL Server does that. You may temporary deny database access to those logins you think they no longer need and see whether users complain about.
June 27, 2003 at 1:10 pm
Maybe you can setup linked table in Access to SQL Server table. Or setup linked server to Access Database in SQL Server. Not quite understand your question.
June 27, 2003 at 1:06 pm
Who is your job owner? If you can, try to take SQL Server Agent resource offline and online to see any help.
June 26, 2003 at 1:11 pm
SQL Server Book Online, You can download it from http://www.microsoft.com/sql
June 26, 2003 at 1:06 pm
Depends on what kind of indexes table has. If there is a cluster index for the table, dbcc dbreindex will reorganize the data according the clustered index and fill factor....
June 26, 2003 at 12:42 pm
Use Enterprise Manager to do that. Start Profiler to trace and you will find out exactly SQL statements that SQL Server actually recreate the table with identity columns when you...
June 26, 2003 at 12:37 pm
quote:
Does reorganize data actually unload and reload table data? Does DBREINDEX unload/reload data or just work at the index level?
June 26, 2003 at 12:32 pm
sysperfinfo will give all information you are looking for. Meanwhile, I guess you are looking for dbcc memorystatus and dbcc memusage.
Edited by - Allen_Cui on 06/26/2003 12:26:48 PM
June 26, 2003 at 12:26 pm
quote:
The database I'm having problems with was on one virtual server default instance (VServer1). I moved it to another virtual server...
June 26, 2003 at 12:23 pm
quote:
1st error message:SELECT permission denied on object 'ObjectName', database 'DatabaseName', owner 'dbo'.
The cursor was not declared.
June 26, 2003 at 12:03 pm
Use System Monitor (Performance Monitor) to retrieve information on SQL Server memory usage and available memory. Task Manager does not provide accurate memory usage information for AWE. Therefore, the memory...
June 26, 2003 at 11:48 am
One work around is to empty the primary log file and restrict the automatically grow file so any transaction logs will be logged in the second log file.
No ideas...
June 26, 2003 at 9:30 am
Why do you want to make second log file as primary? What do you want to achieve?
June 26, 2003 at 9:06 am
Viewing 15 posts - 1,561 through 1,575 (of 2,387 total)