Administering

• Topics

  Started by

  Posts

  Last post

• Linked Server Error: Cannot obtain the schema rowset "DBSCHEMA_CATALOGS"

  I am trying to create a linked server using a Teradata ODBC DSN in SQL 2005.  When I create th…

  Joseph Miano

  22 replies

  14 years, 10 months ago

  By: Toni-256719

• TEMP DB remains huge

  hi guys i need help with the size of my temp DB in my production instance. the initial size of my d…

  DBA-640728

  2 replies

  14 years, 10 months ago

  By: DBA-640728

• Urgent: How to add Linked Server in SQL 2005

  I have a domain id: company\abc, this account is a dedicated account for fetching data from another…

  halifaxdal

  1 replies

  14 years, 10 months ago

  By: Ninja's_RGR'us

• TUF FILE IS DELETED

  HI in the log shiiping tuf is deleted then what happenns to log shipping

  Arjun SreeVastsva

  4 replies

  14 years, 10 months ago

  By: forsqlserver

• Fast Growing temp file

  Hi Pretty new to SQL admin and am running a SQL 2005 Standard server hosting Dynamics AX DB. The s…

  zuma01

  9 replies

  14 years, 10 months ago

  By: TheSQLGuru

• sp_who2 only CPU increases no change in I/O

  i occasionally see a long running job. I have noticed that after certain time only CPU usage incre…

  curious_sqldba

  7 replies

  14 years, 10 months ago

  By: TheSQLGuru

• Splitting data files

  I have a single data file of 350 GB in SQL Server 2000(Server A). We are migrating it to another se…

  Knowledge Hunter

  5 replies

  14 years, 10 months ago

  By: Knowledge Hunter

• tempDB quiz- how to manage 2-nd file

  My IT manager is going to replace all SAN disks (lease is over), i.e. C: disk will be intact (with …

  Yuri55

  6 replies

  14 years, 10 months ago

  By: Perry Whittle

• Transaction Log Backup

  I require some clarification. I run full backup every day @ 12:01AM. Diff Backup at 6hrs interval a…

  swapan.dey

  1 replies

  14 years, 10 months ago

  By: Gail Shaw

• Transaction Log Backup Misunderstanding.

  Ones again sorry for my question, but i need to clarify for me something. In every blog/article, th…

  pavlenych

  14 replies

  14 years, 10 months ago

  By: Gail Shaw

• Perfomance slow of the sql server 2005

  Hello All, we have a production server that has been running fine for a while,lately the queries st…

  BoobyB

  6 replies

  14 years, 10 months ago

  By: TheSQLGuru

• Database is suspect

  Please, sometimes i have some databases in sql server 2000 which are marked "SUSPECT". Each time, …

  abdielmomo

  7 replies

  14 years, 10 months ago

  By: M&M

• Help me: QUERY OUTPUT

  Hello i've got the following query, but the output is not the desired. I need to get only values wh…

  JMSM

  4 replies

  14 years, 10 months ago

  By: swamy.gare

• sql server error 18456, login failed for USER 'NTAUTHORITY\SYSTEM'. [SQL STATE 28000]

  Hi Folks, 1.sql server error 258, unable to complete login process due to delay in login response,[…

  MasterDB

  2 replies

  14 years, 10 months ago

  By: MasterDB

• Compatibility Level 80 to 90

  Hi we migrated our SQL Server Database SQL Server 2000 EE to SQL Server 2005 SP4 EE 64 bit in our C…

  raguyazhin

  2 replies

  14 years, 10 months ago

  By: Perry Whittle