SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SSRS 2008 - click on URL - page not found

  I installed a named instance of Sql Server 2008. When I go to "Reporting Services Configuration ma…

  Jerry44

  11 replies

  14 years, 10 months ago

  By: sathyareddy

• Trouble running sql 2008 query captured from profiler on sql 2000

  I ran a trace against our development server which is SQL 2008. If I copy one of the sql statements…

  Dave-483064

  2 replies

  14 years, 10 months ago

  By: Dave-483064

• Working with large de-normalized dataset

  Hi, I'm trying to find a way to programmatically pivot a very large data set, the structure of whic…

  Kevin Dahl

  6 replies

  14 years, 10 months ago

  By: Kevin Dahl

• How To Edit a Databasemail Email Profile

  I need to remove an email address from a DatabaseMail Email Profile. How do I go about doing this?

  dndaughtery

  1 replies

  14 years, 10 months ago

  By: danschl

• MEMORY utilization fior sqlserver 2008 r2

  I have a windows server 2008 R2 64 bit platform with 8 Gb Ram, I installed Sql server 2008 R2 DEv E…

  jamessdba

  3 replies

  14 years, 10 months ago

  By: sql_lock

• MAXDOP setting ignored

  Hello. Has anyone seen where the max degree of parallelism setting under sp_configure is ignored? W…

  ken.trock

  11 replies

  14 years, 10 months ago

  By: Marios Philippopoulos

• SQL Trace on Production?

  We're currently running a server side trace on a SQL 2008 Production instance. The trace has a fil…

  jackimo

  7 replies

  14 years, 10 months ago

  By: K Foster

• How to Increase value of Student ID(int) by 1 automatically?

  I have table of Student_Details where StudentID is int type and set as Primary Key. I want when any…

  Gopal Singh

  6 replies

  14 years, 10 months ago

  By: GSquared

• Database Mirroring Errors (SQL 2005)

  Hello Gurus Is there anyway i can figure out why the mirroring is failing? The mirroring fails only…

  sqlcool

  4 replies

  14 years, 10 months ago

  By: Craig Purnell

• Read commited

  Hi, As we know read commited is on by default and which means It prevents transactions to read dat…

  praveensatya

  1 replies

  14 years, 10 months ago

  By: Grant Fritchey

• how to display the months based on date

  hi.. this is my SP USE [TASKDB] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE…

  vinayak.v

  6 replies

  14 years, 10 months ago

  By: vinayak.v

• Help with Stored Procedure

  Hi I have a situation where I need to look at payments if they pass a criteria they go into a paym…

  steveb4rrett

  12 replies

  14 years, 10 months ago

  By: steveb4rrett

• Maintainence plan

  hi, After I manually create maintenance plan using SQL server Maintenence Plan Wizard with SQL Serv…

  mhdmehraj

  2 replies

  14 years, 10 months ago

  By: crazy4sql

• Stand alone SQL 2008/5 installs sharing SAN space.

  Hello, I wondered if I could gather some opinions/advice on stand alone SQL 2008/5 machines sharing…

  Duran

  5 replies

  14 years, 10 months ago

  By: Craig Purnell

• SQL xp_cmdshell COPY inside of a loop.

  This probably belongs in the newbie section, but maybe someone here can help... I want to Copy and …

  amiller-888168

  4 replies

  14 years, 10 months ago

  By: amiller-888168