SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• CommVault Backup errors on SQL 2000

  i am getting the belwo event on windows event: Event in Windows: Error: 823, Severity: 24, State: 2…

  zahoorr

  1 replies

  13 years, 5 months ago

  By: Ignacio A. Salom Rangel

• Trying a DB RESTORE

  Trying to restore a db to my local machine from development server. So, I created the db locally an…

  eddykelly1

  2 replies

  13 years, 5 months ago

  By: eddykelly1

• Difference between decimal and smallmoney

  Hi smallmoney type takes up to 4 bytes. Monetary data values from -214,748.3648 through +214,748.36…

  terry999

  10 replies

  13 years, 5 months ago

  By: Paul White

• read multiple fields with common delimited data into either a temp table or table variable without using cursors

  if I have a table with fields which contain common delimited data in them, is there a way I can rea…

  mick burden

  12 replies

  13 years, 5 months ago

  By: Luis Cazares

• Fetching data from an SQL Server in to an Access database

  Hi Everybody, I am trying to fetch some data from an SQL Server Database. I have a query, but it ke…

  rpouwels

  2 replies

  13 years, 5 months ago

  By: rpouwels

• Question about Shrinking

  Hello all, I have read loads of articles about the danger of shrinking and I am under the impressio…

  YarHad

  8 replies

  13 years, 5 months ago

  By: YarHad

• Creating dynamic SP(date changes)

  Hi Guys, I have an MIS system where I have to run 15 queries and update 15 sheets which takes a lot…

  prasan.dash83

  5 replies

  13 years, 5 months ago

  By: OTF

• Bulk insert of large files (more then 450MB)

  Hi everyone I have to populate a table with a pretty large text file and I'm happily using the very…

  adminorama

  12 replies

  13 years, 5 months ago

  By: Jeff Moden

• Creating Trigger To Update Total On 'Parent' Table

  Hi, I have two Table, Order and OrderDetail Create Table [Order] ( OrderID BigInt Identity(1,1)…

  F8R

  19 replies

  13 years, 5 months ago

  By: spaghettidba

• sqlservr.exe Memory usage

  Why is it that sqlservr.exe process is using almost 5GB when viewed in task manager but sql server …

  jdbrown239

  3 replies

  13 years, 5 months ago

  By: jdbrown239

• Unable to select from table without adding schema name

  I have server Admin password, however even when I choose the AdventureWorks Database from the dropd…

  kingdonshel

  10 replies

  13 years, 5 months ago

  By: Orlando Colamatteo

• unique patients from duplicate patient row entries

  I have one table "patients"...one row per patient. Patient.ID, Patient.Name, Patient.address, P…

  boehnc

  7 replies

  13 years, 5 months ago

  By: Nils Gustav Stråbø

• Multi database to SQL Server at record level

  Hi All I have created a touchscreen data collection system that stores its information on local Acc…

  Douglasjbell

  25 replies

  13 years, 5 months ago

  By: Yvan Bouchard

• SQLCMD bat not working

  Very new to sqlcmd. I can run my command in a cmd, however if I create a bat file with the exact sa…

  lance_thoumire

  2 replies

  13 years, 5 months ago

  By: lance_thoumire

• regarding ssrs preparation

  Hello all, i am a newbie, i want to know the best way to prepare reporting services. i …

  vsql

  2 replies

  13 years, 5 months ago

  By: vsql