SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Calculating Balance based on the transaction

  I have two tables that stores balance and transaction information about an account. The first table…

  yogesh_pandey

  3 replies

  15 years, 5 months ago

  By: yogesh_pandey

• Restore SQL Server 2005 database in SQL Server 2008 instance

  Hi, I'm trying to restore a SQL Server 2005 database into a SQL Server 2008 instance and getting th…

  gary1

  5 replies

  15 years, 5 months ago

  By: Gail Shaw

• Naming a SQL server instance ".\SQLExpress"

  I am taking a Database Programming course. At my school they named the SQL server ".\SQLExpress" a…

  myavast

  6 replies

  15 years, 5 months ago

  By: myavast

• Sql 2008 license query

  Is there a query I can run for Sql 2008 to find out if a server is licensed under per processor or …

  amdavis

  4 replies

  15 years, 5 months ago

  By: MysteryJimbo

• Looping through the recordset to assign different balance value to each transaction row

  I have two tables that stores balance and transaction information about an account. The first table…

  yogesh_pandey

  6 replies

  15 years, 5 months ago

  By: yogesh_pandey

• Maxdop, does it work against processors or core's?

  I have a server with 4, 6 core processors. Does sql server see this as 24 processors? For testing d…

  winston Smith

  3 replies

  15 years, 5 months ago

  By: Derrick Smith

• copy all table structure in one database to another

  If trying to copy all table structure from one database to another but can't seem to remember how t…

  mashikoo

  4 replies

  15 years, 5 months ago

  By: mashikoo

• Duplicate records in Query ouput

  Hello, CREATE TABLE [dbo].[test2]( [name] [varchar](20) NULL, [id] [varchar](20) NOT NULL, [country…

  Tina1225

  3 replies

  15 years, 5 months ago

  By: Derrick Smith

• Dumb primary key question

  So I've got this database with a type of key I've never seen before. I don't even know what to cal…

  kdbarrett

  3 replies

  15 years, 5 months ago

  By: kdbarrett

• syspolicy_purge_history failing because of invalid SQLPS.exe location

  Hey all, Recently brought up a new 2008 R2 x64 cluster on Windows 2008 x64. When the instance is ru…

  Adam Bean

  1 replies

  15 years, 5 months ago

  By: Adam Bean

• SQL2008 -> SQL2005 using 'copy database' and SMO objects - just won't work!

  Has anyone managed to use the ‘Copy database’ facility via SQL Management Objects in order to copy …

  SQLCharger

  9 replies

  15 years, 5 months ago

  By: Perry Whittle

• 2005 to 2008 db restore taken 6 days and counting ...

  Morning, 450GB DB 300GB bak file On 2005 i ran a full db backup. Zipped Transferred Unzipped 2008 m…

  scott_lotus

  4 replies

  15 years, 5 months ago

  By: scott_lotus

• Dumping the transaction log in SQL Server 2008

  In SQL Server 2005 I used to dump tran MyDatabaseName with no_log DBCC SHRINKDATABASE ('MyDatabaseN…

  coenie-353912

  2 replies

  15 years, 5 months ago

  By: Gail Shaw

• passing 70-433 exam

  I passed my 70-433 exam yesterday. Having been a Ms Access developer for over decade I decided to g…

  Henk de W

  3 replies

  15 years, 5 months ago

  By: Henk de W

• The query processor ran out of internal resources and could not produce a query plan.

  Hi All, I have created more than 30 temporary tables like "DECLARE @tblPop9351 TABLE(Name VARCHAR(1…

  mpsathiskumar

  3 replies

  15 years, 5 months ago

  By: Dave Ballantyne