Administering

• Topics

  Started by

  Posts

  Last post

• What is the OFFICIAL Microsoft response/fix to "Unable to load client print control" with reporting services

  Hi, We need OFFICIAL Microsoft response/fix to "Unable to load client print control" with reporting…

  gary1

  33 replies

  5 years, 10 months ago

  By: Vijay Badhe

• Instance Failure (System.Data) after configuring hostname alias

  Hi, I have configured hostname aliases for 3 different instances (2 2008r2 & 1 2012) on the sa…

  daigia_dzadzich

  2 replies

  5 years, 11 months ago

  By: patilmah

• How To Get Last Inserted Record Value In SQL Server

  How To Get Last Inserted Record Value In SQL Server The table have no Primary key, identity, it hav…

  Vijay Sinha

  20 replies

  5 years, 12 months ago

  By: drew.allen

• Lost in sp_executesql

  I want to read the SpaceUsed property for a file in another database then the database I'm currentl…

  Marco

  10 replies

  6 years ago

  By: planetmatt

• 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

  6 years 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

  6 years ago

  By: jasona.work

• 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

  6 years ago

  By: ivanmleonb

• Delete Please

  Delete Please This topic was modified 6 years ago by kewlrobd.

  kewlrobd

  1 replies

  6 years 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 da…

  kewlrobd

  4 replies

  6 years 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

  6 years 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

  6 years, 1 month 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

  6 years, 1 month 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

  6 years, 1 month 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 env…

  RaviShankar1234

  7 replies

  6 years, 2 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

  6 years, 2 months ago

  By: Mr. Brian Gale