SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Approach to archiving tables with foreign key constraints

  Hi, I'd like to get your thoughts on the approach to archiving data from a set of tables with forei…

  anni00

  7 replies

  11 years, 4 months ago

  By: MMartin1

• Script for Copying Logins from one server to other server with database

  Hi, I want to copy a set of windows Logins & Database Logins from one server to other sever …

  Anil Kumar Kurra

  6 replies

  11 years, 4 months ago

  By: nhashmi

• Importing XML into Multiple Tables

  I have looked at 2 ways of doing this. I really wanted to import using the XML Source and SQL Serv…

  swoozie

  5 replies

  11 years, 4 months ago

  By: Eirikur Eiriksson

• How can I pivot results of query?

  How would you create a query to get the Metric as columns? Basically, to look like this. YearMonth …

  NineIron

  5 replies

  11 years, 4 months ago

  By: Neil Burton

• Import Excel Data into SQL Table - Fails because of CR/LF

  I need to import several Excel Worksheets into SQL tables for processing, after which I will need t…

  Thomas Ashby

  7 replies

  11 years, 4 months ago

  By: symenh

• SQL

  Hi All, Can someone help me with the SQL that will always lift hearing date no matter where it is l…

  eobiki10

  2 replies

  11 years, 4 months ago

  By: eobiki10

• uri format error in ssis 2008 R2 script task

  Hi, I need to get the latest file from sharepoint. To get the file names in array, I am using the b…

  rajn.knit07

  3 replies

  11 years, 4 months ago

  By: rajn.knit07

• trying to find a more efficent way

  Hi, I have to running totals like this at work, and this works; but it is not efficent since it doe…

  itmasterw 60042

  10 replies

  11 years, 4 months ago

  By: itmasterw 60042

• I'm Stumped - Starting SQL With Domain Account

  So, having spent most of Friday and a portion of the weekend trying to sort out this issue I have c…

  Sean Pearce

  9 replies

  11 years, 4 months ago

  By: Sean Pearce

• How to free up the drive space in SQL that has data files

  Hi all , I am having a problem with running out of space of E:\ ... 75 GB free space out of 500 GB…

  WhiteLotus

  13 replies

  11 years, 4 months ago

  By: WhiteLotus

• Difference between Lazywriter and checkpoint

  I am trying to understand the difference between lazy writer and checkpoint.If Lazywriter is suppos…

  Sachin Nandanwar

  10 replies

  11 years, 4 months ago

  By: saurabh.x.sinha

• xml PARSING

  Hi I am very new to xml , i want to parse an xml . I have been trying to do this but getting the f…

  nikki123

  12 replies

  11 years, 4 months ago

  By: nikki123

• Compare Rows in sample Table - T-SQL help

  Hi All, I need help with writing T-SQL query to compare rows in same table and track changes over t…

  myjobsinus

  4 replies

  11 years, 4 months ago

  By: Luis Cazares

• capturing login user id in audit log table

  i have a table called employee.and the columns are Name,SID,C,Date and i created an audit log table…

  mcfarlandparkway

  2 replies

  11 years, 4 months ago

  By: Lowell

• Read Null and Empty string from xml in SQL Server

  Hi, This Code (in bottom) give the result NULL for the 2 fields HID1 and HID2 but I want to use the…

  mazen khoder

  1 replies

  11 years, 4 months ago

  By: mazen khoder