SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• HOW TO INSERT A RECORD IN ORDER

  My date table has all 366 dates of year 2008.suppose a date is deleted from the date table ,for ins…

  praveen901

  5 replies

  14 years ago

  By: praveen901

• datetime sql ...

  hi, i have this sql proc CREATE PROCEDURE dbo.ListeLettreFichier -- Add the parameters for the st…

  marclas

  3 replies

  14 years ago

  By: Prasad.N

• SQL Query help

  Hi everyone, I am a newbie with SQL Server and T-SQL. I have got a problem and appreciate if anyone…

  vickys

  15 replies

  14 years ago

  By: vickys

• Server E-Mail when file lock?

  Is there anyway to create some type of procedure whereby SQL Server will e-mail me when a file lock…

  david.williams 50026

  5 replies

  14 years ago

  By: Ant-Green

• Inserting Results from Stored Proc into another Database Table

  Hi All, I am currently going through the internet and finding some solutions on backing up while us…

  Tava

  3 replies

  14 years ago

  By: Tava

• Moving a VLDB

  Hi, I am hoping someone can assit me here. I have a system that is hosted by a 3rd party. We are lo…

  Ford Fairlane

  4 replies

  14 years ago

  By: Ford Fairlane

• Case When or Loop based on Complex Logic

  I need to create member staus based on two variables (MbrID and MCDate). The logic is explained in …

  helal.mobasher 13209

  8 replies

  14 years ago

  By: helal.mobasher 13209

• 2008 R2... alerts not firing one server...

  I'm creating alerts which call a job on a bunch of servers. Alerts like this: declare @job_id varc…

  NJ-DBA

  8 replies

  14 years ago

  By: Lynn Pettis

• upgrade sql

  what is the process to upgrade sql2008 to sql2008 r2 where some of the databases are configured log…

  ramyours2003

  1 replies

  14 years ago

  By: Orlando Colamatteo

• Error Establishing Connection using SQL Authentication

  At one of our 10 remote sites, we are getting allot of login failures with this message - A connect…

  schillingt

  4 replies

  14 years ago

  By: RBarryYoung

• Best method to store time

  Hi, I'm working on a project that requires us to store an employee's work schedule. For example o…

  megan_c99

  5 replies

  14 years ago

  By: MysteryJimbo

• How to add 2nd instance on my laptop

  I have 2008 r2 installed with default instance. I am wondering If I can add another instance on the…

  Sen1

  5 replies

  14 years ago

  By: Lynn Pettis

• Best practices for monitoring databases-related issues?

  1) What you monitor regarding your databases? 2) How you monitor them (internal SQL function)? 3) H…

  DataAnalyst110

  3 replies

  14 years ago

  By: DataAnalyst110

• How to use SQLIO for Mount points on cluster

  How to use SQLIO for Mount points on cluster to test the IO on SAN?

  madhu-686862

  1 replies

  14 years ago

  By: Perry Whittle

• Retrieving Info from Central Management Servers (CMS)

  Hi everyone, I have configured CMS on my 2008 R2 server. I have a CMS node containing several SQL 2…

  dbaforever

  8 replies

  14 years ago

  By: dbaforever