SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• configuring Report services login

  hello, i have recently installed a new server ( sql 2008R2 ) and am trying to deploy my reports to …

  flashkarni

  1 replies

  15 years ago

  By: flashkarni

• SELECT All Columns from a table - without re-engineering if table stucture changes

  Hi, My problem statement is very simple, all I have to do is write a stored procedure to get data f…

  ASDL

  28 replies

  15 years ago

  By: Jeff Moden

• can someone help, I get the error scalar variable "@maxyr"

  SELECT top 1 @maxyr= convert(int,EquipmentYear), @viosum2= sum(vio) sumvio FROM vwTimingB…

  foxjazzG

  3 replies

  15 years ago

  By: ASDL

• Problem with restore.

  We are trying to restore a Database from one server to another. Both the servers are SQL server 200…

  manoharanpraveen

  1 replies

  15 years ago

  By: SQLRNNR

• Can't get SSIS migrated package to run in SQL Server job, due to changes made by BIDS.`

  I have a DTSX/SSIS package that I created on a dev-server and now I'm moving it to the production s…

  david.wheelock

  3 replies

  15 years ago

  By: david.wheelock

• Code to summary row

  Can someone help me to code for row summary based on user's selection? For example, one table is as…

  adonetok

  7 replies

  15 years ago

  By: LutzM

• Moving SqlExpress Data from one location to another

  Hi there, I have installed SQL Server 2008 R2 as well as SQL Express as two instances on default pa…

  ssudry

  14 replies

  15 years ago

  By: ssudry

• error when i try and run an ssis package in a sql server 2005 job

  anyone know what "The product level is insufficient for component "Flat File Source 1" (1721). " me…

  BaldingLoopMan

  3 replies

  15 years ago

  By: iapearsall

• Find statistics on each database object accessed, tables, views, stored procedures etc (sql 2008)

  I am trying to find a tool that logs access to all the database objects. We recently inherited the …

  chandra.pottipati

  1 replies

  15 years ago

  By: Ron McCullough

• Infromation from tables

  Ok I was just given a task I have no idea what to do...Have a sql database where I need to pull cli…

  webin

  12 replies

  15 years ago

  By: SQLRNNR

• Login Failure issue - SQL Server 2008 on Windows Server 2008

  SQL throwing login failure error when an NT user (NT Login) trying to login on SQL. But the same us…

  Jayakumar Krishnan

  16 replies

  15 years ago

  By: david.jobin 9674

• What could cause Network I/O waits high?

  Running SQL Server 2008 SP1 Enterprise Ed. In Activity Monitor/Resource Waits, the numbers in the N…

  DBA in Unit 7

  5 replies

  15 years ago

  By: DBA in Unit 7

• Clearing adhoc plans from the memory CACHESTORE will be useful for the data buffer memory

  Clearing adhoc plans from the memory CACHESTORE will be useful for the data buffer memory

  latheesh.jaya

  4 replies

  15 years ago

  By: Latheesh NK

• compate two table

  Hi all, I am trying to compare four columns in two tables(both are in the same schema), table a has…

  ssingh 90019

  9 replies

  15 years ago

  By: ssingh 90019

• SELECT IF greater than within specified period

  Hi I'm trying to query the following tables to find out the Resource Companyname and Project Title …

  garethdyson

  15 replies

  15 years ago

  By: garethdyson