Administering

• Topics

  Started by

  Posts

  Last post

• mdf file increasing a lot !!!

  Hi All, I am a novice DBA and our company have a geodatabase appliaction that feeds data to SQL ser…

  SQLQuest29

  2 replies

  17 years ago

  By: SQLQuest29

• I need your SQL Server expertise again. Identity Columns

  All, After the invaluable input I received on my 1 database vs. 13 database conundrum, I am once …

  troy.hodge-981400

  8 replies

  17 years ago

  By: Lynn Pettis

• Read Application Log(Windows) from SQL Server 2005

  Hi, Is there any way to read application event log (windows) from SQL Server 2005. Thanks and Re…

  suresh_vc_mfc-784576

  1 replies

  17 years ago

  By: Rudyx - the Doctor

• Copying an sql table from one sql server to another sql server

  Hello, Iam new to sql2005, I am trying to see how to copy a sql table from one sql server to anothe…

  Juanita

  3 replies

  17 years ago

  By: Juanita

• Any idea what and why this is being generated? 'select top 1 1 test from sysobjects (nolock)'

  Running the following query I found a high hit count on this and I don't know where or why it's bei…

  zach_john

  2 replies

  17 years ago

  By: Gail Shaw

• Finding Tables Used on 1000 SP

  Hi All I have got nearly 1000 SP's on one of our database, i need to figure out a way t…

  CrazyMan

  22 replies

  17 years ago

  By: TheSQLGuru

• How to create a database with its correct zise

  I have 2 databases with different sizes; Database A size 6GB Database B size 18GB I have to merge b…

  MTY-1082557

  6 replies

  17 years ago

  By: GSquared

• Migrating SQL Mail to SQL Server 2005

  Hi We have SQL Mail feature enabled on a SQL 2000 instance and now we are planning to migrate that…

  SQLBuddy123

  4 replies

  17 years ago

  By: M Murphy

• COPY_only Backup??

  HI Team, May i know Hoe to use Copy_only Backup??

  Ram-1104378

  1 replies

  17 years ago

  By: Grant Fritchey

• DTSRun Error for user

  So, I'd like a user to run a Legacy DTS package via xp_cmdshell. I've created a test windows accoun…

  homebrew01

  2 replies

  17 years ago

  By: homebrew01

• ALLOW_PAGE_LOCKS vs DEADLOCKS vs REBUILD INDEX

  Hi, I would like to know if there is a link between any of these 3 things. Specifically the followi…

  Casper101

  3 replies

  17 years ago

  By: Gail Shaw

• how to create a batch file to execute files in production servier.

  hi to all, how can i create a batch file to execute bunch of scripts in production server. i.e., we…

  SQL*

  5 replies

  17 years ago

  By: M Murphy

• What is the column naming convention when creating columns in a table?

  Hi, This may be a dummy question for DBA fundass... What are the common standards that we need to f…

  suneel-210238

  4 replies

  17 years ago

  By: Grant Fritchey

• Resource db in 2008

  Hi Team, I installed sqlserver2008 in my pc but i did n't found Resource db if there any reason.

  Ram-1104378

  7 replies

  17 years ago

  By: Ram-1104378

• Problem installing sql server 2005 EE on Windows Vista home Basic SP2.

  Hi, I am trying to install sql server 2005 EE on Windows Vista home Basic SP2. After running the se…

  SqlServer Rocking

  4 replies

  17 years ago

  By: EdVassie