SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• ANSI_WARNINGS explanation please

  The application that we develop prepares and executes statements and I was recently asked a questio…

  keith.gilbert-1064677

  6 replies

  14 years, 7 months ago

  By: keith.gilbert-1064677

• SSIS: Moving files to subdirectory on remote client FTP server

  Hi all, i am really hoping i could get some help on this. I have a FTP access to client FTP server …

  guri31

  1 replies

  14 years, 7 months ago

  By: Mahesh Bote

• Sql server doesnt release memory.

  hi How can i release the memory used by sql server. When more and more users are logged in, …

  joshy mathew

  4 replies

  14 years, 7 months ago

  By: InvisibleCat

• SQL Script to Run DOS Batch File

  I am running SQL Server 2008. I have created a batch file that executes the dtexec.exe program on …

  Anonymous

  13 replies

  14 years, 7 months ago

  By: Jeff Moden

• what to link dm_exec_query_stats to

  Hi, dm_exec_query_stats shows statistics about the performance and resources consumed for every que…

  ahmed_b72

  3 replies

  14 years, 7 months ago

  By: Grant Fritchey

• Shared database and Separate schema

  Hi, We have used 'Shared database and separate schema' approach under Multi-tenant database archit…

  apjchandresh

  7 replies

  14 years, 7 months ago

  By: Grant Fritchey

• Created a SSRS 2008 R2 report, can it be downgraded to 2008 R1?

  Created a SSRS 2008 R2 report, can it be downgraded to 2008 R1? Please help.

  tan110

  1 replies

  14 years, 7 months ago

  By: jw3970

• Row or Page lock ?

  Silly question: what is the default lock for sql server 2008 R2 ? ddfg

  awu

  2 replies

  14 years, 7 months ago

  By: ghanshyam.kundu

• Error while splitting xml!!

  Hi All Iam getting the following error while trying to split the xml : declare @XML xml set @XML =N…

  rams.prsk

  2 replies

  14 years, 7 months ago

  By: rams.prsk

• Splitting XML

  When I ran my SP in server i will get the below xml : <ReturnMessage id="3654397910"> <AdC…

  rams.prsk

  1 replies

  14 years, 7 months ago

  By: ColdCoffee

• "Cannot generate SSPI context" error when trying to connect to 2008 DB

  Hi, We have SQL server 2008 installed on window 2008. We have restored our production database on t…

  Harish Ajabe

  3 replies

  14 years, 7 months ago

  By: SQLArcher

• sys.dm_exec_plan_attributes - set_options values

  this topic can be deleted

  Adam Bean

  1 replies

  14 years, 7 months ago

  By: Johan Bijnens

• DateAdd function returns wrong result

  When I run the following query in SS2008 to get days around the end of the month, I get the same re…

  Jim ONeill

  7 replies

  14 years, 7 months ago

  By: SQLRNNR

• the title more sold in Pubs database without using CURSOR

  I am practicing sql server 2008, i want to ask if there is any way to find the title more sold in t…

  luis martin ortiz barrutia

  6 replies

  14 years, 7 months ago

  By: dogramone

• Massive Negative performance change for a delete

  I'm working on and have "completed" a process to purge old data from a database. Last Friday when …

  Jack Corbett

  13 replies

  14 years, 7 months ago

  By: Gail Shaw