SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Difficulty exporting table

  I need some advice on exporting a large table. I've tried exporting from one server to another, ex…

  Erin Ramsay

  7 replies

  15 years, 10 months ago

  By: Derrick Smith

• Could not find table or object ID 825398117. Check system catalog.

  I have a sproc that im running, and it runs fine 9 times out of 10, but then it will throw this err…

  winston Smith

  3 replies

  15 years, 10 months ago

  By: winston Smith

• Page Splits And Fill Factor

  Page Splits ------------- When page split happens - which part of the row is moved? Is the whole ro…

  pradeep_pvn

  4 replies

  15 years, 10 months ago

  By: pradeep_pvn

• Determine which index page belongs to which table

  Hi How to determine which index page belongs to which table Error: 644, Severity: 21, State: 3 …

  parthi-1705

  3 replies

  15 years, 10 months ago

  By: Gail Shaw

• using like

  I would like to see if there are records in my table using LIKE. select * from mitmas where mmitno …

  sharonmtowler

  2 replies

  15 years, 10 months ago

  By: sharonmtowler

• Datetime conversion

  Can I get some help in converting a column data formatted in (weekday,Month,date) Example:Monday, M…

  Eshika

  4 replies

  15 years, 10 months ago

  By: Michael Valentine Jones

• How to licence SQL Server 2008 in a Virtual Environment. ARRRRRGGGH!!!

  Hi Gang, There's a lot of confusion where I work about the licencing model of SQL Server 2008 in a …

  Stueyd

  3 replies

  15 years, 10 months ago

  By: Stueyd

• SSIS Script Post Execute Problems

  I have two paths out of a dataflow lookup transformation that are connected to script components. E…

  nano2nd

  2 replies

  15 years, 10 months ago

  By: nano2nd

• query use different execution plan

  Hi, I've a table with 20 mill records. when i run this simple query but with the sp_executesql the …

  Mad-Dog

  18 replies

  15 years, 10 months ago

  By: Stefan_G

• Insert data from SQL 2008 to 2000

  Without using linked server, how to code to insert into tableA (in SQL 2000) select * from tableB (…

  adonetok

  1 replies

  15 years, 10 months ago

  By: steveb.

• Import Oracle table to SQL Server database

  Hi, We have Oracle database and one of tables stores the users information and we need to import th…

  gary1

  2 replies

  15 years, 10 months ago

  By: Stueyd

• Running BCP from .Net 4 C# System.Diagnostics.Process

  Hi, I'm trying to put together a utility that can execute BCP for me in a consistent fashion but I'…

  Adam.denby@focus-solutions.co.uk

  5 replies

  15 years, 10 months ago

  By: Adam.denby@focus-solutions.co.uk

• Backing up from a remote server on to your c drive

  Hi, What would be the best way to create a back up of a database on a remote server (a web hosting …

  marjan76

  9 replies

  15 years, 10 months ago

  By: Oliiii

• Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 524288

  Hi All, I'm getting the following error: "Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 52428…

  pakman

  3 replies

  15 years, 10 months ago

  By: pakman

• SELECT query is timing out due to SELECT STATMAN process

  So I'm running a simple SELECT statement on a table that is ~44 GB in data size. However, the quer…

  Chinesinho

  2 replies

  15 years, 10 months ago

  By: Chinesinho