SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• caculate age from birthdate in SQL stored procedure

  I would write something in a stored procedure. If age<23, but we don't have age colum, but only …

  sqlfriend

  5 replies

  14 years, 5 months ago

  By: sroumel

• Alter Index Rebuild Fails with Object Does Not Exist...

  Hi, Please advise. We have a regular rebuild/reorg index job that runs weekly against the databas…

  sql_jr

  2 replies

  14 years, 5 months ago

  By: Gail Shaw

• Query to find which columns have different values in a pair of rows

  I have a table which consists of pairs of records from two sources whose data differ in one or more…

  Marios Philippopoulos

  11 replies

  14 years, 5 months ago

  By: Jeff Moden

• data function

  Hi All In Sql Server Db2005 record is like give below Column-YearMonthNumber of dayHospital Na…

  faroz2003

  3 replies

  14 years, 5 months ago

  By: Jeff Moden

• SQLcmd

  I am getiing some scripts which written in SQLcmd code which connect various server and excutes th…

  Satya_0000

  2 replies

  14 years, 5 months ago

  By: Satya_0000

• xp_ss_backup

  I don't see xp_ss_backup on 2008..I am using enterprise edition....Can you please help? Where can I…

  SQL_Surfer

  2 replies

  14 years, 5 months ago

  By: okbangas

• Do get a column in a specific order

  Recently I have gone through an interview. There I was asked that I have a table and I have to get …

  ammit.it2006

  2 replies

  14 years, 5 months ago

  By: Jeff Moden

• ssis expression- calculate age by using birthdate

  I have a flat source file to import into a table. One column is birthdate, format is DT_DBDate, dat…

  sqlfriend

  4 replies

  14 years, 5 months ago

  By: raghu-sql

• Transfer Login

  Hi, I want to transfer logins from SQL server 2005 to new SQL server 2008. I need to transfer serve…

  Satya_0000

  1 replies

  14 years, 5 months ago

  By: salum

• Backup Strategy and DR

  Hi all, So we re-looking at our backup strategy and trying to put in some DR onto it as well. I ha…

  Staggerlee

  1 replies

  14 years, 5 months ago

  By: danschl

• Why DR site alert is coming red in report.

  I have configured logshipping between dc and dr for 6 databases.for 1/2 an hour replication time. A…

  forsqlserver

  1 replies

  14 years, 5 months ago

  By: danschl

• Possible return values for last_executed_step_id

  I've tried about 12 different searches on Google now and have come up with nothing. I even tried M…

  MyDoggieJessie

  1 replies

  14 years, 5 months ago

  By: MyDoggieJessie

• Deserialization failed

  SQL Reporting Error loading report: ReportName - The report definition is not valid. Details: Deser…

  mak12

  1 replies

  14 years, 5 months ago

  By: okbangas

• Replicating Database for read-only reporting access

  At month-end for 2-3 days our accounting application database (SQL 2008), is heavily used for prod…

  steveh-534443

  7 replies

  14 years, 5 months ago

  By: Chrissy321

• Problem creating Oracle Data Sources in SSAS 2008 R2

  Working on a Windows 2008 server (64 bit), SQL 2008 R2 (64 bit) and I've installed Oracle 11g (64 b…

  Michael.Gagne

  1 replies

  14 years, 5 months ago

  By: rufhowse