SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 months ago

  By: Dave Ballantyne

• Object naming protocol when using triggers to write to another DB on same SQL server.

  Folks, I am working on a production DB where I want to use simple auditing triggers to write to ano…

  mick L

  2 replies

  15 years, 10 months ago

  By: mick L

• Using OPENROWSET and BCP

  Can I insert any files into a blob varbinary and then use bcp to export the file.. I have experimen…

  agh100

  2 replies

  15 years, 10 months ago

  By: agh100

• TRIGGER: UPDATE, DELETE or INSERT?

  Hi, I hope a simple question. When I create a trigger on update, insert and delete, is there a way …

  Raymond van Laake

  3 replies

  15 years, 10 months ago

  By: mpsathiskumar

• Adding SQL Server Agent in SQL Server 2008

  I m trying to find SQL server Agent in SQL server 2008 but i am unable to find it. Please let me kn…

  vikas.rawat

  3 replies

  15 years, 10 months ago

  By: Gail Shaw

• Replication issue - Log Reader stuck on Initializing!!!

  Log Reader stuck on Initializing, I have SQL server 2008, and the transactions are not getting repl…

  Mh-397891

  1 replies

  15 years, 10 months ago

  By: winash