SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• proxy account and service account

  I'm using SQLSERVER 2008. We setup a proxy account by creating a credential first. The account for …

  sqlfriend

  4 replies

  14 years, 10 months ago

  By: SQLBuddy123

• Using a View as an abstraction for a table

  I've inherited a database which is far from consistent in it's naming conventions (as well as norma…

  ShawnTherrien

  4 replies

  14 years, 10 months ago

  By: MysteryJimbo

• Cursors

  [font="Tahoma"] Hello Friends, I am using cursors for the first time and i have written a code to d…

  MuraliKrishnan1980

  2 replies

  14 years, 10 months ago

  By: MuraliKrishnan1980

• SQL Server 2008 Express Advances Install Fails

  I am trying to install SQL Server 2008 Express Advance and I keep recieveing the following error: …

  Arthur.Lorenzini

  4 replies

  14 years, 10 months ago

  By: Arthur.Lorenzini

• SQL Server 2008 Policy Management

  I'm trying to set up a policy to verify that only specific accounts are members of the sysadmin ser…

  mps

  3 replies

  14 years, 10 months ago

  By: Jon.Morisi

• Need Parameters For Dummies

  I wrote this query here and by the way I am very brand new to SSRS and creating actual reports I ha…

  davemcsheffrey

  2 replies

  14 years, 10 months ago

  By: Jeffrey Williams

• dangers of copying to excel from ssms

  sql 2008 & excel 2010 Been using the copy all records from sql grid to excel for long time but…

  skeezwiz

  2 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• Table size is increased due to ghost records related to LOB data

  Hi, A have the following table on Production environment. It is heavily updated (lots of inserts a…

  Pawel PPA

  1 replies

  14 years, 10 months ago

  By: Sergaent

• Adding one more secondary database in logshipping is giving error

  I have configured Logshipping on Mirroring Database.It is running fine. Now I want to add one more …

  forsqlserver

  1 replies

  14 years, 10 months ago

  By: Geoff A

• Begin Tran and Commit/Rollback Tran in SSIS

  Hi I am finding following error for transaction. Error: 0xC002F210 at CommitTransaction1, Execute …

  avadhut.joshi 17339

  7 replies

  14 years, 10 months ago

  By: avadhut.joshi 17339

• move to new SQL 2008 server where master db is in a new location

  I am migrating to a new SQL server. My existing sql server is currently running SQL 2008 sp1. How…

  Julie Hobert

  5 replies

  14 years, 10 months ago

  By: george sibbald

• Data format -cross tab

  I have the following data. name number addr1 addr2 city state zipcountry timezone a1 …

  sql_novice_2007

  4 replies

  14 years, 10 months ago

  By: sql_2005_fan

• How can I round the number and remove decimal palces

  Hi, How can I round the number and remove decimal palces in sql server in simple way? EX:134.678 I …

  kuppurajm

  5 replies

  14 years, 10 months ago

  By: Lamprey13

• Names of People Born in specific month

  I need a stored procedure with Output in XML format where I would give a month of employee date of …

  njdevils39

  14 replies

  14 years, 10 months ago

  By: ColdCoffee

• Problem with daylight savings times and SQL Server error logs?

  Hey all, I am writing to confirm the possibility of a bug within SQL in regards to the error logs. …

  Adam Bean

  4 replies

  14 years, 10 months ago

  By: Adam Bean