SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SQL Transactional Replication

  Hi, We have a 2008 based replication system up and running. We have a table, which is currently rep…

  steve.roberts_boohoo

  6 replies

  7 years, 10 months ago

  By: Sue_H

• The transient database snapshot for database 'DB1' (database ID 5) has been marked suspect due to an IO operation failure.

  I have looked all over google regarding 'snapshots' in SQL 2008 and I have been reading up on their…

  Leeland

  16 replies

  7 years, 10 months ago

  By: Jack 95169

• Errors in the OLAP storage engine

  Hi everyone. So I am quite new to sql and I am job that rebuilds a cube. the job was working fine u…

  edgar.earl

  4 replies

  7 years, 10 months ago

  By: jacqueline.trent

• Primary key incrementation

  Hello, I know from Microsoft Access when you enter any value in any column it automatically adds a …

  xboxown

  20 replies

  7 years, 10 months ago

  By: sgmunson

• TDE & CLE certificates + key files: store in Azure Key Vault?

  Environment: Win2008 R2 / SQL Server 2008 R2 SP3 on Azure VM (IaaS)Issue: Can I store TDE and CLE c…

  quackhandle1975

  1 replies

  7 years, 10 months ago

  By: Steve Jones - SSC Editor

• please help me date ranges update based on first service used

  telephonic Service given likeEmployee_code          Start_date   …

  vemula.narayanan

  2 replies

  7 years, 10 months ago

  By: Steve Jones - SSC Editor

• Affinity Mask...

  Hey Folks,Appreciate if somebody can share knowledge on factors one has to take into…

  Arsh

  9 replies

  7 years, 10 months ago

  By: Steve Jones - SSC Editor

• Error - SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server.

  Hi  Below statement is giving error insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8…

  jagjitsingh

  1 replies

  7 years, 10 months ago

  By: Sue_H

• A few quick questions about sysjobhistory table

  Hi there, I've got a couple of quick questions about the sysjobhistory table in msdb which I c…

  Graham4th

  3 replies

  7 years, 10 months ago

  By: ScottPletcher

• remove only number in the given string

  HI Friends ,I have one doubt in sql server .how to remove only numeric only in the given string. sa…

  srinudw88

  5 replies

  7 years, 10 months ago

  By: Jeff Moden

• Export to Excel

  Hi I want Data from the Sql table to Excel in predefined Excel Template . I have attached file…

  jagjitsingh

  2 replies

  7 years, 10 months ago

  By: pietlinden

• How do you do select and update together that actually works?

  Right now under company information profile when I click save button it goes through this code: Di…

  xboxown

  9 replies

  7 years, 10 months ago

  By: sgmunson

• How Best To DUplicate a SQL Server 2008R2

  We are transitioning form one SQL Server 2008r2 Instance to another (that's on a different windows …

  YSLGuru

  3 replies

  7 years, 10 months ago

  By: Sreekanth B

• SQL Server Setup -Unable to generate a temporary class

  TITLE: SQL Server Setup failure.------------------------------ SQL Server Setup has encountered the…

  ssurekha2000

  3 replies

  7 years, 10 months ago

  By: sgmunson

• xp_create_subdir for non-sysadmins

  Hi, Is it possible for non-sysadmins to run xp_create_subdir on the Express version of 2008 R2? Whe…

  jpoole

  15 replies

  7 years, 10 months ago

  By: Jeff Moden