SQL Server 2017 : SQL Server 2017 - Administration

SQL Server express 2017 Limitaions - Hi, What are the limitations of SQL Server express 2017 Limitations. How to enable Sql Server Agent in

SQL Server 2017 : SQL Server 2017 - Development

Need to display a column with deleted overlapping dates - I want to get rid of the following overlapping records from the table and display the below output. Also, I...

SQL Server 2014 : Administration - SQL Server 2014

DB in Recovery Pending - Hi Guys/Gals I thought I'd just come straight to the experts. I have a important DB in a Recovery Pending state,...

SQL Server 2014 : Development - SQL Server 2014

db_owner - do i need to be database owner to change table definition from SSMS? I am not able to do that...

Understanding Deadlock - Dear Experts, Myself created a deadlock situation to better understand it. The process created a deadlock involving multiple process but I...

SQL Server 2012 : SQL 2012 - General

Migrating data from one server to another - Hi Is there any way other than export and import where we can migrate data from one server to another. Thanks

Rollup/Aggregate tables and maintenance - Hello, We have numerous customers, each with their own database and in those databases we have a table called jobs. This...

SQL Server 2012 : SQL Server 2012 - T-SQL

Automating activity logging - Hi: So I found this great script here on SQL Server Central that allows me to query my database to see ...

Please help - complete missing data with latest recorded - Hi there, I have been stuck on this for days and I need submitting this report in the next two days. This...

SQL Server 2008 : T-SQL (SS2K8)

Find Receipt entry against invoice - Hello experts I need some help regarding SQL query, I have a table to save invoices and receipts against invoices. need a query...

Any better way of querying multiple tables based on a column value? - Hi all,I often have situations where I have a table which stores, in two separate columns, a value and a...

How to read list of files in folder using T-SQL? - Does anyone know how to read files from spesific folder/path using T-SQL? Regards, Eko Indriyawan

SQL Server 2008 : Security (SS2K8)

Grant Execute on an SP - Hi All, I've two databases on a server , DB1 and DB2. There is User1 who has Read\Write on DB1 and no...

Reporting Services : Reporting Services

Highlighting of changeable data using a "colour table" - I am a lone, and originally accidental, DBA, so would very much appreciate feedback on a solution I have come...

Programming : General

Odd results from WHERE in SQL - So I have a bit of VBA put together to manage the output of data based on selections made from...

Programming : SSDT

SSDT install fails in VS 2017 enterprise edition - Hi , I am unable to install SSDT for integration services for Visual Studio 2017 . I downloaded Analysis Services and reporting...

Data Warehousing : Integration Services

Granting SSIS access to developers - I'm trying to give access to our developers to SQL 2012 Integration Services without granting server admin, following the procedure...

SQL Server 2005 : Backups

Issues while backing up to the network - I am having some issues dealing with some of the back jobs that run on a SQL Server 2005 machine....

SQL Server 7,2000 : T-SQL

Sort column without ORDER BY - Is there any method to sort a column(numeric) without using ORDER BY clause.

Career : Certification

Exam 70-461 - Hi, Ive just ordered the book: Querying SQL Server 2012 Training Kit. I am planning to take the exam 70-461 within...