SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• sql query issue

  I have an SQL query built in SQL server. I want to select all products below margin 35%, however It…

  jman76

  1 replies

  14 years, 10 months ago

  By: Lowell

• Rounding rounding decimal values by 0.25

  Hi , I'm trying to round up my decimal values by 0.25 , for Example if the value is 2.20 then it sh…

  affu1100

  4 replies

  14 years, 10 months ago

  By: spaghettidba

• How to avoid entering credentials every time while running the SSRS report

  I want to deploy my SSRS report on web. I am facing a problem that, whenever I run the report by ty…

  anand.mind

  2 replies

  14 years, 10 months ago

  By: Warwick Rudd

• SQL Server 2008 Replication

  Can someone comment cons of sql server replication? Obvious things to me are additional server hard…

  kwoznica

  10 replies

  14 years, 10 months ago

  By: salar

• changing the font size of a table for html email

  Hi, I'm using the BOL format for emailing this table. It looks ok, but everything is huge. I've s…

  jshurak

  2 replies

  14 years, 10 months ago

  By: jshurak

• how can i create Unique Constraint on one column that allow multiple null values,

  Hi Please tell me how can i create Unique Constraint on one column that allow multiple null values,…

  vineetbhargav

  10 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• EMERgency PLease help

  Is there any way to check if a connection between 2 SQL Servers exists. For instance I don't want…

  Larry Page(Ehsan.Akbar)

  5 replies

  14 years, 10 months ago

  By: PaulB-TheOneAndOnly

• SQL server job logs are deleted after 4 days

  Hello, On our instance, all job history is deleted after 4 days. We've test to disable our purge jo…

  Rhox

  1 replies

  14 years, 10 months ago

  By: Rhox

• Reference a view in a foreign key

  I know that you cannot reference a view in a foreign key. I wonder if there is an alternative for t…

  dankwart menor

  13 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• Convert Datatype of Existing Data from Char to Date/time with SQL

  Hi, I am relatively new to SQL Server and am trying to update the datatype of about 3000 records fr…

  hkflight

  5 replies

  14 years, 10 months ago

  By: WayneS

• SQL Server R2 does not upgrade 2005 database

  hi there, I am in weird situation, i am upgrading (in place) 2005 to 2008 r2. step 12 where it ask …

  Virendra Chauhan

  16 replies

  14 years, 10 months ago

  By: Virendra Chauhan

• How to Make this Sp a hard delete Proc?

  Please help me. CREATE PROCEDURE [Test].[usp_EmployeeEmail_delete] @Email_ID Bigint, @Phone_ID Bi…

  goushik

  6 replies

  14 years, 10 months ago

  By: SQLRNNR

• Encrypting SQL server authentications credentials

  Hi All, In one of my requirement i need to configure my package with sql server authentications to …

  krish.sett

  4 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• save pictures in database or to file?

  hi' In a database project which use of pictures, Is it better to save pictures in database or to fi…

  armm1388

  2 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• Counting down in a single table

  I have a single table with the following columns EventId TicketsAvailable TicketCost 1010010.00…

  pnr8uk

  8 replies

  14 years, 10 months ago

  By: WayneS