General

• Topics

  Started by

  Posts

  Last post

• Storing Media Files

  Hi..I would like to know if there's any way to store media files such as mp3,avi directly inside th…

  Ida Zuraida

  1 replies

  22 years ago

  By: Frank Kalis

• DTS Errors

  I have created several DTS packages that run if I execute them immediately, but error out if schedu…

  jherren

  3 replies

  22 years ago

  By: fromnaija

• To get system information from sqlserver

  I need system information of the client machine talking  to Sql server database in a trig…

  punitnb

  6 replies

  22 years ago

  By: Frank Kalis

• Why 249 Non clustered Indexes?

  Hai all, Happy new year.. Is there any reason to have restriction on non clustered indexes(i.e 24…

  ramesh_kondaparthy

  11 replies

  22 years ago

  By: K. Brian Kelley

• stored procedure

  I am writing a stored procedure CREATE PROCEDURE Sp_RepHour AS declare @MaxTime int SELECT max(cast…

  nnmmss

  2 replies

  22 years ago

  By: Rodrigo Acosta

• issues when implementing an inventory

  Hi, I am in the process of implementing an inventory.I've googled for sample articles, but no…

  yogiberr

  2 replies

  22 years ago

  By: yogiberr

• Multi-statement table-valued UDF problem

  I have a multi-statement table-valued UDF which takes a datetime parameter. The following example i…

  Johnny Doyle

  10 replies

  22 years ago

  By: Johnny Doyle

• result to produce single row from multiple rows

  I have three tables 1. Street_house_addresses containing - property_ID - house_number - street_name…

  Lashams

  4 replies

  22 years ago

  By: Lashams

• SQL Server 2000 Developer Edition

  I just bought a copy of SQL Server 2000 (with service pack 3a) that I intended to install and run o…

  Eugene L. Frassetto

  5 replies

  22 years ago

  By: jxflagg

• Record Size Limitation

  I have to create a table that has to store a record of more than 8000 bytes, but SQL Serve warns me…

  kaliyappan_k

  3 replies

  22 years ago

  By: jxflagg

• Question about full-text search

  I am new to SQL Server, but have recently installed it and I am evaluating it for some upcoming pro…

  fillae

  2 replies

  22 years ago

  By: fillae

• Rows in a page?

  Is there a way to determine the number of rows in a page? DBCC SHOWCONTIG tells me: - Avg. Bytes Fr…

  Crispin Proctor

  2 replies

  22 years ago

  By: Chris Hedgate

• dtsrun /A

  I am trying to pass GLOBAL VARIABLE to dtsrun. It complains about incorect switch. Does my SQL SERV…

  daniel.danes

  1 replies

  22 years ago

  By: Amit Jethva

• Storing and retreiving Image Data

  How to store images in a table in the image data type and read back in a front end such as VB or AS…

  kaliyappan_k

  1 replies

  22 years ago

  By: Frank Kalis

• DERIVED FIELD autocalculation

  I am creating a table for a student database. I had the Dateofbirth field, I want to have anotehr D…

  cincuan

  1 replies

  22 years ago

  By: wz700