gajayku (7/2/2014)

Thanks for quick response. Let assume that I have schema of both source and destination in the following formats.

In excel File, I have columns (Id, Name, Salary) and...

where is the comparison going to occur? in a script task , likecomparing rows in a datatable DataTable to DataTable, for example?

on the SQL server so you can use...

I have a data massage macro in EditPlus exactly for this situation, where i replace \tNULL\t and \tNULL\n and also \nNULL\t with an empty string;

then i can copy and paste...

at one point, Microsoft had a script that you ran to simply add yourself as sysadmin to an instance. it required a stop and start of the instnace, but it...

didn't see the screenshot you attatched, and you said "SQL 2003 SP3", did you mean 2000, since that is the forum you posted? 2005?2008?

a bit of research on my side seems to tell me this DMV can help: sys.database_recovery_status :

if the database in question is in this resultset, it does not have a...

Perry your example doesn't seem to be telling me what i thought I should find.

i think the OP is asking if he can test whether he can take a log...

you will be much better off simply scripting out all your procedures, and doing a find and manual replace/edit.

any search is going to have the potential to fail, simply because...

yeah i tlooks like the account has read access to the share for sure.

is there any chance an application has the file open, so the bulk insert process cannot open...

before you do anything, run the followign command, and post the full results here for some peer review:

DBCC CHECKDB('msdb') WITH NO_INFOMSGS, ALL_ERRORMSGS

DO NOT reboot the server, take the database offline,...

i beleive delegation is not involved at all;

if xp_cmdshell is enabled, you can run this and see who the user is, as wella s wehtehr the user ahs access to...

pure permissions is the issue;

this is a common security misconception/"gotcha". The problem is that when you access any resource OUTSIDE of SQL server, like network shares, local hard drives and...

stating the obvious, windows users would not need to be resynced as orphans.

if we are talking about SQL users, i can certainly think of a classic scenario where this would...

well, first, 26 milliseconds is fast. the difference is pretty minimal for things under 50 milliseconds, i don't know if it's worth investigating much.

also, how are you measuring this? is...

in a non tech setting like with inlaws or strangers , i just say "i work in an office, and i work with the business group", as i've learned the...