SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Using SQL Management Query in Visual Studio

  I am trying to use a query that works in SQL Management in Visual Studio but the code it not transl…

  mjmshopper

  3 replies

  12 years, 12 months ago

  By: Sean Lange

• DB400 to SQL Server data extraction

  Hi all, We have a DB400 (DB2 based AS400 platform) database and I'd like to pull data from it using…

  WWDMark

  2 replies

  12 years, 12 months ago

  By: WWDMark

• Query to Search the Data

  Hi, My requirement is,I want to search records,in my application, Example, Lnno Name Code SNo T…

  avdhut.k

  4 replies

  12 years, 12 months ago

  By: avdhut.k

• CTE Recursive

  Hi I have a query below and I will explain what I wish to archive. I have two methods that I need t…

  hoseam

  1 replies

  12 years, 12 months ago

  By: ChrisM@Work

• Databse auditing and management of audit logs

  Need assistance on the following : a) What are the common SQL database events/activities that shoul…

  albert.tan

  1 replies

  12 years, 12 months ago

  By: Grant Fritchey

• Cannot delete a SQL Server login

  I've got the following error when I try to delete a login using MS SQL Server Management Studio: Dr…

  eddy_gpeng

  8 replies

  12 years, 12 months ago

  By: suneet.mlvy

• Best method of handling optional parameters in WHERE clause

  Hi all, I'm trying to determine what the preferred method is for handling optional parameters in WH…

  gdpollock

  8 replies

  12 years, 12 months ago

  By: mister.magoo

• find pairs of NULL records without resorting to CURSORS

  create table #tmp ( ref int, Date datetime, time int, seqno int ) insert into #tmp (ref,date,time,s…

  aaron.reese

  8 replies

  12 years, 12 months ago

  By: ChrisM@Work

• Insertion in table

  HI, This is the table structure and script below: CREATE TABLE [dbo].[GV_Booklet]( [BookletId] [in…

  kapil_kk

  14 replies

  12 years, 12 months ago

  By: kapil_kk

• Help with SQL Server backups slow ( backup performance slower than before after data purge)

  Hi everyone, (searched SQL Central... I didn't find anything specific) Wanted to get some ideas on…

  sqlsurfing

  12 replies

  12 years, 12 months ago

  By: sqlsurfing

• Row Compression vs. Page compression

  Ok - trying to get a better understanding of when it's best to use Row compression vs. Page compres…

  SuperDBA-207096

  6 replies

  12 years, 12 months ago

  By: sky_night

• Can I keep x number of iterations in XP_CMDSHELL

  Hi I'm using the following to write a query out to a file... I will be running this daily, but I wa…

  jbalbo

  9 replies

  12 years, 12 months ago

  By: Lowell

• SSIS Data flow to AS400/DB2 looses records

  We insert data into DB2 tables on an AS400. The transfer happens over the WAN. The source server i…

  GerritKellerman

  1 replies

  12 years, 12 months ago

  By: Calibear

• How do I retrieve a value in a text column that has a XML

  Folks I have a table with a column "message" whose type is "TEXT". The contents inside this column …

  mw_sql_developer

  11 replies

  12 years, 12 months ago

  By: mw_sql_developer

• Letting Users Modify Other Users Jobs

  There is a team of five people that are currently sysadmins and I want to get them out of that role…

  Whisper9999

  1 replies

  12 years, 12 months ago

  By: Jared