SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Failed to restore a SQL2000 backup to a SQL2008R2 instance

  Hello gents The SQL2000 backup is fresh without corruption but when I tried to restore it to a SQL2…

  sqlnickxu

  12 replies

  13 years, 7 months ago

  By: sqlnickxu

• Will shrinking the transaction log reduce the size of a full backup?

  Will shrinking the transaction log reduce the size of a full backup?

  Jon.Morisi

  5 replies

  13 years, 7 months ago

  By: Gail Shaw

• SELECT TOP(100 PERCENT) in Derived Table

  Hi All I'm trying to optimize a monstrous query in a report that a vendor supplied. Part of the que…

  mark 4643

  6 replies

  13 years, 7 months ago

  By: ChrisM@home

• How to find Which SQL Server instance is taking 100% CPU

  Hi, We have 3 SQL Server 2008 R2 instance on Windows Server 2008 R2 64 bit. The server is constantl…

  Mani-584606

  2 replies

  13 years, 7 months ago

  By: Mani-584606

• First function Access

  hi im migratting an MS Access database to SQL Server 2008, and I have a trouble trying to convert t…

  hugo_17_23 19942

  2 replies

  13 years, 7 months ago

  By: Lynn Pettis

• Re-creating users after database restore

  Here is my scenario: I backup a production database and restore it to dev environment. But after th…

  SQL Guy 1

  4 replies

  13 years, 7 months ago

  By: Alan Burstein

• Cleanup txt files from Z:\drive issue?

  I have job setup on all the PROD servers(2005, 2008r2, 2012). The Job will generate a .txt file eve…

  anzz

  8 replies

  13 years, 7 months ago

  By: anzz

• Database change policy and procedure

  Presently we have no defined process or policy for changes to SQL Server instances and databases in…

  joffwilliams

  9 replies

  13 years, 7 months ago

  By: Tony Fountain

• CTE - Help with repeated data

  Thank You

  deep_patel1

  1 replies

  13 years, 7 months ago

  By: Sean Lange

• send attachment in email

  I have this Proc setup to send a attachment in an email. If I take the file stuff out it sends the …

  edward_hall76

  2 replies

  13 years, 7 months ago

  By: edward_hall76

• ?? on Current_timestamp update

  Hi, I ran an update on one record to update the datetime using current_timestamp I might be losing …

  jbalbo

  4 replies

  13 years, 7 months ago

  By: Michael Valentine Jones

• split column

  Hi, I'm trying to split a single column into a number of columns, with the split being the delimite…

  DBayliss

  4 replies

  13 years, 7 months ago

  By: Fantastica

• Suddenly receiving Transport error trying to start jobs

  I'm trying to start a job on a hosted db. I've connected using SSMS, created the job and try to sta…

  PurpleLady

  2 replies

  13 years, 7 months ago

  By: PurpleLady

• DBCC PAGE

  Hi SSC, Im not an advanced DBA so apologies if this question seems simple but I would like some gui…

  BLOB EATER

  14 replies

  13 years, 7 months ago

  By: Gail Shaw

• Database ABC has more than 1000 virtual log files which is excessive issue

  I restored a SQL2000 db into SQL2008R2 and I am getting this message: Database ABC has more than 10…

  Anonymous

  2 replies

  13 years, 7 months ago

  By: Anonymous