SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Moving a table to a new file group

  Hi, I was wondering if someone could help me, I have table which is currently about 500mb on my dev…

  InvisibleCat

  7 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• SQL 2008 INSTALL ERROR

  Hi, I am trying to install SQL server 2008 R2 dev edition on Window 2008 R2 enterprise(new server).…

  HBK_4700

  2 replies

  14 years, 10 months ago

  By: Steve Jones - SSC Editor

• shrink mdf file problem

  Hi I've got a large mdf database file that i need to shrink. I've got 400gigs free space, due to o…

  007DBA

  4 replies

  14 years, 10 months ago

  By: SQLRNNR

• SQL Native Client x32 or x64?

  When installing the x64 SQL 2008 native client, it also installs the 32bit binaries. How does the …

  jallmond

  19 replies

  14 years, 10 months ago

  By: jallmond

• linkedserver connection test

  I'm using the following code to establish a linked list to a server: sp_addlinkedserver 'IP_Addres…

  platipino

  5 replies

  14 years, 10 months ago

  By: Syed Jahanzaib Bin hassan

• Active Connection Staying Open After Switching DB in Management Studio

  I just installed 2008 R2 on my laptop and I'm noticing some strange behavior. I start Management S…

  Johnny Clark-301564

  1 replies

  14 years, 10 months ago

  By: HelloFOFO

• I need a query for getting avg from the below table.

  Hi all, I want to get average from the below records. project country vendor …

  kuppurajm

  10 replies

  14 years, 10 months ago

  By: GSquared

• Unable to Create Trigger on CDC Tables

  Hi All, I'm trying to create an insert trigger on the CDC table which will load the data from the C…

  pkposani

  4 replies

  14 years, 10 months ago

  By: parthi-1705

• temp table and dynamic sql problem

  i created a store proc i created a temp table and data is passed using another temp table now i am …

  pardeshkumar

  12 replies

  14 years, 10 months ago

  By: Willem G

• Any way to find all deletes done on a table in last 24 hours?

  Hi, I was wondering if there is a way to find all the deletes done to table or database in the las…

  Staggerlee

  2 replies

  14 years, 10 months ago

  By: Staggerlee

• Missing DSN Name in ODBC Connection on Server for SSRS Report

  Hi All, Need some help. a. When using Excel 2007 as data base for SSRS report I am able to ge…

  josh2abhi

  3 replies

  14 years, 10 months ago

  By: josh2abhi

• Check and Drop an Article

  Hi, Is it possible to check for an replication article if it exists and drop the article. Thanks …

  dhanasekar.palani

  1 replies

  14 years, 10 months ago

  By: David Benoit

• Export to flat file without extended stored procedure

  Hi All, Sorry if the query exists previously. I would like to transfer data from SQL Server to flat…

  MSSQLBuddy

  2 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• Database Response is too slow

  I am using window Server 2008 64bit with MS SQL Server 2008 64 bit Service Pack 1 installed. Usuall…

  azhar.iqbal499

  18 replies

  14 years, 10 months ago

  By: ModestyBlaise84

• Is the -g memory_to_reserve startup parameter relevant on 64-bit systems?

  This article talks about the -g parameter forcing SQL Server to set aside additional memory for non…

  Orlando Colamatteo

  10 replies

  14 years, 10 months ago

  By: Gail Shaw