Administering

• Topics

  Started by

  Posts

  Last post

• Linked Server Collation issues

  Running SQL2005 sp4 and I have linked server to DB2400 UDB for iSeries using IBMDASQL provider. I u…

  iamtig

  1 replies

  13 years ago

  By: Orlando Colamatteo

• Can we Upgrade from sql server enterprise edition 2k5 to sql server enterprise edition 2012?

  hello All, I need experts advised who have already started to work on sql serevr 2012, i came acros…

  sqlpanther

  1 replies

  13 years ago

  By: Perry Whittle

• Restore deleted SQL Server agent job

  I have a situation where I had two SQL Server agent jobs scheduled to run daily. The jobs are a bi…

  Julie Hobert

  6 replies

  13 years, 1 months ago

  By: loi.nguyen2000

• Error: 924 - Database "abc123" is open and can have only one user at a time.

  I could not do anything on this server on any db, i get this same error on the server what ever i t…

  Tara-1044200

  1 replies

  13 years, 1 months ago

  By: Sinfonico25

• One sql sevrer 05 runs fine in UAt other runs slow ni Dev--Please suggest

  hello All, i have 2 sql server 05 in 2 diff environment one in UAt and One in DEV theone server in …

  sqlpanther

  4 replies

  13 years, 1 months ago

  By: sqlpanther

• sql server user database file create date

  how to find sql server database file create and alter date and time please help us

  senfriends2008

  4 replies

  13 years, 1 months ago

  By: senfriends2008

• Maintenance plan for SQL DB maintenance order

  Hi, Best maintenance plan order for Production Database(>100GB) sqlserver 2005. Thanks in advance

  jamessdba

  6 replies

  13 years, 1 months ago

  By: Gail Shaw

• Performance issue advise

  Hi All, One of our developer said that he is seeing performance issues on our web based application…

  Sarwan

  3 replies

  13 years, 1 months ago

  By: Gail Shaw

• How to find a column in a DB ?

  Hello, How to look for a column lets say the column name has the word _commodity_ in it in a SQL…

  SQL SERVER ROOKIE

  10 replies

  13 years, 1 months ago

  By: SQL SERVER ROOKIE

• What would be the best practice to migrate my database from 2005 to 2008? Thanks.

  I will need to migrate my current SQL 2005 database over to 2008R2, other than back and restore, I …

  halifaxdal

  3 replies

  13 years, 1 months ago

  By: Sean Lange

• Awaiting command problem in sql server 2008

  I have used begin transaction in stored procedure that sp used about 1500 To 2000 times in one day …

  lucky_walia2003

  1 replies

  13 years, 1 months ago

  By: Chris Harshman

• Database Integrity and backup job failing.

  Hi, We have a Database Integrity Job and Backup Job that are scheduled in a gap of 6 hrs, with the …

  abhishekkulkarni1284

  7 replies

  13 years, 1 months ago

  By: Perry Whittle

• Reindexing job is failing

  Hi All, When i am executing DB Reindex in pre production environment..this job is getting failled a…

  Simha24

  10 replies

  13 years, 1 months ago

  By: shd.eftekhari

• splitting tempdb to multiple files - max size?

  i have noticed tempdb contention on our tempdb, so i want to split the data file to multiple files.…

  curious_sqldba

  6 replies

  13 years, 1 months ago

  By: curious_sqldba

• Unconsistent consistency errors...

  Hi yall. This is my first post here so bear with me please. I'm currently working for a company as …

  NTesla

  12 replies

  13 years, 1 months ago

  By: Gail Shaw