SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• how to get the text of isnull function in sql server

  In Sql server to see the function text, we can use sp_helptext. can you please help me to view the …

  Durai Samuel

  2 replies

  12 years, 11 months ago

  By: Eugene Elutin

• Cluster validation - Active/passive

  I setup two nodes (node1 and node2 ) as active/passive clustered server. When I run the falilover c…

  lsalih

  1 replies

  12 years, 11 months ago

  By: Perry Whittle

• How to read each row and update table

  Arrears Credit Line Dates AvailableAmount Principal Interests Principal Interests 001…

  edw_munya

  1 replies

  12 years, 11 months ago

  By: Sean Lange

• Estimating space needed for database

  Hello - is there a way to determine the disk space needed based on this request... "please determin…

  NJDave

  3 replies

  12 years, 11 months ago

  By: NJDave

• Query executed by user

  On my DB Instance some user truncated all my data table. So is there a way to find the user who exe…

  jeetsingh.cs

  3 replies

  12 years, 11 months ago

  By: Ed Wagner

• SQL Server 2008 Business Studio

  Hello Folks, I am looking out to learn about the business studio features in details in 2008 versio…

  sqlnaive

  1 replies

  12 years, 11 months ago

  By: sqlnaive

• Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

  Dear All, From morning onward in my sql server 2008 i am getting following error. Timeout expired. …

  samihcl

  3 replies

  12 years, 11 months ago

  By: SQL Show

• Decimal(18,0) or int?

  Hi I have a column of data type decimal(18,0) can i change it to Int for the above case whethe…

  mpradeep23

  16 replies

  12 years, 11 months ago

  By: Gail Shaw

• alert configuration

  i need to setup alert when the sql server is shutdown and server is up , how to achieve this

  ramyours2003

  3 replies

  12 years, 11 months ago

  By: HanShi

• Sql Programme for allocation of amount in accounting

  Hi, I want to build the logic for "allocation of overhead amount in accounting" in sql serv…

  avdhut.k

  2 replies

  12 years, 11 months ago

  By: Kingston Dhasian

• backup log

  is it possible to take log backup in a restored database ?

  ramyours2003

  1 replies

  12 years, 11 months ago

  By: Oliiii

• Using case statement in where clause to fetch rows whose column values are null

  Hi, I need to fetch rows from a table in SP depending on input parameter value. @var is an input p…

  Lucy08

  3 replies

  12 years, 11 months ago

  By: Steven Willis

• Execution SSIS-package from SQL Server-Agent fails

  Hi, there is a SSIS-package, that runs properly in Visual Studio. It has a for-each-container wich …

  m.rikus

  2 replies

  12 years, 11 months ago

  By: m.rikus

• Databas Shrink

  Hello there, I have a database where we have archived and purged 95% of the data, leaving a 230GB f…

  Paul Treston

  6 replies

  12 years, 11 months ago

  By: Sean Pearce

• Using fetch and cursor in a while loop

  Hi I have a master table that has truck,lisens and startdate. Now I need to run this, one record at…

  @DJ

  3 replies

  12 years, 11 months ago

  By: Lynn Pettis