SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• PLEASE HELP CREATING A DTS PACKAGE

  hi , Pls help me to create DTS package .. I have report in excel sheet .. i want to copy the data …

  John Paul-702936

  3 replies

  15 years, 4 months ago

  By: Steve Jones - SSC Editor

• Need help asap if possible, Subject 'sp_send_cdosysmail'

  I have been searching high and low on the internet to see if it's possible to send Query results in…

  netguykb

  2 replies

  15 years, 4 months ago

  By: DougGifford

• stored procedure problem

  I have a biggggg problem!!! i have a webpage have gridview, the button in gridview allocates locati…

  schauhan13

  2 replies

  15 years, 4 months ago

  By: John Rowan

• stored proc performanace

  This may be a simple question. I have procs that selects from a table that has about 2,000,000 reco…

  jim.rasmussen

  2 replies

  15 years, 4 months ago

  By: jim.rasmussen

• Migrating data from SQL 2000 EXPRESS to SQL 2005

  Hello all! I have been a subscriber to SQL Server Central for about 2 years now, and I get a lot of…

  olie480

  6 replies

  15 years, 4 months ago

  By: Gift Peddie

• Sending an email based on query results

  I need help with the following code. I want to send an email based on the query results from the fo…

  netguykb

  1 replies

  15 years, 4 months ago

  By: LutzM

• Changing Builtin/users to builtin/administrators

  I'm a newbie who has setup SQL server 2008 Express on a Vista machine. I installed the express edit…

  Like2SQL

  6 replies

  15 years, 4 months ago

  By: SQLRNNR

• What Is Purpose Of SET FMTONLY ON, SELECT "for nothing", SET FMTONLY OFF

  I'm looking at output from Profiler, activiity from our 3rd party ERP application and see a lot: SE…

  EdA ROC

  8 replies

  15 years, 4 months ago

  By: EdA ROC

• Database Design - Indexes To Create

  For anyone who wishes to help a newbie learn about using indexes... This is a question to help me b…

  EdA ROC

  16 replies

  15 years, 4 months ago

  By: EdA ROC

• SQL 2000 SP4 Partition

  Hi Guys, I am MSSQL newbie and have a DL380G5 with 2 CPUs, 4 x 146 10K SAS HDD, 18GB RAM and Enterp…

  ahsiangsiang

  5 replies

  15 years, 4 months ago

  By: ahsiangsiang

• Locking a stored procedure for updating/reading

  Hey all. I have a stored procedure which will get called very frequently. This stored procedure has…

  paul.davidson.uk

  14 replies

  15 years, 4 months ago

  By: Terri-92562

• Complicated Stored Procedure Help

  I need help creating a Stored procedure to display records from one table regardless if a secondary…

  netguykb

  7 replies

  15 years, 4 months ago

  By: netguykb

• Problem in client computer connection to SQL server

  hello guys, please solve my problem. i have installed sql server 2000 on a computer on my firms dom…

  sibtain125

  2 replies

  15 years, 4 months ago

  By: briogene

• How to view transaction log for SQL Server 2005

  I need to view last 7 days transaction on a database in MS SQL Server 2005. Can anyone pls help me …

  charan-703265

  16 replies

  15 years, 4 months ago

  By: Steve Jones - SSC Editor

• Is There A Way To View Tables Updated By An Application?

  I develop in house reports, using Access, to complement our ERP Application. Often I need to figure…

  EdA ROC

  6 replies

  15 years, 4 months ago

  By: EdA ROC