SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Replication issue - DROP TABLE failed due to SCHEMABINDING

  I had the following error in Replication Monitor earlier: "Cannot DROP TABLE 'dbo.MyTable' because …

  mazzz

  1 replies

  14 years, 5 months ago

  By: Cyrille Lonyem-243779

• Can't create database diagrams in SS 2000 using SSMS 2008

  I'm unable to create database diagrams in a SS 2000 database using SSMS 2008. I am a domain admin …

  georgiabasser

  1 replies

  14 years, 5 months ago

  By: Greg Charles

• Query data and report data from differt site

  1) We have two sites Silverton and Port Elizabeth, the data from Silverton needs to be read a…

  solomon.jernas

  3 replies

  14 years, 5 months ago

  By: SanDroid

• table performance

  I have a transactions table created in my Sql 2008 database which stores data entered by users from…

  znkin

  19 replies

  14 years, 5 months ago

  By: TheSQLGuru

• Maintenance plan creating 2 backups of each database

  I am having the strangest issue over the last few days. I have a maintenance plan that backups all …

  Aaron Christenson

  12 replies

  14 years, 5 months ago

  By: Devendrakumar

• SSIS keep autonumeric field values when transfering object (table)

  Hello, im new here. Now this is my problem: how to using SSIS Transfer SQL Server Objects Task tran…

  oskaroh

  2 replies

  14 years, 5 months ago

  By: oskaroh

• Taking Backup of Partitioned Tables

  Hi All, Is there a way I can take backup of all the unused filegroups. e.g. I have switched all the…

  swaroop.sahoo

  3 replies

  14 years, 5 months ago

  By: Devendrakumar

• Marketing Customer Target Email Query

  Hi, I've been given the task of coming up with a query to allow our company send out emails to our …

  JayK

  1 replies

  14 years, 5 months ago

  By: Cadavre

• XML Import 1:n relationship

  Hi All, I have the code below which is for importing xml files It results in customernumber accou…

  jjzzmp

  3 replies

  14 years, 5 months ago

  By: Mark Cowne

• Create a new column that concatenates a phrase with an integer

  Hello, I'd like to make a new column, let's call it TestColumn, in my table called TestTable, and I…

  mahdib21

  11 replies

  14 years, 5 months ago

  By: mahdib21

• SQL 2008 Cluster Virtual IP RDP

  I would like to know is it safe to take RDP of virtual IP of SQL instance. I mean hope there is no …

  mehtaamitm

  3 replies

  14 years, 5 months ago

  By: mehtaamitm

• sql query

  HI i am having query like this in oracle when i try to execute this query in sql server i got erro…

  sql Anand

  5 replies

  14 years, 5 months ago

  By: Suresh B.

• SQL 2008 Cluster Virtual IP RDP

  I would like to know is it safe to take RDP of virtual IP of SQL instance. I mean hope there is no …

  mehtaamitm

  1 replies

  14 years, 5 months ago

  By: Ant-Green

• calling WCF Service in SQL 2008 Job

  Hi For a project I am trying to call WCF webservice in SQL 2008 Job for regular execution of the se…

  tlrsekar 23727

  1 replies

  14 years, 5 months ago

  By: SpringTownDBA

• derived column error

  hi, i am getting error while putting the following expression in SSIS. Here IsLogistics and TradePe…

  duggal.priyanka06

  3 replies

  14 years, 5 months ago

  By: Koen Verbeeck