General

• Topics

  Started by

  Posts

  Last post

• List Active Users

  Is there a way using T-SQL to get a list of active logins? What I'm looking for is something simil…

  fhanlon

  4 replies

  22 years ago

  By: Azor

• trapping large loops

  Hi, I did something silly and let my app enter in 33,000 records into the database.I deleted them o…

  yogiberr

  2 replies

  22 years ago

  By: yogiberr

• Absolute Beginner Troubles

  I appear to have everything working properly except for one problem. I have a tblproperty and tblr…

  bjensen

  4 replies

  22 years ago

  By: bjensen

• Any way to restore an Oracle backup into SQL2K?

  Hi There, Doing a data migration from an Oracle8 personal db system into SQL2K. All I have from th…

  ctklein

  6 replies

  22 years ago

  By: mngong

• Storing Binary Data

  How can one store mp3s and other binary data in SQL Server? -Isaiah

  iadams

  4 replies

  22 years ago

  By: Frank Kalis

• Tool to create 200 tables at a stretch

  Dear friends, I want to create 200 tables at a stretch. which tool is the best in such a scenario.…

  pjanil1

  1 replies

  22 years ago

  By: Dinesh Asanka

• Full-text indexing

  Hi, I would like to use SQL Server 2000 Full-text indexing on various file extension types such as …

  Sang Nahm

  1 replies

  22 years ago

  By: jwiner

• SQL-Error

  when i run my old procedures into a new machine i am getting errors [Microsoft][ODBC SQL Server Dri…

  sqlquery-101401

  1 replies

  22 years ago

  By: Andy Warren

• Creating Indexes while Replicating.

  I need to create an Index on relicating tables, the relication doesnt replication Schema only the d…

  Chris111

  1 replies

  22 years ago

  By: Andy Warren

• Retrieving updated rowset

  Hi! I'd like to ask if there is an SQL update statement or special function that will enable me to …

  cathsasu

  1 replies

  22 years ago

  By: NPeeters

• SQL Index Tables Out Of Sych - How?

  What would cause an index table to get out of synch? I've been working w/ SQL for the last two mon…

  Starhura

  7 replies

  22 years ago

  By: Starhura

• Returning XML to MSMQ via Trigger

  I have asked to trigger a message using MSMQ send an XML document to the queue. Another applicati…

  KCGolf63

  4 replies

  22 years ago

  By: cneuhold

• Oracles LPAD / RPAD equivalent

  CONVERT(VARCHAR, DAY(GETDATE())) does return a varchar of todays date (eg 8) Any way ican pad it to…

  Oscar Zamora

  6 replies

  22 years ago

  By: cneuhold

• Newbie Question: Help with select statement

  I was just tossed into SQL with no experience and am needing some assistance with what may be easy …

  dammek

  5 replies

  22 years ago

  By: jxflagg

• image datatype vs URL - pros & cons

  My boss wants to start storing images in the db. All our apps store images on disk with a varchar …

  sunshine

  3 replies

  22 years ago

  By: Frank Kalis