SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Auto login screen in management studio

  How do I keep the Auto login screen in management studio for SQL 2008 R2 from appearing? I remembe…

  Robert Stewart

  4 replies

  14 years, 2 months ago

  By: Robert Stewart

• Default Value or Binding: right clicking table's column and properties vs table designer -different values show?

  I am looking at one of our tables that has a column with a default value set. When I right click on…

  Maxer

  1 replies

  14 years, 2 months ago

  By: Orlando Colamatteo

• Creating a job to run a .exe program without using cmdexec in the job setup?

  Need to know how to Create a job to run a .exe program without using cmdexec in the job setup?

  veronica.smiley01

  14 replies

  14 years, 2 months ago

  By: veronica.smiley01

• How to enable execution tree in a ssis package?

  I want to view execution tree of my ssis package. How do I enable it?

  kirti.malukani

  1 replies

  14 years, 2 months ago

  By: Antares686

• importing dump backup database from oracle to sql server

  Hi all Can anyone tell me how to import dump backup database from oracle to sql server.is it poss…

  praspras42

  1 replies

  14 years, 2 months ago

  By: Greg Charles

• Does the plan get cached when you have WITH RECOMPILE on a proc?

  Thanks.

  Lexa

  1 replies

  14 years, 2 months ago

  By: BrainDonor

• Remote connection with vb script to SQL Server 2008 R2

  Hello. I'm trying to stablish a connection to a SQL Server 2008 R2 from a vb script based applicati…

  Jhonny Banegas

  2 replies

  14 years, 2 months ago

  By: Jhonny Banegas

• SQL Server changed from one instance to another

  Hello Folks; I spend several hours browsing and I can't find the answer for my issue, I'll explain …

  jokesbox_mail

  3 replies

  14 years, 2 months ago

  By: Orlando Colamatteo

• OpenQuery AS400 Error: SQL query exceeds specified time limit or storage limit

  The following Statement returns the error listed below: select * from openquery(lsctlr40dat,'selec…

  Welsh Corgi

  1 replies

  14 years, 2 months ago

  By: Welsh Corgi

• Row size of the Table

  Is there a way I can find out the row size fo a table ?

  sqlnaive

  3 replies

  14 years, 2 months ago

  By: Ron McCullough

• How to reduce the execution time of a query?

  Hi Friends.. I am having kinda same problem... I have more than 7 million records in a table.. i wa…

  Charmer

  37 replies

  14 years, 2 months ago

  By: Charmer

• Percentage based on totals in a Matrix

  Hi, I'm fairly new to SSRS and I'm having trouble trying to add percentages into a matrix. Some bac…

  PMI_Andy

  2 replies

  14 years, 2 months ago

  By: davoscollective

• sysmail_unsentitems shows emails that I have received as a status of retrying

  Any idea what I should look at here? SQL 2008 R2 RTM Lots of emails make it to the sysmail_sentitem…

  mtassin

  1 replies

  14 years, 2 months ago

  By: kat 70972

• Valid XML causing Service Broker queue to Error

  Hi - I have a problem that I hope somebody can throw some light on. We use SB a lot to pass data ar…

  Bob JH Cullen

  3 replies

  14 years, 2 months ago

  By: Lowell

• User DB permissions

  hello, i would like to know if there's any way, i can check what specific securables / permissions …

  klunky

  3 replies

  14 years, 2 months ago

  By: Ant-Green