SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Can someone explain what "Chack your Indexes on the tables" means?

  I did a job for a client a while ago and it was the first time i used SQL Server in a production en…

  Chris Gilbert

  5 replies

  19 years, 11 months ago

  By: Chris Gilbert

• ADP Frontend

  I've created a SQL dB and set up a Access ADP as the front end. I've now got to the point of testin…

  Michael Graves

  3 replies

  19 years, 12 months ago

  By: Ninja's_RGR'us

• How to display 0 in a count query if no records?

  I am working on a Helpdesk system for my organisation that is based on sql server 2000. I have a re…

  Andrew Murphy-239027

  16 replies

  19 years, 12 months ago

  By: Gabor Nyul

• Maintenance Plan Backup File Generation Failure

  Hello, I have created a maintenance plan in SQL 2000 for a database that is 35 gigs large. I get a …

  Joseph Polimeni

  3 replies

  19 years, 12 months ago

  By: Derrick Leggett

• Stored PRocedure: @@ERROR problem

  Hi, I'm trying to detect when an error occurs within a sp and returning the error number if not 0…

  dec_obrien

  18 replies

  19 years, 12 months ago

  By: ron k

• SQL Server 2000 Install Fails on XP Home SP2 - I have the log file and I can''t tell what needs to be fixed

  This started when I tried to install ACT 2005. That install failed, apparently at the end of the i…

  Barney Corwin

  2 replies

  19 years, 12 months ago

  By: Barney Corwin

• looping with DTS

  I have a set of data transformations that I would like to perform twice (2 passes). I would like to…

  Dan Wing

  1 replies

  19 years, 12 months ago

  By: Paul Smith-221741

• User auditing

  Hi all. This is my first post in fact i new in this forum. I got this question: Have you ever know…

  Isidro Contreras

  1 replies

  19 years, 12 months ago

  By: Derrick Leggett

• SQL Newbie - date ?

  I've got a table for contracts and when input a field dateinput as a default as getdate. What i'm h…

  Michael Graves

  10 replies

  19 years, 12 months ago

  By: Ninja's_RGR'us

• Another Date question

  I am trying to query some things in our database off of a certain date column which is in the forma…

  chuck lane

  6 replies

  19 years, 12 months ago

  By: chuck lane

• Table design with NULL in column

  Hello all, I have this design: ID    int IDENTITY   PRIMARY KEY Nr&nb…

  H-122523

  4 replies

  20 years ago

  By: H-122523

• calling an UDF

  I am confused of how to call a UDF. I have 2 UDFs, fnStringFunction and fnTableFunction, which ret…

  James Chan

  4 replies

  20 years ago

  By: James Chan

• Date in String format to be changed to right format

  I have date coming to one page as a string in the following format "May 4 2005 12:00AM" I need to q…

  alpoor reddy

  2 replies

  20 years ago

  By: ron k

• Network Settings (SQL Server Standard)

  Hello, I have a client that has been running Access 2.0 in a small business and they have a program…

  CircuitJerk

  18 replies

  20 years ago

  By: pg53

• Help with subquery

  Hello, I need help buiding a query: I have Multiple single items with different statuses (one item …

  Jennifer-238180

  15 replies

  20 years ago

  By: Ninja's_RGR'us