SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• 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

  11 years, 2 months 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

  11 years, 2 months 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

  11 years, 2 months 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

  11 years, 2 months 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

  11 years, 2 months 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

  11 years, 2 months 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

  11 years, 2 months 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

  11 years, 2 months 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

  11 years, 2 months 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

  11 years, 2 months 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

  11 years, 2 months 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

  11 years, 2 months ago

  By: Jack Corbett

• File Size from T-SQL

  Hi, I need a way to get a physical file's size from T-SQL, without using xp_cmdshell. My exact situ…

  ralu_k_17

  19 replies

  11 years, 2 months ago

  By: Gazareth

• How to export SQL scripts to the SQL Server?

  Hi Recently i have recovered the SQL database from corrupt one with help of SQL recovery tool but i…

  Elliswhite

  3 replies

  11 years, 2 months ago

  By: Elliswhite

• Redo Transaction Logs

  I have two disconnected SQL Server 2008 R2 instances with the same databases, but with different da…

  emchugh7

  1 replies

  11 years, 2 months ago

  By: Grant Fritchey