SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Skip on error SQL statements

  I have a script with nearly 1000 update statements. Soem of them are not properly executed since th…

  Minnesota - Viking

  2 replies

  15 years, 5 months ago

  By: endo64

• SQl Query

  Hi In my table the below multiple values with comma separated Asset Protection Lead,Corporate 1 Ass…

  aspdotnet.ghvisali

  3 replies

  15 years, 5 months ago

  By: aspdotnet.ghvisali

• What are the implications of using the simple recovery model?

  Hi all, I work for a software company whose software uses SQL. We use full back-ups to back-up the …

  SQLUserC

  3 replies

  15 years, 5 months ago

  By: Gail Shaw

• Is there any Compact Comparison List amongst 2008, 2008 SP1, 2008 R2 and Denali!

  [font="Verdana"]Is there any Compact Comparison List amongst 2008, 2008 SP1, 2008 R2 and Denali; is…

  Abrar Ahmad_

  2 replies

  15 years, 5 months ago

  By: Gail Shaw

• SSIS package data flow task with OLEDB as source having a parametrized SP executing a dynamic query

  Hi, I have a data flow task. The source in ole db. And the sql command calls a stored procedure exe…

  namrata.dhanawade-1143388

  3 replies

  15 years, 5 months ago

  By: namrata.dhanawade-1143388

• How do you model an overridable series of values in a hierarchy?

  I am working on a project that has a hierarchy. Each level of the hierarchy may have a value, and I…

  Jason Whitney

  2 replies

  15 years, 5 months ago

  By: Jason Whitney

• Filegroup shrinking with partitioned table

  Here's my scenario: I created 11 filegroups with a single file in them each. Each file was created…

  SumOfDavid

  2 replies

  15 years, 5 months ago

  By: SumOfDavid

• IPS vs Actual Security Rights

  Hello everyone. Just looking for some input on IPS's (Intrusion Prevention Systems) and more speci…

  Fraggle-805517

  1 replies

  15 years, 5 months ago

  By: andersg98

• Union Xml Output

  Hi, is there a way to do a union over two or more instances for xml??? something like this: Select …

  Danky 7

  3 replies

  15 years, 5 months ago

  By: kfranken-728999

• Tds Packet Size

  I have a problem about tds packet size one client connect to sql server 2008 I run a query and ı ga…

  ESAT ERKEC

  3 replies

  15 years, 5 months ago

  By: ESAT ERKEC

• Script Stops with No Error on 250,000 INSERT... VALUES Statements

  We send out one script with table updates to our clients and use INSERT INTO TableName VALUES (v1,…

  malik_nagel

  4 replies

  15 years, 5 months ago

  By: Pieter-423357

• loading flat file via SSIS

  I try to execute an SSIS package that essentially loads a flat file into a new SQL Server database.…

  ron.nicholls

  3 replies

  15 years, 5 months ago

  By: ron.nicholls

• Change collation in SQL Serrver 2008 database.

  Hi, I have a database on SQL Server 2008 its default collation is SQL_Latin1_General_CP1_CI_AS now …

  beejug1983

  1 replies

  15 years, 5 months ago

  By: Anonymous

• store procedure result to excel

  Please help in turning the store procedure result into excell and also to call this store procdure …

  hydbadrose

  5 replies

  15 years, 5 months ago

  By: hydbadrose

• Data isssue - with time

  I have a time data which is in the format - '10:15 AM' in excel, but when I am loading it to nvarch…

  Eshika

  6 replies

  15 years, 5 months ago

  By: Eshika