SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Suggestions and Ideas for Maintenance Plans

  Hi,I am requesting ideas, to take courage to speak to my boss. I am administering more than 12…

  Lou

  2 replies

  9 years, 3 months ago

  By: alnor

• when we go for cross apply and when we go for inner join in sql server 2012

  Hi Friend, I have small doubt  in sql server .when we go for cross apply and when we go for in…

  asrinu13

  2 replies

  9 years, 3 months ago

  By: drew.allen

• Database error: Row handle referred to a deleted row or a row marked for deletion

  We have a client running our help desk software (Web+Center) package and use SQL*Server on the back…

  scott 87260

  3 replies

  9 years, 3 months ago

  By: Sue_H

• Any idea how to overcome this error in 2008 ?

  This is the message I get  Msg 529, Level 16, State 2, Line 1Explicit conversion from data typ…

  mw_sql_developer

  4 replies

  9 years, 3 months ago

  By: mw_sql_developer

• Restore a backup from primary filegroup into the secondary filegroup

  Hi, We have to migrate a SQL-2008 DBe to SQL 2014. All 300 tables are hosted in primary filegr…

  info 58414

  1 replies

  9 years, 3 months ago

  By: Gail Shaw

• Warnings and SP_recompile messages from SP execution - How to not log those messages

  Dear all,  I have a stored procedure that is returning messages other then the only one I…

  river1

  2 replies

  9 years, 3 months ago

  By: Jeff Moden

• DBmail shut down and how to audit.

  We had an issue and was noticed until client inform. [br]Can someone help on how to audit who stopp…

  anzz

  5 replies

  9 years, 3 months ago

  By: Lowell

• While invoking the command to import the master..sp_help_revlogin output to the server erroring out

  Hello I executed the below command to extract the login to a .sql file. sqlcmd -E -S server -d mast…

  SQL_Hunt

  4 replies

  9 years, 3 months ago

  By: SQL_Hunt

• How to concatenate a string that looks like a number?

  This is the first line in my query...select '1002.' + b.dept_20K + '.90003' as 'roc', but I get an …

  NineIron

  2 replies

  9 years, 3 months ago

  By: NineIron

• Extract sqlcmd output to multiple files

  Can you please suggest how to extract sqlcmd output to multiple files? sqlcmd -E -S server -d maste…

  SQL_Hunt

  1 replies

  9 years, 3 months ago

  By: Sue_H

• FTP Task

  Hi, I have to develop an FTP task that moves files from an FTP server that are older than a mo…

  Briceston

  8 replies

  9 years, 3 months ago

  By: Bob Thiele

• Displayed 'Grantor' v system table results ?

  When I select server properties -> permissions, SQL server appears to display the 'grantor' as t…

  joseph.uher

  2 replies

  9 years, 3 months ago

  By: joseph.uher

• Moving Encrypted Database

  Hey Guys, I am trying to move an encrypted database that some contractors installed over a year ag…

  lkennedy76

  22 replies

  9 years, 3 months ago

  By: Joie Andrew

• How to check the snapshot location working directory

  Hello, I need to search the folder which contains all the replication snapshot details say idx, pre…

  SQL_Hunt

  1 replies

  9 years, 3 months ago

  By: Sue_H

• Size of sys.allocation_units.used_pages

  New accidental DBA. Am tasked with finding the size of each table in each DB in BYTES. To do so, I'…

  scarr030

  4 replies

  9 years, 3 months ago

  By: Gail Shaw