Administration

• Topics

  Started by

  Posts

  Last post

• Error on DB Maintenance plan Job (ODBC SQLState: 42000)] Error 1934

  I have A DB maintenance plan which is scheduled, till now it was working fine now the Job is failin…

  Anand Premraj

  1 replies

  15 years, 5 months ago

  By: ashkan sirous

• What to consider when scaling up from 20 GB to 2 TB?

  Hello, We are currently using MSSQL 2000 Enterprise Edition. Our current database size is ~ 20 GB.…

  sql_er

  5 replies

  15 years, 5 months ago

  By: Steve Jones - SSC Editor

• When creating new table does column order matter if different data types?

  Hi, I work with MSSQL 2000. When creating tables I never paid attention to the order and type of c…

  sql_er

  8 replies

  15 years, 5 months ago

  By: Rick.Cornell.SME

• Need to measure Trans Volume

  Team I have been asked to measure : need to get data on transaction volumes -- specifically, tran…

  Frank-396605

  1 replies

  15 years, 5 months ago

  By: David Benoit

• Sp_Cycle_ErrorLog not working

  Hi,   I have a problem with sp_cycle_errorlog not cycling the error logs properly (and they ar…

  dgray1

  26 replies

  15 years, 5 months ago

  By: xxxx

• DB-Issue

  Hi All, Low disk space issue, One of our collegue to shrink the database. every one week the s…

  balaji.ganga

  11 replies

  15 years, 5 months ago

  By: John Mitchell-245523

• copying databases from physical server to Virtual VMWare server

  Hi, we plan on moving a physical SQL (2000) Database server to Virtual VMWare. The systems people h…

  Dana Bibeault

  2 replies

  15 years, 5 months ago

  By: Dana Bibeault

• C2 Audit

  Hi, On one of our 2000 servers C2 Auditing is enabled. We have a situation wherein we want to turn …

  ps.

  4 replies

  15 years, 5 months ago

  By: Lowell

• Query delay from ODBC / IIS / Server 2008

  We are attempting to upgrade our web servers to IIS7 on Server 2008. On our Windows 2003 server, e…

  jim-653533

  1 replies

  15 years, 5 months ago

  By: jim-653533

• Restore Database is taking forever

  Hi All, The restore database is taking for ever on sql server 2000 sp4 /windows server 2003 64 bit.…

  sqlbee19

  7 replies

  15 years, 5 months ago

  By: andrewkane17

• BCP

  Hi All, How to insert data from a text file to SQL Serevr 7.0 table, using BCP utility. Comma is a …

  Raghavender Chavva

  1 replies

  15 years, 5 months ago

  By: mark.pleasance

• Shrinking & Reindexing

  Hi All, In which scenerio we can use the shrinking database , reindexing and all.. …

  balaji.ganga

  2 replies

  15 years, 5 months ago

  By: balaji.ganga

• queue reader agent failed because of deadlock

  Dear all, i got one error.Please give me information if there is any imapct or not. In our oragniza…

  Minto Minto(quendans)

  7 replies

  15 years, 5 months ago

  By: Minto Minto(quendans)

• Reindexing and truncate

  Hi, Iam new to administrator , but i have given a script and i need to analyse it. It will DBREIN…

  mirravi

  12 replies

  15 years, 5 months ago

  By: balaji.ganga

• SQL Server 2000 Full text index components

  I have a SQL Server 2000 instance with about 50 databases. I need to migrate them to a SQL Server 2…

  Golfer22

  3 replies

  15 years, 5 months ago

  By: Adiga