https://www.simple-talk.com/books/sql-books/how-to-become-an-exceptional-dba,-2nd-edition/

Thanks for the comments 🙂

Excellent suggestion!!!

Ron just keep in mind to change change the package for DelayValidation = False, otherwise your package will fail.

This looks like a school assignment. I think rather then giving him code we should send him some good tutorials.

Hi,

I could not understand the update query within that stored procedure.

UPDATE @FirstTable

SET masuk = b.datang

from

(select userid,

convert(date,CHECKTIME,103) tgl,

convert(VARCHAR(5),min(CHECKTIME),14) datang,

convert(VARCHAR(5),MAX(CHECKTIME),14) selesai

from CHECKINOUT

WHERE convert(date,CHECKTIME,103) >= @sdate and convert(date,CHECKTIME,103) <=...

I think you are trying to update a table and using @update (which is used for variables) instead of update

use this (i just delate @ infront of UPDATE)

string sql...

The code is not working. There are numbers of errors like the following even you parse the query

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near '?'.

Msg 102, Level...

Another possible solution is to create a temp table ans store data there. hope that helps 🙂

Agreed with Perry.

Moreover, if you have cluster situation and you are using drives or MPs of different node then both servers should be on the same cluster node.

If you want to see the database changes then you can set a trace for the users having admin rights.

Following are the ones you need to understand and use...

use this

SET @sql = 'IF EXISTS(SELECT * FROM ' + QUOTENAME(@SCHEMANAME) + '.' + QUOTENAME(@TABLENAME) + ' WHERE ' + @COLZ + ') INSERT INTO #RESULTS(TBLNAME,COLNAME,SQL) VALUES('''...

Excellent Code, thanks Lowell 🙂

When i ran sp_UglySearch proc I did not get ColName.

use this

SET @sql = 'IF EXISTS(SELECT * FROM ' + QUOTENAME(@SCHEMANAME) + '.' +...

Redgate is the best tool I used for database schema and data comparison.

Although it is not free but you can use a 30days trial to see if it is...

The below microsoft artical might help you.

http://support.microsoft.com/kb/976030

Many thanks 🙂

/* Below is the well written topic to generate SQL Server Logins with hex passwords

http://support.microsoft.com/kb/918992 */

Regards,

Bilal