SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Problems with $(...) powershell sintax in SQL Server

  Hi All I have a doubt about it I have a job running on SQL Server 2008 R2 that has a step with Powe…

  isc.jacervantes

  3 replies

  14 years, 1 months ago

  By: isc.jacervantes

• How can I Get The Oldest 3 Records for each student

  i have result table which contains result for each student per month ID StudentID ResultDate …

  ahmedhussein787

  4 replies

  14 years, 1 months ago

  By: ahmedhussein787

• Certificate I created could not be restored!!!

  Hi Guys, I created a certificate to be used for Encryption in SQL 2005 and backed up the files; how…

  Laura_SqlNovice

  2 replies

  14 years, 1 months ago

  By: Laura_SqlNovice

• Trigger Help

  Hello all, I have a table where I need to format a string before it inserts or updates, I think I n…

  kstephens 90242

  8 replies

  14 years, 1 months ago

  By: kstephens 90242

• table partitioning on persisted computed column referencing scalar function

  to do "table partitioning on persisted computed column referencing scalar function" you have to use…

  vlad-548036

  1 replies

  14 years, 1 months ago

  By: Sean Lange

• Update Trigger

  Basically im not great with database design and I need a trigger which takes the updated data from …

  lukebaker

  19 replies

  14 years, 1 months ago

  By: Gail Shaw

• Does changing the Isolation Level affect the settings for Quoted Identifiers

  I had a strange problem last night. We updated a report stored procedure and Set the Transaction I…

  pamozer

  1 replies

  14 years, 1 months ago

  By: Jack Corbett

• Strange Tables In TempDB

  I was trying to find out why my TempDB is as large as it is, and found some strange tables in the d…

  fahey.jonathan

  9 replies

  14 years, 1 months ago

  By: Gail Shaw

• Limited permissions but able to delete data

  There is this server where a user is having only db_reader access and execute permissions only for …

  M&M

  12 replies

  14 years, 1 months ago

  By: TomThomson

• how to validate a windows login in domain through SQL queries

  how to validate a windows login in domain through SQL queries

  SSRfromChennai

  5 replies

  14 years, 1 months ago

  By: Orlando Colamatteo

• split date range to individual dates

  hi,all i want split data like id startdate enddate 1 2012-2-1 2012-2-3 to datas like:…

  hacker012

  4 replies

  14 years, 1 months ago

  By: hacker012

• Use of 4-Part object naming and effects on local plan execution

  [Background] I'm in the unfortunate situation where the only data I have to develop against is loca…

  cgm/

  3 replies

  14 years, 1 months ago

  By: Jack Corbett

• SSIS

  I'm new to using SSIS and I'm trying to figure out how to run a query, get a bunch of email address…

  rortizsoftware

  7 replies

  14 years, 1 months ago

  By: mdkmohan

• Remove SQL Server Installation

  I was given a new Server to be used for SQL Server 2008 R2. I was not expecting them to install SQL…

  Welsh Corgi

  3 replies

  14 years, 1 months ago

  By: Welsh Corgi

• How to identify query causing huge drop in Page Life Expectancy

  I have a database server that has a page life expectancy drop to almost 0 each morning. intuition i…

  winston Smith

  10 replies

  14 years, 1 months ago

  By: Jeff Moden