SQL 2016 link server - Our environment requires that I create a link server from SQL to Oracle. The current production system functions as expected....
Scripting out schema permissions - Hi all Help please! Why does it seem so complicated to script out schema permissions in SQL? I've got various scripts...
Error moving log.ldf - Hi all, Tried moving log.ldf to another drive but hit error. Script and error as below... ALTER DATABASE dbName set offline ALTER DATABASE...
SSIS: Case clause with sintax error - Dear all, I am creating a derivated column task. It has a case in the expression but I always get the...
Get the year and Qtr - Ia am trying to get the year and Qtr from my date column which has values like- YYYY-MM (2017-02). I...
Substring - I get a files with a dates e.g Generate20170922, These files are stored like this in the db. I want...
Query running slow across linked server - Hi all Firstly, apologies for the lengthy post, but I'm trying to get everything in I thought would be useful. I've got...
Challenge: Insert a specific number of rows based on an integer column in one query! - I am creating promo codes. They are issued simply by inserting a record for the customer into the PromoCode table....
.bat file fails in SSIS - I have created a Execute Process task that runs a .bat file. This bat file creates a very small .txt...
One of my Passed Exam of MCSA shows in MCSE, Why? - Hello, I passed MCSA today. When I see the requirement for MCSE, among the list, it shows an exam (70-762) to get...
TSQL Query help plz.. - Hi All, Need tsql help please. Below is the sample schema/tables and description is written at the end(my requirement). use master go...
Entire Database Encryption - Dear Experts, My requirement is to encrypt entire database. Even DBA does not view data from the database(Not talking about column...
Creating a table from existing table. - I have a table which is 175GB in size. I am working on getting only the data from August and...
Updating 1 record in Table A with multiple records in Table B - Hello. SQL Server 2012, novice level programmer. I am trying to UPDATE a master table with records from a daily...
Database trigger to send email after column in table is updated. - Hello all, Thank you for any help given in advance, it is much appreciated. Scenario - What I require is a database trigger...
Recover data from encrypted log file - I have a 2008 R2 database encrypted using TDE that crashed. The MDF was lost, but the LDF survived. I was...
Column Length - Dear All, Question regarding the length of a column . As its understandable it has to be in accordance with the data...
Occasional mysterious time outs on SQL Server db table - Hi there, We have users in the field who use a mobile web GIS application (using Java) which use forms to edit/update spatial...
Faster way to release the Unused Space back to Disk - Hi, I have few databases that have 8 data files allocated with 300 GB each and used only 110 - 120...
SSIS package shows successful but not working - I have an SSIS package that was executing successfully for some time but last week started erroring. The error on...
