SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Msg 128, Level 15, State 1, Line 2 The name "sp_resetstatus" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

  The following SQL " Use FlexFamilyMembership PRINT sp_resetstatus 'FlexFamilyMembership' ALTER DATA…

  najeeb_kt2000

  1 replies

  13 years, 10 months ago

  By: Jared

• db permissions...

  I am having one login srclogin is having datawriter,datareader and executer permission on the datab…

  mohan.bndr

  4 replies

  13 years, 10 months ago

  By: Jared

• ALTER INDEX ..... SORT_IN_TEMPDB

  if you rebuild an index using the SORT_IN_TEMPDB option, do you need tempdb size of at least the si…

  jsqldba

  13 replies

  13 years, 10 months ago

  By: Nadrek

• Deleting log backups after fullbackup

  Hi All On my prod sql server 2008, I run log backup every 5 min, differential backup at every 8 hrs…

  S_Kumar_S

  3 replies

  13 years, 10 months ago

  By: dan-572483

• Get incorrect result in the query.

  Posted - 07/10/2012 : 10:57:30 -------------------------------------------------------------------…

  tantcu

  4 replies

  13 years, 10 months ago

  By: tantcu

• How to check for any open transaction in tempdb SQL Server 2000.

  Help Please. How to check for any open transaction in tempdb SQL Server 2000.

  anzz

  1 replies

  13 years, 10 months ago

  By: Loundy

• Changing from automatic to manual identity range management

  I have inherited a database that uses merge replication for high availability between geographicall…

  FishNChipPapers

  1 replies

  13 years, 10 months ago

  By: GSquared

• Database Backups

  Hi, I currently backup my databases everynight and also run a maintenance plan that deletes backup …

  guerillaunit

  1 replies

  13 years, 10 months ago

  By: Robert Klimes

• Same Databases in different server I run same queries but execution plans are different

  Hi All, I have 2 same queries in same databases but in different servers. I run same queries, bu ex…

  Thinky Night

  5 replies

  13 years, 10 months ago

  By: Thinky Night

• SPN and CAP

  Hi, Can kerberos be used against a Client Access Point in a SQL Server cluster? I registered SPN's…

  adb2303

  3 replies

  13 years, 10 months ago

  By: Perry Whittle

• Can i INSERT a Column at the beginning?

  Dear All, Is it possible to insert a column into a table at any place, by default it is adding at t…

  SqlServerPass

  24 replies

  13 years, 10 months ago

  By: GSquared

• possible to see when a piece of text was removed from an SP?

  i have a Stored Procedure (SP1) which calls multiple other Stored Procedures. I've noticed that a c…

  davidandrews13

  7 replies

  13 years, 10 months ago

  By: Lowell

• SQL Server memory usage (sqlserv.exe)

  Hi, we have an SQL server instance with memory capped on 16GB. The total memory of the server itsel…

  svenjoos

  2 replies

  13 years, 10 months ago

  By: svenjoos

• Msg 102, Level 15, State 1, Line 2 Incorrect syntax near '‘'.

  Hi, I was executing following SQL Batch , " Use FlexFamilyMembership EXEC sp_resetstatus (‘Flex…

  najeeb_kt2000

  6 replies

  13 years, 10 months ago

  By: ChrisM@Work

• What is the third 'file' in the database folder.

  what is the type of 'file' in the database folder other than .mdf and .ldf files. what is its use. …

  najeeb_kt2000

  1 replies

  13 years, 10 months ago

  By: Gail Shaw