Administering

• Topics

  Started by

  Posts

  Last post

• How to fix 'PRIMARY' filegroup is full error

  I have just added a 500G USB drive. I have created a DB on it and am attempting to export data to …

  kirk-510417

  9 replies

  5 years, 3 months ago

  By: katedaisy

• Clearing out msdb.dbo.sysmail_mailitems...

  OK, so we (I) finally noticed that the MSDB backup was rather large. In looking into the problem I…

  jasona.work

  32 replies

  5 years, 3 months ago

  By: hiramfleitas

• sp_send_dbmail attachments

  Very strange one which I cant see a definitive answer for, apologies if its around here already btw…

  david.alcock

  6 replies

  5 years, 4 months ago

  By: ivanmleonb

• Delete Please

  Delete Please This topic was modified 5 years, 4 months ago by  kewlrobd.

  kewlrobd

  1 replies

  5 years, 4 months ago

  By: kewlrobd

• Backing up a database named update

  I have what I think is a unique situation.  I recently deployed an application that uses several d…

  kewlrobd

  4 replies

  5 years, 4 months ago

  By: Lowell

• shrink fails with error - File ID of database ID cannot be shrunk as it is either being shrunk by another process or is empty

  This is an fyi (no response necessary). I got this error and researched it and found no good answer…

  Deb Anderson

  33 replies

  5 years, 4 months ago

  By: Rinat Yulchurin

• Do we need to perform DBCC CHECKDB for TempDB

  Hi, I'm performing DBCC CHECKDB for all databases. But I'm not sure that we can perform DBCC CHECKD…

  pshaship

  5 replies

  5 years, 4 months ago

  By: Jack 95169

• Job fails for linked server ("Executed as user: 'service accnt name'. Login failed for user 'service accnt name'. [SQLSTATE 28000] (Error 18456). The step failed.")

  Experts, I have two different sql servers in same domain. We can't change the authentication mode o…

  Joy Smith San

  6 replies

  5 years, 5 months ago

  By: vucando

• How can access SQL Server by same windows user account from multiple Machine

  I have a scenario, Need to create windows based authentication in SQL Server, but applications are …

  Prakash T

  17 replies

  5 years, 5 months ago

  By: Prakash T

• Difference between possible owners and preferred owners

  Hi I have some confusion between possible owners and preferred owners in sql server clustering envi…

  RaviShankar1234

  7 replies

  5 years, 5 months ago

  By: LauraRowland

• FUll Text Index Very slow

  I am using full text indexing for partial match and Today it started to be very slow when I use the…

  mbassem91

  2 replies

  5 years, 6 months ago

  By: Mr. Brian Gale

• Reporting Services - Oracle Source.

  Hi, I am getting the error message while viewing from http://localhost/reports after deploying the …

  sudhakara

  6 replies

  5 years, 7 months ago

  By: vanu

• Does rebuilding a clustered index effect non clustered index.

  Hello All, I have an interesting question asked by a freind. we have a table with 1 clustered and 2…

  striker-baba

  17 replies

  5 years, 7 months ago

  By: Jeff Moden

• Operating system error 2(The system cannot find the file specified.)

  I know this is driving people crazy, there is a 2000 server with only sp2! and it crashed! I am cal…

  halifaxdal

  6 replies

  5 years, 9 months ago

  By: Jack 95169

• Missing backup information in backupset

  Hello Folks,We have a SQL Server 2005 box (well, please don't ask why... 🙁 ). Since last week, I…

  Nishith-121814

  3 replies

  5 years, 9 months ago

  By: Sue_H