Viewing 15 posts - 1,171 through 1,185 (of 2,387 total)
You may have to setup master/target servers using Multi Server Administration.
September 11, 2003 at 7:05 am
quote:
But in general, I don't feel comfortable giving Prod access to developers
mdamera,
Agreed with you....
September 10, 2003 at 1:36 pm
I have never see these in my clustered SQL Serers, either default or named instances.
Try to fail-over back to see which port the SQL Server is going to use.
September 10, 2003 at 11:47 am
Dod you set the TEMPDB to auto grow? Do you have free spaces in the disks the TEMPDB located?
Edited by - allen_cui on 09/10/2003 11:42:32 AM
September 10, 2003 at 11:42 am
From Link http://www.sqlservercentral.com/sqlpass.asp
quote:
The SQLServerCentral.com crew (Andy Warren, Steve Jones and Brian Knight) will all be at The PASS Community Summit...
September 10, 2003 at 10:12 am
'db_datareader' database role only.
September 10, 2003 at 9:56 am
A tilde (~) character after the forward slash (for example, /~Z) indicates that the parameter value is encrypted and what follows is the hexadecimal text of the encrypted value. No...
September 10, 2003 at 9:49 am
Could it be used by other applications?
http://support.microsoft.com/default.aspx?scid=kb;en-us;307197
http://support.microsoft.com/default.aspx?scid=kb;en-us;293107
http://support.microsoft.com/default.aspx?scid=kb;en-us;308091
http://support.microsoft.com/default.aspx?scid=kb;en-us;313178
September 10, 2003 at 9:40 am
Have you tried use server network utility to fix the port number?
Did you say SQL Server uses different port after fail-over?
Edited by - allen_cui on 09/10/2003 09:07:21 AM
September 10, 2003 at 8:58 am
quote:
Even with that setting it fills and generates an error 17.
Can you post...
September 10, 2003 at 8:38 am
What about to use select 'truncate table ' + name from dbo.sysobjects where xtype = 'U' to generate truncate statements for all your user tables.
September 10, 2003 at 8:32 am
You may check 'backupset' table that contains a row for each backup set. This table is stored in the msdb database.
September 9, 2003 at 5:07 pm
I have SQL Server 2000 installed with Sybase in one server as test server. It works fine but you have to be aware of the resources needed by both applications...
September 9, 2003 at 2:51 pm
Is there a job scheduled to shrink the log file? I seen one of my application does that. It comes from application installation.
September 9, 2003 at 1:34 pm
I have heard people complain about query/stored procedure behave slowness after the upgrade. You may perform a test upgrade to ensure application runs fine.
September 9, 2003 at 11:51 am
Viewing 15 posts - 1,171 through 1,185 (of 2,387 total)