SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• SCOM and Performance Monitoring

  Hello all, I've inherited the monitoring project at my company (I'm not sure who I made angry, prob…

  Grant Fritchey

  3 replies

  14 years, 10 months ago

  By: Pam Brisjar

• unable to allocate 'min server memory'

  Hi, Over the weekend we have updated our OS with the latest patch (Windows Server 2003 R2 Data Cent…

  Rem70Rem

  6 replies

  14 years, 10 months ago

  By: Rem70Rem

• group query output

  Is this something that SQL can do, or should I just code for it within the app? I'm looking to do t…

  SQL_NuB

  2 replies

  14 years, 10 months ago

  By: SQL_NuB

• Question about job scheduling

  I have a job that I want to run every 20 minutes (because it takes about 15 minutes to run). When I…

  andegre

  6 replies

  14 years, 10 months ago

  By: andegre

• SQL Log File Viewer Q - Does it Sometimes Drop Records

  Had a rather odd problem this morning wth the SQL Log Viewer. At first when I looked at it the vie…

  YSLGuru

  2 replies

  14 years, 10 months ago

  By: TheSQLGuru

• Last 10 run of a script

  Hi All, i have a script that runs on a set of servers and, based on the result, writes an entry in …

  davrose

  4 replies

  14 years, 10 months ago

  By: spaghettidba

• SQL Server Breaks down for every 10mins

  Hi ALL, I am new to SQL Sever.I m facing a problem and need urgent help and suggestions.The Sql Ser…

  pinnamaneni.pavani999

  19 replies

  14 years, 10 months ago

  By: Jeff Moden

• Database size versus table size allocated

  I have a SS_2000 user database that is approx 9 GB total size. sp_database reports 9415680. The rec…

  297t73g

  3 replies

  14 years, 10 months ago

  By: 297t73g

• Script to script the Login dependencies

  Hi All, I have a login on one instance which have access to 50 databases with different roles. On f…

  Praveen Reddy Nagulapally

  1 replies

  14 years, 10 months ago

  By: AlexSQLForums

• Collation Conflict Error

  Hi, When I am migrating stored procedure from SQL Server 2000 to SQL Server 2005, I am getting the …

  Ezhilan

  9 replies

  14 years, 10 months ago

  By: Gail Shaw

• Can we rollback all DML,DDL and DCL commands

  Hi, Can we rollback all DML,DDL and DCL commands. Or is it that we can rollback or commit only part…

  cmrhema

  1 replies

  14 years, 10 months ago

  By: Adi Cohn-120898

• how we will use logshipping in real time email infrastrcture priject

  What is the role of logshipping and this process

  shoukat.sohel

  1 replies

  14 years, 10 months ago

  By: Gail Shaw

• Count the number of rows with same last part

  Hello All, I have a query which returns 1000 rows. Example: 1111.root.abc---el-paso 124521.root.abc…

  chaudharyabhijit

  5 replies

  14 years, 10 months ago

  By: Jeff Moden

• How to handle null values in pivot stored procedure

  Hi, How to handle null values below stored procedure returns null value when i dont have da…

  naresh0407 93367

  1 replies

  14 years, 10 months ago

  By: LutzM

• Update View with Column that performs SUM on two fields from each row

  Hello, I created a view from a select against a database table. I added a new column (QtyTotal) to…

  btodd 61953

  2 replies

  14 years, 10 months ago

  By: btodd 61953