SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SSRS problem with aggregate functions and having to group by Date column

  First post and ultimage noob. I have a report from a medical database. One of the columns is a th…

  wilmer 15225

  13 replies

  14 years, 5 months ago

  By: wilmer 15225

• Directory Permissions for SQL Server Service Account

  I'm trying to follow the following directions as a workaround for a problem I've been experiencing,…

  Mike Scalise

  2 replies

  14 years, 5 months ago

  By: Mike Scalise

• Once Sql server Jobs Fail it Starts Automatically or Manualy?

  I have a problem with one of my sql server jobs Was failed. It's getting data from win services. wh…

  rama_rk1048

  1 replies

  14 years, 5 months ago

  By: cindyaz

• Using CMS to change some, not all, DB owners

  Is there an easy way to use CMS to change DB owner on a multiple databases/servers at once? What I…

  uk00121 90875

  5 replies

  14 years, 5 months ago

  By: Kenneth.Fisher

• Rule of thumb for determining PLE

  Hi all, I'm new to the SQL server forums - I am an "accidental" DBA that would like to understand m…

  bathawes 16438

  2 replies

  14 years, 5 months ago

  By: Gail Shaw

• SQL Agent jobs not running as scheduled

  I am running SQL Server 2008 R2 SP1. This is a new install. I set up maintenance plans to backup …

  Sheila.Roscoe

  18 replies

  14 years, 5 months ago

  By: Sheila.Roscoe

• If or case statement to determine a join

  Hi All, I have been asked to alter one of our reports so that the end users can select whether to i…

  clarmatt73

  9 replies

  14 years, 5 months ago

  By: clarmatt73

• How to shrink the tempdb (without service re-start or re-boot) ?

  My SQL Server configuration : 2008 Standard Edition (64-bit), version 10.0.2531.0 My tempdb data fi…

  onlo

  7 replies

  14 years, 5 months ago

  By: spaghettidba

• Cannot use Large Page Extensions: lock memory privilege was not granted.

  I'm getting this message on some of my newly built SQL 2008 R2 servers and I'm just wondering, is i…

  PhilipC

  4 replies

  14 years, 5 months ago

  By: MysteryJimbo

• DBCC SHRINKFILE

  Hi, The command does not seem to perform anything on one of our databases which is set to SIMPLE re…

  Lexa

  2 replies

  14 years, 5 months ago

  By: Lexa

• User Defined Types not working in ODBC System DSN datasources

  This one has me stumped and google isn't helping... When I use an ODBC system dsn and try to use MS…

  Trey Staker

  4 replies

  14 years, 5 months ago

  By: Trey Staker

• SMSS 2008

  Question In the table design there is an option for the description of each field. Does some one kn…

  eBoR

  1 replies

  14 years, 5 months ago

  By: Steve Cullen

• restricting AdminDomainUsers

  hi everyone!!! i enter in a company where all databases and servers have Admin Domain users like al…

  mvillar

  7 replies

  14 years, 5 months ago

  By: Jared

• SQL Query to sum data up to

  Hi All, I need to get the records with sum up to 1800. Having a table, in it on duration column the…

  jaype-365633

  1 replies

  14 years, 5 months ago

  By: LutzM

• How Get Reports To See Shared Data Sources

  I am running 2008 R2 I have an entire set of reports that I have to load into RS. These were develo…

  Rufassa

  2 replies

  14 years, 5 months ago

  By: Rufassa