SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Create intelligent datatype using .NET

  In my database there's a table called document which contains a varbinary(max) field. Because we ar…

  hrc

  4 replies

  15 years, 5 months ago

  By: hrc

• Grouping

  Hello All, I'm suck and would like to know if there is a way to query one table but have the data G…

  Clkgtrs1

  6 replies

  15 years, 5 months ago

  By: UMG Developer

• SSIS Package configuration error & SQL authentication

  Hi, I have a simple package which reads from SQL Server and loads into a flatfile. The OLE DB sourc…

  BaconPopper

  11 replies

  15 years, 5 months ago

  By: nick.mcdermaid

• IF ELSE .. doesnt update else part

  Hi all, I having trouble with the following code. It has to update the table fileinfo if it fi…

  Eshika

  14 replies

  15 years, 5 months ago

  By: Eshika

• Stored Procedure - Insert and Update w/2 tables involved

  I've been a casual sql user for sometime, but this is my first stored procedure. 😀 I frequently se…

  tshelly

  3 replies

  15 years, 5 months ago

  By: tshelly

• NEED TO CONVERT AN INTERGER TO A STRING THEN USE AS A JOIN TO THE TABLE.

  I have a stored procedure where i am trying to join an order table to a customer table by cust # (d…

  sharonmtowler

  2 replies

  15 years, 5 months ago

  By: sharonmtowler

• exclude BIT column from the Group By clause

  Hello All, I have a query which is returning columns in various datatypes. this query uses the gro…

  Vincy-856784

  2 replies

  15 years, 5 months ago

  By: LutzM

• possible to return the amount of keywords found using function contains

  I am fairly new with full text search. I managed to put the contains search right. But is it possib…

  sai.mopidevi

  1 replies

  15 years, 5 months ago

  By: rakhi.bhatia

• convert Access query iif to SQL statement

  I want to convert Access query iif to SQL statement but got errors: IIf(#TUploadTo.WCFComplete=True…

  adonetok

  4 replies

  15 years, 5 months ago

  By: mferanda

• Question about nested stored procedure

  I have a wrapper stored procedure which in turn calls other 10 procedures. In outer procedure I put…

  SQL Guy 1

  2 replies

  15 years, 5 months ago

  By: Grant Fritchey

• How to do the load testing sqlserver 2008R2

  Hi All, how to perform the load testing in sql server 2008R2, when 2 r 3 users connecting to server…

  kommagoni

  6 replies

  15 years, 5 months ago

  By: jasonlorraine1999

• Query Performance tuning

  I have self join query which is taking very long time to execute as it is cost about 30000 and exec…

  Vijay_Raju

  3 replies

  15 years, 5 months ago

  By: Vijay_Raju

• CONNECT TO REMOTE PC

  How to Connect SQL Server of a Remote PC? I want to connect My Home SQL Server PC To My Office SQL …

  ßhavin

  6 replies

  15 years, 5 months ago

  By: Ali Tailor

• Sql server and sql agent wont start

  Hi, I have installed sql 2008 and evreything worked fine until i restart my computer.When i restart…

  dino.maric

  4 replies

  15 years, 5 months ago

  By: Ali Tailor

• Difficulty setting up transactional replication

  Hey all, I am attempting to test setting up transactional replication on two computers on a network…

  SQLUserC

  2 replies

  15 years, 5 months ago

  By: SQLUserC