SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Unable to change the database context. What's wrong here?

  USE master Declare @db as nvarchar(258) = quotename (N'tempdb') EXEC (N'USE' + @db + N'; EXEC(''SEL…

  SQL_Hunt

  5 replies

  11 years ago

  By: SQL_Hunt

• Error MSG in Table Valued Func/Cursor

  I received the following when constructing the below table valued function with cursor. My attempt …

  forrest77

  19 replies

  11 years ago

  By: forrest77

• Replication from Oracle to SQL Server

  We are trying to replicate from Oracle 11G to SQL Server 2008R2. OS: windows server 2008R2 64bit. S…

  Mh-397891

  8 replies

  11 years ago

  By: phil.rodas

• Client Tools

  I have 2 SSIS packages and 3 SQL scripts (I could make them Stored Procedures if needed) that I nee…

  doug-583247

  1 replies

  11 years ago

  By: cunningham

• Identity column insert issue

  I have two tables having one row identifier column each of int datatype. Both these columns are par…

  sqlnaive

  4 replies

  11 years ago

  By: sqlnaive

• Howto Comparing two multi instance SQL Server 2008 R2 installations.

  Hi all, I'm in a pickle. I have 2 SQL server installs for 2008 R2 configured as multi instances. I…

  peter.birksmith

  2 replies

  11 years ago

  By: peter.birksmith

• Move sql 7.0 to sql 2008R2

  Can some kindly help me how to move sql 7.0 to sql 2008R2. We have 10 databases and there are 15 DT…

  sureshjevani 78421

  2 replies

  11 years ago

  By: SQLBill

• SQL Server Provider issue - Microsoft.ACE.OLEDB.12.0

  Hi Folks, In our environment, we have installed Microsoft.ACE.OLEDB.12.0 (64-bits) provider on Wind…

  Er.Karthikeyan

  1 replies

  11 years ago

  By: Er.Karthikeyan

• Where and or

  Ok so SQL isn't my strong point and I'm literally going to loose my mind in a minute. The applicati…

  .Netter

  2 replies

  11 years ago

  By: ScottPletcher

• SQL Server 2008 - Dump generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION

  Hi, we have an sql-server agent job which runs every night and imports data from dwh into dm. At th…

  PowerUser

  1 replies

  11 years ago

  By: Grant Fritchey

• I want to set deadlock priority of a stored proc to low so that when ever any one calls it from entity or command object it should use same priority.

  Hi, I want to set deadlock priority of a stored proc to low so that when ever any one calls it f…

  rajemessage 14195

  2 replies

  11 years ago

  By: Grant Fritchey

• split a comma separated string into columns

  Hi Our front end saves all IP addresses used by a customer as a comma separated string, we need to …

  cerian

  8 replies

  11 years ago

  By: cerian

• Trigger syntax error

  I receive a syntax error " Incorrect syntax near 'QuoteId' " when creating this trigger. I assume …

  doug-583247

  3 replies

  11 years ago

  By: Eirikur Eiriksson

• Snapshot replication to different schema name

  I need to setup snapshot replication for 1 large table. Source table: SourceDatabaseName.dbo.MyTab…

  Express12

  1 replies

  11 years ago

  By: Express12

• Snapshot replication of 1 table to a target DB w/ 100 tables

  Regarding Snapshot replication.... If I have 200 tables on my source DB and 100 tables on my target…

  Express12

  2 replies

  11 years ago

  By: Express12