SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• pulling data from 3 different table depending on some conditions

  Hi, I know it sounds very simple with the subject line but for me it's not. BACK GROUND My Client …

  deepak.palkar

  2 replies

  17 years, 7 months ago

  By: deepak.palkar

• Can You Give Me Tips To Creating Test Data

  SQLServer 2005 I have tables with live data and would like to create new test tables with dummy dat…

  hlpmypc

  5 replies

  17 years, 7 months ago

  By: Steve Jones - SSC Editor

• SQL upgrade

  Im busy doing a inplace upgrade from SQL 2000 32 bit std. to SQL 2005 64 bit Enterprise. I ran Advi…

  Stephan Grove

  6 replies

  17 years, 7 months ago

  By: EdVassie

• Copy/Export encrypted SP

  Is it possible to copy/export an encrypted stored procedure from one db to another? My goal is to c…

  J M-314995

  3 replies

  17 years, 7 months ago

  By: David Webb-CDS

• proper UNION form

  Hi there, I have a simple little select statement: SELECT PrimeType1 , SystemTradeDate , Securit…

  Christopher Klein

  1 replies

  17 years, 7 months ago

  By: Christopher Klein

• INSERT Query

  Hello! Using ASP, with the RecordSet Object (objRS), I have a question When running the following q…

  Sandy-535251

  3 replies

  17 years, 7 months ago

  By: goodguy

• Trn Log Shipping Timestamp/Format

  Hello Experts I am shipping the Trn.Log to the Standby and is getting shipped properly. But for som…

  gk-411903

  1 replies

  17 years, 7 months ago

  By: Janet Keith-489067

• SQL installation, a dual core CPU count "Per Processor" licensing model?

  Hello Does a dual core CPU count as 1 or 2 CPU's in the "Per Processor" section during installation…

  Ryan D.

  2 replies

  17 years, 7 months ago

  By: Ryan D.

• Convincing customers about poor infrastructure (memory)

  Hi everybody, I have a customer which insist to use a regular PC (P4 3GB with 512MB RAM) for using …

  Radu Costescu

  3 replies

  17 years, 7 months ago

  By: Jo Pattyn

• DTS is extreamly slow to transfer data for just 1 small table. Please help!

  I'm using DTS to transfer data from an sql server 2000 located in an internal office to another sql…

  dusty-526638

  5 replies

  17 years, 7 months ago

  By: mrpolecat

• DTS :: Logical OR implementation

  Hello there, while working on a DTS package, i reached a situation where i need to implement logica…

  vinesh

  3 replies

  17 years, 7 months ago

  By: vinesh

• shrinking database

  i Shrank the database through ENTMGR, and after shrinking there was no record into main transactio…

  onlyvirgo

  3 replies

  17 years, 7 months ago

  By: Vidhya Sagar

• Problem with UDF

  I have a UDF that is supposed to loop through a comma delimited list, grab the integer value out of…

  Miranda Johnson

  9 replies

  17 years, 7 months ago

  By: Jeff Moden

• System Views for finding out what logs are applied?

  Hello I set up Standby log shipping and the i am able to see the log getting shipped and restored o…

  gk-411903

  9 replies

  17 years, 7 months ago

  By: george sibbald

• Importing data from Access

  I am just learning about SQL Server so please excuse what may be a silly question. I am importing t…

  Neville Turbit

  8 replies

  17 years, 7 months ago

  By: dusty-526638