General

• Topics

  Started by

  Posts

  Last post

• Exporting to excel file with OPENROWSET

  This is the error I get when execute the sp: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an …

  jluis_hdezg

  1 replies

  16 years, 11 months ago

  By: jluis_hdezg

• Read in file layout in DTS?

  I've been search the site for a way to do something like this in SQL2K but haven't found anything. …

  Ron-279530

  5 replies

  16 years, 11 months ago

  By: richardq.s

• Moving DTS Packages from SQL 7 to SQL 2000

  I am moving a couple of databases from SQL 7 on old machine to SQL 2000 on a new machine. I can mov…

  anuragingle

  3 replies

  16 years, 11 months ago

  By: Greg Charles

• Mixed language in event description ?!

  I have across this weird issue on one of my reporting server. Whenever the event ID 108 is logged o…

  ninad.soman

  3 replies

  16 years, 11 months ago

  By: GSquared

• Distribute data from monster SQL 2000 table into small, variable, and dynamic Access databases.

  *I apologize for the duplication, I posted this in the 'Replication' forum as well, but was not sur…

  Henny-997017

  19 replies

  16 years, 12 months ago

  By: Lynn Pettis

• Implicit Conversion - What can affect it

  Background - I mistakenly reindexed my prd db with a very low fill factor (10). The db grew from 2…

  Cricketdogger

  1 replies

  16 years, 12 months ago

  By: Cricketdogger

• SQL Jobs - accessing job name

  Hi All, I am wondering if it is possible to programmatically access the name of a SQL Job from one …

  Machine

  2 replies

  16 years, 12 months ago

  By: Machine

• How to pass table variable into SQL UDF

  Hi all, i need to pass table variable as argument into UDF and,then UDF return another table …

  avhlasith

  1 replies

  16 years, 12 months ago

  By: Lowell

• cross tab query

  I need to create a query to create my columns dynamically as employee names and their case id numbe…

  Guy Peay

  1 replies

  17 years ago

  By: AnzioBake

• Importing Validation

  Hi, Y'all Q. I created an import Job using DTS, and it works fine, the only issue is when the sprea…

  lrosales

  5 replies

  17 years ago

  By: lrosales

• Varchar Max Size

  Currently I have a column that is varchar(720) and when I run my alter table script I get a warning…

  tready

  2 replies

  17 years ago

  By: tready

• urgent plz- decrypting a value

  i have a table with testtable var1 int pk, prize_id int prize_encrypt varbinary i am storing encry…

  venkatesh.kuppili

  1 replies

  17 years ago

  By: Lowell

• Macola MacMSS.dll error

  I need help with this error An error occured in MacMSS.dll (ver. 76.400.00.6) DB Provider Error: N…

  justo.liz

  1 replies

  17 years ago

  By: Lowell

• Error Message - please help

  USE Program; GO SET NOCOUNT ON; --print header information PRINT '=================================…

  mlang

  4 replies

  17 years ago

  By: mlang

• Error 81;15Arithmetic overflow error ...

  Good evening In a production system using sqlserver 2000 a make a simple sql stament like this sele…

  pavargasq

  2 replies

  17 years ago

  By: Preet_S