|
How to take backup databaseobjects(tables scripts,storeprocedure and functions etc) in sqlserver using sql scripts
|
|
2
|
644
|
October 27, 2017
|
|
For linked server returned message "ROW-00014: 젠⣫update) 饸䠮멥寠餰ꥰ魠᮱㠤ລ੭ ...". Msg 7343, Level 16, State 4, Line 1 The OLE DB provider "ORAOLEDB.Oracle" for linked server "Myoracle" could not UPDATE table "[Myoracle]..[CS1].[ITF_MATERIAL]"
|
|
1
|
1582
|
October 27, 2017
|
|
Convert Date into Default format
|
|
4
|
668
|
October 25, 2017
|
|
Convert Varchar round value to 2 decimals
|
|
4
|
3365
|
October 25, 2017
|
|
Batch File is hanging through SQL Job
|
|
4
|
1699
|
October 25, 2017
|
|
Formulated Closing Balance Column
|
|
1
|
612
|
October 25, 2017
|
|
How to Store More then 30000 characters in sql server 2012
|
|
4
|
2582
|
October 25, 2017
|
|
Index increment by exactly 1000
|
|
10
|
1161
|
October 25, 2017
|
|
String Manipulation
|
|
2
|
574
|
October 25, 2017
|
|
ForEach Loop Connection Fails Due to Slash in Server Name
|
|
3
|
1275
|
October 24, 2017
|
|
Convert varchar to number
|
|
3
|
587
|
October 24, 2017
|
|
Select only duplicates entry with join
|
|
3
|
555
|
October 24, 2017
|
|
Restoring replicated database
|
|
0
|
481
|
October 24, 2017
|
|
2016 AlwaysOn High Availability
|
|
4
|
1045
|
October 24, 2017
|
|
Execute SSIS package via SSRS
|
|
10
|
4169
|
October 23, 2017
|
|
Need to verify and "AND" tsql
|
|
4
|
694
|
October 23, 2017
|
|
Help This Clueless Guy Please!
|
|
1
|
526
|
October 23, 2017
|
|
Removing Duplicates
|
|
7
|
819
|
October 22, 2017
|
|
SQL server 2016 SP1 CU5 shows incompletely installed shared features
|
|
0
|
909
|
October 20, 2017
|
|
Trying to detect incorrect capitalisation in names
|
|
5
|
870
|
October 19, 2017
|
|
Converting rows to columns
|
|
1
|
488
|
October 19, 2017
|
|
Display data from vertical to horizontal
|
|
1
|
489
|
October 19, 2017
|
|
Backup File Retention - a cautionary tale
|
|
3
|
635
|
October 18, 2017
|
|
How to make pivote table from this source table
|
|
1
|
516
|
October 18, 2017
|
|
SP is inserting only ONE row of records. Any ideas?
|
|
6
|
877
|
October 18, 2017
|
|
Deployment State Compliance Question
|
|
5
|
596
|
October 18, 2017
|
|
Format Function doesnt work
|
|
6
|
922
|
October 18, 2017
|
|
Dividing 0 by 0
|
|
3
|
1248
|
October 18, 2017
|
|
Login failed non trust domain
|
|
0
|
446
|
October 17, 2017
|
|
Problem in Decimal
|
|
7
|
793
|
October 17, 2017
|