Administering

• Topics

  Started by

  Posts

  Last post

• Uneven usage of CPUs in SQL 2005 environment: some CPUs consistently busier than others

  We have a SQL-2005 instance (standard edition, 32-bit) on a VM server (Windows 2003 R2) consisting …

  Marios Philippopoulos

  9 replies

  15 years ago

  By: Marios Philippopoulos

• Strange problem with SQL job

  Hi, I have strange problem with SQL backup job. The trans backup job was running fine on its schedu…

  prashantv_sawant

  1 replies

  15 years ago

  By: Dan.Humphries

• Remote Access setup

  I am developing within JD Edwards and need to periodically call a stored procedure to run. I create…

  Richard Rice

  4 replies

  15 years ago

  By: Richard Rice

• delete records from table2 that are not in table1

  Hello, I need to delete records from table2 that are not in table1 I have a table1 and table2 table…

  Krasavita

  3 replies

  15 years ago

  By: Jeff Moden

• what to do after shrink transaction log for backup

  Another question related with transaction log. We have some db backed up weekends full, weekdays di…

  sqlfriend

  4 replies

  15 years ago

  By: sqlfriend

• SSIS Flat File Source Splitting Columns to different Tables in the database

  Hello all, I'm looking to import data from a flat file and not all columns are going to the same ta…

  czeke107

  10 replies

  15 years ago

  By: Bill Gurling

• timeout error.

  Hi , while i am conneting to the SSMS i got error like below. please assistance on this how to toub…

  narasimhareddy.dba

  1 replies

  15 years ago

  By: Ron McCullough

• LINKED Server does not return all records.

  Local Server: SQL Server 2008 Web Edition SP2 Linked Server: SQL Server 2005 Standard Edition SP2 P…

  kashif.nadeem

  5 replies

  15 years ago

  By: Brandie Tarvin

• QuestionCan SQL 2005 SP 4 be UNinstalled? How do you install SP4 on a Cluster?

  We are looking to upgrade our Windows Server 2003, SQL 2005 clusters to SQL 2005 Service Pack 4. Bu…

  jpSQLDude

  5 replies

  15 years ago

  By: M&M

• Property Owner is not available for Database - root cause?

  Hello, I am getting this error when I try to right-click in SSMS and check properties of a database…

  webrunner

  9 replies

  15 years ago

  By: SQLRNNR

• Replicating Tables on Different Publications / Schedules

  Hi, Is it possible to replicate tables on different schedules or publications? I have a replicated …

  MostInterestingMan

  3 replies

  15 years ago

  By: homebrew01

• How to monitor multiple sql servers by a script?

  Hi Freinds, How i can monitor the multiple servers through a script? I want to check; 1) disk space…

  MSQLDBA

  5 replies

  15 years ago

  By: MSQLDBA

• Oracle OEM grid for SQL Server Monitoring

  Hi Friends, Currently I am working on Oracle OEM grid for SQL Server Monitoring. As per the client …

  mohan.pariveda

  4 replies

  15 years ago

  By: SQLDCH

• min / max memory and lock pages in memory

  Hello Our prod server have 10Gb Memory, Win NT 5.2 (Build 3790: Service Pack 2) Sql server 2005 x64…

  onixsoft

  5 replies

  15 years ago

  By: TheSQLGuru

• Complex SQL Server MEMORY questions - Instances, RAM, Virtual Memory, Cluster, etc

  Problem: I want to know how to set SQL Server Instance memory settings as well as Windows Server v…

  jpSQLDude

  4 replies

  15 years ago

  By: TheSQLGuru