SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• adding a computed persisted column to a large table and error out due to transaction log size

  I have a 1.5TB size of table(3.8 Billion Records) and want to add a new computed persisted column t…

  Selvaraju

  10 replies

  14 years, 10 months ago

  By: Selvaraju

• Error - the target table of the output into clause cannot be on either side of a relationship

  If any of you saw my post yesterday about an archiving job and how to do the OUTPUT INTO clause, th…

  andegre

  5 replies

  14 years, 10 months ago

  By: andegre

• Security events. Special Logon

  Hi, In one of our server we are getting security audit logs with event Id 4672 (Special privileges …

  Ryan007

  1 replies

  14 years, 10 months ago

  By: SQLRNNR

• 2008 R2 set up stops after product key is entered.

  Hello, I hope somebody can help me out. I have having to reinstall a copy of SQL server 2008 after …

  Duran

  2 replies

  14 years, 10 months ago

  By: Duran

• @Variables...can they lose scope/value over time?

  This is probably a SILLY question and a quick Google search didn't yield any satisfying results so …

  MyDoggieJessie

  1 replies

  14 years, 10 months ago

  By: gsc_dba

• Sop or Check list for Applying Hotfixes, Service Packs

  Hi All, Does any one have the Sop or Check list for Applying Hotfixes, Service Packs, Update Roll…

  Arman Khan

  2 replies

  14 years, 10 months ago

  By: mensheer

• pls suggest methodology for building select query when there are many tables to choose from

  Would a developer kindly provide advice... I know exactly what my results set should look like. It …

  KoldCoffee

  1 replies

  14 years, 10 months ago

  By: Jeremy-475548

• Databases Growth - Calc

  Hi All, I want to know the growth statistics of all my production databases over last 6 months. Th…

  aby_dvd

  12 replies

  14 years, 10 months ago

  By: Ninja's_RGR'us

• Copy stored procedures to another db (instance)

  How can I copy all the stored procedures to another db (or another instance)? In SQL2000 you could …

  Rhox

  4 replies

  14 years, 10 months ago

  By: Rhox

• SQL server with SCOM

  Hi All, We have very odd issue that around 3AM to 4AM the CPU utilization of the server goes to 1…

  Latheesh NK

  1 replies

  14 years, 10 months ago

  By: Grant Fritchey

• returns 1 row from date range rows

  Dear All, Please help me write a T_SQL (SQL 2008). For all rows in the sample data below where the …

  vee_jess

  6 replies

  14 years, 10 months ago

  By: vee_jess

• Moving data between filegroups

  I need some help in understanding the options that are available in moving data from one filegroup …

  M&M

  2 replies

  14 years, 10 months ago

  By: M&M

• CREATE and ALTER Indexes in MSSQL 2000

  I have to use MS SQL2000 server. I have problem to use the following script to customize the index…

  kpresario

  2 replies

  14 years, 10 months ago

  By: kpresario

• Ceate a Table from inside view

  I am writing a query for a view which creates some tables from inside the view and then use them ta…

  seftest_09

  3 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• sql agent job set up

  When I tried to schedule a one time occurence job to run on sql server agent, I see there is a yell…

  sqlfriend

  2 replies

  14 years, 10 months ago

  By: kusampudir