Viewing 15 posts - 7,381 through 7,395 (of 9,253 total)
The table 'GBR_Test.dbo.CDR_0_test' has clustered index 'GBR_CDR_0_Test_IX_Xharging_TimeStamp_Partition' while the table 'GBR_Test.dbo.CDR_0_Test_Part' does not have clustered index.
?
November 22, 2010 at 1:56 pm
Patricia
check for a SQL Server agent job that executes against the Insight database and contains a step that manually truncates the log. I had this issue previously with another application...
November 22, 2010 at 10:23 am
What operating system are you using on the cluster nodes and the stand alone server?
Is the stand alone server completely stand alone or is it a member of the same...
November 21, 2010 at 12:13 pm
Best to stop the job really so it releases locks. Go into Computer Management and view open files there.
November 21, 2010 at 6:54 am
this is already in discussion at the link posted by LutzM
November 21, 2010 at 5:50 am
Ok, thats undoubtedly part of the issue. You must use SQL Server configuration manager to change the service user account\password credentials!
Note: Local system will automatically have full rights to...
November 21, 2010 at 5:34 am
ocolakoglu (11/21/2010)
We have change the sql server startup user from domain account to local system
how are you changing the user account for the sql server service?
November 21, 2010 at 4:32 am
have you checked the net backup job status?
November 21, 2010 at 4:09 am
Sp_help shows you the default which looks like it's using the default (1, 1). This happens if you do not supply values during the creation phase. Design the table in...
November 21, 2010 at 2:51 am
Buzz-523717 (11/19/2010)
executing master..sqlbackup in a script step of the scheduled job.
Check the Redgate SQLBackup logs for details of any potential errors or warnings
November 20, 2010 at 3:27 pm
ocolakoglu (11/20/2010)
Last week we upgraded our system
Sql server 2005 to Sql server 2008
Windows 2003 to Windows 2008
32 cpu 64 gb ram to 64 cpu 256 gb ram
One server strcuture...
November 20, 2010 at 11:58 am
Sree-258588 (11/19/2010)
I've table with THE following structure:
id int identity(1,1)
name varchar(100) not null
id is the primary key
now I want to change the identity (0,1)
set the seed value to 0
I've...
November 20, 2010 at 11:23 am
have you exposed the LUN to both servers?
November 20, 2010 at 7:12 am
MysteryJimbo (11/18/2010)
Guestimate of 6 x 2Gb to ensure proportional fill.
Could be overkill, how many logical processors do you have?
November 18, 2010 at 8:53 am
I would also add the auth_scheme column to Lowell's query to check for NTLM or Kerberos authentication type.
November 16, 2010 at 7:49 am
Viewing 15 posts - 7,381 through 7,395 (of 9,253 total)