SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Partitioning in SQL Server

  Hi what would be best thing to do when you are partioning a table. a. create the Index first then…

  RaviShankar1234

  3 replies

  15 years ago

  By: Syed Jahanzaib Bin hassan

• Create Proxy error

  Hi all I am wanting to run a SQL Job under the context of another account. I have created a local …

  Kwisatz78

  2 replies

  15 years ago

  By: Kwisatz78

• User does not exist or you do not have permission issue

  I have bunch of user who has db_reader & db_writeer rights on database. For some reason , they…

  Abhijit More

  3 replies

  15 years ago

  By: BLOB EATER

• How to drop the extended stored procedure

  HI All while i am droping the extended stored procedure....i got following error "Cannot drop the…

  kollisudheer27

  3 replies

  15 years ago

  By: Lowell

• Diffrent Versions of Analysis Services and SQL Database Engine

  Hello all, I very new to DBA stuff. Most of my experience has been just installing SQL Server. Wel…

  carbonscoring

  1 replies

  15 years ago

  By: DNA_DBA

• "Advanced" backup scheduling......

  The networking group (the guys with the tape backup unit) need me to backup certain databases on th…

  Barkingdog

  4 replies

  15 years ago

  By: Jeffrey Williams

• How to uninstall SQLServer2008R2

  I need to uninstall a default instance SQL SERVER 2008R2 Standard Edition 64 bit. this is the only …

  Eshika

  3 replies

  15 years ago

  By: george sibbald

• Confused? Space Available Property?

  Hey guys, Im confused on this property Space Available under General Tab on the Database Properties…

  asm1212

  9 replies

  15 years ago

  By: Jeffrey Williams

• Stop SQL Server Service or Server Shutdown

  We have a heavy transactional database on a SQL 2008 server (Enterprise) with Windows 2003 Server R…

  jimmycjen

  3 replies

  15 years ago

  By: jimmycjen

• Can data in sys.dm_db_index_usage_stats be deleted due to memory pressure?

  In BOL - http://msdn.microsoft.com/en-us/library/ms188755(v=SQL.100).aspx - it is stated that: The…

  Marios Philippopoulos

  3 replies

  15 years ago

  By: Grant Fritchey

• unique nonclustered index

  i did some quick research, but i have to log off my computer. Can someone help me find some informa…

  nawillia

  8 replies

  15 years ago

  By: Don Halloran

• Database role error on dbo objects

  Hello, So I mapped my windows login to the new Database role which i created. I went into securable…

  JackIntheBox

  3 replies

  15 years ago

  By: Don Halloran

• Execute permission was denied on new stored procedure in SQL Server 2008 R2

  Hi, SQL Server 2005 databases are migrated to SQL Server 2008 R2, but I found execute permission is…

  Puja Shah

  8 replies

  15 years ago

  By: Puja Shah

• Issue with Global Temp Tables and SQL Connections

  Does anyone have experience with SQL Server Connections not getting disposed of after creating glob…

  Hawkeye_DBA

  6 replies

  15 years ago

  By: Hawkeye_DBA

• Database stuck in recovery mode

  I have a database stuck in recovery mode, after a large delete operation was canceled and server ra…

  Marios Philippopoulos

  5 replies

  15 years ago

  By: Marios Philippopoulos