Administration

• Topics

  Started by

  Posts

  Last post

• Server Side cursors - Handling

  Hey all, Thanks for looking. I have encountered a number of performance issues with our ERP system,…

  McSQL

  1 replies

  15 years, 2 months ago

  By: SQLRNNR

• change the sql authentication mode

  Hi, How to change the Authentication of SQL Server from Registry level. Thanks in advance.

  Oracle_91

  2 replies

  15 years, 2 months ago

  By: Oracle_91

• Tempdb growing huge

  i am working with sql server 2000 & few days ago i found my tempdb database become so large. i…

  shohan_db

  4 replies

  15 years, 2 months ago

  By: SQLRNNR

• database growth issue

  Hi All, The M: drive on Test Server running with very low space. It has now only 6.25% free sp…

  balaji.ganga

  1 replies

  15 years, 2 months ago

  By: SQLRNNR

• How to configure Static port for SQL Server 2000 defalt instance?

  Hi, We have SQL Server 2000 default instance listening on 1433. I want to change it to a different …

  gary1

  1 replies

  15 years, 2 months ago

  By: David Sorauer

• How to find out the actual user who is running the script on a sql server?

  Hi, I have strange problem. I wanted to find out the who is running the scripts from the applicatio…

  SQL Rao

  2 replies

  15 years, 2 months ago

  By: SQL Rao

• could not find stored procedure 'sp_addextendProc'

  Dear Sir, I am in great trouble. When I am registering a external procedure like exec sp_addextendp…

  deba_20032004

  1 replies

  15 years, 2 months ago

  By: nigel.

• Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

  Hi, We have SQL Server 2000 with SP4 and getting the below error: A network-related or instance-spe…

  gary1

  3 replies

  15 years, 2 months ago

  By: gary1

• Issues creating tables with table owner as DBO

  Hi All, I am a dba in a small firm. A developer has issues creating tables with dbo as schema/owner…

  sqlbee19

  4 replies

  15 years, 2 months ago

  By: sqlbee19

• Changing sa password

  Hello, We have changed sa password for one of the servers. The DTS packages which were scheduled to…

  SQLRO

  5 replies

  15 years, 2 months ago

  By: Steve Jones - SSC Editor

• Changing the Agent service account.

  Hello, I would like to change my SQL agent (SQL 2k SP4) from local system to a domain user account,…

  Duran

  2 replies

  15 years, 2 months ago

  By: Duran

• computed column "Version" from table sysdatabases

  Hi, i need to change the value of the computed column "Version" from table sysdatabases, but as it…

  river1

  7 replies

  15 years, 2 months ago

  By: Gail Shaw

• Database Mirroring Problem

  I have a single instance of SQL 2005 with 5 databases with mirroring turned on on all the databases…

  anish_ns

  2 replies

  15 years, 2 months ago

  By: anish_ns

• Performance implications due to data growth on well tuned database

  Hi, Recently our company began considering an increase in the amount of content we house in our MSS…

  sql_er

  2 replies

  15 years, 2 months ago

  By: sql_er

• How To Identify Missing Indexes in a SQL Server 2000 Database?

  I'm used to using Performance Dashboard for SQL Server 2005 and 2008. It's not compatible with SQL …

  Gail Wanabee

  1 replies

  15 years, 2 months ago

  By: Gail Wanabee