SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• TimeStamp and @@DBTS feature/syntax deprecated in future version, what is the alternative provided by SQLServer

  HI, As mentioned in the this link that don't use TimeStamp feature in future development. http://ms…

  iBar

  2 replies

  14 years, 8 months ago

  By: Grant Fritchey

• sp_MSreplcheck_publish and replicating Stored Procedures

  Hi, Posted this in the SS2K5 Replication forum a couple of days ago but it seems very quiet there. …

  ohack

  2 replies

  14 years, 8 months ago

  By: ohack

• How to update catelog view sys.servers

  Hi I have some 200-300 linked servers created on my database server.Server Instance of databases to…

  gkmsbi

  4 replies

  14 years, 8 months ago

  By: deepkt

• Query performance irregularity

  Hi everyone, I was told by someone that they have two servers that are exactly the same in every re…

  shahgols

  3 replies

  14 years, 8 months ago

  By: Grant Fritchey

• sp_attach_db with ATTACH AS

  Hi, I wanted to know how do I use sp_attach_db for attaching EDM with "attach as" option. Thanks, A…

  SQL_By_Chance

  2 replies

  14 years, 8 months ago

  By: SQL_By_Chance

• search query as per selected checkboxes

  Hi, I have build a search in asp.net as user will select values from dropdownlists e.g. state, city…

  Hem.Singh

  21 replies

  14 years, 8 months ago

  By: Hem.Singh

• SQL SERVER(T-SQL)

  Hi all, I am using SQL SERVER 2008 What is the query(T-SQL) to get the Keywords in resu…

  maheshkrishnas

  5 replies

  14 years, 8 months ago

  By: maheshkrishnas

• Same query, different reads/duration in Profiler

  Hi all, I could use some advice on a few poorly performing queries. Unfortunately they are Microsof…

  bathawes 16438

  3 replies

  14 years, 8 months ago

  By: Grant Fritchey

• Create linked server with Windows Authentication rights

  Dear all, I have a Windows Domain account to connect to a SQL Server database with Windows Authenti…

  coby_cai

  2 replies

  14 years, 8 months ago

  By: coby_cai

• Grouping/Partitioning data

  I have dataset that consists of 3 fields. Package number, IC_CODE and a description I am trying to …

  eseosaoregie

  12 replies

  14 years, 8 months ago

  By: Evil Kraig F

• Performance Issue In DB

  i have a database of 100 GB recently we are facing some problem to performance. the front end appl…

  Dhirju

  53 replies

  14 years, 8 months ago

  By: Steve Jones - SSC Editor

• keywords in sql server

  hi i want to see keywords in sql server 2008 in oracle by using this query- help reserved words; we…

  sql Anand

  4 replies

  14 years, 8 months ago

  By: bsdtux

• Question about log shipping from SQL 2005 to SQL 2008

  I have setup log shipping to go from our SQL Server 2005 server to our SQL Server 2008 R2 server. H…

  bsdtux

  10 replies

  14 years, 8 months ago

  By: bsdtux

• ISOLATION level difference between Client connections and Database

  All, I have a database set on Snapshot Isolation Level. SELECT * FROM sys.databases -- Result: -…

  _UB

  7 replies

  14 years, 8 months ago

  By: Gail Shaw

• SQL Server 2008 Maintenence Plan - Backup file name

  Is there a way to specify the backup file name in the Backup Maintenence Plan? It looks something …

  icata

  1 replies

  14 years, 8 months ago

  By: sturner