Administration

• Topics

  Started by

  Posts

  Last post

• Generate scripts for all databases

  How do I generate scripts for all objects in all databases for a particular instance. Thanks.

  ramadesai108

  1 replies

  14 years, 10 months ago

  By: Johan Bijnens

• Script SS2000 Recovery model/last backup/etc help

  Hi, I nice fellow on here was able to help me inventory my numerous new 2005 database backups and c…

  Vertigo44

  2 replies

  14 years, 10 months ago

  By: Vertigo44

• Poor Restore Times

  After suffering through a 13 hour restore yesterday for an old server I need to understand the fact…

  csoloway

  12 replies

  14 years, 10 months ago

  By: Roy Ernest

• Limit on connections

  How many user connections a sql server 2000 edition can have at a time? I know the maximum concurre…

  DBABC

  1 replies

  14 years, 10 months ago

  By: GSquared

• SQL 2000 - polling for password change

  First apologies for this .... and in SQL 2000 too. Dev wants to create a process to allow nominated…

  OnTheNumbers

  4 replies

  14 years, 10 months ago

  By: OnTheNumbers

• Consultant required for setting up best practices for security and delegation from IIS to SQL Server 2005

  Hi I have limited experience in setting up the security, logins, spn's and delegation for connectin…

  vbgenie

  2 replies

  14 years, 10 months ago

  By: vbgenie

• How can I cycle sqlagent.out file?

  Dear friends, My SQLAGENT.OUT fie is growing fast , and all I can do is restarting sqlagent to chan…

  ashkan sirous

  5 replies

  14 years, 10 months ago

  By: Adiga

• SQL Server Service Pack 4 Setup Issue

  I recently tried to install Service Pack 4 on a clustered instance but received the following messa…

  Mark Manfredi

  1 replies

  14 years, 10 months ago

  By: MANU-J.

• unable to Kill a Process

  Hi, I am getting the following error while trying to kill a process from another session. "Process …

  naveen.nagareddy

  14 replies

  14 years, 10 months ago

  By: naveen.nagareddy

• Create copy of existing database with new Transaction Log

  I am looking to create a blank copy of an existing database (Houston) , and thought that the best w…

  gary.lafferty

  2 replies

  14 years, 10 months ago

  By: Keith Langmead

• MSDE - 17207, udopen: Operating system error 32(error not found) during the creation/opening of physical

  Hi there, I'm hoping somebody here can help with this problem. In the Application Event Viewer we'…

  Danger Mouse

  12 replies

  14 years, 10 months ago

  By: ramprabhakar.n

• Failed Authentication Attempts

  Is there a way in SQL Server 2000, to check within a given time frame if there have been any connec…

  Chris-717525

  1 replies

  14 years, 10 months ago

  By: Adiga

• Making sure new system is performing well

  Hi, We recently migrated out MSSQL 2000 servers to another system. We have both systems working in …

  sql_er

  2 replies

  14 years, 10 months ago

  By: sql_er

• CHECKDB - Catalog Msg 3853

  Dear All, When I ran DBCC CHECKDB('abc') with no_infomsgs I got the below error. "Msg 8992, Level 1…

  ravisamigo

  2 replies

  14 years, 10 months ago

  By: ravisamigo

• log file fills up in simple recovery model

  We have a 1.2TB wharehouse database running in simple mode. The log file filled up the other day t…

  Dana Bibeault

  4 replies

  14 years, 10 months ago

  By: Jeff Moden