Viewing 15 posts - 286 through 300 (of 314 total)
For both SQL Server 7.0 & SQL Server 7.0 Enterprise Edition, Mainstream Support Retired date is 31-Mar-04, Extended Support Retired date is 31-Mar-06.
April 1, 2003 at 1:08 pm
I opt for Steve's suggestion of creating a new role, adding the users to the new role before load and removing after the load sounds good.
April 1, 2003 at 1:01 pm
<font color=blue>
Let me put this way... If I would have been in your shoes, I would first opt to implement the same on the Non-Prod segment before even thinking of...
April 1, 2003 at 9:11 am
Yes. Thats true. Even for my servers I have Monthly reboots scheduled. But if the servers are being used for some other apps as well in the production segment, then...
March 28, 2003 at 10:04 am
Infact, you can write a procedure to automate the SQL Server Agent to start as soon as you restart SQL Server. For further info you can check this page:
http://vyaskn.tripod.com/code/sql_server_agent_autostart.txt
NOTE: Please...
March 28, 2003 at 9:17 am
You can also do the following:
@ECHO OFF
NET STOP SQLSERVERAGENT
NET STOP MSSQLSERVER
SLEEP <<TIME INTERVAL>>
NET START MSSQLSERVER
NET START SQLSERVERAGENT
For more info, you can check this page:
March 28, 2003 at 8:42 am
Is this the same for SQL 7.0 and SQL 6.5 as well, that we don't need to be the local admin on the BOX?! Some time back, I did deny...
March 27, 2003 at 1:04 pm
You can copy the whole database daily or twice a day and Logshipping every hour in the above method racosta suggested.
March 24, 2003 at 10:46 am
With the following query you can better idea what objects and who is the owner:
<pre id=code><font face=courier size=2 id=code>
select so.name, so.uid, su.name
from sysobjects so,
sysusers su
where so.uid <> 1
ANDsu.uid=so.uid
ORDER...
March 21, 2003 at 11:25 am
Can we do the same (as above) with Windows Shell Scripting?! Because I do administer all my Servers Remotely and VB is not installed on the servers.
I do not have...
March 21, 2003 at 8:36 am
1. How much is the Size of your database?
2. How many tables are there in your database?
3. How many Clusterd indexes are there in your database?
4. How many processors are...
March 20, 2003 at 11:08 pm
I am not having a clue other than the data inserted on Monday must have been BAD. That nights DBCC must have corrected it.
March 20, 2003 at 8:50 am
Do you backup the database only if its clean (no errors while backups) or Backup with out checking??? Please check that flag in your backup...
I had this kind of...
March 20, 2003 at 8:32 am
Viewing 15 posts - 286 through 300 (of 314 total)