SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Logshipping in SQL 2005

  Hi All, Database was configured as logshipped . I've removed the logshipping from primay database a…

  asifejaz

  1 replies

  13 years, 6 months ago

  By: Ant-Green

• Sql Error Message: Allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

  Hi all, i'm not sure if this is the right place to put this post, so if anyone has an alternative p…

  extremenovice

  12 replies

  13 years, 7 months ago

  By: Daryl Quadros

• Count Function

  I was able to get the query results I need, but I am looking to now present the results as the tota…

  jennigirl

  10 replies

  13 years, 7 months ago

  By: Jeff Moden

• sp_send_dbmail

  My client uses SQL Server 2005, though I have SSMA 2008 available to me. I want to send an email w…

  Jim

  3 replies

  13 years, 7 months ago

  By: Jeff Moden

• Combining Simple Count Queries

  I am able to write the query I need from each table, but I am not sure how to go about combining th…

  jennigirl

  7 replies

  13 years, 7 months ago

  By: Jeff Moden

• Dynamic insert into a table from Stored Procedure

  I need a way to format the expression like ((A or B) and C) or D and insert into the table(S_No, Ex…

  mail2bharu

  3 replies

  13 years, 7 months ago

  By: spaghettidba

• Table design bias to rows or columns

  Firstly this is my understanding when designing a table: the bias should always be vertical (rows) …

  Digs

  6 replies

  13 years, 7 months ago

  By: jcb

• Trimming data from cells.

  Hi Guys, I've got a bit of an issue, I need to trim some data from the end of a few cells(3000+, ok…

  subzzz_

  11 replies

  13 years, 7 months ago

  By: Eric M Russell

• email excel file using sp_send_dbmail

  I have a sql job that uses a query to fetch results and then email the results in a text file. Now …

  Pink123

  2 replies

  13 years, 7 months ago

  By: Brandie Tarvin

• Data Import from one table to another

  I am trying to import data from one table to another in SQL 2005 database. I imported the data into…

  saghbash

  4 replies

  13 years, 7 months ago

  By: Jason Wolfkill

• database design for fee registration system

  I am designing a database for fee registration system. but I can not figure out the database design…

  nischalinn

  4 replies

  13 years, 7 months ago

  By: Devendrakumar

• query database for different packages for same employee

  I have this query working with union all for 2 periods but I cannot get it to work with multiple co…

  dennibears

  4 replies

  13 years, 7 months ago

  By: Brandie Tarvin

• How to output results from a "Execute T-SQL Statement Task" in a Maintenance Plan in SQL 2008

  This may already have been answered somewhere in this Forum but haven't been able to locate anythin…

  Ron Perron

  1 replies

  13 years, 7 months ago

  By: Brandie Tarvin

• I am hoping there is a simple way to accomplish this selection

  I need to select certain data, but I am not sure of the best way to perform the select. Given the …

  meichner

  4 replies

  13 years, 7 months ago

  By: meichner

• db link access

  Hi friends, We have a linked server from sql server database to Oracle. I want to give read only a…

  newbieuser

  4 replies

  13 years, 8 months ago

  By: newbieuser