SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Upgrade a SQL Instance (side by side)

  Hello Experts, I have a requirement to upgrade an old SQL Server 2008 R2 sql instance to SQL 2014/1…

  SQL_Hunt

  1 replies

  9 years, 5 months ago

  By: rvsc48

• Does these tables and procedures belong to any replication or service broker?

  Hi, I have the following tables and sp's in a database and wondering if they are part of any kind o…

  Santhoshkumar KB

  1 replies

  9 years, 5 months ago

  By: doug.brown

• Edit a SSIS pakcage without Visual Studio

  This might have been already been answered already but could not find it. Apologize if repetitive.…

  sdh96

  5 replies

  9 years, 5 months ago

  By: sdh96

• Job that runs an SSIS Package security issue

  Hi I feel like I am missing something obvious in my thought process here... Using SQL Server 2008 R…

  DamianC

  3 replies

  9 years, 5 months ago

  By: DamianC

• set variable values when calling a SQL Agent Job from PowerShell

  Hi guys, Is it possible to set variable values when calling a SQL Agent Job from PowerShell? If we…

  mylenechalut

  1 replies

  9 years, 5 months ago

  By: Chris Harshman

• Simple header alias using parameters

  Hi friends , i woud like to make display the header and value using parameter eg : (below code is …

  Anand BI Developer

  3 replies

  9 years, 5 months ago

  By: Eirikur Eiriksson

• sp_special_columns_100 returns no records after table modification

  Hi all, I manage several SQL Server 2K8R2 databases. Last week , I modified several tables (change …

  jeanyvesR

  1 replies

  9 years, 5 months ago

  By: Eirikur Eiriksson

• 2008r2 vs 2014 (and 2012) - Ignoring 'tab/illegal' characters

  Hello everyone, I hope you can help, I have a simple query, where I am copy/pasting grid results to…

  Rob-350472

  6 replies

  9 years, 5 months ago

  By: Rob-350472

• database owner is null

  Hi, I ran below tsql to find the database owner but for some of the databases the owner returned NU…

  ramana3327

  2 replies

  9 years, 5 months ago

  By: ramana3327

• SQL server not using Index when dates are used as variables as opposed to constants

  SQL server fails to use Index when I use these set of variables: Declare @FromDate datetime Declar…

  datsun

  7 replies

  9 years, 5 months ago

  By: ScottPletcher

• Get data between 3PM and 2AM

  This data represents visits to our Emergency Room. I need to pull the records for patients that wer…

  NineIron

  12 replies

  9 years, 5 months ago

  By: NineIron

• Is SSIS import buggy or am I missing anything here on the failing import?

  Hello, This is really driving me nut: I have a pipe delimited text file to be imported into a new d…

  halifaxdal

  5 replies

  9 years, 5 months ago

  By: halifaxdal

• Mirror Database - Cannot create snapshot

  Hi, I have a mirrored database configuration, with two SQL Server 2008 Enterprise boxes, and SQL Se…

  Matthew Orton

  6 replies

  9 years, 5 months ago

  By: jthompson-602408

• Track replicated transaction.

  Publisher to Distributor History and in Distributor to Subscriber History I can see - 1 transaction…

  SQL_Hunt

  2 replies

  9 years, 5 months ago

  By: Bart Lewandowski

• Unable to cleanup a replication publication.

  Hello Experts, I have a publication but the subscription is removed already from the other server. …

  SQL_Hunt

  3 replies

  9 years, 5 months ago

  By: Bart Lewandowski