SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• automate daily backup

  Hello all, instead of reinventing the wheel i wanted to find out if someone is already doing someth…

  max_scalf

  7 replies

  12 years ago

  By: Michael L John

• Backup, Mirror, Snapshot, Cubes,.. What should I have to use?

  Hi. I have a database with all my customers data and I want to create other databases per customer …

  denisribeiro

  3 replies

  12 years ago

  By: HanShi

• Hpw to make SUM() return in BIGINT

  Hi All! I have this CURSOR in a stored procedure: DECLARE CounterBal CURSOR FOR SELECT SUM(CASE W…

  Edvard Korsbæk

  4 replies

  12 years ago

  By: Gazareth

• Log shipping wizard fails to restore secondary datab

  Hello, I hope someone could give me a hand. I have had to remove log shipping from a database in or…

  Duran

  6 replies

  12 years ago

  By: Perry Whittle

• Using Linked Server Dynamic Parameter

  For a linked server provider I have enabled the Dynamic parameter option. However I have tried a nu…

  marks_262

  1 replies

  12 years ago

  By: spaghettidba

• bcp error

  I really like bcp but it really makes me frustrated, I keep getting error: Starting copy... SQLSta…

  halifaxdal

  18 replies

  12 years ago

  By: x

• Foreign key and primary key

  Need help in understanding Foreign key and primary key and how to use them in a table Thanks

  beginner2000

  6 replies

  12 years ago

  By: Grant Fritchey

• convert type sql 2008

  hi, I want to know is it is possible to convert an int to date in a table. When I run ALTER TABLE …

  eboucicaut 94437

  3 replies

  12 years ago

  By: Luis Cazares

• Is there a way to enforce the use of a where clause in a select?

  I have a client who constantly runs select statements without a where clause. This has been causing…

  Darryn the Tired

  29 replies

  12 years ago

  By: davoscollective

• Count rows after non zero

  How to count rows after first non zero in a set? Example in the set data that have 2 column month a…

  saxsena_sanjay

  5 replies

  12 years ago

  By: Koen Verbeeck

• SQL Release

  Hi Techies, I'm SW developer and using the MSSQL in the current project. At this moment we have a p…

  xavieraraujo

  3 replies

  12 years ago

  By: Grant Fritchey

• Select case statement

  Is it possible to use the result of case statement as Alias? Select date, case when age>20 then …

  glarry

  19 replies

  12 years ago

  By: glarry

• provider : Named pipes Provider, error : 40 - Could not open a connection to SQL Server

  Hi All, My Team was creating the subcriber for replication purpose . When I connected to the subcri…

  WhiteLotus

  2 replies

  12 years ago

  By: WhiteLotus

• Error: 701, Severity: 17, State: 193.

  I am very new to SQL Server. This is the first error I am working on myself. I have sent time tryin…

  a7x_rocks_hard

  2 replies

  12 years ago

  By: a7x_rocks_hard

• Database Mail Issue...

  Hi there .. I setup the Database Mail on Sql Server 2008 R2, when i setup the DBMAIL most of the s…

  fawad.majid

  2 replies

  12 years ago

  By: Jack Corbett