Click here to Skip to main content
14,765,699 members
Home » Discussions » Database
   

Database

 
QuestionRecursive CTE in T-SQL Pin
Rahul_Biswas24-Oct-16 23:15
professionalRahul_Biswas24-Oct-16 23:15 
AnswerRe: Recursive CTE in T-SQL Pin
Richard MacCutchan25-Oct-16 1:18
mveRichard MacCutchan25-Oct-16 1:18 
GeneralRe: Recursive CTE in T-SQL Pin
Rahul_Biswas25-Oct-16 1:44
professionalRahul_Biswas25-Oct-16 1:44 
GeneralRe: Recursive CTE in T-SQL Pin
Richard MacCutchan25-Oct-16 1:51
mveRichard MacCutchan25-Oct-16 1:51 
GeneralRe: Recursive CTE in T-SQL Pin
Rahul_Biswas25-Oct-16 1:58
professionalRahul_Biswas25-Oct-16 1:58 
GeneralRe: Recursive CTE in T-SQL Pin
Richard MacCutchan25-Oct-16 2:08
mveRichard MacCutchan25-Oct-16 2:08 
QuestionWhy SQL server maintenance plan Cannot rebuild clustered index offline? Pin
cornpoppy24-Oct-16 1:11
Membercornpoppy24-Oct-16 1:11 
AnswerRe: Why SQL server maintenance plan Cannot rebuild clustered index offline? Pin
Eddy Vluggen25-Oct-16 1:37
professionalEddy Vluggen25-Oct-16 1:37 
The answer is literally in the error-message.

From MSDN[^]
Clustered indexes must be created, rebuilt, or dropped offline when the underlying table contains large object (LOB) data types: image, ntext, text, varchar(max), nvarchar(max), varbinary(max), and xml.

Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

GeneralRe: Why SQL server maintenance plan Cannot rebuild clustered index offline? Pin
cornpoppy25-Oct-16 19:50
Membercornpoppy25-Oct-16 19:50 
GeneralRe: Why SQL server maintenance plan Cannot rebuild clustered index offline? Pin
Eddy Vluggen25-Oct-16 23:17
professionalEddy Vluggen25-Oct-16 23:17 
AnswerRe: Why SQL server maintenance plan Cannot rebuild clustered index offline? Pin
Richard Deeming26-Oct-16 4:23
mveRichard Deeming26-Oct-16 4:23 
QuestionConfiguration from a parent variable "ServerName" did not occur because there was no parent variable collection or Edit the existing Package Configurations using C# Pin
indian14321-Oct-16 13:12
Memberindian14321-Oct-16 13:12 
QuestionVisual Studio Database Projects and General Use Pin
cjb11018-Oct-16 3:38
Membercjb11018-Oct-16 3:38 
AnswerRe: Visual Studio Database Projects and General Use Pin
Matt U.18-Oct-16 11:12
MemberMatt U.18-Oct-16 11:12 
GeneralRe: Visual Studio Database Projects and General Use Pin
cjb11019-Oct-16 21:56
Membercjb11019-Oct-16 21:56 
GeneralRe: Visual Studio Database Projects and General Use Pin
Matt U.20-Oct-16 6:01
MemberMatt U.20-Oct-16 6:01 
SuggestionIncrease the Execution time or Connection Time out property of SSIS package from C# code Pin
indian14312-Oct-16 14:40
Memberindian14312-Oct-16 14:40 
QuestionTo run a SSIS package outside of SQL server data tools you must install populate filecollection of integration services or higher Pin
indian14310-Oct-16 7:39
Memberindian14310-Oct-16 7:39 
AnswerRe: To run a SSIS package outside of SQL server data tools you must install populate filecollection of integration services or higher - resolved Pin
indian14312-Oct-16 13:58
Memberindian14312-Oct-16 13:58 
QuestionExport Access db to Sql Server db everyday Pin
meeram396-Oct-16 16:09
professionalmeeram396-Oct-16 16:09 
AnswerRe: Export Access db to Sql Server db everyday Pin
Eddy Vluggen10-Oct-16 7:58
professionalEddy Vluggen10-Oct-16 7:58 
QuestionIdentity_Column Pin
Member 111616253-Oct-16 20:43
MemberMember 111616253-Oct-16 20:43 
AnswerRe: Identity_Column Pin
Chris Quinn4-Oct-16 0:11
MemberChris Quinn4-Oct-16 0:11 
AnswerRe: Identity_Column Pin
Swinkaran4-Oct-16 2:17
professionalSwinkaran4-Oct-16 2:17 
QuestionSQL Server Reporting Services Query to Get Stored Procedure Name for Shared Dataset Pin
David_4129-Sep-16 12:48
MemberDavid_4129-Sep-16 12:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.