SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• getting previous month id

  How to get previous month id for an entry if present month id field is null? I have some many recor…

  navireddy.g

  1 replies

  14 years, 11 months ago

  By: ColdCoffee

• Retrieve employee data without using stored procedure and c

  Hi All, I tries the following by using cursors.. but cursors consume more memory is there any othe…

  odanwada

  18 replies

  14 years, 11 months ago

  By: odanwada

• Management Studio doesn't show DTS versions

  I have one DTS package that when I try to right click and open with either SSMS 2K5 or 2K8, it show…

  TrailRunner

  6 replies

  14 years, 11 months ago

  By: sgmunson

• calculation for the multiple periods in the date range

  please help how can i do this calculation for the whole period ( Tperiod1 to Tperiod48) without re…

  s_nyanzowa

  4 replies

  14 years, 11 months ago

  By: s_nyanzowa

• How to compare multiple rows of one table with multiple rows of another table

  Hey all, I want to check before inserting into a table if a specific set of values exists or not I'…

  kamranzafar_ch

  2 replies

  14 years, 11 months ago

  By: Ninja's_RGR'us

• error opening a SSIS package

  Hi everyone, I get this error when I try to open a DTSx package in my machine, can anyone help me ?…

  bryan72florida

  6 replies

  14 years, 11 months ago

  By: Welsh Corgi

• Transaction won't roll back!

  I have a backup statement that I had to stop using the kill statement after 10 minutes. Now it's r…

  T Moore

  3 replies

  14 years, 11 months ago

  By: Gail Shaw

• help about create table relation

  Hi! i want to consult about relations between tables. my database is interested with e-commerce. th…

  sa.ordekci

  2 replies

  14 years, 12 months ago

  By: sa.ordekci

• Problem connecting SQL Instance in a Single User Mode

  I want to connect to the SQL Server Instance as a Single User Mode. First i stopped the SQL Server …

  king_emperor_in

  13 replies

  14 years, 12 months ago

  By: Perry Whittle

• need script to take back up of only failed backup jobs for the user databases (by cheking the latest backup job failures)

  Hi everyone, I am looking for the script to take the backup of only failed backup jobs example i ha…

  smileswithharish86

  1 replies

  14 years, 12 months ago

  By: Michael Valentine Jones

• MSSQL 2008 R2 Web ??

  I have developed my DB in MSSQL 2008 R2 developer edition (I think developer is the MSSQL enterpris…

  Digs

  6 replies

  14 years, 12 months ago

  By: Steve Jones - SSC Editor

• cannot view databases etc in reporting service in ssms

  I just add a Reporting service feature to my local sql server 2008 developer version installation o…

  sqlfriend

  4 replies

  14 years, 12 months ago

  By: sqlfriend

• training class of sql 2008

  I would like to take a class of sql server 2008 near seattle area. I hope the class is for SQL serv…

  sqlfriend

  2 replies

  14 years, 12 months ago

  By: Gail Shaw

• sp_help_revlogin

  Hello All, Typically I export the results of sp_help_revlogin to a file on a daily basis for backup…

  Chrissy321

  14 replies

  14 years, 12 months ago

  By: Chrissy321

• SQL 2008 Report Model Entity Issue

  Hello, I have a report model over a relational DB built in VS 2008. It has one main fact entity an…

  melissa21_13

  1 replies

  14 years, 12 months ago

  By: tinku.reddy