SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• exception handling when we have network problems

  Hi every one, I have a table which will transfer the rows into oracle linked server table.till now…

  srilu_bannu

  4 replies

  15 years ago

  By: srilu_bannu

• Length of a column

  Hello All, This is my problem. Column Name: CdLstName Column Size: varchar(30) The final output fro…

  chaudharyabhijit

  3 replies

  15 years ago

  By: mtillman-921105

• Stored Procedure and Excel

  I need to know how to make a stored procedure that can read excel file and then load the data of th…

  wallydelgado

  10 replies

  15 years ago

  By: Rich Mechaber

• Using xp_cmdshell

  Hi All I am trying to use xp_cmdshell to run a batch file but I am not having much luck. How do I …

  craigalaniz

  1 replies

  15 years ago

  By: Lowell

• Upgraded everything to ssis 2008

  Hi , i have ssis 2005 and 2008 and there are some files in ssis 2005 that are not upgraded,but i un…

  srilu_bannu

  10 replies

  15 years ago

  By: Gail Shaw

• Creating a new Database for a large Enterprise

  Hello All, I need some help with creation of DB for a Bank ERP software (Its having near about 300 …

  djdhere

  1 replies

  15 years ago

  By: Sean Lange

• Script

  Sorry guys please help this runs locally but not via script/Batch file: %LOGONSERVER%\NETLOGON\UTLi…

  davidshephard

  9 replies

  15 years ago

  By: davidshephard

• Finding SSIS Package References in SP's

  I have stored procedures that call SSIS packages. Does anyone know of a query I can use to find wh…

  dave.molyneaux

  2 replies

  15 years ago

  By: NickDBA

• Update Trigger Using Inserted Table

  I'm writing an update trigger and using the Inserted table to update another table. Code is below…

  mpd777

  1 replies

  15 years ago

  By: Bhuvnesh

• Calculating values from a single table

  Hi Everybody. I writing applications in C# with SQL server 2005 database storing the data for my pr…

  jasonshaw

  5 replies

  15 years, 1 month ago

  By: jasonshaw

• Transaction log size with moving large amounts of data

  create archivedb..mysp_archive @dtto datetime as SET @iRowsAffected =1 SET @iRows = 10000 WHILE @iR…

  terry999

  7 replies

  15 years, 1 month ago

  By: Gail Shaw

• sql server 2000 - TEXT datatype input parameter to a SP

  Hello All, I have a proc test_put_inbound, that accepts @payload as a TEXT. I have another table TE…

  anmolblues

  2 replies

  15 years, 1 month ago

  By: Gail Shaw

• Conversion failed when converting datetime from character string.

  Hi , I have two string columns that i have just imported from a flat file: Columns: LineDate varcha…

  srilu_bannu

  7 replies

  15 years, 1 month ago

  By: pankushmehta

• ODBC error

  Hi all, We are facing this error intermittently when connecting from the application server to SQL…

  newbieuser

  5 replies

  15 years, 1 month ago

  By: Hunk Wang

• How to use the data from a stored procedure in a stored procedure

  Hi everyone, I have a small question regarding stored procedure result set. let' say i have procedu…

  srilu_bannu

  7 replies

  15 years, 1 month ago

  By: fahey.jonathan