SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Error loading MS Access (2007) table to SQL Server (2008)

  We recently moved from SQL Server 2005 (32 bit) to 2008 (64 bit). We have three MS Access 2007 dat…

  Howard C. BAchtel-438731

  9 replies

  15 years ago

  By: Howard C. BAchtel-438731

• How to script a profiler trace in SQL Server 2008

  I want to run a trace on schedule. can any one tell me how to script a SQL Server profiler trace? S…

  theunique1011

  3 replies

  15 years ago

  By: theunique1011

• Added a Clustered index On ID cloumn but not ordered? Why?

  Hi All, I added Clustered Index to ID Cloumn on Testtable, after adding index records did not order…

  thinknight

  15 replies

  15 years ago

  By: Gail Shaw

• Connecting to SQL Server through a firewall to a virtual server by IP/Port

  They recently started virtualizing or databases servers here. I have some applications on of web si…

  Sean Grebey-262535

  3 replies

  15 years ago

  By: Sean Grebey-262535

• identity problem when moving from interbase to sql server

  We are moving our interbase database to a new MS sql 2008 server. We used a tool to create the data…

  geert.massa

  10 replies

  15 years ago

  By: Ninja's_RGR'us

• Batch File For Executing Multiple SP's

  Hi, The scenario is that I have got around 30 SP's to be executed & my manager wants me to cre…

  Hakuna Matata

  5 replies

  15 years ago

  By: Hakuna Matata

• How to analyze client statistics output in ssms?

  How to analyze client statistics output in ssms? Client Execution Time17:44:3917:39:0717:13:15…

  forsqlserver

  2 replies

  15 years ago

  By: forsqlserver

• Displaying data for the upcoming 4 quarters

  hi, if i am executing query in jan2011 or feb2011 or mar2011 then i need to consider records till d…

  subramani.rudrappa 78855

  3 replies

  15 years ago

  By: Ryan007

• DENY CONNECT ON ENDPOINT TO public

  I have set up a SQL2008 R2 server with named pipes disabled and the SQL Port set to 2433, in window…

  simon.letts

  5 replies

  15 years ago

  By: simon.letts

• Which index will get the prority and why?

  I am able to create Cluster and Non clustered index on same Column of same table. Which index will …

  forsqlserver

  3 replies

  15 years ago

  By: Lowell

• Replication LogRead agent

  Hi, If am creating multiple publisher, would it be there multiple log reader agent serving the purp…

  Latheesh NK

  2 replies

  15 years ago

  By: Latheesh NK

• Index creation in a huge table

  Hi all I had a problem in my SQL server 2008 R2. I got an error on a nonclustered index so I tried …

  oriol.saludes

  10 replies

  15 years ago

  By: oriol.saludes

• restore db of sqlserver2000 in sqlserver2008

  restore db of sqlserver2000 in sqlserver2008 i created a db in sqlserver2000 before. now i want to …

  armm1388

  1 replies

  15 years ago

  By: colin.Leversuch-Roberts

• Date different exclued weekend,holiday and non-working hours

  HI all, I have two date columns. i need date difference in HH:MM format that exclude weekend, h…

  latitiacasta

  1 replies

  15 years ago

  By: Latheesh NK

• Difference between count(*) and select *

  Can someone tell me the difference b/w below queries. 'select * from db.table_name' 'select count(*…

  M&M

  21 replies

  15 years ago

  By: Johan Bijnens