SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Is this right Microsoft SQL Server forum?

  Hello everybody, am a bit new here. My question is, if I am on the right place here? I feel like be…

  evalina1987g

  1 replies

  14 years ago

  By: Gail Shaw

• How to decrypt the flat file in SSIS

  Hi, My flat file source was encrypted .Now i want to decrypt then load into destination.How can…

  SriSudha

  5 replies

  14 years ago

  By: Lynn Pettis

• Performance of jobs

  I have two jobs running in SQL server, each takes about an hour and few mins to complete  when run …

  peacesells

  2 replies

  14 years ago

  By: peacesells

• Passing parameter Dynamically to Open Query inside Function

  Can I pass a parameter Dynamically to Open Query inside a Function like this? Create Function dbo.…

  vinu512

  10 replies

  14 years ago

  By: vinu512

• Sage/Accpac/PSQL support for MSSQL08

  Hello I am a tech supporting a small lan. We are looking to replace our accounting package to the a…

  Manny Cruz

  2 replies

  14 years ago

  By: SQLRNNR

• SSIS 2K8 script task to CLR function

  Hi all - I'm really green with SSIS and I've inherited a partially complete dtsx package and have b…

  Uripedes Pants

  4 replies

  14 years ago

  By: Uripedes Pants

• To TOP or not to TOP?

  I have a query that should return the fields of a table along with the field properties like type, …

  gemisigo

  39 replies

  14 years ago

  By: Paul White

• Select ... into statement generates different schemas between SQL2000 vs SQL2008R2

  Hello, I'm in the middle of doing an upgrade from MS SQL 2000 to MS SQL 2008R2 During the conversi…

  Robert.Paolone

  2 replies

  14 years ago

  By: Paul White

• SQL Server Agent Job issue

  i have a scheduled a job and it ran perfectly the last time I ran. Today i get a bunch of error eve…

  Murphy'sLaw

  2 replies

  14 years ago

  By: david.tyler

• Create view on CDC to display only the changes but not the change for latest values in the table.

  I have to create a view on CDC(change data capture) which only displays the records for the changed…

  Learner093

  1 replies

  14 years ago

  By: Lowell

• No SQL Server Management Studio installed

  Hi DBA'S I had a server where there is a sql server 2008, i cant see sql server management studio i…

  SQListic

  2 replies

  14 years ago

  By: SQListic

• Not enough space on Server

  Dear All, I was trying to import data into a new table but, I received an error message saying log …

  tt-615680

  7 replies

  14 years ago

  By: tt-615680

• How to performance tune this Merge statement for our DW ETL process?

  Hi all, I have this relatively simple (logic-wise) merge statement which we do every day to update …

  boxta

  6 replies

  14 years ago

  By: Jeff Moden

• Drop statistics syntax error

  I am trying to drop statistics on a table in SQL2008R2 but am having trouble with the syntax. I ha…

  Anonymous

  2 replies

  14 years ago

  By: Anonymous

• Condition statements

  Hello All, I have the following query: I am storing the start month in a variable called @Start…

  ramadesai108

  9 replies

  14 years ago

  By: GSquared