Administering

• Topics

  Started by

  Posts

  Last post

• Restricting SQL Server TCP/IP Port Range

  Hello, everyone! I am experiencing issues with SQL Server 2005 grabbing hold of random TCP/IP port…

  Jose Johnson

  3 replies

  14 years, 10 months ago

  By: William Soranno

• Database Attach problem

  I dettached a database so that i can move the files to a differnt drive which i have done many time…

  Tara-1044200

  6 replies

  14 years, 10 months ago

  By: GSquared

• get queries affecting tempdb?

  is there anyway to get a list of all the queries currently running on sql server which are affectin…

  anuragingle

  2 replies

  14 years, 10 months ago

  By: M&M

• Restore Differential Backup

  I have a full backup and 3 differential backups after that, i did restore full backup successfully …

  Tara-1044200

  3 replies

  14 years, 10 months ago

  By: Gail Shaw

• A buffer failed while allocating bytes

  Dear All, My SSIS package is failing due to the below error. It was working fine till yesterday. OS…

  jishar

  1 replies

  14 years, 10 months ago

  By: BLOB EATER

• Database Mail error

  Hey guys, I can set up Database Mail through pointing and clicking in SSMS, and send out a test ema…

  colin_sloss

  6 replies

  14 years, 10 months ago

  By: Geetha Chari

• 2 Tier RS Question

  Hello friends, I have to arrange moving our RS(2005) to another server. The environment is as follo…

  Mr J

  5 replies

  14 years, 10 months ago

  By: Mr J

• sys.dm_exec_request showing negative total_elapsed_time

  Hi all, One of my SQL Session is opened from long time and it is a SQL Job which opened this sessio…

  mohan.pariveda 18256

  3 replies

  14 years, 10 months ago

  By: Lowell

• Can we call SSIS Package through MS Access

  Hi All, I want to call a SSIS Package through MS Access VBA Code. So is there any way out that I ca…

  gauravin2007

  2 replies

  14 years, 10 months ago

  By: Evil Kraig F

• Use of Partitioning to increase import AND query speed?

  Hi, Not sure if this question fits into "Administering" or "Developement" really - I am a developer…

  dwill

  5 replies

  14 years, 10 months ago

  By: ricer

• Integer or Numeric

  What is better to use numeric or integer in the table, which takes less space?All for uniquie(auto)…

  Krasavita

  3 replies

  14 years, 10 months ago

  By: Gail Shaw

• Finding out database name using .mdf file

  Hi, I've a SQL data file (.mdf) I would like to find out to which database it's linked to ? Is ther…

  SqlSavy

  4 replies

  14 years, 10 months ago

  By: SqlSavy

• Instances different versions on different nodes

  Recently tried to apply 2005 SP4 and now the instances are different versions on the nodes. The maj…

  lulu_lutz

  6 replies

  14 years, 10 months ago

  By: lulu_lutz

• does max dop query hint over write max dop setting at server level?

  I always get confused when trying to understand max dop :(. I was so lost after talking to Microsof…

  curious_sqldba

  1 replies

  14 years, 10 months ago

  By: Jeff Moden

• Orphan DB

  How to solve orphan database error?

  swapan.dey

  7 replies

  14 years, 10 months ago

  By: Yuri55