SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• NEED HELP= Monthly SQL database growth calculation script

  Hello, I have created the table with the following columns and I have the data as well. I need to g…

  hydbadrose

  37 replies

  3 weeks, 5 days ago

  By: Srinivas Merugu

• Full backup Checkpoint LSN does not match Differential DatabasebackupLSN

  Hi Everyone, I am testing a DR scenario at work but having problems. Our backup strategy consists o…

  TerrenceTheCat

  8 replies

  3 weeks, 6 days ago

  By: Srinivas Merugu

• Scripting object securables

  Hi all I am wanting to script out all the object permissions for a particular user in my DB. I had…

  Kwisatz78

  5 replies

  4 weeks ago

  By: pjbondi

• Why I get null instead I should get 0

  Code for mssql 2008 DECLARE @CompanyID TINYINT DECLARE @MemNo decimal DECLARE @MemberFrom Integer D…

  hilme70

  2 replies

  1 month ago

  By: prabhu.st

• retrieve all .rdl files from report server

  Is there a folder on the report server that houses all of the .rdl files for all of the reports. We…

  Snargables

  5 replies

  4 months, 3 weeks ago

  By: omoola25

• Need to migrate a databases from DB2 to SQL server

  Hi, Need a help in Migrating a database of 100 GB from DB2 to Sql server. Client would extract the …

  bala2

  21 replies

  7 months ago

  By: Alex_K

• Login Failed. The login is from an untrusted domain and error 18452

  Hello People, I found information over the internet and went step by step to check each setting but…

  vmarinovbg

  3 replies

  7 months, 3 weeks ago

  By: Lansend1

• SQL Intellisense

  Hi, We have given read-only access to user1 on one of the production database1 But today we found o…

  HBK_4700

  4 replies

  8 months, 3 weeks ago

  By: Lonely Rogue

• Unzip file from T-SQL Script

  Hi All, How to unzip file by using T-SQL Script ? any Examples pls...?

  PRAMANA.DBA

  7 replies

  9 months, 1 week ago

  By: cmartel 20772

• Release FileStream space

  Hi All, I'm hoping someone might be able to help me. I'm new to these forums, so my appologies if t…

  Eugene-928407

  24 replies

  9 months, 1 week ago

  By: Dalec 60753

• Creating Index take a long time

  Hi All, I have just created 1 index in a large database ( 172 million rows ) in the testing server …

  WhiteLotus

  17 replies

  10 months, 2 weeks ago

  By: MMartin1

• Linked server permissions issue

  Hello everyone, Hope all is well. I have recently setup a linked server from sql server 2005 to mas…

  Pyman

  67 replies

  1 year ago

  By: SSSPrince

• Dropping indexes with low read to write ratio?

  I've been archiving index usage stats for about 60 days now. Gradually, table by table - I've drop…

  SkyBox

  43 replies

  1 year, 2 months ago

  By: Thomas Dean

• Problems initializing a subscription from a backup

  Hi, I am trying to initialize a subscription from a backup. I am getting this error: The transacti…

  Roust_m

  2 replies

  1 year, 3 months ago

  By: umaShankar godi

• Merge Replication SQL 2008 (10.0.6556) - downloads slow and behind

  Merge Replication SQL 2008 (10.0.6556) - downloads slow and behind I am working on newly virtualize…

  aweb67dab

  1 replies

  1 year, 3 months ago

  By: aweb67dab