SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Linked Server Basics - Who can use them

  I've setup a bunch of linked servers in the past few years but had an Oracle admin bring up a quest…

  ImYourDBA

  9 replies

  14 years, 7 months ago

  By: Steve Jones - SSC Editor

• SQL Server 2008 r2 database

  Hello everyone, I have a customized application which replicates data in to sql server 2008 r2. the…

  sal-295209

  10 replies

  14 years, 7 months ago

  By: Ninja's_RGR'us

• Replication size limitations?

  I'm testing our "Pull data from SQL 2008 to SQL 2000" solution. It seems that I am having some trou…

  Shark Energy

  2 replies

  14 years, 7 months ago

  By: Shark Energy

• DBCC SHOW_STATISTICS, Rows and sampled Rows are not match

  Hi, DBCC SHOW_STATISTICS Result is showing Rows and sampled rows are not matched after UPDATE STATI…

  SQL Galaxy

  2 replies

  14 years, 7 months ago

  By: Gail Shaw

• Crosstab help needed!

  I have a table of data for which I need to make some of the columns separate rows, but I do not wan…

  tmummert

  3 replies

  14 years, 7 months ago

  By: GSquared

• Opening .sql in SSMS - R2

  Hi all, I have associated .sql files to open using SSMS. When I double-click on an .sql file, and S…

  schleep

  17 replies

  14 years, 7 months ago

  By: schleep

• Peculiar problem

  For one SQL Server instance, I am unable to connect when I provide port number but able to connect …

  ameer_k_k

  4 replies

  14 years, 7 months ago

  By: Suresh B.

• Measuring database availabilty

  Hi, I want to measure database availability for a particular month say for July 2011. Any idea how …

  Ryan007

  2 replies

  14 years, 7 months ago

  By: colin.Leversuch-Roberts

• Index Partitioning and Foreign Keys

  I have table create table T1( id int, name varchar(64), isopen bit ) And I Have an clustered index …

  Thinky Night

  3 replies

  14 years, 7 months ago

  By: Shark Energy

• Rows Archive and Purge

  Hi Please help me on this.. one of my database in SQL server 2005 is using for some audit purpose.t…

  vamshi.sql

  1 replies

  14 years, 7 months ago

  By: Lynn Pettis

• Will table compression also cause transaction log to be smaller?

  Hey guys, I have a table insert that is eating up a lot of transaction log space. If I had both tab…

  coder_t2

  15 replies

  14 years, 7 months ago

  By: Gail Shaw

• Triggers or replication?

  Hi all, I frequently use the forums here and they are a fantastic resource. I just hadn't signed up…

  Jimmy Nixx

  14 replies

  14 years, 7 months ago

  By: Roy Ernest

• Need Help with a Question

  Does anyone know, What are the system tables accessible from DML triggers? Describe them?

  Grass

  23 replies

  14 years, 7 months ago

  By: Gail Shaw

• Manage Resource

  Hi Friends, In our environment we have NT server which host both SQL Server Engine and SQL Analysis…

  vino5786

  4 replies

  14 years, 7 months ago

  By: @SQLFRNDZ

• Adding a new Service Account for agent

  Hi, My infra guys are on vaccation.Before that, on my recommendation they removed sysadmin rights f…

  chandan_jha18

  8 replies

  14 years, 7 months ago

  By: Adam Durr