SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Need To Move SQL Data To Another Drive

  Our SQL Backups, SQL Data, SQL Integrity, and SQL Optimization folders are on an E: drive. This E: …

  EdA ROC

  2 replies

  14 years, 8 months ago

  By: EdA ROC

• Report Access based on user role in SSRS 208 R2.

  Hi, I have deployed a report say Report1 on my report server running on Sql Server 2008 R2. I have …

  Hakuna Matata

  2 replies

  14 years, 8 months ago

  By: Hakuna Matata

• Createding table simple question

  When creating a table how do make the FieldID auto increment Create table( PostID int Primary auto …

  kirkdm01

  4 replies

  14 years, 8 months ago

  By: nhimabindhu

• Pad table rows with zeros for the last 5 years

  I have a query that current returns the year that a company donated money, as well as the amount of…

  BurrowOwl

  13 replies

  14 years, 8 months ago

  By: BurrowOwl

• Concatanated varchar as a function.

  I have this part of a select statement. SELECT ProductItems.ProductItemID, ProductItems.ProductItem…

  kcbeard

  2 replies

  14 years, 8 months ago

  By: kcbeard

• DMVs go how far back?

  I've been trying to find all the queries that affect a particular table that have been run recently…

  Sioban Krzywicki

  5 replies

  14 years, 8 months ago

  By: Sioban Krzywicki

• How do I know if the SDK is installed?

  What is the best way to check if the SQL SDK is installed on a server? Is the easiest way to check …

  SQLSandwiches

  1 replies

  14 years, 8 months ago

  By: Jared

• cte delete operation

  I have a cte that loops through the records creates a list and i pass a parameter of @ParamterID in…

  kirkdm01

  3 replies

  14 years, 8 months ago

  By: fahey.jonathan

• Restore Database Failed

  I recently created our company's disaster recovery plans which included a daily backup schedule. I …

  jarid.lawson

  13 replies

  14 years, 8 months ago

  By: Steve Jones - SSC Editor

• getting rid of "dbo." prefix in Access

  Is there anyway to get rid of the "dbo." prefix that is attached to SQL table names in Access?

  guerillaunit

  2 replies

  14 years, 8 months ago

  By: Matt Miller (4)

• If value is null, then $0.00

  Hi there, I have a couple of money columns that sometimes have null values. I would like these nul…

  guerillaunit

  2 replies

  14 years, 8 months ago

  By: Steve Jones - SSC Editor

• Online registration for certification exams

  Hi, Can I register and book online for any microsoft exams (70-433)? If there, could you please pro…

  Ryan007

  1 replies

  14 years, 8 months ago

  By: AluburaJ

• How to handle sql server stored procedure output parameter in .bat file

  Hi, I have to run two procedures using .bat file. To run second procedure i need output patameter o…

  VENUGOPAL.RR

  7 replies

  14 years, 8 months ago

  By: spaghettidba

• T-Log in simple recovery

  I have been reading Gail's excellent article which can be found here: http://www.sqlservercentral.c…

  Kwisatz78

  1 replies

  14 years, 8 months ago

  By: MyDoggieJessie

• blocking processes on a SQL Server instance

  Hello, Actually I capture blocking processes via Alerts on my SQL SERVER INSTANCE (WINDOWS SERVER 2…

  ERIC CRUDELI

  4 replies

  14 years, 8 months ago

  By: savethytrees