Administering

• Topics

  Started by

  Posts

  Last post

• migration or Upgradation from sql 2000 to sql 2005

  Hi Experts, Currently we have a Sql server 2000 production Box Running Under 8.00.194RTMPersonal …

  sivark1

  10 replies

  16 years ago

  By: Sunny1

• Stored procedure fine tuning steps/guidelines

  hi to all, Can anyone give the sp fine tuning steps/guidelines, how can i optimize the sp? if a sp …

  SQL*

  6 replies

  16 years ago

  By: Nadrek

• SQL Server procedure- Strange problem

  Hi Have seen some strange problem Environment: SQL Server 2005 SP3 on Windows 2003 standard edition…

  khushbu

  4 replies

  16 years ago

  By: Lowell

• Process

  friends one of my production server one database process is in suspend mode.could u plz let me know…

  d.srikanth50

  8 replies

  16 years ago

  By: d.srikanth50

• Clusterd or non clusterd enviroment

  How to find out if I am working in clustered or non clustered enviroment. I know it is a stupid que…

  Krasavita

  3 replies

  16 years ago

  By: Krasavita

• Job

  Hi, SQL server 2005 SP3 I have disabled the job's(copy , Restore & alert) which is belongs to …

  sudhakara

  7 replies

  16 years ago

  By: Bhuvnesh

• Green connected icon !

  Hi everyone Strange issue here. Installed SQL 2005 Dev on both my laptop and desktop running XP SP2…

  MickyD

  6 replies

  16 years ago

  By: Ewan Hampson

• SQL Server 2000 Developer edition client server configuration error

  On my local I have : Windows XP SP2, SQL server 2000 Developers edition. SQL Server installation co…

  chandrakant_gaurav

  2 replies

  16 years ago

  By: chandrakant_gaurav

• database filesize and free available space

  Hi, I'm looking for a query to find out the free available space in the database files? Pls suggest…

  SQL_Hunt

  3 replies

  16 years ago

  By: Bhuvnesh

• Sql Server Services

  Hi, I have set the sql server database service as Automatic and the Agent service as Manual. while…

  sudhakara

  6 replies

  16 years ago

  By: sandy_1006

• Index Rebuild in SQL Server vs ORACLE

  Hi, We have both Oracle 11g Databases and SQL Server 2005 SP3 databases. Our Oracle DBA's do perofr…

  pshaship

  2 replies

  16 years ago

  By: Dhananjay-440114

• SQLCMD

  Hi, I am running the query through the command prompt but the result sets is not coming in the prop…

  sudhakara

  8 replies

  16 years ago

  By: sudhakara

• An invalid schema or catalog was specified for the provider "SQLNCLI" for linked server

  Hello. I have one linked server from server "A" to server "B" between 2 sql server 2005 with the la…

  jaramillo05

  2 replies

  16 years ago

  By: pk_nirmal

• Restoring Prod db to Test

  Hi I have a prod db on server 1 with User A and User B. Now it has to be restored on another S…

  SQLBuddy123

  6 replies

  16 years ago

  By: SQLRNNR

• Look at everything, change nothing

  I'm in a position now where I am managing an outsorced DBA service. I'd like to be able to look at…

  David Webb-CDS

  7 replies

  16 years ago

  By: LutzM