SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Arithmetic overflow error converting expression to data type datetime.

  Hi Arithmetic overflow error converting expression to data type datetime. Create View CREATE VIEW…

  mr.burax

  3 replies

  11 years, 4 months ago

  By: Eirikur Eiriksson

• resourcedb object id appears in blocked processes trace

  Hi Folks, Appreciate any ideas on this unusual problem. I'm trying to track down details about bloc…

  NJ-DBA

  1 replies

  11 years, 4 months ago

  By: NJ-DBA

• SSIS issue<!-- 864 -->

  When we try to run an SSIS package on the server we get this error message: The program can't start…

  Summer90

  2 replies

  11 years, 4 months ago

  By: Summer90

• SQL 2008 - SSRS - Parameter Limit

  maximum number of values or filters tha tcan be given is 1000. I know we can modify MaxHttpCollecti…

  balasach82

  5 replies

  11 years, 4 months ago

  By: balasach82

• Time Out - Retrospective look at what caused it

  Hi there - We experienced a number of SQL times outs yesterday. I have the code which timed out b…

  arrjay

  2 replies

  11 years, 4 months ago

  By: arrjay

• shrinking log file

  What are the ways to shrink the log file in a replicated datbase (database is in replication )

  ramyours2003

  1 replies

  11 years, 4 months ago

  By: Gail Shaw

• Classic ASP Recordset and SQL Server 2008 - DateTime formatting problems

  I am working with a Classic ASP file upload application which uses the Recordset.AddNew functionali…

  cajun_sql

  6 replies

  11 years, 4 months ago

  By: cajun_sql

• will windows security updates affect SQL server database

  hi all, My windows server admin install a security patch on a windows 2008 R2 server. KB 2982791 KB…

  flaskvacuum

  1 replies

  11 years, 4 months ago

  By: Jack Corbett

• Convert decimal(8,0) value to a time value

  Good day. How do I convert decimal(8,0) value to a time value. TransactionDate 12310476 should read…

  mario 58303

  14 replies

  11 years, 4 months ago

  By: Eirikur Eiriksson

• Check if temp table exists

  This code is not working IF OBJECT_ID('test.dbo.#temphistory') is not null begin drop table #temphi…

  Priya004

  3 replies

  11 years, 4 months ago

  By: Priya004

• Page Compression

  Hello Experts, I had done a page compression on an archive Table on my Dev Server. And it significa…

  er.mayankshukla

  8 replies

  11 years, 4 months ago

  By: Gail Shaw

• Data Compression

  My question is If I am specifying Data Compression at the time of table creation, how it differs by…

  er.mayankshukla

  1 replies

  11 years, 4 months ago

  By: Gail Shaw

• TDE - Database encryption

  Hi there - What level of encryption does SQL 2008 R2 TDE encrypt at; 128, 258? Thanks! -----------…

  arrjay

  4 replies

  11 years, 4 months ago

  By: arrjay

• select statement recognising apostrophe as a quotation mark

  Hello I'm trying to do a query which includes CASE WHEN LEFT(LASTNAME,2) = 'O'' THEN ....... I'm …

  Tania Mofflin

  3 replies

  11 years, 4 months ago

  By: Tania Mofflin

• Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".

  hello all. I use this script for export query result to existing dbf file : insert into openrowset …

  elham_azizi_62

  3 replies

  11 years, 4 months ago

  By: prabhu.st