SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Associated data export

  I'm sorry if this question is daft, but what seems an obvious need has managed to utterly escape me…

  Kevin Butterworth

  2 replies

  14 years, 9 months ago

  By: Kevin Butterworth

• Back up restore question

  I have to run a BACKUP restore (full replace). The MSSQL 2008 R2 Web database has 5 agent jobs runn…

  Digs

  4 replies

  14 years, 9 months ago

  By: Syed Jahanzaib Bin hassan

• Learning sql 2008

  Hi all I am new to here and am about to do a sql 2008 course . I am just wondering what do you all …

  WolvesAly

  3 replies

  14 years, 9 months ago

  By: Syed Jahanzaib Bin hassan

• Query performance - 3 part name

  Simplified code example. Same query, run from two different database contexts: use DB_ONE go selec…

  Don Halloran

  8 replies

  14 years, 9 months ago

  By: Don Halloran

• Hi,small clarification............

  Why to sort data sets before merge transformation in SSIS and what is the difference between merge …

  sqlmaverick

  3 replies

  14 years, 10 months ago

  By: Warwick Rudd

• Challenge to deal with XML file using ssis? ANy one can give the better solution

  I have to do this using SSIS( BIDS) business integration tool. (DTS Transformations) I have to ta…

  sqlmaverick

  2 replies

  14 years, 10 months ago

  By: LutzM

• a database disappear from my management studio

  I have at my home sql server express 2008 and i am the only that use sql server,i added 2 stored pr…

  luis martin ortiz barrutia

  2 replies

  14 years, 10 months ago

  By: Johan Bijnens

• Query for left join

  I have a query that pull sql information from Discovery database. My question is for the query belo…

  sqlfriend

  4 replies

  14 years, 10 months ago

  By: Welsh Corgi

• why we use try catch in Sql server

  hi all, I am using .net 2005 with sql server 2005. In this case why we have to use try c…

  kuppurajm

  5 replies

  14 years, 10 months ago

  By: gaur1982

• Fast growing db and lots of integrations

  I need some opinions from sql DBAs. The managment is thinking of acquiring a new set of data. Bas…

  Luke79

  5 replies

  14 years, 10 months ago

  By: LutzM

• As a new DBA and a general SQL Newbie.. (recommendations on managing SS2k8 & Other tasks)

  I am a novice to SQL (In general) and a fairly new DBA -- I have quite a few questions. I'm really …

  ryan.macy

  6 replies

  14 years, 10 months ago

  By: Syed Jahanzaib Bin hassan

• Urgent help with stored procedure (Re-Post) Please need Immediate help...

  i have a table with below structure Create Table Status ( ID int Identity(1,1), ClientID int, Statu…

  Lucky9

  29 replies

  14 years, 10 months ago

  By: Welsh Corgi

• Data conversions for hours.

  I have hours coming into a stored procedure with definition of nvarchar(24). I am getting this fro…

  ruffindmc

  7 replies

  14 years, 10 months ago

  By: Ron McCullough

• Minimum SQL database permissions required to use impersonation on SSRS data source connection?

  Hi I am currently encountering the following error when I try to specify a datasource from SSRS to …

  killian_Davies

  1 replies

  14 years, 10 months ago

  By: kevin_nikolai

• Login failed for user ''. The user is not associated with a trusted SQL Server connection.

  Hello all, I am on sql server 2005. And lately we been getting these error on our sql server log.…

  crazylifescary

  9 replies

  14 years, 10 months ago

  By: kevin_nikolai