SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Pivot Query Problem

  hi everybody, i have a table with following data and i want to generate the output as follow usning…

  akshay.tankhiwale

  4 replies

  15 years, 10 months ago

  By: akshay.tankhiwale

• Census Track Maps for SQL Server 2008 R2 Reporting Services

  Anyone have something like this?

  jcraddock

  4 replies

  15 years, 10 months ago

  By: Ron McCullough

• lock on select

  First of all, Hi Everyone! ((Sorry for my bad englsh!)) Ill try to explain my problem the best way …

  abitguru

  24 replies

  15 years, 10 months ago

  By: Paul White

• Print A3 format report in SSRS

  Hi, I'm new to SSRS. I already have an report in SSRS which by default print in A4 format. I want t…

  sasiee2k

  1 replies

  15 years, 10 months ago

  By: ahsansharjeel

• Disk Defrag

  Hi, I've been operating with the preference to take SQL server offline when defragmenting the disks…

  Jon.Morisi

  9 replies

  15 years, 10 months ago

  By: Jon.Morisi

• Combining XML records in a custom logging table for auditing

  I've created Delete, Insert, and Update triggers for a few of our core tables to log the changes as…

  samalex

  1 replies

  15 years, 10 months ago

  By: jjbear11

• date in 3 seperate fields

  I have 3 fields in my invoice table YEAR, MONTH, DAY i want to have them actually display as a date…

  sharonmtowler

  13 replies

  15 years, 10 months ago

  By: Lynn Pettis

• Incorrect syntax near '0'.

  myCommand = New SqlCommand("insert into invoices ('" & RouteNumber & "','" & Route_d…

  tmurray 69699

  12 replies

  15 years, 10 months ago

  By: Alvin Ramard

• Alert if events do not occur?

  Is there a way to generate an alert if events occurred out of expected order or if only one of the …

  sheilas3

  1 replies

  15 years, 10 months ago

  By: Rome1981

• SQL 2008 query result message tab display limit

  Hi All, I need to print the message more than 8000 characters. But sql server 2008 can't support mo…

  mpsathiskumar

  4 replies

  15 years, 10 months ago

  By: winash

• Sql Server Authentication and counting the number of users accessing sql server

  I was given a sql server to administer. Some databases are accessed by sql authentication and I can…

  Barkingdog

  4 replies

  15 years, 10 months ago

  By: jeff.mason

• SQL 2008 SP2 - Web Syncronization Broken Since SP2

  Just wondering if anyone else has the same issue where I browse to https://server/folder/replisapi.…

  Pete-L

  1 replies

  15 years, 10 months ago

  By: Pete-L

• SQL Server Agent job runs but does not perform SQL in a particular job step.

  I have a 4 step job defined in SQL Server Agent, all steps are set to "Quit the job reporting failu…

  forco02

  4 replies

  15 years, 10 months ago

  By: forco02

• Excel File Creation In SSIS Package

  Hi.... Friends.. I have to export data from sql table to Excel on certain condition so every time a…

  Datta4u

  3 replies

  15 years, 10 months ago

  By: Leo Suresh

• Opimize SQL query

  I have simple sql query with 8 tables of which 3 tables have 30, 60 and 80 lakhs of records I have …

  amit-1143912

  10 replies

  15 years, 10 months ago

  By: Ali Tailor